Year Make Model Rating Price ($1000) Part a Use the area below to draw a scatter diagram. 1984 Chevrolet Corvette 18 1650.0 1956 Chevrolet Corvette 265/225-hp 19 4100.0 1963 Chevrolet Corvette coupe (340-bhp 4-speed) 18 1050.0 1978 Chevrolet Corvette coupe Silver Anniversary 19 1300.0 1960-1963 Ferrari 250 GTE 2+2 16 390.0 1962-1964 Ferrari 250 GTL Lusso 19 2800.0 1962 Ferrari 250 GTO 18 425.0 1967-1968 Ferrari 275 GTB/4 NART Spyder 17 450.0 1968-1973 Ferrari 365 GTB/4 Daytona 17 170.0 1962-1967 Jaguar E-type OTS 15 72.5 1969-1971 Jaguar E-type Series II OTS 14 59.0 1971-1974 Jaguar E-type Series III OTS 16 110.0 1951-1954 Jaguar XK 120 roadster (steel) 17 390.0 1950-1953 Jaguar XK C-type 16 240.0 au 1956-1957 Jaguar XKSS 13 66.0 co 19 Rating Rating log(Rating) Price ($1000) log (Price) Formula 20 18 1650.0 #N/A #N/A #N/A 19 4100.0 #N/A #N/A #N/A 18 1050.0 #N/A #N/A #N/A Part b 19 1300.0 #N/A #N/A #N/A After reading these instructions delete all text in this shaded area. 16 390.0 #N/A #N/A #N/A 19 2800.0 #N/A #N/A #N/A Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis. 18 425.0 #N/A #N/A #N/A 17 450.0 #N/A #N/A #N/A After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area 117 co 17 170.0 #N/A #N/A #N/A 15 72.5 #N/A #N/A #N/A Your Linear Regression analysis output should fit into this shaded area. 14 59.0 #N/A #N/A #N/A 16 110.0 #N/A #N/A #N/A 390.0 #N/A #N/A #N/A 240.0 #N/A P #N/A #N/A 66.0 #N/A #N/A #N/Am A simple linear regression model | does not appear v @ to be appropriate. . Develop an estimated multiple regression equation with @ = rarity rating and % as the two independent variables. Price=( |+ |Rating+[ |Rating (to whole numbers) What is the value of the coefficient of determination? Note: report R? between 0 and 1. : (to 3 decimals) What is the value of the F test statistic? : (to 2 decimals) What is the p-value? : (to 4 decimals) . Consider the nonlinear relationship shown by equation E(y] = ,Su\"l'. Use logarithms to develop an estimated regression equation for this model. log(Price) = : + \\:I log(Rating) (to 3 decimals) What is the value of the coefficient of determination? Note:! report R? between 0 and 1. : (to 3 decimals) What is the value of the F' test statistic? : (to 2 decimals) What is the p-value? : (to 4 decimals) Do you prefer the estimated regression equation developed in part (b} or part (c)? Explain. The model in part @ is preferred because it provides a better fit