The National Football League (NFL) polls fans to develop a rating for each football game (NFL website, October 24, 2012). Each g
ame is rated on a scale from (forgettable) to (memorable). The fan ratings for a random sample of games follow. Excel File: data07-11.xlsx a. Develop a point estimate of mean fan rating for the population of NFL games. b. Develop a point estimate of the standard deviation for the population of NFL games (to 4 decimals).
1 answer:
This question is incomplete, in that the Excel File: data07-11.xlsx a. was not provided, but I was able to get the information on the Excel File: data07-11.xlsx a. from google as below:
57 61 86 74 72 73
20 57 80 79 83 74
The image of the Excel File: data07-11.xlsx a. is also attached below.
Answer:
a) Point estimate of sample mean = 68
b) Point estimate of standard deviation (4 decimals) = 17.8122
Step-by-step explanation:
a) Point estimate of sample mean, \bar{x} = ∑Xi / n = (57 + 61 + 85 + 74 + 73 + 72 + 20 + 58 + 81 + 78 + 84 + 73)/12 = 68
b) Point estimate of standard deviation = sqrt ∑ Xi² - n\bar{x}² / n-1)
= sqrt(((57 - 68)^2 + (61 - 68)^2 + (85 - 68)^2 + (74 - 68)^2 + (73 - 68)^2 + (72 - 68)^2 + (20 - 68)^2 + (58 - 68)^2 + (81 - 68)^2 + (78 - 68)^2 + (84 - 68)^2 + (73 - 68)^2)/11) = 17.8122
You might be interested in