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.

RBI Kings. As reported on MLB.com, the five players with the highest runs batted in (RBI) during the 2012 Major League Baseball season are listed in the following table. Also included are the teams for which they played, their positions, and their weights. Identify the type of data provided by the information in each column of the table. Player Team Position RBI Weight (lb) M. Cabrera Detroit 3B 139 240 J. Hamilton Texas LE 128 225 C. Headley San Diego 3B 115 220 R. Braun Milwaukee LE 112 205 E. Encamacion Toronto IB 110 230

Find the mode of the following list of weights (in pounds) of Boston terriers at a pet store. 17,12,8,21,8,16,12,8,21,16,8

How long does it take to finish the 1161-mile Iditarod Dog Sled Race from Anchorage to Nome, Alaska? Finish times (to the nearest hour) for 57 dogsled teams are shown below. 261 271 236 244 279 296 284 299 288 288 247 256 338 360 341 333 261 266 287 296 313 311 307 307 299 303 277 283 304 305 288 290 288 289 297 299 332 330 309 328 307 328 285 291 295 298 306 315 310 318 318 320 333 321 323 324 327             For this problem, use five classes. (a) Find the class width. (b) Make a frequency table showing class limits, class boundaries, midpoints, frequencies, relative frequencies, and cumulative frequencies. (Give relative frequencies to 2 decimal places.)

How would you answer this?

Scenario: The following table lists the typing speed as measured by a standard typing test for 12 college students, along with the number of pages they had to type for their Sociological Research Methods class.  Use the data to answer the Three questions listed below.  Make sure that you summarize and report if the results were significant using the F ratio formula. Report your answers in the Computed Value Tables. Student Number of pages typed Typing speed Chris 37 73 Mary 6 24 Paul 12 36 Juan 24 72 Marcel 16 50 Olga 7 19 Ni 22 49 Nima 4 6 Sari 34 48 Jarrod 32 59 Kevin 17 38 Lisa 8 16 Computed  Values Record the Results for each value ∑x 490 ∑y 219 ∑xy 10662 SSx 4159.66 SSy 1210.25 SP 1719.5 r 0.76636 a 1.37 b 0.41388 Regression Equation     Computed values Compute and record   SS residual 499.4515…

Scenario: The following table lists the typing speed as measured by a standard typing test for 12 college students, along with the number of pages they had to type for their Sociological Research Methods class. Use the data to answer the Three questions listed below. Make sure that you summarize and report if the results were significant using the F ratio formula. Report your answers in the Computed Value Tables.   Student Number of pages typed Typing speed Chris 37 73 Mary 6 24 Paul 12 36 Juan 24 72 Marcel 16 50 Olga 7 19 Ni 22 49 Nima 4 6 Sari 34 48 Jarrod 32 59 Kevin 17 38 Lisa 8 16 Using α = .05 test the significance of the regression equation.  Use the value of r (r = 0.76636) computed above to find SS residual and SS regression and round your answers to three decimal places for SS residual, SS regression, MS residual, MS regression.  Round to two decimal places…

Problem 3 help