Answer the followingquestions and upload to Canvas. Submit in Word or PDFformat.  Show your work and upload the Excel sheet aswell. All the writing parts must be your original writing, don'tquote, write in your own words.
The following tablepresents the orders of Samson Company for the last 36 months (3years).
Month | Order Year 1 | Order Year 2 | Order Year 3 |
January | 502 | 614 | 712 |
February | 408 | 592 | 698 |
March | 491 | 584 | 686 |
April | 456 | 532 | 644 |
May | 481 | 599 | 694 |
June | 511 | 604 | 702 |
July | 522 | 624 | 724 |
August | 500 | 612 | 716 |
September | 510 | 625 | 732 |
October | 512 | 627 | 740 |
November | 520 | 650 | 745 |
December | 536 | 680 | 756 |
- Use the data in the above table and regression analysis toforecast the orders for the next 12 months (4th year). Include yourexcel work sheet and your work in your write up. Show theregression equation, values of intercept, slope, correlationcoefficient and coefficient determination and the forecast oforders for the next 12 months.
- Explain how you could make your forecast’s results morereliable by incorporating a qualitative research to yourquantitative results.
