Question
In: Statistics and Probability
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized with Solver - pick your own...
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized with Solver - pick your own initial values for the y-axis intercept (a) and slope parameter (b) before optimizing the model The data for this problem is shown in the table below. Note: changes from the original problem data are highlighted in yellow. DO NOT USE the "brute force" method shown in Example 8 on pages 120-121. DO NOT USE the linear regression function from Excel's ToolPak or the LINEST Excel function. Set up a forecasting table and use Excel Solver to optimize it. Time (t) Actual A(t) 1 950 2 930 3 940 4 955 5 972 6 926 7 834 8 840 9 828 10 813 11 don't have yet What is the value for MAD using this method?
Solutions
Expert Solution
MAD = 26.12727
| Period | Demand (y) | Period(x) | Forecast | Error | Absolute | Squared | Abs Pct Err | |
| Period 1 | 950 | 1 | 976.6909 | -26.6909 | 26.69091 | 712.4046 | 02.81% | |
| Period 2 | 930 | 2 | 959.3818 | -29.3818 | 29.38182 | 863.2912 | 03.16% | |
| Period 3 | 940 | 3 | 942.0727 | -2.07273 | 2.072727 | 4.296198 | 00.22% | |
| Period 4 | 955 | 4 | 924.7636 | 30.23636 | 30.23636 | 914.2377 | 03.17% | |
| Period 5 | 972 | 5 | 907.4545 | 64.54545 | 64.54545 | 4166.116 | 06.64% | |
| Period 6 | 926 | 6 | 890.1455 | 35.85455 | 35.85455 | 1285.548 | 03.87% | |
| Period 7 | 834 | 7 | 872.8364 | -38.8364 | 38.83636 | 1508.263 | 04.66% | |
| Period 8 | 840 | 8 | 855.5273 | -15.5273 | 15.52727 | 241.0962 | 01.85% | |
| Period 9 | 828 | 9 | 838.2182 | -10.2182 | 10.21818 | 104.4112 | 01.23% | |
| Period 10 | 813 | 10 | 820.9091 | -7.90909 | 7.909091 | 62.55372 | 00.97% | |
| Total | -1.1E-13 | 261.2727 | 9862.218 | 28.58% | ||||
| Intercept | 994 | Average | -1.1E-14 | 26.12727 | 986.2218 | 02.86% | ||
| Slope | -17.309091 | Bias | MAD | MSE | MAPE | |||
| SE | 35.11093 | |||||||
| Correlation | -0.84546 | |||||||
| Coefficient of determination | 0.714797 |
orchestra answered 1 year agoRelated Solutions
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized with Solver - pick your own...
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized
with Solver - pick your own initial values for the y-axis intercept
(a) and slope parameter (b) before optimizing the model The data
for this problem is shown in the table below. Note: changes from
the original problem data are highlighted in yellow. DO NOT USE the
"brute force" method shown in Example 8 on pages 120-121. DO NOT
USE the linear regression function from Excel's ToolPak or the
LINEST...
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized with Solver - pick your own...
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized
with Solver - pick your own initial values for the y-axis intercept
(a) and slope parameter (b) before optimizing the model The data
for this problem is shown in the table below. Note: changes from
the original problem data are highlighted in yellow. DO NOT USE the
"brute force" method shown in Example 8 on pages 120-121. DO NOT
USE the linear regression function from Excel's ToolPak or the
LINEST...
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized with Solver - pick your own...
Ch 04 HW 3 Forecasting problem Method: Linear Trend optimized
with Solver - pick your own initial values for the y-axis intercept
(a) and slope parameter (b) before optimizing the model The data
for this problem is shown in the table below. Note: changes from
the original problem data are highlighted in yellow. DO NOT USE the
"brute force" method shown in Example 8 on pages 120-121. DO NOT
USE the linear regression function from Excel's ToolPak or the
LINEST...
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution...
Solve the following linear programming problem using Solver. Be
sure to write in your optimal solution below the problem. Max Z =
20X1 + 30X2 + 25X3 + 32X4 s.t. 4X1 + 8X2 + 5X3 + 6X4 ≤ 40 X1 + X2 ≥
3 (X1 + X2) ≤ (X3 + X4) ?1 ?2 ≥ 3 2 X1 = __________ X2 =
___________ X3 = ___________ X4 = ___________ Z = ____________
Solve the following linear programming problem using Solver. Be sure to write in your optimal solution...
Solve the following linear programming problem using Solver. Be
sure to write in your optimal solution below the problem.
Max Z = 20X1 + 30X2 + 25X3 + 32X4
s.t. 4X1 + 8X2 + 5X3 + 6X4 ≤ 40
X1 + X2 ≥ 3
(X1 + X2) ≤ (X3 + X4)
x1/x2 ≥ 3/2
X1 = __________X2 = ___________X3 = ___________X4 = ___________Z
= ____________
Problem 3-9 a. Obtain the linear trend equation for the following data on new checking accounts...
Problem 3-9
a.
Obtain the linear trend equation for the following data on new
checking accounts at Fair Savings Bank and use it to predict
expected new checking accounts for periods 16 through 19.
(Round your intermediate calculations and final answers to
2 decimal places.)
Period
New
Accounts
Period
New
Accounts
Period
New
Accounts
1
200
6
231
11
281
2
213
7
244
12
275
3
211
8
250
13
286
4
222
9
254...
In your own words, describe why forecasting risk is a problem that needs to be addressed...
In your own words, describe why forecasting risk is a problem
that needs to be addressed by financial
analysts/managers.
For this problem you will be creating your own linear model for data of your choosing....
For this problem you will be creating your own linear model for
data of your choosing. Please do the following: • Find a data set
that you believe to be linear. You can measure and collect your own
data or search the internet. Be sure to cite where you get your
data. • Plot the data on a coordinate plane. Include a link to this
graph in your submission of this assignment. • Approximate a slope
and intercept for your...
Solve the following linear programming problem using generalised simplex method Maximise z= 2x1+3x2 subject to -2x1+x2>=3...
Solve the following linear programming problem using generalised
simplex method
Maximise z= 2x1+3x2
subject to -2x1+x2>=3
3x1+x2<=5
x1,x2>=0
3) Explain in your own words the Economic Calculation Problem. How would you use the insights...
3) Explain in your own words the Economic Calculation Problem.
How would you use the insights of the Economic Calculation Problem
to understand an event that you have observed in your life, an
event from the news, or an event in your life?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- In order to manage change and implement change strategies, it is important to avoid implementing irrelevant...
- Smoky Mountain Corporation makes two types of hiking boots—Xtreme and the Pathfinder. Data concerning these two...
- Drug delivery systems are often ‘pelletized’ as spheres. Construct the control volume. Determine the continuity equation...
- NIST cybersecurity framework. Summarize the purpose, approach, goals, and scope of this topic publication.( cite references)
- Site for the significance of vitamins in the body
- 1) What are a few (name at least three) important values in Japanese culture? 2) What...
- S&P 500 Index is at 2780. A European June 21, 2019 SPX call option struck at...
ADVERTISEMENT