View the step-by-step solution to:

Can you please help me with this HW question?

Can you please help me with this HW question?


Use the charting tool in Excel to develop a regression model to fit the trend effects using the data below for this scenario.


The "Economic Report to the President of the United States" included data on the amounts of manufacturers' new and unfilled orders in millions of dollars. Shown here are the figures for new orders over a 21-year period:


Year

Total Number of New Orders

1 55,022

2 55,921

3 64,182

4 76,003

5 87,327

6 85,139

7 99,513

8 115,109

9 116,251

10 121,547

11 123,321

12 141,200

13 162,140

14 168,420

15 171,250

16 176,355

17 195,204

18 209,389

19 237,025

20 272,544

21 293,475

What is required is first a linear model (chart) and then a polynomial (order 2) model (chart) using the above data, and each chart must show the line formula and the r-squared value.


The charts then should be used to answer the following questions:


How well does either model fit the data?


 Which model should be used for forecasting?


And provide explanations using the relevant metrics.

Top Answer

(2) In linear regression R 2 = 0.944 In polynomial regression R 2 = 0..980 As we can see in polynomial regression... View the full answer

E5.JPG

Sign up to view the full answer

Other Answers

Fit of the data for both models: Linear model: R 2 =... View the full answer

A6.PNG

A7.PNG

A8.PNG

A9.PNG

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online