12 part 2 98349 Dr Design Layout References Mang Review View Hip Comments Shaw Time-14 A A A A E Prat AalbCd AaBbCd AaBbc Aalbcct AB Octobe Select Autolave The Home A-A- Questions 1-6 are based on the following scenario: 20 Designers of backpacks use exotic material such as supernylon Delrin, high-density ethylene, aircraft aluminum, and thermo molded foam to make packs that fit comfortably and distribute weight to eliminate pressure points. The following data show the capacity (cubic inches), comfort rating, and price (dollars) for 10 backpacks tested by Outside Magazine. Comfort was measured using a rating from 1 to 5, with a rating of 1 denoting average comfort and a rating of 5 denoting excellent comfort. Regress price on comfort and capacity using excel and answer the following questions 1. What is the interpretation of adjusted R-square for this problem? 2. What price would you predict for a backpack with a mean capacity of 5700 (cubic inches) and confort rating of 47 3. Provide the appropriate test statistic and p-value for assessing whether there is evidence that comfort aids in predicting price. 4. Provide an interpretation for the sample regression coefficient of capacity. 5. Is the overall model significant at 0.05 level of significance? Why or why not. 6. Does capacity aid in predicting price at 0.05 level of significance? Why or why not. (4 points) Data for this scenario is as follows: Manufacturer & Model Capacity Comfort Price (5) Came Traits Paragon EMS 5500 Town Almaya 190 5500 219 5500 4 2410 Maurot Moun Kelly Brafoot Gregory Whitney 4700 24 5209 250 5500 41 340 Osprey 75 4700 300 An Innox Dora 5500 202 Deen Design Templan 500000 430 629 Type here in warn 2:00PM SPY Sunny