The following table presents the orders of Samson Company for the last 36 months (3 years).MonthOrder Year 1Order Year 2Order Year 3January450600612February418575668March490580680April451534653May466555674June511604702July522624724August500612716September502633712October523634724November533643735December534676755 Use the data in the above table and regression analysis to forecast the orders for the next 12 months (4th year). Include your excel work sheet and your work in your write up. Show the regression equation, values of intercept, slope, correlation coefficient and coefficient determination and the forecast of orders for the next 12 months.Explain how you could make your forecast’s results more reliable by incorporating a qualitative research to your quantitative results.

Answered: Image /qna-images/answer/e3762746-57a1-4af6-a1f3-a9b3e799cc2f.jpg

Answered: The following table presents the orders…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

The following table presents the orders of Samson Company for the last 36 months (3 years).

Month	Order Year 1	Order Year 2	Order Year 3
January	450	600	612
February	418	575	668
March	490	580	680
April	451	534	653
May	466	555	674
June	511	604	702
July	522	624	724
August	500	612	716
September	502	633	712
October	523	634	724
November	533	643	735
December	534	676	755

Use the data in the above table and regression analysis to forecast the orders for the next 12 months (4th year). Include your excel work sheet and your work in your write up. Show the regression equation, values of intercept, slope, correlation coefficient and coefficient determination and the forecast of orders for the next 12 months.
Explain how you could make your forecast’s results more reliable by incorporating a qualitative research to your quantitative results.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 7 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Time Series Analyses, Forecasting Methods, and Indices$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions