Corvette, Ferrari, and Jaguar produced a variety of classic cars that continue to increase in value. The data showing the rarity rating (1–20) and the high price ($1000s) for 15 classic cars is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Excel template - SavedK220212223242526272829File303132333435363738HomeRating1819181916AB1YearMake21984Chevrolet Corvette31956Chevrolet Corvette 265/225-hp41963519781960-1963Chevrolet Corvette coupe (340-bhp 4-speed)Chevrolet Corvette coupe Silver AnniversaryFerrari 250 GTE 2+21962-1964 Ferrari 250 GTL Lusso678Ferrari250 GTO19621967-196810 1968-19739Ferrari 275 GTB/4 NART SpyderFerrari1962-1967 Jaguar365 GTB/4 DaytonaE-type OTS11121969-1971 JaguarE-type Series II OTS1971-1974Jaguar E-type Series III OTSXK 120 roadster (steel)1314 1951-1954 Jaguar15 1950-1953 Jaguar XK C-typeJaguar XKSS161956-1957171819u9877 154167161319181717InsertRating²ArialfxDraw+CModellog(Rating)DataCalculation Mode: Automatic Workbook StatisticsPage Layout10BFormulasRating181918191619181717151416171613&950.01350.0400.02550.0375.0460.0170.075.067.0125.0360.0280.067.0Search (Option + Q)DataEPrice ($1000)1650.03900.0950.01350.0400.02550.0375.0460.0170.075.067.0125.0360.0280.067.0FReviewGPrice ($1000) log(Price) Formula1650.0#N/A#N/A3900.0#N/A#N/A ▼#N/A#N/A#N/A#N/A#N/A ▼ #N/A#N/A ▼ #N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/AView#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/AabH#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/AHelpGeneralJPart aPart b←0.00.00→.0KLUse the area below to draw a scatter diagram.MNEditing ✓Σ ✓ ✓PCommentsGive Feedback to MicrosoftƠAfter reading these instructions delete all text in this shaded area.Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis.After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (K23).Your Linear Regression analysis output should fit into this shaded area.TR90% + b. Develop an estimated multiple regression equation withx = rarity rating andx² as the two independent variables.+=Price(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(to 2 decimals)of the F test statistic?What is the p-value?(to 4 decimals)=Rating +c. Consider the nonlinear relationship shown by equation E(y) = ßoß. Use logarithms to develop an estimated regression equation for this model.log(Price)Rating²What is the p-value?+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)(to 4 decimals)

The data of the ratings and Price (in $1000s) are shown below…

K2 1 2 3 4 5 6 7 8 9 16 17 10 11 12 1969-1971 13 1971-1974 14 1951-1954 15 1950-1953 1956-1957 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 A Year 1984 1956 1963 B Make Chevrolet Corvette Chevrolet Corvette 265/225-hp Chevrolet Corvette coupe (340-bhp 4-speed) 1978 Chevrolet Corvette coupe Silver Anniversary 1960-1963 Ferrari 250 GTE 2+2 1962-1964 Ferrari 250 GTL Lusso 1962 Ferrari 250 GTO 1967-1968 Ferrari 275 GTB/4 NART Spyder 1968-1973 Ferrari 365 GTB/4 Daytona 1962-1967 Jaguar E-type OTS Jaguar E-type Series II OTS Jaguar E-type Series III OTS Jaguar XK 120 roadster (steel) Jaguar XK C-type Jaguar XKSS Rating Rating² 18 19 18 fx 19 16 19 18 17 17 15 14 16 17 16 13 с Model log(Rating) D Rating 18 19 18 19 16 19 18 17 17 15 14 16 17 16 13 E Price ($1000) 1650.0 3900.0 950.0 1350.0 400.0 2550.0 375.0 460.0 170.0 950.0 1350.0 400.0 2550.0 375.0 460.0 170.0 75.0 67.0 125.0 360.0 280.0 67.0 75.0 67.0 125.0 360.0 280.0 67.0 Price ($1000) log(Price) Formula 1650.0 3900.0 #N/A #N/A #N/A #N/A #N/A ▼ #N/A #N/A #N/A #N/A F ▼ #N/A ▼ #N/A ▼ ▼ ▼ ▼ ▼ ▼ ▼ ▼ ▼ ▼ ▼ ▼ ▼ #N/A #N/A #N/A #N/A ▼ G H #N/A ▼ #N/A #N/A #N/A #N/A ▼ #N/A ▼ ▼ #N/A #N/A #N/A ▼ #N/A #N/A #N/A #N/A #N/A #N/A ▼ #N/A #N/A ▼ #N/A ▼ #N/A ▼ #N/A #N/A #N/A ▼ #N/A #N/A #N/A ▼ #N/A #N/A ▼ #N/A #N/A ▼ #N/A I J Part a Part b Use the area below to draw a scatter diagram. M N O P Q After reading these instructions delete all text in this shaded area. Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis. After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (K23). Your Linear Regression analysis output should fit into this shaded area. R

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P