PART C - Prediction Analysis Once you have finalized your prediction models, answer the following question: Royal Pizza has just opened a new pizzeria covering 4,600 square feet in a ZIP Code with a population of 44,500 people and 9 competing restaurants. The company is planning to spend $21,500 in Internet advertising and $15,500 in radio advertising in the first year of operation. What are the projected sales of this new pizzeria for the first year? You should have 6 answers: 1 from each of the 5 SLR equations, and 1 from the MLR equation. Be sure to include both a quick 95% confidence interval and quick 95% prediction interval for each of the 6 answers. PART D - Project Report Please use the following format for your project report: Introduction: Explain the background of the organization and the goals you are attempting to accomplish on behalf of the organization. SLR Models and Analyses: Include a separate section for each of the 5 bivariate analyses. Identify the dependent and independent variables for each regression model. Explain how well the variables fit the model. Explain the outcome of your regression analysis for each model. Hint: list and interpret certain calculations such as r, R2, the Significance of F p-value, the p-values of the relevant coefficients, etc. for each model. MLR Model and Analysis: Include a separate section for the multivariate analysis. Identify the dependent and independent variables for the regression model. Explain how well the variables fit the model. Explain the outcome of your regression analysis. Hint: list and interpret certain calculations such as R2, Adjusted R2, the Significance of F p-value, the p-values of the relevant coefficients, the results of testing for collinearity from the correlation matrix, the results of testing for multicollinearity from the Variance Inflation Factor calculations, etc. for the model. Prediction Analysis: Include a separate section to answer the prediction analysis question using the 6 regression equations from above. Include the quick 95% confidence interval and quick 95% prediction interval for each answer and explain your findings. Clipboard Xvfx Font Alignment Number Styles B C D E F G H I SUIVIMARY OUTPUT J K 1.0 2.0 Sales and Size y 142.01x 22.18 = R = 0.7901 3.0 4.0 5.0 Size of Pizzeria (in thousands of square feet) Regression Statistics Multiple R R Square 0.88887211 0.79009363 Adjusted R Sc 0.78259698 Standard Errc 90.824543 Observations 30 Format Cells Editing Add-ins ANOVA df Regression Residual 1 SS 869395.57 MS 28 230974.733 869395.5701 8249.097604 Total 29 1100370.3 Intercept SIZE Coefficients Standard Erro -22.18034 62.5482833 142.006959 13.8326101 t Stat -0.354611484 M N P F 105.3928092 Significance F 5.37321E-11 10.2661 P-value 0.725537626 5.37321E-11 Lower 95% Upper 95% Lower 95.0 -150.3046897 105.944011 -150.3046 113.6721413 170.341776 113.67214 RESIDUAL OUTPUT 6.0 7.0 8.0 PROBABILITY OUTPUT Observation 'redicted SALE 1 432.241928 2 318.636361 2 707 750275 -0.78482866 -0.674956043 0167030107 SLR Sales and Population SLR Sales and Competition Correlation Matrix Pizze + Residuals -70.041928 -60.236361 Standard Residuals Percentile 1.666666667 11 5106751 SALES 255.4 5 258.4 222222222 763 0 11 SLR Sales and Size SLR Sales and Internet Ads SLR Sales and Radio Ads DATA DICTIONARY Annual Gross Sales (thousands of dollars) Size of Pizzeria (thousands of square feet) INTERNET ADSAnnual Internet Advertising Expense (thousands of do RADIO ADS Annual Radio Advertising Expense (thousands of dolla POPULATION Number of People in ZIP Code (thousands of people) COMPETITIONNumber of Competing Restaurants in ZIP Code ES SIZE INTERNET ADS RADIO ADS POPULATION COMPETITION 362.2 3.2 12.7 13.3 27.8 15 258.4 2.4 10.2 12.0 15.0 16 SALES SIZE 801.8 5.7 25.2 17.1 52.4 5 669.4 4.6 23.9 15.7 46.2 9 746.5 5.0 24.2 16.9 41.9 8 471.3 3.3 21.5 13.2 33.8 14 306.4 2.7 14.8 12.8 28.4 16 866.6 5.6 33.2 22.5 40.6 665.4 4.4 24.3 15.6 45.8 11 720.1 4.9 22.7 16.4 49.0 7 611.0 4.5 14.5 10.6 52.1 8 263.8 2.8 8.5 12.3 21.8 17 614.4 4.0 19.3 15.5 45.5 11 764.9 5.5 22.0 16.6 53.0 5 809.1 5.8 26.0 17.4 52.1 4 536.3 3.8 19.4 14.7 37.4 10 530.6 3.7 16.3 14.9 38.0 9 783.7 5.3 24.9 17.1 51.2 4 621.0 7.2 21.9 12.1 39.6 12 360.5 3.2 12.4 13.3 27.8 15 255.4 2.4 9.8 12.0 15.0 16 795.3 5.7 25.2 17.1 52.4 5 671.5 4.6 23.8 15.7 46.2 9 743.1 5.0 24.0 16.9 41.9 8 464.2 3.3 21.7 13.2 33.8 14 315.0 2.7 14.5 12.8 28.4 16 869.6 5.6 33.0 22.5 40.6 5 660.8 4.4 24.2 15.6 45.8 11 614.5 4.0 19.2 15.5 45.5 11 756.3 5.5 21.7 16.6 53.0 5