Designers of backpacks use exotic materials such as super nylon Delrin, high-density ethylene, and aircraft aluminum, and
Fantastic news! We've Found the answer you've been seeking!
Question:
Designers of backpacks use exotic materials such as super nylon Delrin, high-density ethylene, and 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 the price on comfort and capacity using excel and answer the following questions.
please show how to solve with answers
What is the interpretation of adjusted R-square for this problem? | ||||||||||
What price would you predict for a backpack with a mean capacity of 5700 (cubic inches) and comfort rating of 4? | ||||||||||
Manufacturer & Model | Capacity | Comfort | Price ($) | ||
Camp Trails Paragon | 4330 | 2 | 190 | ||
EMS 5500 | 5500 | 3 | 219 | ||
Lowe Almay | 5500 | 4 | 249 | ||
Marmot Muir | 4700 | 3 | 249 | ||
Kelly Bigfoot | 5200 | 4 | 250 | ||
Gregory Whitney | 5500 | 4 | 340 | ||
Osprey 75 | 4700 | 4 | 389 | ||
Arc' Teryx Bora | 5500 | 5 | 395 | ||
Dana Design Terraplane | 5800 | 5 | 439 | ||
The Works @ Mystery | 5000 | 5 | 525 |
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris
Posted Date: