Find some data set where conducting a time series analysis would be appropriate. Preferably the data set should be from your place of employment, but if this is not possible, then you may find any applicable data set on the internet. There is no minimum or maximum number of entries or variables that should be in the data, but the data should be complex enough that meaningful analysis can be conducted. For example, if the data is quarterly, having 16 quarters of data (4 years) should be sufficient for this exercise.
Use the tool of your choice to conduct your analysis, but Microsoft Excel is more than capable of doing this.
In a Word document, complete the following:
- Describe the data set (where you found it, what it means, etc.)
- Conduct a time series analysis
- You must use one of the following: moving average, exponential smoothing, double exponential smoothing, or Holt-Winters method
- Note: Moving average and exponential smoothing is the easiest (and sufficient for this exercise)
- Interpret the output
- Insert images of output into Word document and explain what it means both statistically and in layman’s terms.
3/4 pages double-spaced is sufficient. Include both your analysis and the data set in your submission.
Time Series Analysis (Assignment) Top of Form Find some data set where conducting a time series analysis would be appropriate. Preferably the data set should be from your place of employment, but if this is not possible, then you may find any applicable data set on the internet. There is no minimum or maximum number of entries or variables that should be in the data, but the data should be complex enough that meaningful analysis can be conducted. For example, if the data is quarterly, having 16 quarters of data (4 years) should be sufficient for this exercise. Use the tool of your choice to conduct your analysis, but Microsoft Excel is more than capable of doing this. In a Word document, complete the following: · Describe the data set (where you found it, what it means, etc.) · Conduct a time series analysis · You must use one of the following: moving average, exponential smoothing, double exponential smoothing, or Holt-Winters method · Note: Moving average and exponential smoothing is the easiest (and sufficient for this exercise) · Interpret the output · Insert images of output into Word document and explain what it means both statistically and in layman’s terms. 3/4 pages double-spaced is sufficient. Include both your analysis and the data set in your submission. Bottom of Form