Description This problem involves forecasting techniques only Instructions Question 1 contains the actual values for 12...

Description	This problem involves forecasting techniques only
Instructions	Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two decimal places.

Description

This problem involves forecasting techniques only

Instructions

Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two decimal places.

QUESTION 1

The actual values for 12 periods (shown in order) are:

(1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 57 (7) 64 (8) 58 (9) 68 (10) 66 (11) 72 (12) 75

Using a 5 period simple moving average, the forecast for period 13 will be:

QUESTION 2

Using the 4 period weighted moving average, the forecast for period 13 will be:

QUESTION 3

With exponential smoothing, the forecast for period 13 will be:

QUESTION 4

With linear regression, the forecast for period 13 will be:

QUESTION 5

With quadratic regression, the forecast for period 13 will be:

QUESTION 6

Considering only the forecasts for period 6-12, what is the lowest MAD value for any of the methods?

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Provide a case scenario of a problem (actual or hypothetical) that involves a continuous random variable...

Provide a case scenario of a problem (actual or hypothetical) that involves a continuous random variable X that follows a normal probability distribution. Ideally, it will come from your work or field of study, but it is not absolutely necessary. You will need to use the normal probability rules to solve that problem. Important Note: Email a draft of your problem scenario early in the week to your instructor for him/her to review it and provide feedback early in the...

Question 5 The following is a description of the Time class and its actual Time.h: (A.)...

Question 5 The following is a description of the Time class and its actual Time.h: (A.) Four Member Variables (1.) hour (int) (2.) minute (int) (3.) second (int) (4.) count (static int) (B.) Constructors (Each constructor should increment the count static member variable) (1.) A Default Constructor that initializes the time to 0:00:00 (2.) A Single Parameter Constructor that initializes the time to x:00:00 (where x is the parameter value) (3.) A Double Parameter Constructor that initializes the time to x:y:00...

QUESTION 5 The best approach to forecasting future performance is to focus only on the company's...

QUESTION 5 The best approach to forecasting future performance is to focus only on the company's past earnings. True False QUESTION 8 Management's choice of accounting methods and accrual estimates will not affect valuations based on earnings and book values. True False 4 points QUESTION 9 Abnormal Earnings arise when a company is able to produce earnings that exceed the expected rate of return on equity. True False QUESTION 14 Strategy analysis provides a critical understanding of a company's...

The Problem involves building a 12 – foot diameter sewer at a bottom depth of 40...

The Problem involves building a 12 – foot diameter sewer at a bottom depth of 40 feet in loose sand with a water table at a depth of 8 feet. The alignment is along city streets. The project needs to be completed in 800 days. Determine the amount and types of equipment you feel should be used on this project. The sewer is ten miles in length.

Please answer only Question 12 and 13. Question 12: In reference to the original sequence (shown...

Please answer only Question 12 and 13. Question 12: In reference to the original sequence (shown in Question 8), classify each type of mutation present from Questions 9 to 11. Choose the best option for each. mutation #1 mutation #2 mutation #3 A. base substitution - silent mutation B. insertion - frameshift mutation C. deletion - frameshift mutation D. base substitution - missense mutation E. base substitution - nonsense mutation 3 points QUESTION 13 Questions 9 to...

Problem 1. A set of 25 measurements consists of the values 3 6 7 15 12...

Problem 1. A set of 25 measurements consists of the values 3 6 7 15 12 6 8 4 5 6 5 12 1 3 3 7 5 10 8 3 9 2 6 1 5 (a) Construct a relative frequency histogram to describe the data. (10 pts) (b) Find: the median m (5 pts), the sample mean ¯x (5 pts), the sample standard deviation s (5 pts), the upper and lower quartiles (10 pts), the 37-th percentile (5 pts)....

This question involves coding in RStudio Problem 3 (Verzani problem 2.22): Write a function to compute...

This question involves coding in RStudio Problem 3 (Verzani problem 2.22): Write a function to compute the average distance from the mean for some data vector.

Problem description Write a program that uses a loop to read integer values from the standard...

Problem description Write a program that uses a loop to read integer values from the standard input stream. Each non-zero value, x, is the first number of a sequence. Define a0 = x; an+1 = an / 2 if an is even; an+1 = 3 * an + 1 if an is odd. Then there exists an integer k such that ak = 1. For each non-zero value of x, the program outputs the integer k such that ak =...

PART 1: Design a program (using only native MIPS instructions, no pseudo instructions) that will prompt...

PART 1: Design a program (using only native MIPS instructions, no pseudo instructions) that will prompt user to enter three decimal numbers. Each decimal number will not exceed six digits The program can't ask user how many digits will be entered. Both numbers must be stored in memory as NULL terminated strings. The first number must be stored at the memory address 0x10000000. The second number must be stored in the memory 0x10000008. The third number must be stored at...

This question involves coding in RStudio Problem 3 (Verzani problem 8.18): The data set normtemp (Data...

This question involves coding in RStudio Problem 3 (Verzani problem 8.18): The data set normtemp (Data set can be found in the UsingR package) contains measurements of 130 healthy, randomly selected individuals. The variable temperature contains normal body temperature. Does the data appear to come from a normal distribution? Is so, find a 90% confidence interval for the mean normal body temperature of the population that was sampled. Does it include 98.6 degrees Fahrenheit?

Subjects