Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Open the monthly call volume Download monthly call volumeJMP file and see that it contains four years of monthly call volume data. Answer the following
Open the monthly call volume Download monthly call volumeJMP file and see that it contains four years of monthly call volume data. Answer the following questions in preparation for applying the (1) moving average method of order 5 to examine a level data pattern, and (2) linear regression for seasonality to examine 12 levels of monthly fluctuations.
- Before you can apply the moving average method, you must create a column that contains a running count of [ Select ] ["48", "24", "12", "4"] time periods from Year 1 Month 1 to Year 4 Month 12 to serve as the [ X, Time ID ].
- The column of running count described above is created by right-clicking the "Year" column then selecting [ Select ] ["Formula", "New Formula Column > Row > Lag", "New Formula Column > Row > Row", "Column Properties > Formula", "Cols > Utilities > Make Indicator Columns"] .
- Before you can apply the linear regression for seasonality method, you must create [ Select ] ["12", "3", "11", "4"] columns of dummy variables to represent the values in "Month".
- The columns of dummy variables described above is created by selecting the [ Select ] ["Year", "Row", "Month", "Period"] column then selecting Cols > [ Select ] ["Utilities > Make Indicator Columns", "New Columns", "Column Info", "Formula"]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started