The data below shows the demand for frozen dessert pies indicated by Pie sales and the related price and advertising budget. Using a multiple regression approach; – Identify an appropriate regression...

The data below shows the demand for frozen dessert pies indicated by Pie sales and the related price and advertising budget. Using a multiple regression approach; – Identify an appropriate regression equation that can be used to predict pie sales (dependent variable) if price and advertising budget are considered as independent variables. – Find the coefficient of determination and coefficient of correlation – Evaluate the related SST, SSE and SSR – Using the F statistics, test the model for significance (using the appropriate hypothesis tests)


INDIVIDUAL ASSIGNMENT 1 QUANTITATIVE ANALYSIS (ISD 551) INDIVIDUAL ASSIGNMENT 1 QUANTITATIVE ANALYSIS (ISD 551) • The data below shows the demand for frozen dessert pies indicated by Pie sales and the related price and advertising budget. Using a multiple regression approach; – Identify an appropriate regression equation that can be used to predict pie sales (dependent variable) if price and advertising budget are considered as independent variables. – Find the coefficient of determination and coefficient of correlation – Evaluate the related SST, SSE and SSR – Using the F statistics, test the model for significance (using the appropriate hypothesis tests) – NOTE: – Do not use a computer software for this assignment. – Submission should be done on handwritten A2 sheets – SUBMISSION: At the beginning of class next week (27th March, 2021) Week Pie Sales Price ($) Advertising ($100s) 1 350 5.50 3.3 2 460 7.50 3.3 3 350 8.00 3.0 4 430 8.00 4.5 5 350 6.80 3.0 6 380 7.50 4.0 7 430 4.50 3.0 8 470 6.40 3.7 9 450 7.00 3.5 10 490 5.00 4.0 11 340 7.20 3.5 12 300 7.90 3.2 13 440 5.90 4.0 14 450 5.00 3.5 15 300 7.00 2.7