b. 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 between 0 and 1 (to 3 decimals) What is the value of the test statistic? (to 2 decimals) What is the p-value? (to 4 decimals) c. Consider the nonlinear relationship shown by equation Ely) - pop. Use logarithms to develop an estimated regression equation for this model log(Price) - + 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) d. Do you prefer the estimated regression equation developed in part (b) or part (c)? Explain. 1 Year Make Model Chevet Corvette 1966 Crew Corvette 265/225 hp De Chevrolet Corvette coupe (140-ho- Chevrolet Corvette coupe Silver Anniversary 1860-1963 Ferrari 250 GTE 22 1062-1964 Ferrari 250 GTL La Ferrari 250 GTO Format 275 GTB NART Spyder 1966-1973 Ferrari 365 TB4 Daytona Jaguar E-type OTS 12 1960-1971 Jaguar E-type Soll OTS 1971-1974 Jaguar E-type Series OTS 1951-1954 Jaguar XK 120 ratel) 1950-1950 Jaguar XK C-type T956-1957 Jaguar XKSS Rating Price (1000) 18 15.500 10 41000 18 10000 10 13500 16 3600 2500 18 3750 17 4000 17 1700 15 72.5 14 580 10 1200 17 3700 16 280.0 13 700 10 14 15 16 17 18 19 20 21 22 Rating! lop Rating Part b F - F After reading these instructions delete text in this sh WNIA WNIA NA Use the XL Miner Analysis ToolPak to conduct your Lin Rating 18 19 18 19 18 19 18 17 17 15 14 16 17 10 Price (51000) logiPrice Formula 1550,0 SNA F ANIA 4100.0 10000 UNIA F 13500 INA 3000 F 28500 3750 400.0 NIA 170.0 F 72.5 FONIA F 58.0 120.0 WNA F 370.0 #NA 280.0 NA ANIA ONA WNIA NA ANIA NA INA NA ANIA #N/A ANIA NA ANIA MMA UNA UNIA NA WNIA ANJA WNIA ANIA UNIA #NA ANIA SINIA #NA ANA DNIA NA Aher deleting alles in this shaded aren, set the out Your Linear Regression analysis output should find F 27 20 29 30 31 NA F F NA 11 b. 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 between 0 and 1 (to 3 decimals) What is the value of the test statistic? (to 2 decimals) What is the p-value? (to 4 decimals) c. Consider the nonlinear relationship shown by equation Ely) - pop. Use logarithms to develop an estimated regression equation for this model log(Price) - + 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) d. Do you prefer the estimated regression equation developed in part (b) or part (c)? Explain. 1 Year Make Model Chevet Corvette 1966 Crew Corvette 265/225 hp De Chevrolet Corvette coupe (140-ho- Chevrolet Corvette coupe Silver Anniversary 1860-1963 Ferrari 250 GTE 22 1062-1964 Ferrari 250 GTL La Ferrari 250 GTO Format 275 GTB NART Spyder 1966-1973 Ferrari 365 TB4 Daytona Jaguar E-type OTS 12 1960-1971 Jaguar E-type Soll OTS 1971-1974 Jaguar E-type Series OTS 1951-1954 Jaguar XK 120 ratel) 1950-1950 Jaguar XK C-type T956-1957 Jaguar XKSS Rating Price (1000) 18 15.500 10 41000 18 10000 10 13500 16 3600 2500 18 3750 17 4000 17 1700 15 72.5 14 580 10 1200 17 3700 16 280.0 13 700 10 14 15 16 17 18 19 20 21 22 Rating! lop Rating Part b F - F After reading these instructions delete text in this sh WNIA WNIA NA Use the XL Miner Analysis ToolPak to conduct your Lin Rating 18 19 18 19 18 19 18 17 17 15 14 16 17 10 Price (51000) logiPrice Formula 1550,0 SNA F ANIA 4100.0 10000 UNIA F 13500 INA 3000 F 28500 3750 400.0 NIA 170.0 F 72.5 FONIA F 58.0 120.0 WNA F 370.0 #NA 280.0 NA ANIA ONA WNIA NA ANIA NA INA NA ANIA #N/A ANIA NA ANIA MMA UNA UNIA NA WNIA ANJA WNIA ANIA UNIA #NA ANIA SINIA #NA ANA DNIA NA Aher deleting alles in this shaded aren, set the out Your Linear Regression analysis output should find F 27 20 29 30 31 NA F F NA 11
