EBK BIOSTATISTICS FOR THE BIOLOGICAL AN
EBK BIOSTATISTICS FOR THE BIOLOGICAL AN
2nd Edition
ISBN: 9780134679228
Author: ROY
Publisher: PEARSON CUSTOM PUB.(CONSIGNMENT)
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 2.1, Problem 20SLCT
To determine

To construct the frequency distribution of the data of Freshman 15 and to see if it appears that males gain lb during th 15 eir freshman year.

Expert Solution & Answer
Check Mark

Answer to Problem 20SLCT

The frequency distribution is:

    Class-IntervalFrequency
    40-492
    50-5917
    60-6916

Explanation of Solution

Given:

The data of freshman is as follows:

    SEXWT SEPTWT APRILBMI SEPTBMI APRIL
    M725922.0218.14
    M978619.717.44
    M746924.0922.43
    M938826.9725.57
    F686421.5120.1
    M595518.6917.4
    F646024.2422.88
    F565321.2320.23
    F706830.2629.24
    F585621.8821.02
    F504717.6316.89
    M716924.5723.85
    M676620.6820.15
    F565520.9720.36
    F706827.326.73
    F616023.322.88
    F535219.4819.24
    M929224.7424.69
    F575820.6920.79
    M676720.4920.6
    F585821.0921.24
    F495018.3718.53
    M686822.422.61
    F696928.1728.43
    M878823.623.81
    M818226.5226.78
    M606118.8919.27
    F525319.3119.75
    M707120.9621.32
    F636421.7822.22
    F565719.7820.23
    M686922.422.82
    M686922.7623.19
    F545620.1520.69
    M808222.1422.57
    M646620.2720.76
    F575922.1522.93
    F636523.8724.67
    F545618.6119.34
    F565821.7322.58
    M545618.9319.72
    M737525.8826.72
    M777928.5929.53
    F636621.8922.79
    F515418.3119.28
    F596219.6420.63
    F656823.0224.1
    F535620.6321.91
    F626522.6123.81
    F555822.0323.42
    M747720.3121.34
    M747820.3121.36
    M646819.5920.77
    M646821.0522.31
    F576123.4725.11
    F646822.8424.29
    F606419.520.9
    M646818.5119.83
    M667121.422.97
    F525717.7219.42
    M717722.2623.87
    F556021.6423.81
    M657122.5124.45
    M758223.6925.8
    F424915.0817.74
    M748222.6425.33
    M9410536.5740.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:

EBK BIOSTATISTICS FOR THE BIOLOGICAL AN, Chapter 2.1, Problem 20SLCT , additional homework tip  1

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

    Class-Interval
    40-49
    50-59
    60-69

Applying the function COUNTIFS for calculating frequencies as shown below:

EBK BIOSTATISTICS FOR THE BIOLOGICAL AN, Chapter 2.1, Problem 20SLCT , additional homework tip  2

This is the formula for first class interval and in all the class intervals apply the same formula only values of 40 and 49 will change by 50 and 59,60 and 69 and so on respectively. After applying the formula the result will be:

    Class-IntervalFrequency
    40-492
    50-5917
    60-6916

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

And by looking at the data we can see that it does not appear that males gain 15 lb during their freshman year.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Suppose that you want to estimate the mean monthly gross income of all households in your local community. You decide to estimate this population parameter by calling 150 randomly selected residents and asking each individual to report the household’s monthly income. Assume that you use the local phone directory as the frame in selecting the households to be included in your sample.  What are some possible sources of error that might arise in your effort to estimate the population mean?
For the distribution shown, match the letter to the measure of central tendency. A B C C Drag each of the letters into the appropriate measure of central tendency. Mean C Median A Mode B
A physician who has a group of 38 female patients aged 18 to 24 on a special diet wishes to estimate the effect of the diet on total serum cholesterol. For this group, their average serum cholesterol is 188.4 (measured in mg/100mL). Suppose that the total serum cholesterol measurements are normally distributed with standard deviation of 40.7. (a) Find a 95% confidence interval of the mean serum cholesterol of patients on the special diet.

Chapter 2 Solutions

EBK BIOSTATISTICS FOR THE BIOLOGICAL AN

