Notes+for+time+series+Assessment


 * NOTES:**


 * Row Height:** Click on top lefthand corner of spreadsheet (between numbers and letters) then right click the number 1 and select 'row height' change to 30.


 * Alignment of columns (eg: move typing to top):** Select the column you want to format by clicking on the letter at the top, then right click somewhere on that column and select 'format cells'; select the Alignment tab, then underneath 'vertical' select 'top'.


 * Where do you start and stop when doing a 4pt MM?** start in the cell that lines up with the THIRD value on the left (or between the 2nd and 3rd value) - put: =average(.........select the 4 cells.......). One value should appear. Place the cursor on the bottom right hand side of that cell, click on it then drag it down to the second cell from the bottom (value should appear between the 2nd and 3rd value of the last 4 numbers.


 * Where do you start and stop when doing a 12pt MM:** like above but start between the 6 and 7 value.

When you select the columns to graph, select the first, second and fourth (the moving mean is only a line of working). Hold down the 'control' button so you can select the 4th column.
 * Centred Mean (4th Column):** only find the average for every two cells (no matter if a 4pt or 12pt moving mean).


 * First 3 things you must do on your graph:** 1. Click on the horizontal axis, select 'format axis' then select the box 'text axis' AND 2. select the box 'position axis on tick marks' 3. Go to 'layout' on the top bar then add a 'chart title' and 'axis titles'.


 * Move your graph to a new page:** if you click on your graph you should see 'move chart' on the right side of the top bar, click on that then select 'new sheet' and ok.


 * Create a trendline:** right click on top of the centred mean line (on your graph) and select 'add trendline' then select, 'display equation' AND 'display R-squared value on chart (you don't need to make any comments on the R-squared value). Move the equation to the side of the graph.

2. Write your own one here: ||
 * Note:** the gradient is the value that is in front of the x value in the equation; that is the one you use in your comments/conclusion
 * Conclusion:** Here is a template you could use (you'll need to change values etc. in the assessment). You can write your conclusion next to your data in a 'text box' (by selecting 'insert', then 'text box') or you could put in on a word doc. You must make sure that your conclusion is in context of what you are trying to find out.
 * 1. The avocado sales between Sep 2000 and Sep 2004 decrease quarterly by 0.0009 millions dollars according to my trendline and calculations.The sales data fluctuates from season to season with higher sales during September and lower sales during June and May. There is an outlier at Sep 2001 which requires further investigation.The trend line and equation could be used to make any future predictions.