Answer the following questions and upload to Canvas. Submit in Word or PDF format.Â Â Show your work and...

80.2K

Verified Solution

Question

Statistics

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.

Answer & Explanation Solved by verified expert

4.3 Ratings (698 Votes)

Regression output SUMMARY OUTPUT Regression Statistics Multiple R 096639242 R Square 09339143 Adjusted R Square 093197061 Standard Error 249413658 Observations 36 ANOVA df SS MS F Significance F Regression 1 2988952001 2988952 4804835 122696E21 See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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