Ch. 2.1 - Prob. 11SLCTCh. 2.1 - Prob. 12SLCTCh. 2.1 - Prob. 13SLCTCh. 2.1 - Prob. 14SLCTCh. 2.1 - Prob. 15SLCTCh. 2.1 - Prob. 16SLCTCh. 2.1 - Prob. 17SLCTCh. 2.1 - Prob. 18SLCTCh. 2.1 - Prob. 19SLCTCh. 2.1 - Prob. 20SLCTCh. 2.1 - Prob. 21SLCTCh. 2.1 - Prob. 22SLCTCh. 2.1 - Prob. 23SLCTCh. 2.1 - Prob. 24SLCTCh. 2.1 - Prob. 25SLCTCh. 2.1 - Prob. 26SLCTCh. 2.1 - Prob. 27SLCTCh. 2.2 - Prob. 1SLCTCh. 2.2 - Prob. 2SLCTCh. 2.2 - Prob. 3SLCTCh. 2.2 - Prob. 4SLCTCh. 2.2 - Prob. 5SLCTCh. 2.2 - Prob. 6SLCTCh. 2.2 - Prob. 7SLCTCh. 2.2 - Prob. 8SLCTCh. 2.2 - Prob. 9SLCTCh. 2.2 - Prob. 10SLCTCh. 2.2 - Prob. 11SLCTCh. 2.2 - Prob. 12SLCTCh. 2.2 - Prob. 13SLCTCh. 2.2 - Prob. 14SLCTCh. 2.2 - Prob. 15SLCTCh. 2.2 - Prob. 16SLCTCh. 2.2 - Prob. 17SLCTCh. 2.2 - Prob. 18SLCTCh. 2.2 - Prob. 19SLCTCh. 2.3 - Prob. 1SLCTCh. 2.3 - Prob. 2SLCTCh. 2.3 - Prob. 3SLCTCh. 2.3 - Prob. 4SLCTCh. 2.3 - Prob. 5SLCTCh. 2.3 - Prob. 6SLCTCh. 2.3 - Prob. 7SLCTCh. 2.3 - Prob. 8SLCTCh. 2.3 - Prob. 9SLCTCh. 2.3 - Prob. 10SLCTCh. 2.3 - Prob. 11SLCTCh. 2.3 - Prob. 12SLCTCh. 2.3 - Prob. 13SLCTCh. 2.3 - Prob. 14SLCTCh. 2.3 - Prob. 15SLCTCh. 2.3 - Prob. 16SLCTCh. 2.3 - Prob. 17SLCTCh. 2.3 - Prob. 18SLCTCh. 2.4 - Prob. 1SLCTCh. 2.4 - Prob. 2SLCTCh. 2.4 - Prob. 3SLCTCh. 2.4 - Prob. 4SLCTCh. 2.4 - Prob. 5SLCTCh. 2.4 - Prob. 6SLCTCh. 2.4 - Prob. 7SLCTCh. 2.4 - Prob. 8SLCTCh. 2.4 - Prob. 9SLCTCh. 2.4 - Prob. 10SLCTCh. 2.4 - Prob. 11SLCTCh. 2.4 - Prob. 12SLCTCh. 2 - Prob. 1CQQCh. 2 - Prob. 2CQQCh. 2 - Prob. 3CQQCh. 2 - Prob. 4CQQCh. 2 - Prob. 5CQQCh. 2 - Prob. 6CQQCh. 2 - Prob. 7CQQCh. 2 - Prob. 8CQQCh. 2 - Prob. 9CQQCh. 2 - Prob. 10CQQCh. 2 - Prob. 1RECh. 2 - Prob. 2RECh. 2 - Prob. 3RECh. 2 - Prob. 4RECh. 2 - Prob. 5RECh. 2 - Prob. 6RECh. 2 - Prob. 7RECh. 2 - Prob. 1CRECh. 2 - Prob. 2CRECh. 2 - Prob. 3CRECh. 2 - Prob. 4CRECh. 2 - Prob. 5CRECh. 2 - Prob. 6CRE
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
College Algebra
Algebra
ISBN:9781337282291
Author:Ron Larson
Publisher:Cengage Learning
Text book image
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Text book image
College Algebra
Algebra
ISBN:9781938168383
Author:Jay Abramson
Publisher:OpenStax
Continuous Probability Distributions - Basic Introduction; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=QxqxdQ_g2uw;License: Standard YouTube License, CC-BY
Probability Density Function (p.d.f.) Finding k (Part 1) | ExamSolutions; Author: ExamSolutions;https://www.youtube.com/watch?v=RsuS2ehsTDM;License: Standard YouTube License, CC-BY
Find the value of k so that the Function is a Probability Density Function; Author: The Math Sorcerer;https://www.youtube.com/watch?v=QqoCZWrVnbA;License: Standard Youtube License