Homework Help is Here – Start Your Trial Now!
Math
Statistics
Add a new worksheet to your Excel file for problem 3. Problem 3- Football Players The weights (in pounds (lb)) of 52 randomly selected NFL football players are presented below. 305 307 313 295 265 218 246 287 315 212 285 290 235 300 230 194 216 255 300 308 270 241 242 306 237 318 230 210 265 201 195 187 204 257 185 255 236 244 194 190 183 315 190 185 315 215 316 200 324 245 200 185 We would like to construct a 90% confidence interval for the mean weight of NFL football players. a. Explain why it is not necessary to assess normality for this sample. b. Use Excel to find summary statistics (including the margin of error for a 90% confidence interval) for this data set using the Descriptive Statistics command in the Data Analysis options under the Data menu. On your Excel file in the summary statistics you just obtained, highlight the point estimate in yellow and the margin of error in green. c. Show how to find the boundaries of a 90% confidence interval using only the highlighted values from your summary statistics output. (For this activity, do not use any other methods to find the confidence interval.) d. Write an interpretation for your confidence interval, including units if appropriate. You may round the upper and lower limits to the nearest whole number. e. Does the confidence interval estimate the mean weight for the sample of 52 NFL players or for the population of NFL players? Explain.

Add a new worksheet to your Excel file for problem 3. Problem 3- Football Players The weights (in pounds (lb)) of 52 randomly selected NFL football players are presented below. 305 307 313 295 265 218 246 287 315 212 285 290 235 300 230 194 216 255 300 308 270 241 242 306 237 318 230 210 265 201 195 187 204 257 185 255 236 244 194 190 183 315 190 185 315 215 316 200 324 245 200 185 We would like to construct a 90% confidence interval for the mean weight of NFL football players. a. Explain why it is not necessary to assess normality for this sample. b. Use Excel to find summary statistics (including the margin of error for a 90% confidence interval) for this data set using the Descriptive Statistics command in the Data Analysis options under the Data menu. On your Excel file in the summary statistics you just obtained, highlight the point estimate in yellow and the margin of error in green. c. Show how to find the boundaries of a 90% confidence interval using only the highlighted values from your summary statistics output. (For this activity, do not use any other methods to find the confidence interval.) d. Write an interpretation for your confidence interval, including units if appropriate. You may round the upper and lower limits to the nearest whole number. e. Does the confidence interval estimate the mean weight for the sample of 52 NFL players or for the population of NFL players? Explain.

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question
g the Margi Review Mailings View Help in viruses. Unless you need to edit, it's safer to stay in Protected View. ences Add a new worksheet to your Excel file for problem 3. Problem 3 - Football Players The weights (in pounds (lb)) of 52 randomly selected NFL football players are presented below. 305 265 307 218 313 246 295 187 287 285 290 315 265 212 204 201 210 Q Search 308 Enable Editing 235 185 257 194 270 255 L 300 230 195 236 244 194 190 216 255 300 241 242 306 316 318 230 315 190 185 183 315 215 200 185 237 We would like to construct a 90% confidence interval for the mean weight of NFL football players. a. Explain why it is not necessary to assess normality for this sample. 200 324 245 b. Use Excel to find summary statistics (including the margin of error for a 90% confidence interval) for this data set using the Descriptive Statistics command in the Data Analysis options under the Data menu. On your Excel file in the summary statistics you just obtained, highlight the point estimate in yellow and the margin of error in green. c. Show how to find the boundaries of a 90% confidence interval using only the highlighted values from your summary statistics output. (For this activity, do not use any other methods to find the confidence interval.) d. Write an interpretation for your confidence interval, including units if appropriate. You may round the upper and lower limits to the nearest whole number. e. Does the confidence interval estimate the mean weight for the sample of 52 NFL players or for the population of NFL players? Explain. e of 6 g X 0 S W
Transcribed Image Text:g the Margi Review Mailings View Help in viruses. Unless you need to edit, it's safer to stay in Protected View. ences Add a new worksheet to your Excel file for problem 3. Problem 3 - Football Players The weights (in pounds (lb)) of 52 randomly selected NFL football players are presented below. 305 265 307 218 313 246 295 187 287 285 290 315 265 212 204 201 210 Q Search 308 Enable Editing 235 185 257 194 270 255 L 300 230 195 236 244 194 190 216 255 300 241 242 306 316 318 230 315 190 185 183 315 215 200 185 237 We would like to construct a 90% confidence interval for the mean weight of NFL football players. a. Explain why it is not necessary to assess normality for this sample. 200 324 245 b. Use Excel to find summary statistics (including the margin of error for a 90% confidence interval) for this data set using the Descriptive Statistics command in the Data Analysis options under the Data menu. On your Excel file in the summary statistics you just obtained, highlight the point estimate in yellow and the margin of error in green. c. Show how to find the boundaries of a 90% confidence interval using only the highlighted values from your summary statistics output. (For this activity, do not use any other methods to find the confidence interval.) d. Write an interpretation for your confidence interval, including units if appropriate. You may round the upper and lower limits to the nearest whole number. e. Does the confidence interval estimate the mean weight for the sample of 52 NFL players or for the population of NFL players? Explain. e of 6 g X 0 S W
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS