Question

In: Statistics and Probability

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?

Expert Solution

orchestra answered 2 years ago

Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create...

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...

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...

The primary difference between demand management and demand forecasting is 1) forecasting is only possible when...

The primary difference between demand management and demand forecasting is 1) forecasting is only possible when quantitative data are available. 2) demand management is proactive, while forecasting attempts to predict. 3) a firm cannot execute both approaches simultaneously. 4) one approach deals with uncertainty, while the other deals with known demand.

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...

Choose only one problem: 1- Write a multithreaded program that calculates various statistical values for a...

Choose only one problem: 1- Write a multithreaded program that calculates various statistical values for a list of numbers. This program will be passed a series of numbers on the command line and will then create three separate worker threads. One thread will determine the average of the numbers, the second will determine the minimum value, and the third will determine the maximum value. The variables representing the average, minimum, and maximum values will be stored globally. The worker threads...

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.