Hi guys, I was wondering if you could tell me how to forecast this data using th

Question

Hi guys, I was wondering if you could tell me how to forecast this data using the regressional tool pak in excel. Also how would I develop forecasts for 4 periods beyond this data based on using both a trend and seasonal adjusted model. Thank you!

Year Quarter Revenue ,110 Qtr2 4,982 4,591 Qtr4 5,680 2000 Qtr 4,191 Qtr2 4,928 Qtr3 4,909 Qtr46,410 2001 Qtr5,330 1999 Qtr1 Qtr3 Qtr2 Qr26,713 6,113 Qtr3 6,906 Qtr4 7,986 2002 Qtr5,101 Qtr2 6,178 tr3 6,376 Qtr4 7,457 Qtr1 5,530 2003 Qtri Qtr2 2 6,538 Qtr3 6,830 2004 Q Qtr4 Qtr1 8,073 6,131 Qtr2 7,070 Qtr3 7,257 8,800 Qtr4

Explanation / Answer

The regression tool in excel will help to forecast the data dependent on a certain set of parameter such as time, weight etc. In this case, the data from year to year can be forecasted using the date forecast and as many number of equations can be generated.

Open the data analysis tab, from the tab data in the excel. Then choose the option regression.

Once the regression dialog box appears, select the input X range as the sales figure and input Y range as the date available from 1999 to 2004 for all quarters. Now run the regression analysis and view the results.

The R square would be your main analysis factor. It needs to be 96% to represent an efficient level.

For more details, the following link can be accessed:

https://faculty.fuqua.duke.edu/~pecklund/ExcelReview/Use%20Excel%202007%20Regression.pdf

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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