I’m working on a statistics spreadsheet and need support to help me learn.Hello, I need help solving this assignment. I have attached the data file you need to complete the assignment. RequirementsBe sure to create a tab as the first page of the spreadsheet.
On this tab, include your NAME and DATE. (Put X for name and date put May 30, 2021).
The Excel spreadsheet should be an .xlsx file.
If you complete this assignment on a Mac, you must open the Excel spreadsheet on a Windows machine to make sure it works before submitting.
Checklist:Your completed spreadsheet should have the following completed tabs: OVERVIEW (first tab, your name/date), Runs, Autocorrelation, Random Walk, Autoregression, Linear, Exponential, Moving Avgs, Exponential Smoothing, SeasonalityIndex, and SeasonalityRegression.
You may leave Holt and HoltWinters blank. (You will use these tabs in Module 4)
Refer to your textbook chapter 13 for further discussion on Moving Averages and Exponential Smoothing. These two tabs are deliberately left open to use any method you choose. i.e. You can type in the formulas manually, use the tools from the Data Analysis Toolpack in Excel, or use the Palisade tools; but it must be done in Excel. – I will send you chap 13 pages once you accept my assignment to complete.
Requirements: As long as needed to get full points