. Question 12 In order to determine the relationship between the number of units sold of a company's product (y) in 12 cities with their major competitor's price (21) in dollars, and the number of stores ($2) the competitor has in each city, the following data were collected. Units sold Competitor Competitor Price Stores 545 35 3 600 40 2 590 40 2 560 39 3 600 41 600 44 3 590 36 680 45 0 540 40 5 510 35 5 510 35 5 582 36 Generate a linear multiple regression output for the data. a) Report the regression coefficients accurate to 3 decimal places: y= b) Report the coefficient of determination accurate to 3 decimal places: R' =. Question 13 Suppose in a regression analysis to predict house price ($000) using the number of rooms and distance (km) from city's core, the following data were collected. House Price Rooms Distance 1084 5 24 950 3 10 1266 6 17 433 4 88 999 7 40 724 6 81 780 5 61 894 4 32 940 15 645 2 32 647 62 980 5 32 Generate a multiple regression output for the data. a. Find SSE and SSR rounded to the nearest whole number. SSE = SSR = Report the required values in parts b., c., and d. accurate to 3 decimal places: b. R' = c. The standard error of estimate is d. The regression coefficients: b1 = by =. Question 15 A multiple linear regression analysis involves 3 independent variables and 47 observations. The explained variation variation, E(9 - y)? = 206.5, and the coefficient of determination, R" = 0.59. What is the F-statistic for testing the validity of the regression model? The F-stat is: O 26.608 O23.101 O 30.114 O20.626 14.851 O 17.532