C D E of the country. The owners would like to estimate weekly sales revenue as a function of advertising expenditures. Data for a sample of either markets for a recent week follows: ASSIGNMENT: 1) Run a multiple regression using Excel; including Dummy Variables; 2) Include the Residuals and Residual Plot; 3) Answer the same type of questions, we practiced on last week. 4) Comment on the pattern of the residual plot 5) Analyze the B1 for the dummy variables. 9 Market Revenue TV Advertising Newspaper Advertising Rating of Newspaper 10 Fayetteville 101.9 5 1.5 Average 11 Wichita 51.9 3 High 12 Topeka 74.8 4 1.5 Average 13 Little Rock 126.2 4.3 4.3 Average 4 Springfield 137.8 3.6 4 High 15 Tulsa 101.4 3.5 2.3 High 16 Kansas City 237.8 5 8.4 Top Notch 17 Oklahoma City 219.5 6.9 5.8 Top Notch 19 20 1) Identification of Indep and Dep Var 21 24 2) Scatter diagram and general comments (simple regression only) - NOT DONE HERE SINCE IS MULTIPLE REGRESSION 3) Identification and Analysis of Coefficient of Correlation Identification and Analysis of Coefficient of Determination 34 5 4) Identification of Bo (or A or Y intercept) & B1 (or b1 or slope of the line) 36 & B2 (or slope of the line) and Analysis of the Meaning including p value 5) Make a comment about the patter of residuals. Does it look like a random pattem or do you see potential issues with the data? 6) What are the values of the B1 for the dummy variables and what do they mean