Quantitative Analysis
Attached is the excel document that lists the table.
The pictures of the problems are attached.
For # 1 through #3, please use this file Table7.10.xlsx
#1 – Complete #4 on p.473 of your course text but you don’t need to use Excel for the moving average, you can design your own formula. For part b, please also calculate both the MAD and MAPE.
|
|
b) What is the MAD? |
|
b2) What is the MAPE? |
#2 – Complete #5 on p.473 of your course text but you don’t need to use Excel for the moving average, you can design your own formula. For part b, please also calculate both the MAD and MAPE.
|
|
b) What is the MAD? |
|
b2) What is the MAPE? |
#3 – Complete #6 on p.474 of your course text but you don’t need to use Excel for the weighted moving average, you can design your own formula. For part b, please also calculate both the MAD and MAPE.
|
|
b2) What is the MAPE? |
