Be sure to explain your answers to receive full credit. In some cases, there may

Question

Be sure to explain your answers to receive full credit. In some cases, there may be more than one correct answer, you must select all correct answers (but no incorrect ones) to receive full credit (5 points) 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. b. 23 6. Explanation: e. None of the above/There is not enough information to tell. A B |C |D 17 23 -SA1 7. (5 points) 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 Explanation: Chart A: Residuals Chart B: Residuals 145 1s5

Explanation / Answer

6. formula $A1 - Freezes Column A and row number changes as we move the formula to any other location

With movement to D3 Column will be A and Row will change to 2

At E3, A will remain same and row will change to

formula at E3 will be =$A2 = 4

Answer 4

b)

characteristics of a well-behaved residual vs. fits plot and what they suggest about the appropriateness of the simple linear regression model:

Answer Chart B only

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.