A company shows the following historical sales data (Table 4):

a. Run the linear regression model and obtain the ANOVA table.

b. Make a prediction of the quantity sold for year 2019 and build the prediction interval at 95%.

c. Use the built-in Excel Forecast Sheet to make a sale prediction for 2019.

d. Plot the results. 5. The parent company revenues and the branch revenues of a company, over 3 years and by quarter, are compared in Table

Transcribed Image Text:

TABLE 4 Quantities Sold Year n 2010 -4 99,600 2011 -3 99,300 2012 -2 95,500 2013 -1 91,500 2014 0 88,600 2015 1 86,400 2016 2 83,600 2017 3 78,200 2018 4 75,800