Answered step by step
Verified Expert Solution
Link Copied!

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.

  1. 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 ].
  2. 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"] .
  3. 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".
  4. 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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Forensic Accounting

Authors: Michael A Crain, William S Hopwood

2nd Edition

1948306441, 978-1948306447

Students also viewed these General Management questions