Excel Work

Label each Tab using the corresponding chapter and question number, e.g., Ch12 Q10. If you use multiple tabs for one question label the tabs indicating the parts. e.g., Ch12 Q10 a, Ch12 Q10 b etc.

Chapter 12: Problems 10, 13, 25 (a-c), 47 (a-b)

Additional Questions: • In Problem 10, use the regression equation to predict the revenue in years 2017, 2018, 2019 and 2020. Visualize the time series of actual and predicted revenue values. Interpret the results. • In Problem 13, use the regression equation using GDP data from Q1-1966 through Q4-2007 to predict the revenue from Q1-2008 to Q4-2011. Visualize the time series of actual and predicted revenue values. Interpret the results.

Hint for Question 47 Part a: Add two additional columns to capture quarter and months using the column A values. Month can be computed using MONTH() function. Quarter can be computed using ROUNDUP(MONTH()/3,0) function. Use pivot charts to compare average sales values categorized by month, and another pivot table for average sales values categorized by quarter. Interpreting the findings can help justify the model selection.