1. Give and explain two characteristics of effective spreadsheets.
2. A general rule in hypothesis testing is to reject H0 if p < ?. If p = 0.024, for what significance (?) values would H0 be rejected?
3. Explain the difference between an unbounded problem and an unbounded feasible region. Does one imply the other (both directions)? Explain.
4. Explain the purpose of the correlation matrix in multiple linear regression. What do the values represent? What sorts of values would you prefer to see (large, small, positive, negative...)? Explain.
5. In regression modeling, what is a reference category? Explain.
6. Consider the spreadsheet below. If the formula in cell D2 is copied “right” and “down” into cells D3, and E2:E3, what will be the value in cell E3?
a. 17.
b. 23.
c. 4.
d. 9.
e. None of the above/There is not enough information to tell.
7. Consider the scatterplots of residuals versus fitted values below. Which meet(s) linear regression assumptions?
a. Chart A only.
b. Chart B only.
c. Both A and B.
d. None of the above/There is not enough information to tell