
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
MyLab Statistics with Pearson eText -- Standalone Access Card -- for Biostatistics for the Biological and Health Sciences (My Stat Lab)
- Please help me with this statistics questionarrow_forwardPlease help me with the following statistics questionFor question (e), the options are:Assuming that the null hypothesis is (false/true), the probability of (other populations of 150/other samples of 150/equal to/more data/greater than) will result in (stronger evidence against the null hypothesis than the current data/stronger evidence in support of the null hypothesis than the current data/rejecting the null hypothesis/failing to reject the null hypothesis) is __.arrow_forwardPlease help me with the following question on statisticsFor question (e), the drop down options are: (From this data/The census/From this population of data), one can infer that the mean/average octane rating is (less than/equal to/greater than) __. (use one decimal in your answer).arrow_forward
- Help me on the following question on statisticsarrow_forward3. [15] The joint PDF of RVS X and Y is given by fx.x(x,y) = { x) = { c(x + { c(x+y³), 0, 0≤x≤ 1,0≤ y ≤1 otherwise where c is a constant. (a) Find the value of c. (b) Find P(0 ≤ X ≤,arrow_forwardNeed help pleasearrow_forward7. [10] Suppose that Xi, i = 1,..., 5, are independent normal random variables, where X1, X2 and X3 have the same distribution N(1, 2) and X4 and X5 have the same distribution N(-1, 1). Let (a) Find V(X5 - X3). 1 = √(x1 + x2) — — (Xx3 + x4 + X5). (b) Find the distribution of Y. (c) Find Cov(X2 - X1, Y). -arrow_forward1. [10] Suppose that X ~N(-2, 4). Let Y = 3X-1. (a) Find the distribution of Y. Show your work. (b) Find P(-8< Y < 15) by using the CDF, (2), of the standard normal distribu- tion. (c) Find the 0.05th right-tail percentage point (i.e., the 0.95th quantile) of the distri- bution of Y.arrow_forward6. [10] Let X, Y and Z be random variables. Suppose that E(X) = E(Y) = 1, E(Z) = 2, V(X) = 1, V(Y) = V(Z) = 4, Cov(X,Y) = -1, Cov(X, Z) = 0.5, and Cov(Y, Z) = -2. 2 (a) Find V(XY+2Z). (b) Find Cov(-x+2Y+Z, -Y-2Z).arrow_forward1. [10] Suppose that X ~N(-2, 4). Let Y = 3X-1. (a) Find the distribution of Y. Show your work. (b) Find P(-8< Y < 15) by using the CDF, (2), of the standard normal distribu- tion. (c) Find the 0.05th right-tail percentage point (i.e., the 0.95th quantile) of the distri- bution of Y.arrow_forward== 4. [10] Let X be a RV. Suppose that E[X(X-1)] = 3 and E(X) = 2. (a) Find E[(4-2X)²]. (b) Find V(-3x+1).arrow_forward2. [15] Let X and Y be two discrete RVs whose joint PMF is given by the following table: y Px,y(x, y) -1 1 3 0 0.1 0.04 0.02 I 2 0.08 0.2 0.06 4 0.06 0.14 0.30 (a) Find P(X ≥ 2, Y < 1). (b) Find P(X ≤Y - 1). (c) Find the marginal PMFs of X and Y. (d) Are X and Y independent? Explain (e) Find E(XY) and Cov(X, Y).arrow_forwardarrow_back_iosSEE MORE QUESTIONSarrow_forward_ios
- Big 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 MCDOUGALGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
- Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning





