Chapter 2.1, Problem 19SLCT

To determine

To construct the frequency distribution of the data of Freshman $15$ .

Answer to Problem 19SLCT

The frequency distribution is:

Class-Interval	Frequency
50-59	2
60-69	12
70-79	11
80-89	3
90-99	4

Explanation of Solution

Given:

The data of freshman is as follows:

SEX	WT SEPT	WT APRIL	BMI SEPT	BMI APRIL
M	72	59	22.02	18.14
M	97	86	19.7	17.44
M	74	69	24.09	22.43
M	93	88	26.97	25.57
F	68	64	21.51	20.1
M	59	55	18.69	17.4
F	64	60	24.24	22.88
F	56	53	21.23	20.23
F	70	68	30.26	29.24
F	58	56	21.88	21.02
F	50	47	17.63	16.89
M	71	69	24.57	23.85
M	67	66	20.68	20.15
F	56	55	20.97	20.36
F	70	68	27.3	26.73
F	61	60	23.3	22.88
F	53	52	19.48	19.24
M	92	92	24.74	24.69
F	57	58	20.69	20.79
M	67	67	20.49	20.6
F	58	58	21.09	21.24
F	49	50	18.37	18.53
M	68	68	22.4	22.61
F	69	69	28.17	28.43
M	87	88	23.6	23.81
M	81	82	26.52	26.78
M	60	61	18.89	19.27
F	52	53	19.31	19.75
M	70	71	20.96	21.32
F	63	64	21.78	22.22
F	56	57	19.78	20.23
M	68	69	22.4	22.82
M	68	69	22.76	23.19
F	54	56	20.15	20.69
M	80	82	22.14	22.57
M	64	66	20.27	20.76
F	57	59	22.15	22.93
F	63	65	23.87	24.67
F	54	56	18.61	19.34
F	56	58	21.73	22.58
M	54	56	18.93	19.72
M	73	75	25.88	26.72
M	77	79	28.59	29.53
F	63	66	21.89	22.79
F	51	54	18.31	19.28
F	59	62	19.64	20.63
F	65	68	23.02	24.1
F	53	56	20.63	21.91
F	62	65	22.61	23.81
F	55	58	22.03	23.42
M	74	77	20.31	21.34
M	74	78	20.31	21.36
M	64	68	19.59	20.77
M	64	68	21.05	22.31
F	57	61	23.47	25.11
F	64	68	22.84	24.29
F	60	64	19.5	20.9
M	64	68	18.51	19.83
M	66	71	21.4	22.97
F	52	57	17.72	19.42
M	71	77	22.26	23.87
F	55	60	21.64	23.81
M	65	71	22.51	24.45
M	75	82	23.69	25.8
F	42	49	15.08	17.74
M	74	82	22.64	25.33
M	94	105	36.57	40.86

Formula used:

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Calculation:

Import the data of SEX and WEIGHT SEP from the provided data set then apply filter to the data. Data of male and female is provided.

Copy the data of male shown in screen shot:

Make the class interval starting from $60$ with the class width $10$ in each interval:

Class-Interval

50-59

60-69

70-79

80-89

90-99

Applying the function COUNTIFS for calculating frequencies as shown below:

This is the formula for first class interval and in all the class intervals apply the same formula only values of $50\text{ and }59$ will change by $60\text{ and }69,70\text{ and }79$ and so on respectively. After applying the formula the result will be:

Class-Interval	Frequency
50-59	2
60-69	12
70-79	11
80-89	3
90-99	4

According to the above created table the data is approximately normally distributed.