(Step-by-Step) You may now wish to modify the dataset into two columns. The first column showing the year and quarter and the second column showing the
Question: You may now wish to modify the dataset into two columns. The first column showing the year and quarter and the second column showing the sales for that period. You may also wish to generate a third column with the numbers 1 through 24 to denote the index number for each sales value.
Deliverable: Word Document 
(See Steps) Generate seasonal indexes for the four quarters using
![[See Solution] Adjust the seasonal indexes generated](/images/solutions/MC-solution-library-32228.jpg "[See Solution] Adjust the seasonal indexes generated so that the")
[See Solution] Adjust the seasonal indexes generated so that the
(Solution Library) Generate a scatterplot of your modified dataset
![[Step-by-Step] Generate a simple linear regression of](/images/solutions/MC-solution-library-32230.jpg "[Step-by-Step] Generate a simple linear regression of the form:")
[Step-by-Step] Generate a simple linear regression of the form:
(See Solution) Prepare deseasonalized forecasts for year 7 quarters
System of Equation Calculator Using Matrices - MathCracker.com