ANSWER QUESTION 7.2 USING EXCEL AND EXCEL FUNCTIONS, AND REFERENCING THE BELOW E

Question

ANSWER QUESTION 7.2 USING EXCEL AND EXCEL FUNCTIONS, AND REFERENCING THE BELOW EXAMPLE. PLEASE ANSWER THIS QUESTION FULLY.

Question 7.2

Repeat Example 7.5 but compare the linear function with a second order polynomial plot based on the correlation coefficient. Which of the two plots provides a better result and why?

Example 7.5 Reconsider Example 7.4 but this time build two different scatter plots and then with data value 45 included and excluded from the plots, fit a linear function to both plots. Comment on the results The first scatter plot with a linear function fitted and data value 45 included is as illustrated in Figure 7.14.

Explanation / Answer

The best result is provided by the 2nd order polynomial.This is confirmed by the correlation coefficient which is higher(R2=0.9738) for the 2nd order polynomial.

Linear y=0.769x+19.206 R2=0.9524 2nd order polynomial y=0.016x2+0.3057x+21.523 R2=0.9738

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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