Question
In: Statistics and Probability
Year No. Year Students Enrolled in QM Exponentially Smoothed Forecast (α = .30) 1 2014 –...
|
Year No. |
|
|
|
|
1 |
2014 – 2015 |
439 |
|
|
2 |
2015 – 2016 |
444 |
|
|
3 |
2016 – 2017 |
462 |
|
|
4 |
2017 – 2018 |
467 |
|
|
5 |
2018 – 2019 |
What is the Exponentially Smoothed Forecast for year 5?
|
Year No. |
|
|
|
Trend |
Adjusted |
|
1 |
2014 – 2015 |
439 |
- |
||
|
2 |
2015 – 2016 |
444 |
439 |
||
|
3 |
2016 – 2017 |
462 |
441 |
||
|
4 |
2017 – 2018 |
467 |
449.4 |
||
|
5 |
2018 – 2019 |
456.44 |
What is the trend for year 2?
What is the trend for year 3?
What is the adjusted exponentially smoothed forecast for year 3?
What is the trend for year 4?
What is the adjusted exponentially smoothed forecast for year 4?
What is the forecast for year 5 using linear regression.
Solutions
Expert Solution
What is the Exponentially Smoothed Forecast for year 5?
452.97
| Alpha | 0.3 | ||||||
| Data | Forecasts and Error Analysis | ||||||
| Period | Demand | Forecast | Error | Absolute | Squared | Abs Pct Err | |
| Period 1 | 439 | 439 | 0 | 0 | 0 | 00.00% | |
| Period 2 | 444 | 439 | 5 | 5 | 25 | 01.13% | |
| Period 3 | 462 | 440.5 | 21.5 | 21.5 | 462.25 | 04.65% | |
| Period 4 | 467 | 446.95 | 20.05 | 20.05 | 402.0025 | 0.0429336 | |
| Total | 46.55 | 46.55 | 889.2525 | 10.07% | |||
| Average | 11.6375 | 11.6375 | 222.3131 | 02.52% | |||
| Bias | MAD | MSE | MAPE | ||||
| SE | 21.08616 | ||||||
| Next period | 452.965 |
What is the trend for year 2?
447.9
What is the trend for year 3?
458.1
What is the adjusted exponentially smoothed forecast for year 3?
441
What is the trend for year 4?
468.3
What is the adjusted exponentially smoothed forecast for year 4?
449.4
What is the forecast for year 5 using linear regression.
478.5
| Data | Forecasts and Error Analysis | |||||||
| Period | Demand (y) | Period(x) | Forecast | Error | Absolute | Squared | Abs Pct Err | |
| Period 1 | 439 | 1 | 437.7 | 1.3 | 1.3 | 1.69 | 00.30% | |
| Period 2 | 444 | 2 | 447.9 | -3.9 | 3.9 | 15.21 | 00.88% | |
| Period 3 | 462 | 3 | 458.1 | 3.9 | 3.9 | 15.21 | 00.84% | |
| Period 4 | 467 | 4 | 468.3 | -1.3 | 1.3 | 1.69 | 00.28% | |
| Total | 0 | 10.4 | 33.8 | 02.30% | ||||
| Intercept | 427.5 | Average | 0 | 2.6 | 8.45 | 00.57% | ||
| Slope | 10.2 | Bias | MAD | MSE | MAPE | |||
| SE | 4.110961 | |||||||
| Forecast | 478.5 | 5 | ||||||
| Correlation | 0.969015 | |||||||
| Coefficient of determination | 0.938989 |
| Alpha | 0.4 | ||||||||
| Beta | 0.2 | ||||||||
| Data | Forecasts and Error Analysis | ||||||||
| Period | Demand | Smoothed Forecast, Ft | Smoothed Trend, Tt | Forecast Including Trend, FITt | Error | Absolute | Squared | Abs Pct Err | |
| Period 1 | 439 | 439 | 439 | 0 | 0 | 0 | 00.00% | ||
| Period 2 | 444 | 439 | 0 | 439 | 5 | 5 | 25 | 01.13% | |
| Period 3 | 462 | 441 | 21 | 21 | 441 | 04.55% | |||
| Period 4 | 467 | 449.4 | 17.6 | 17.6 | 309.76 | 0.037687 | |||
| Total | 43.6 | 43.6 | 775.76 | 09.44% | |||||
| Average | 10.9 | 10.9 | 193.94 | 02.36% | |||||
| Bias | MAD | MSE | MAPE | ||||||
| SE | 19.69467 |
orchestra answered 2 years agoRelated Solutions
Using exponential smoothing with α of 0.1 and the given forecast for year 1
As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years: Year12345Heart Transplants46.048.055.057.057.0The director of medical services predicted 6 years ago that demand in year 1 would be 42.0 surgeries a) Using exponential smoothing with α of 0.1 and the given forecast for year 1, the forecasts for years 2 through 6 are (round your responses to one decimal place): Year123456Forecast42.0For the forecast made using exponential smoothing with α...
Guessing the class average game: Suppose we have 30 students enrolled in intermediate microeconomics class and...
Guessing the class average game:
Suppose we have 30 students enrolled in intermediate
microeconomics class and everyone participates in the game to guess
the class average. Each student can pick an integer between 0 and
100( with 0 and 100 included), whoever picks the number that is
closest to the class average( calculated from all the guessed
numbers) will be the winner(s). What is (are) the Nash Equilibrium(
Equilibria) for this game? Explain.(1 point)
Guessing the 1/3 of class average...
For students who first enrolled in two year public institutions in a recent semester, the proportion...
For students who first enrolled in two year public institutions
in a recent semester, the proportion who earned a bachelor's
degree within six years was
0.396
The president of a certain college believes that the proportion
of students who enroll in her institution have a
lower
completion rate.
(a)
Determine the null and alternative hypotheses.
(b)
Explain what it would mean to make a Type I error.
(c)
Explain what it would mean to make a Type II error.
(a)...
For students who first enrolled in two year public instituitons in a recent semester, the proportion...
For students who first enrolled in two year public instituitons
in a recent semester, the proportion who earned a bachelor's degree
within six years was 0.388. The president of a certain college
believes that the proportion of students who enroll in her
institution have a higher completion rate.
A.) Determine the null & alternative hypotheses.
B.) Explain what it would mean to make a Type I error.
C.) Explain what it would mean to make a Type II error.
A.)...
1.The population of India in the year 2000 was 1 billion and it increased exponentially at...
1.The population of India in the year 2000 was 1 billion and it
increased exponentially at a rate of 1.6% per year. If the growth
rate is maintained, what will be the population in the year 2020?
If the growth rate is decreased to 1.2% per year from 2020 onwards
and is maintained at that level, what will be the population in the
year 2050? Assuming the average human exhales 2.3 pounds of carbon
dioxide on an average day, what...
A random sample of 12 second-year university students enrolled in a business statistics course was drawn....
A random sample of 12 second-year university students enrolled
in a business statistics course was drawn. At the course's
completion, each student was asked how many hours he or she spent
doing homework in statistics. The data are listed below.
40, 41, 29, 30, 31, 31, 34, 29, 37, 41, 37, 40
It is known that the population standard deviation is 8. The
instructor has recommended that students devote 3 hours per week
for the duration of the 12-week semester,...
A random sample of 12 second-year university students enrolled in a business statistics course was drawn....
A random sample of 12 second-year university students enrolled
in a business statistics course was drawn. At the course's
completion, each student was asked how many hours he or she spent
doing homework in statistics. The data are listed below.
281726262620292823271820282626292318172620282720
It is known that the population standard deviation is 9. The
instructor has recommended that students devote 2 hours per week
for the duration of the 12-week semester, for a total of 24 hours.
Test to determine whether there...
A study of 60,000 college students (enrolled in 4-year programs) from around the U.S. looked at...
A study of 60,000 college students (enrolled in 4-year programs)
from around the U.S. looked at the high school GPA for each student
and their College GPA at the end of their first full year of
college. The following summary statistics were recorded.
Avg(x) = 3.44, SDx = 0.66, Avg(y) = 3.25, SDy = 0.77, r =
0.6
where xj =HS GPA of the jth student and
yj =FY GPA of the jth student.
Based on this data:
(a) Find...
A study of 60,000 college students (enrolled in 4-year programs) from around the U.S. looked at...
A study of 60,000 college students (enrolled in 4-year programs)
from around the U.S. looked at the high school GPA for each student
and their College GPA at the end of their first full year of
college. The following summary statistics were recorded.
Avg(x) = 3.44, SDx = 0.66, Avg(y) = 3.25, SDy = 0.77, r =
0.6
where xj =HS GPA of the jth student and
yj =FY GPA of the jth student.
Based on this data:
(a) Find...
A random sample of 12 second-year university students enrolled in a business statistics course was drawn....
A random sample of 12 second-year university students enrolled
in a business statistics course was drawn. At the course’s
completion, each student was asked how many hours he or she spent
doing homework in statistics. The data are listed here. It is know
that the population standard deviation is 8. The instructor has
recommended that the students devote 36 hours to the course for the
semester. Test to determine at the 1% significance level whether
there is evidence that the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What are the accounts that make up Shareholder’s Equity on the Balance Sheet?
- Problem 18-5 Beta and Leverage North Pole Fishing Equipment Corporation and South Pole Fishing Equipment Corporation...
- Stenson, Inc., imposes a payback cutoff of three years for its international investment projects. Assume the...
- Mayfield Company sells two products, Blue models and Plaid models. Blue models sell for $41per unit...
- Write an overview of common concerns about adolescent development. Cite any sources.
- When a company has positive net income, does that also mean they have positive cash flows?...
- Consider a project with an initial investment of $60,000, a 6 year usefule life (and study...
ADVERTISEMENT