Grade Quiz Chapters 13 & 14 1 point each 1.If the correlation cooeficient for x = studying & y = high GPA is -1, what would you conclude? 2.Explain the least squares principle. 3.What's the difference between linear & multiple regression? Assignment Chapter 13 These exercises, which may be different from the text, must be done using Excel. [each answer box is 1 point] Exercise 2: The following sample observations were randomly selected. X Y 5 13 3 15 6 7 3 12 4 13 4 11 6 9 8 5 a.Insert the trendline equation. b.Determine the coefficient of correlation and the coefficient of determination. Exercise 6: The owner of Maumee Ford-Mercury-Volvo wants to study the relationship between the age of a car and its selling price.Listed below is a random sample of 12 used cars sold at the dealership during the last year. Car Age [yrs] Price [$1000] Car Age [yrs] Price [$1000] 1 9 8.1 7 8 7.6 2 7 6.0 8 11 8.0 3 11 3.6 9 10 8.0 4 12 4.0 10 12 6.0 5 8 5.0 11 6 8.6 6 7 10.0 12 6 8.0 a.The independent variable is... b.Insert the trendline equation. c.Determine the coefficient of correlation. d.based on this model, the price of a 15 year old car would be... Assignment Chapter 14 There are two primary influences that affect the consumption of natural gas, Y, in cubic feet, to heat a home: 1.The thickness of wall insulation in inches, X₁. 2.The outdoor air temperature in degrees Farenheit, X₂. A multiple regression analysis reveals the following equation relating these variables: Y_hat = 62.65 - 1.86X₁ - .52X₂ a.Determine the gas consumption for a home with 6 inches of insulation at a temperature of 40^o F.