How do I get the Trendline numbers in this in excel?? please help the 2.22.2.33,

Question

How do I get the Trendline numbers in this in excel?? please help the 2.22.2.33, 2.34 ect

It is an already solved problem that I need help understanding , thank you for your time and help !

1. As we see, there's seasonality in the data, so we will use time series decomposition method to forecast the sales of Carlson Stores and that of Countrywide Dept Stores during the 4 months period. Hollee H Penn State, Universi... Steps involved in Time Series decomposition method are as below Step 1: Organlze the data In a serles from month 1 to 48. Plot the data on a graph and also plot the linear regression trend line and display trendline equation on chart. FIND ME A TUTOR Step 2: Calculate trendline for each month as per the equation displayed on chart (y = ax + b) , where a is the slope and b is intercept Step 3: Calclate Seasonal Ratio by dividing actual sales by trendline Step 4: Calculate Seasonal index for each of the 12 months by averaging the seasonal ratio of the corresponding months. For example, to determine seasonal index for January, calculate the average of the seasonal ratio of Janurary months of all the years. Please note there will be only 12 seasonal indices for the month September to August. Step 5: Calculate Forecast Sales by multiplying the trendline with the Seasonal index for corresponding month. Estlmate of Carlson sales had there been no hurricane from September to December Is 2.11, 2.46, 3.09, 4.67 Table 1: Carlson Sales y 0.009x 2.208 17

Explanation / Answer

The trendline equation is given as y =0.009 x + 2.208

For the first row, x=1; so y = 0.009 * 1 + 2.208 = 2.217, is rounded to 2.22

For the second row, x=2; so y = 0.009 * 2 + 2.208 = 2.226, is rounded to 2.23

For the third row, x=3; so y = 0.009 x 3 + 2.208 = 2.235, is rounded to 2.24

And so on...

The seasonality ration is the ratio of Actual sales and forecast sales from the trendline equation.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.