Scribd
Upload
447 views6 pages

Data Analysis Assignment

This document contains a registration for an online data analysis course. It provides a data set of ages of 20 respondents and calculations to analyze the data including frequency distribution, measures of central tendency, variance, standard deviation, and grouping the data into a frequency table. A bar chart is also presented to visualize the age distribution.

Uploaded by

Waafi Live
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
447 views6 pages

Data Analysis Assignment

This document contains a registration for an online data analysis course. It provides a data set of ages of 20 respondents and calculations to analyze the data including frequency distribution, measures of central tendency, variance, standard deviation, and grouping the data into a frequency table. A bar chart is also presented to visualize the age distribution.

Uploaded by

Waafi Live
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 6

1

AMOUD UNIVERSITY

Course Title: Data analysis in research

Course Code: PPM - 8124

SEP 18 – 2021

Online Class

Name: Hodan Hassan Yoonis

REGISTRATION NO : MBA -01-1996-2020-ON


2

Collect data on age from a sample of 20 respondents. Use this data to answer the following
questions.
1. Construct a frequency distribution table for the data set. [4 marks]

15,15,17,17,18,19.19.19.19.19,20,21,23,24,25,26,31,33,34,34

Ages Frequency
15 2
17 2
18 1
19 5
20 1
21 1
23 1
24 1
25 1
26 1
31 1
33 1
34 2
Total = 20

2. Compute the mean, median and mode for the data set. [6 marks]

15+15+17+17+18+19+19+19+19+19+20+21+23+24+25+26+31+33+34+34 = 448
TOTAL = 448/20 = 22.4 it means mean is 22.4
3

Mode :
15,15,17,17,18,19,19,19,19,19,20,21,23,24,25,26,31,33,34,34

15,17,19,34 multimodal

15,15,17,17,18,19,19,19,19,19,20,21,23,24,25,26,31,33,34,34

Median: 19+20 = 39/2 = 19.5

3. Calculate the variance and standard deviation for the data set. [6 marks]

Variance

value Value – mean (Value – mean)2


15 15 – 22.4 = -7.4 54.76
15 15 - 22.4 = -7.4 54.76
17 17 - 22.4 = -5.4 29.16
17 17 - 22.4 = -5.4 29.16
18 18 - 22.4 = - 4.4 19.36
19 19 - 22.4 = - 3.4 11.56
19 19 - 22.4 = - 3.4 11.56
19 19 - 22.4 = - 3.4 11.56
19 19 - 22.4 = - 3.4 11.56
19 19 - 22.4 = - 3.4 11.56
20 20 - 22.4 = - 2.4 5.76
21 21 - 22.4 = - 1.4 1.96
23 23 - 22.4 = -0.6 0.36
24 24 - 22.4 = 1.6 2.56
25 25 - 22.4 = 2.6 6.76
26 26 - 22.4 = 3.6 12.96
31 31 - 22.4 = 8.6 73.96
33 33 - 22.4 = 10.6 112.36
34 34 - 22.4 = 11.6 134.56
4

34 34 - 22.4 = 11.6 134.56


Total = 22.4 Sum = Sum = 730.8 /20 = 36.54

Variance = 36.54

Standard deviation = √ 36.54 = 6.0

4. Construct a grouped frequency distribution table for the data set, using 5 classes.

Age Frequency

15-19 10

20-24 4

25-29 2

30-34 4

35 above 0

5. Calculate the mean age for the grouped data. Interpret your result.

Age Frequency f Midpoint Xm F .Xm

15-19 10 17 170

20-24 4 22 88

25-29 2 27 54
5

30-34 4 32 128

35 above 0 35 0

Total = 20 Total = 440

Mean = 440/20
= 22
Mean age of grouped respondents is 22

6 Calculate the standard deviation for the grouped data.

Age Frequency Midpoint X2m F.Xm F.X2m


, Xm
15 – 19 10 17 289 170 2890
20 – 24 4 22 484 88 1936
25 – 29 2 27 729 54 1458
30 – 34 4 32 1024 128 4096
35 above 0 35 1225 0 0

∑F.Xm = 440 ∑F.X2m = 10380

= 20 (10380) – (440) 2/ 20 (19)


= 207600 – 880 / 380
= 206720/380
Variance = 544
Standard deviation = √544 = 23.32
6

7. Draw a bar chart for the data set. Interpret the figure.

AGE OF RESPONDENTS
6

0
15 17 18 19 20 21 23 24 25 26 31 33 34

This bar graph represents for the age of the respondents and their frequency

You might also like