I need help as soon as possible
1 answer:
You might be interested in
Given a table of historical demand for a product as follows:
![\begin{tabular} {|c|c|} &Demand\\[1ex] April&60\\ May&55\\ June&75\\July&60\\August&80\\September&75\\ \end{tabular}](https://tex.z-dn.net/?f=%5Cbegin%7Btabular%7D%0A%7B%7Cc%7Cc%7C%7D%0A%20%26Demand%5C%5C%5B1ex%5D%0AApril%2660%5C%5C%0AMay%2655%5C%5C%0AJune%2675%5C%5CJuly%2660%5C%5CAugust%2680%5C%5CSeptember%2675%5C%5C%0A%5Cend%7Btabular%7D)
The linear regression equation is given by
where:
and
We calculate the required values using the following table, where
<span>April = 1, May = 2, and so on.
![\begin{tabular} {|c|c|c|c|} X &Y&X^2&XY\\[1ex] 1&60&1&60\\ 2&55&4&110\\ 3&75&9&225\\ 4&60&16&240\\ 5&80&25&400\\ 6&75&36&450\\[1ex] \Sigma X=21&\Sigma Y=405&\Sigma X^2=91&\Sigma XY=1,485 \end{tabular}](https://tex.z-dn.net/?f=%5Cbegin%7Btabular%7D%20%0A%7B%7Cc%7Cc%7Cc%7Cc%7C%7D%0AX%20%26Y%26X%5E2%26XY%5C%5C%5B1ex%5D%20%0A1%2660%261%2660%5C%5C%20%0A2%2655%264%26110%5C%5C%20%0A3%2675%269%26225%5C%5C%0A4%2660%2616%26240%5C%5C%0A5%2680%2625%26400%5C%5C%0A6%2675%2636%26450%5C%5C%5B1ex%5D%0A%5CSigma%20X%3D21%26%5CSigma%20Y%3D405%26%5CSigma%20X%5E2%3D91%26%5CSigma%20XY%3D1%2C485%20%0A%5Cend%7Btabular%7D)
Thus,
and
Therefore, the </span><span>trend line for the historical data is given by
</span>
The linear regression equation is given by
where:
and
We calculate the required values using the following table, where
<span>April = 1, May = 2, and so on.
Thus,
and
Therefore, the </span><span>trend line for the historical data is given by