Homework SourseRun trend regression analysis on Excel Write the equation of
Run trend regression analysis on Excel. Write the equation of the trend line.
| Year | Period | Sales | |
| 2010 | 1 | 1000 | |
| 2011 | 2 | 2500 | |
| 2012 | 3 | 3800 | |
| 2013 | 4 | 3000 | |
| 2014 | 5 | 5000 | |
| 2015 | 6 | 6500 | |
Solution
We can see from the above excel sheet data give in period and sales . putting values of period and sales in excel , we can find y=977.1*x+213.3
