Where do I get the trendline numbers from? 1. As we see, there\'s seasonality in

Question

Where do I get the trendline numbers from?

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

You can get this trendline number by following procedures.

First made the chart and put your cursor on chart. Then right click on any number in the graph and select option "Add trendline" . Then select option "linear" and put tick on the button "Display equation on chart" .

Now we got trendline equation is y^ = 0.009x + 2.208.

now we shall put x valus which is C4 in excel sheet. now put values of X = 1,2,3...n and get the linear trend values.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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