Data Analysis, Project Management, and Probability Assignment

This assignment encompasses several key areas of data analysis and project management. Task A involves data interpretation through tables and percentage calculations, including age and type distributions, and statistical analysis of satisfaction levels, including mean, median, mode, and standard deviation, along with scatter diagrams and regression analysis relating time and satisfaction. Task B focuses on statistical analysis. Task C presents a network diagram and critical path analysis, determining project duration and identifying the critical path. The assignment also explores the impact of activity delays on project timelines. Task D delves into probability calculations using the nCr formula to determine the probability of a specific event and interprets the P-value in relation to occupancy rates, providing insights into statistical significance and its implications. This assignment provides a comprehensive overview of data analysis, project management, and probability concepts, offering practical applications and analytical skills.

Understand and managing data and
info
1

Table of Contents
TASK A...........................................................................................................................................3
TASK B...........................................................................................................................................3
TASK C...........................................................................................................................................3
TASK D...........................................................................................................................................4
2

TASK A
TASK B
1.
Age
Row Labels Sum of Age Percentage
<20 11 17%
20 to 29 13 20%
3

30 to 39 17 27%
40 to 49 11 17%
50 and over 12 19%
Grand Total 64
Type
Row Labels Sum of Type Percentage
1 8 13%
2 52 81%
3 4 6%
Grand Total 64
2.
<20 20 to 29 30 to 39 40 to 49 50 and over
0
2
4
6
8
10
12
14
16
18
11 13
17
11 12
Count of Age
3.
Satisfaction
Mean 32.5
Standard Error 1
Median 33
Mode 35
Standard Deviation 11.7
Sample Variance 136
Kurtosis 0
Skewness 0
4

Range 50
Minimum 10
Maximum 60
Sum 2077
Count 64
4.
5.
Scatter Diagram
0 2 4 6 8 10 12
0
2
4
6
8
10
12
0
2
4
6
8
10
12
Time and Satisfaction
Time Satisfaction
Correlation Coefficient
Correlations
Satisfactio
n
Time
Satisfaction Pearson
Correlation
1 -.838**
Sig. (2-tailed) .000
Time Pearson
Correlation
-.838** 1
Sig. (2-tailed) .000
Regression
5

Regression Statistics
Multiple R 0.838323
467
R Square 0.702786
235
Adjusted R Square 0.697992
465
Standard Error 6.409519
343
Observations 64
ANOVA
df SS MS F Significan
ce F
Regression 1 6022.77
9
6022.77
9
146.604
1
5.53E-18
Residual 62 2547.08 41.0819
4
Total 63 8569.85
9
TASK C
1. network diagram
6

2. The duration of project is 23 weeks. And critical path of project is defined as below:
Critical path
Path 1: 1 + 2 + 4 + 6 + 10+ 12 = 35
Path 2: 1 + 2 + 4 + 6 + 7 + 13 = 33
Path 3: 1 + 2 + 4 + 6 + 14 = 27
From the above calculation it can be seen that path 1 has highest value that is 35.
3. It can be found that if duration of activity A is 2 weeks then there will be delay in activity C
and E. this is because they are proceeding activity. So, overall project will be delayed.
TASK D
1. by applying formula of nCr the probability is P= 0.136.
2. In this the P value obtained is P= 0.136 that is less than P= 0.05. It means that probability of
occupancy rate of room may not be occupied during any week.
7