School of Business, Public Policy & Social Entrepreneurship
Ambedkar University Delhi
Course Code: SBP2MB124 (Business Statistics)
Semester 1: Slot 1 (July to September 2018)
Batch 2019-2021
#The data for MMH is provided in sheet 1
Data Description Mention the Scale of Measurement of the Variable
ID
Age Mother (Yr)
Age Father (Yr)
Birth Order
Baby Weight (Kg)
Overall Satisfaction (measured on a scale of 1-5)
Gender
Smoking
Mother's Edu level (measured on a scale of 1-20)
Father's Edu (measured on a scale of 1-20)
Prenatal Counselling
Based on the collected data conduct anaysis to answering the following questions and draw insights. Give summary of excel fu
1. Conduct descriptive statistics on variable baby weight.
2. Make frequency distribution of overall satisfaction and represent on pie chart.
3. Make Histogram of Mother age and draw conclusion on Normality of data based on Histogram.
3. Conduct outlier analysis (using z score) for variable body weight.
4. Draw a cross tabulation on vaiables birth order and baby weight (without using pivot tables). Also represent graphically on s
5. Is there any correlation between Mother's education level and baby weight?
6. Form a 95% confidance interval around the mean weight of baby boy birth weight assuming standard deviation of baby boy
Give summary of excel functions used in the report.
epresent graphically on side by side bar graph.
ard deviation of baby boy weight = 0.8 .
ID Age Mother (Yr) Age Father (Yr) Birth Order Baby Weight (Kg) Overall Satisfaction Gender Smoking
1 27 29 2 1.05 2 Boy Y
2 21 26 3 1.12 4 Boy Y
3 23 23 1 1.37 3 Girl N
4 37 36 6 3.17 4 Girl N
5 31 21 2 1.06 5 Boy N
6 21 27 1 1.02 4 Girl N
7 16 18 1 2.72 3 Boy Y
8 19 24 1 1.30 3 Girl N
9 22 23 2 2.22 3 Girl N
10 34 36 2 1.23 4 Girl N
11 30 24 1 1.60 2 Girl N
12 23 30 1 3.82 3 Boy Y
13 25 32 3 1.44 4 Girl N
14 29 28 2 1.79 3 Girl N
17 26 54 1 1.53 3 Boy N
19 38 42 3 2.19 3 Girl N
24 22 26 1 2.99 3 Boy N
28 31 40 1 1.81 3 Girl N
29 19 22 3 1.14 3 Boy Y
30 20 22 1 1.78 4 Girl N
34 29 30 2 4.40 3 Boy N
36 28 31 2 1.94 2 Girl Y
37 30 45 4 1.34 2 Boy N
38 23 26 2 1.10 4 Boy Y
FREQUENCY
1 2 3 4 5
INTERVAL METHOD FOR CRO
BABY WEIGHT & BIRTH ORDER
40
39
38
37
36
35
34
33
32
31
30
29
28
27
26
25
24
31
30
29
28
27
26
25
24
23
22
21
20
19
18
17
16
15
14
13
12
11
10
9
8
7
6
5
4
3
2
1
0.00 1.00 2.00 3.00 4.00 5.00 6.00 7.0
Baby Wei ght (Kg) Bi rth Order/Baby weight
Mother Edu level Father's Edu Prenatal Counselling
2 7Y
3 5N
4 4Y
6 8Y
4 3N MAXIMUM 4.40
14 1Y
0 3Y
0 5N
8 5N
5 14 Y
4 14 Y
16 4Y
7 2Y
2 3Y
1 0N
5 9Y
7 7Y
4 3Y
2 0Y
7 3Y
7 7Y
10 12 Y
12 11 Y
16 4N
SATISFACTION FREQUENCY
1 1
2 9
3 15
4 11
5 3
INTERVAL METHOD FOR CROSS TABULATION Baby Weight (Kg) Birth Order/Baby weight 1-1.50
1.05 1 5
1.12 2 12
1.37 3 15
3.17 4 4
1.06 6 0
1.02
2.72
1.30
2.22
1.23
1.60
3.82
1.44
1.79
2.22
2.48
1.53
1.11
2.19
3.65
1.26
1.47
1.67
2.99
1.27
1.54
2.83
1.81
1.14
1.78
1.69
1.92
1.98
4.40
1.38
1.94
1.34
1.10
1.61
1.48
00 6.00 7.00
NUMBER OF ITEMS 40 SKEWNESS KURTOSIS
MEAN 1.87 1.38925435 1.467831
STANDARD DEVIATION 0.819725
MINIMUM 1.02 RANGE 3.38 0.8
BOY 16
AVERAGE WEIGHT 1.88375
Z SCORE 0.498584
CONFIDENCE(95%) 0.391993
Baby Weight (Kg) Gender
1.05 Boy
1.12 Boy
1.06 Boy
2.72 Boy
3.82 Boy
2.48 Boy
1.53 Boy
1.11 Boy
1.47 Boy
2.99 Boy
1.27 Boy
1.54 Boy
1.14 Boy
4.40 Boy
1.34 Boy
1.10 Boy
CORRELATION BETWEEN MOTHER EDU. AND BABY WEIGHT
CORRELATION 0.254856
1.50-2 2-2.50 2.50-3 >3 TOTAL
8 0 3 1 17
8 4 0 4 28
0 3 0 0 18
0 4 0 0 8
0 0 0 6 6
77
0.8
CONFIDENCE INTERVAL
