QMET 251 Funds of Business Statistics Sample Exam 3 Questions with Answers Spring Series A+ Graded University of Louisiana

lOMoAR cPSD| 42147428




QMET 251 Funds of Business
Statistics Sample Exam 3 Questions
with Answers Spring Series A+
Graded University of Louisiana

, lOMoAR cPSD| 42147428




QMET 251 – Exam 3a – Spring Name:

Show all work on this exam. For questions that require calculations (or table lookup), you MUST show your
work on the exam (or indicate values used for table lookup) in order to receive credit.

c(For #’s 1 – 8) Given the following output from Excel used to predict the value of yearly earnings (in millions
of $) of Business Week’s “Best Small Companies”, based on their yearly sales (in $ Millions).
ANOVA
df SS
Regression 1 12,323.56
Residual 8 1,094.842
Total 9 13,418.4

Coefficients t Stat P-value
2.22941 0.05634
Intercept -12.8094 2 9
3.29734 0.01090
sales,X 2.179463 5 2

1. What is the standard error of the estimate?
A. 136.8552
B. 12323.56
C. 11.6985
D. Cannot be computed

2. What is the coefficient of determination?
A. 91.8%
B. 8.2%
C. 90.0%
D. Cannot be computed

3. What is the correlation coefficient?
A. 0.81
B. -0.958
C. 0.958
D. 0.006

4. The regression equation is:
A. = 2.179463 - 12.8094 X
B. = -12.8094 + 2.179463X
C. 12.8094 X = 2.179463
D. None of these

5. The regression analysis can be summarized as follows:
A. No significant relationship between the variables
B. A significant negative relationship exists between the variables
C. A significant positive relationship exists between the variables
D. For every unit increase in X, Y decreases by 12.8094