Dashboar X G The oxyge X Pokemon X h Hulu + Liv X Grades fo X MindTap - X Excel Onli X C My folder X Course H X C Country F X (119) You X + Update : @ about:blank C Chapter 16 Learn... Excel template - Saved Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments 1 v [ v 10 Av ... ab General $ v EV ATY OV . .. Arial B E F2 " X V fx B C D E F G H I K L M N 0 P Q R S A Weight (oz) Price ($) Part a. Use the area below to draw a scatter diagram. 64 250 64 272 JOUTAWNY 64 190 64 207 58 292 47 696 49 905 59 340 99 199 58 309 58 301 52 480 52 471 63 373 62 366 54 552 63 258 63 270 Part c. After reading these instructions delete all text in this shaded area. Use the XLMiner Analysis ToolPak to conduct your Linear Regression analysis. 26 After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (F22). 27 28 Your Linear Regression analysis output should fit into this shaded area. 29 30 31 32 33 E Data + Give Feedback to Microsoft 100% + Calculation Mode: Automatic Workbook StatisticsDashboar X G The oxyge X Pokemon X h Hulu + Liv X Grades fo X MindTap - X Excel Onli X C My folder x Course H X C Country F X (119) You x + C https:/g.cengage.com/staticb/ui/evo/index.html? deploymentld=5935112189509097482354739820&elSBN=9780357110614&id=156750481... ( * G*0 Update : C Chapter 16 Learn... Khoi v CENGAGE | MINDTAP Q Search this course ? My Home Microsoft Excel: Structured Activity X Question 1 Courses 0/10 Video Catalog and Study Tools Submit Automobile racing, high-performance driving schools, and driver education programs run by automobile clubs continue to grow in popularity. All these A-7 Rental Options activities require the participant to wear a helmet that is certified by the Snell Memorial Foundation, a not-for-profit organization dedicated to research, education, testing, and development of helmet safety standards. Snell "SA" (Sports Application)-rated professional helmets are designed for auto racing and provide extreme impact resistance and high fire protection. One of the key factors in selecting a helmet is weight, since lower weight helmets tend to College Success Tips place less stress on the neck. The data in the Excel Online file below show the weight and price for 18 SA helmets. Construct a spreadsheet to answer the following questions. Career Success Tips Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak RECOMMENDED FOR YOU X Open spreadsheet a. Choose the correct diagram for these data with weight as the independent variable. The correct scatter diagram is logace ($) bongo How to Stop Procrastinating -900 +800 ? Help 1 700 Give Feedback -600 A+ -+-500 A. 4-400 Back NextDashboar X G The oxyge X Pokemon X h Hulu + Liv X Grades fo X MindTap - X Excel Onli X C My folder x Course H X C Country F X (119) You x + C https:/g.cengage.com/staticb/ui/evo/index.html? deploymentld=5935112189509097482354739820&elSBN=9780357110614&id=156750481.. ( * G*0 Update : C Chapter 16 Learn... Khoi v CENGAGE | MINDTAP Q Search this course ? My Home Microsoft Excel: Structured Activity X Question 1 Courses 0/10 Catalog and Study Tools Submit $100 50 55 60 65 A-Z Rental Options Weight (oz) b. Does there appear to be any relationship between these two variables? College Success Tips There appears to be a linear relationship between the two variables. The heavier helmets tend to be less expensive. Career Success Tips c. Develop the estimated regression equation that can be used to predict the price given the weight. Also report the standard error of the estimate, R-sq, and R-sq adj. RECOMMENDED FOR YOU The regression equation is (to 1 decimal) Price(pred) = + Weight S = (to 4 decimals) R-Sq = (to 4 decimals) bongo R-Sq (adj) = (to 4 decimals) How to Stop Procrastinating d. Test for the significance of the relationship at the .05 level of significance. ? Help P-value is (to 4 decimals). Wel that the two variables are related. Give Feedback e. Did the estimated regression equation provide a good fit? A+ R-sq is (to 4 decimals). The estimated regression equation provided a v fit . Back Next