In: Statistics and Probability
The monthly ambulatory visit shown in the Table below occurred in an outpatient clinic.
month | visits |
July | 2160 |
august | 2186 |
September | 2246 |
october | 2251 |
november | 2243 |
december | 2162 |
Solve using Excel:
Part a: α = 0.3.
α | 0.3 | |||
Month | Actual (A) | Foercast (F) | A-F | (A-F)2 |
July | 2160 | 2160.00 | 0.00 | 0.00 |
August | 2186 | 2160.00 | 26.00 | 676.00 |
September | 2246 | 2167.80 | 78.20 | 6115.24 |
October | 2251 | 2191.26 | 59.74 | 3568.87 |
November | 2243 | 2209.18 | 33.82 | 1143.66 |
December | 2162 | 2219.33 | -57.33 | 3286.43 |
January | 2202.13 | |||
MSE | 2465.03 | |||
Month | Actual (A) | Foercast (F) | A-F | (A-F)2 |
July | 2160 | =B3 | =B3-C3 | =D3^2 |
August | 2186 | =C3+$C$1*D3 | =B4-C4 | =D4^2 |
September | 2246 | =C4+$C$1*D4 | =B5-C5 | =D5^2 |
October | 2251 | =C5+$C$1*D5 | =B6-C6 | =D6^2 |
November | 2243 | =C6+$C$1*D6 | =B7-C7 | =D7^2 |
December | 2162 | =C7+$C$1*D7 | =B8-C8 | =D8^2 |
January | =C8+$C$1*D8 | |||
MSE | =AVERAGE(E3:E8) |
January = 2202.13
Part b: α = 0.5
α | 0.5 | |||
Month | Actual (A) | Foercast (F) | A-F | (A-F)2 |
July | 2160 | 2160.00 | 0.00 | 0.00 |
August | 2186 | 2160.00 | 26.00 | 676.00 |
September | 2246 | 2173.00 | 73.00 | 5329.00 |
October | 2251 | 2209.50 | 41.50 | 1722.25 |
November | 2243 | 2230.25 | 12.75 | 162.56 |
December | 2162 | 2236.63 | -74.63 | 5568.89 |
January | 2199.31 | |||
MSE | 2243.12 | |||
Month | Actual (A) | Foercast (F) | A-F | (A-F)2 |
July | 2160 | =H3 | =H3-I3 | =J3^2 |
August | 2186 | =I3+$I$1*J3 | =H4-I4 | =J4^2 |
September | 2246 | =I4+$I$1*J4 | =H5-I5 | =J5^2 |
October | 2251 | =I5+$I$1*J5 | =H6-I6 | =J6^2 |
November | 2243 | =I6+$I$1*J6 | =H7-I7 | =J7^2 |
December | 2162 | =I7+$I$1*J7 | =H8-I8 | =J8^2 |
January | =I8+$I$1*J8 | |||
MSE | =AVERAGE(K3:K8) |
January = 2199.31
Part c: α = 0.0
α | 0 | |||
Month | Actual (A) | Foercast (F) | A-F | (A-F)2 |
July | 2160 | 2160.00 | 0.00 | 0.00 |
August | 2186 | 2160.00 | 26.00 | 676.00 |
September | 2246 | 2160.00 | 86.00 | 7396.00 |
October | 2251 | 2160.00 | 91.00 | 8281.00 |
November | 2243 | 2160.00 | 83.00 | 6889.00 |
December | 2162 | 2160.00 | 2.00 | 4.00 |
January | 2160.00 | |||
MSE | 3874.33 | |||
Month | Actual (A) | Foercast (F) | A-F | (A-F)2 |
July | 2160 | =N3 | =N3-O3 | =P3^2 |
August | 2186 | =O3+$O$1*P3 | =N4-O4 | =P4^2 |
September | 2246 | =O4+$O$1*P4 | =N5-O5 | =P5^2 |
October | 2251 | =O5+$O$1*P5 | =N6-O6 | =P6^2 |
November | 2243 | =O6+$O$1*P6 | =N7-O7 | =P7^2 |
December | 2162 | =O7+$O$1*P7 | =N8-O8 | =P8^2 |
January | =O8+$O$1*P8 | |||
Related SolutionsThe nurse manager of an ambulatory care clinic has noted an increased number of visits by...The nurse manager of an ambulatory care clinic has noted an
increased number of visits by patients from different countries and
cultures, including patients from Mexico and other Latin American
countries. Concerned about meeting the needs of this culturally
diverse population, the nurse manager convenes a staff meeting to
discuss this change in patient demographics, and to query the staff
about any learning needs they have related to the care of these
patients. (Learning Objective 3) What strategy to avoid...
The nurse manager of an ambulatory care clinic has noted an increased number of visits by...The nurse manager of an ambulatory care clinic has
noted an increased number of visits by patients from different
countries and cultures, including patients from Mexico and other
Latin American countries. Concerned about meeting the needs of this
culturally diverse population, the nurse manager convenes a staff
meeting to discuss this change in patient demographics, and to
query the staff about any learning needs they have related to the
care of these patients. ( Learning objective 3).
a. What strategy...
An auto dealer's sales numbers are shown in the table below. Find for each month the...An auto dealer's sales numbers are shown in the table below.
Find for each month the mean, median, and mode prices of the cars
she sold. Round your answers to the nearest dollar.
Number sold
Price
May
June
July
$25,000
22
25
24
$15,000
49
24
24
$13,500
25
49
49
June
mean
$
median
$
mode
$
July
mean
$
median
$
mode
$
An auto dealer's sales numbers are shown in the table below. Find for each month the...An auto dealer's sales numbers are shown in the table below.
Find for each month the mean, median, and mode prices of the cars
she sold. Round your answers to the nearest dollar.
Number sold
Price
May
June
July
$25,000
22
25
24
$15,000
49
24
24
$13,500
25
49
49
May
mean
$
median
$
mode
$
June
mean
$
median
$
mode
$
July
mean
$
median
$
mode
v Consider the monthly time series shown in the table. Month t Y January 1 185...v
Consider the monthly time series shown in the table.
Month
t
Y
January
1
185
February
2
192
March
3
189
April
4
201
May
5
195
June
6
199
July
7
206
August
8
203
September
9
208
October
10
209
November
11
218
December
12
216
Use the method of least squares to fit the model E(Yt) = β0 +
β1t to the data. Write the prediction equation.
Use the prediction equation to obtain forecasts for the...
Consider the monthly time series shown in the table. Month t Y January 1 185 February...Consider the monthly time series shown in the table.
Month
t
Y
January
1
185
February
2
192
March
3
189
April
4
201
May
5
195
June
6
199
July
7
206
August
8
203
September
9
208
October
10
209
November
11
218
December
12
216
Use the method of least squares to fit the model E(Yt) = β0 +
β1t to the data. Write the prediction equation.
Use the prediction equation to obtain forecasts for the next...
Five years of a well-established brand’s monthly sales volume data are shown in the table below....Five years of a well-established brand’s monthly sales volume
data are shown in the table below. As may be noted, there is
substantial seasonality in this brand's sales.
Forecaster Simulation: Problem #3 Data
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
January
5550
4782
5283
4760
4314
February
5398
4897
4544
4930
4476
March
4236
4693
4370
4930
4476
April
2977
3747
2419
3065
3350
May
2345
2235
2463
2546
2274
June
1198
1156
1887
1602...
The table below shows monthly beer sales at Gordon’s Liquor Store in 2017. Month Sales Jan...The table below shows monthly beer
sales at Gordon’s Liquor Store in 2017.
Month
Sales
Jan
900
Feb
725
Mar
1000
Apr
800
May
750
Jun
1200
Jul
1000
Aug
1100
Sep
1250
Oct
1050
Nov
1400
Dec
1600
Jan
Forecast beer sales needed for January
2018 using an exponential smoothing method
α = 0.2, α = 0.4 and α = 0.9
Plot the data and identify the method to forecast
the beer sales
2. Table below shows monthly beer sales at Gordon’s Liquor Store in 2017. Month Sales Jan...2. Table below shows monthly beer sales at Gordon’s Liquor Store
in 2017.
Month
Sales
Jan
900
Feb
725
Mar
1000
Apr
800
May
750
Jun
1200
Jul
1000
Aug
1100
Sep
1250
Oct
1050
Nov
1400
Dec
1600
Jan
a) Forecast beer sales needed for January 2018 using an
exponential smoothing method
α = 0.2, α = 0.4 and α = 0.9
b) Compute an adjusted exponential smoothing for the data
using:
α = 0.3 and β = 0.5,...
Consider monthly demand for the ABC Corporation as shown below. Forecast the monthly demand for Year...Consider monthly demand for the ABC
Corporation as shown below. Forecast the monthly demand for Year 6
using the 3-period moving average and 4-period moving average.
Evaluate the bias, TS, MAD, MAPE and MSE. Evaluate the quality of
the forecast
Sales
Year 1
Year 2
Year 3
Year 4
Year 5
JAN
2000
3000
2000
5000
5000
FEB
3000
4000
5000
4000
2000
MAR
3000
3000
5000
4000
3000
APR
3000
5000
3000
2000
2000
MAY
4000
5000
4000
5000...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|