GCU MGT655 week 6 assignment

Details:

Complete "Example 13.2: Process Control Chart Design," located in Chapter 13 of the textbook.

Write a 150-300-word paragraph comparing the simple moving average weighted moving average, exponential smoothing, and linear regression analysis time series models.

Complete "Example 18.4: Computing Trend and Seasonal Factor From a Linear Regression Line Obtained With Excel," located in Chapter 18 of the textbook.

Write a 150-300-word paragraph explaining the market research, panel consensus, historical analogy, and Delphi method qualitative forecasting techniques.

Prepare your responses in Excel with each problem on a separate tab.

While APA format is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

You are not required to submit this assignment to Turnitin.

Question:

EXAMPLE 13.2: Process Control Chart DesignAn insurance company wants to design a control chart to monitor whether insurance claim forms are being completed correctly. The company intends to use the chart to see if improvements in the design of the form are effective. To start the process, the company collected data on the number of incorrectly completed claim forms over the past 10 days. The insurance company processes thousands of these forms each day, and due to the high cost of inspecting each form, only a small representative sample was collected each day. The data and analysis are shown in Exhibit 13.6

EXAMPLE 18.4: Computing Trend and Seasonal Factor from a Linear Regression Line Obtained with Excel

Forecast the demand for each quarter of the next year using trend and seasonal factors. Demand for the past two years is in the following