Automobile toon, high-performance driving schools, and driver education programs run by automobile clubs continue to grow in popularity. All these 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 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 mu HIHI Open spreadsheet a. Choose the correct diagram for these data with weight as the independent variable The correct scatter diagram is 1000 900 300 700 100 1500 A . 400 100 200 Net Gud Weight (02) b. Does there appear to be any relationship between these two variables? There appears to be a linear relationship between the two variables. The heavier helmets tend to be less expensive 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-a, and R-sqadi The regression equation is to 1 decimal) Price(pred) Weight R-Sq= R-Sq (adj) (to 4 decimals) (to + decimals) (to 4 decimas) d. Test for the significance of the relationship the .05 level of significance P-value is (to 4 decimals) We that the two vanables are related c. Did the estimated regression equation provide a good fit? R- (to 4 decimals) The estimated regression equation provided Check My Work Reset Problem Nc 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 A Weight (oz) 64 64 64 64 58 47 49 59 66 58 58 52 52 63 62 54 63 63 B Price ($) 253 269 198 204 309 695 909 336 195 294 295 477 476 368 369 569 259 280 Automobile toon, high-performance driving schools, and driver education programs run by automobile clubs continue to grow in popularity. All these 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 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 mu HIHI Open spreadsheet a. Choose the correct diagram for these data with weight as the independent variable The correct scatter diagram is 1000 900 300 700 100 1500 A . 400 100 200 Net Gud Weight (02) b. Does there appear to be any relationship between these two variables? There appears to be a linear relationship between the two variables. The heavier helmets tend to be less expensive 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-a, and R-sqadi The regression equation is to 1 decimal) Price(pred) Weight R-Sq= R-Sq (adj) (to 4 decimals) (to + decimals) (to 4 decimas) d. Test for the significance of the relationship the .05 level of significance P-value is (to 4 decimals) We that the two vanables are related c. Did the estimated regression equation provide a good fit? R- (to 4 decimals) The estimated regression equation provided Check My Work Reset Problem Nc 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 A Weight (oz) 64 64 64 64 58 47 49 59 66 58 58 52 52 63 62 54 63 63 B Price ($) 253 269 198 204 309 695 909 336 195 294 295 477 476 368 369 569 259 280