Concept explainers
To construct the frequency distribution of the data of Freshman
Answer to Problem 20SLCT
The frequency distribution is:
Class-Interval | Frequency |
40-49 | 2 |
50-59 | 17 |
60-69 | 16 |
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 APRIL 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
Class-Interval |
40-49 |
50-59 |
60-69 |
Applying the
This is the formula for first class interval and in all the class intervals apply the same formula only values of
Class-Interval | Frequency |
40-49 | 2 |
50-59 | 17 |
60-69 | 16 |
According to the above created table the data is approximately
And by looking at the data we can see that it does not appear that males gain
Want to see more full solutions like this?
Chapter 2 Solutions
EBK BIOSTATISTICS FOR THE BIOLOGICAL AN
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL