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