100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 3 out of 3 pages.
Ashton VilleneuveFinal Case Study Part 2In this section, I was asked to determine the long run trend for our company (Price Chomper). The long-run trend for sales of Price Chomper is generally increasing. The graph below takes a look at the existing data on sales. Looking at this graph, it is easy to notice that the trend line for sales is increasing.010000002000000300000040000005000000600000070000008000000SalesUsing the existing sales data, and a regression, I was able to forecast the sales for the next six months after April 2017. To do this, I ran a regression on all of the months, then reran a regression using only statistically significant months. This regression included the months ofJan, Mar, Apr, Jun, Aug, Nov, and Dec. (Shown below).SUMMARY OUTPUTRegression StatisticsMultiple R0.835218226R Square0.697589486Adjusted R Square0.644667646