Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 2 (3 points) Scores on a very difficult statistics exam follow a probability model that is roughly normally distributed. Historically, the exam scores have
Question 2 (3 points) Scores on a very difficult statistics exam follow a probability model that is roughly normally distributed. Historically, the exam scores have a mean of 66 and a standard deviation of 12. Suppose the 25 current students took the exam and the average score was 78. If you were the professor, would this result be surprising? It would not be surprising since 78 is only 1 standard deviation above from the mean. It would be surprising since a mean of 78 for n = 25 students is is 5 standard errors above from the mean. It would not be surprising since a mean of 78 for n = 25 students is 5 standard errors away from the mean. It would be surprising since 78 is fewer than 2 standard deviations away from the mean Question 5 (3 points) Examine the following spreadsheet: A D 9 8 2 8 #REFI 7 15 3 10 11 12 13 14 4 6 5 5 12 19 In cell C2, what does the "#REF!" error message mean? The formula or function in cell C2 is referring to an invalid cell. This is not an error message. The column is not wide enough to display the result. Excel does not recognize the name of the function that has been entered. The wrong type of argument has been entered into the function in this cell
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started