Question

For this week, I want to make sure you have a good, basic grounding in the principles of central tendency. Most statistics operates around two principles: central tendency and dispersion. Central tendency tells us where the "middle" of a set of data is, while "dispersion" allows us to see how spread out the data are from the middle.

This week, we are covering central tendency. Your first assignment is to use the Excel Data Analysis add-in (or a calculator or pencil and paper) to find the mean, mode, and median for the following data set:

49

62

24

34

51

24

35

23

22

21

19

If you choose to do this assignment by hand or on something else other than the Add-In, carry your answers out at least 3 places past the decimal (if it is necessary).

Your second assignment is to organize the same set of data into a frequency distribution with frequency (f) and relative frequency. Again, report your findings at three places past the decimal for the relative frequency column.

Answer 1

Sol:

Install analysis toolpak and then go to

Data >Data analysis >Descriptive statistics we get

Output:

Mean	33.09091
Standard Error	4.419902
Median	24
Mode	24
Standard Deviation	14.65916
Sample Variance	214.8909
Kurtosis	-0.33408
Skewness	0.988563
Range	43
Minimum	19
Maximum	62
Sum	364
Count	11

Mean	33.09091
Median	24
Mode	24

select the data go to insert >histogram

click on + to add data labels

you get

a

Format axis ana make the number of bins to 5

we get

Class	Frequency	Relative frequency=frequency/total
19-27.6	6	0.545
27.6-36.2	2	0.182
36.2-44.8	0	0.000
44.8-53.4	2	0.182
53.4-62	1	0.091
Total	11	1

Mean	33.09091
Median	24
Mode	24

Class	Frquency	Relative frquency
19-27.6	6	0.545
27.6-36.2	2	0.182
36.2-44.8	0	0.000
44.8-53.4	2	0.182
53.4-62	1	0.091
Total	11	1