FRANCIS Quantitative Data Analysis Statistics Excelsheet Help
FRANCIS Quantitative Data Analysis Statistics Excelsheet Help
Attached is the excel doc and pictures of the problems.
For #4 and #5, please use this file: Table7.11.xlsx
#4 – Complete #7 on p.474 of your course text.
A and b) what is your forecast for June?
#5 – Complete #8 on p.474 of your course text. (Note: For 8b, there is a typo in the book. It refers to problem 11 and 12 but it really means table 7.11 and table 7.12)
A) what is your forecast for June? |
B) Don’t do b. |
#6 – Complete #17 on p. 477 of your course text.
Winter Seasonal Index |
Spring Season Index |
Summer Seasonal Index |
Fall Seasonal Index |