Homework Help is Here – Start Your Trial Now!
Math
Statistics
During the past five months the emergency room at the new district Hospital has observed the number of patients during the weekend (Friday through Sunday). They typically experience greater patient traffic on weekends than during the week. WEEK NO. OF PATIENTS 1 105 2 119 3 122 4 128 5 117 6 136 7 141 8 126 9 143 10 140 a) Compute a weighted three-period moving average forecast, using weights of 3, 2, and 1 for the most recent, next recent, and most distant data. b) What are the MAD, MSE and the MPE for this method? c) If the company decided to forecast using exponential smoothing with value of alpha =.3, what is the forecast in month 11? (use 2 decimal places)

During the past five months the emergency room at the new district Hospital has observed the number of patients during the weekend (Friday through Sunday). They typically experience greater patient traffic on weekends than during the week. WEEK NO. OF PATIENTS 1 105 2 119 3 122 4 128 5 117 6 136 7 141 8 126 9 143 10 140 a) Compute a weighted three-period moving average forecast, using weights of 3, 2, and 1 for the most recent, next recent, and most distant data. b) What are the MAD, MSE and the MPE for this method? c) If the company decided to forecast using exponential smoothing with value of alpha =.3, what is the forecast in month 11? (use 2 decimal places)

Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter7: Distance And Approximation
Section7.3: Least Squares Approximation
Problem 31EQ
See similar textbooks
icon
Related questions
Topic Video
Question

During the past five months the emergency room at the new district Hospital has observed the number of patients during the weekend (Friday through Sunday). They typically experience greater patient traffic on weekends than during the week.

WEEK

NO. OF PATIENTS

1

105

2

119

3

122

4

128

5

117

6

136

7

141

8

126

9

143

10

140

a) Compute a weighted three-period moving average forecast, using weights of 3, 2, and 1 for the most recent, next recent, and most distant data.

b) What are the MAD, MSE and the MPE for this method?

c) If the company decided to forecast using exponential smoothing with value of alpha =.3, what is the forecast in month 11? (use 2 decimal places)

Expert Solution
steps

Step by step

Solved in 3 steps with 16 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Proportions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
SEE MORE TEXTBOOKS