Automobile racing, 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. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. of ToolPak 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 . The regression equation is (to 1 decimal) Price(pred)=+Weights=(to4decimals)RSq=(to4decimals)R-Sq(adj)=(to4decimals) d. Test for the significance of the relationship at the .05 level of significance. P-value is (to 4 decimals). We that the two variables are related. e. Did the estimated regression equation provide a good fit? Rsq is (to 4 decimals). The estimated regression equation provided a fit. \begin{tabular}{|r|r|} \hline Weight (oz) & Price (\$) \\ \hline 64 & 238 \\ \hline 64 & 280 \\ \hline 64 & 195 \\ \hline 64 & 200 \\ \hline 58 & 292 \\ \hline 47 & 706 \\ \hline 49 & 904 \\ \hline 59 & 341 \\ \hline 66 & 202 \\ \hline 58 & 303 \\ \hline 58 & 300 \\ \hline 52 & 488 \\ \hline 52 & 480 \\ \hline 63 & 362 \\ \hline 62 & 361 \\ \hline 54 & 555 \\ \hline 63 & 240 \\ \hline 63 & 272 \\ \hline \end{tabular} Automobile racing, 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. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. of ToolPak 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 . The regression equation is (to 1 decimal) Price(pred)=+Weights=(to4decimals)RSq=(to4decimals)R-Sq(adj)=(to4decimals) d. Test for the significance of the relationship at the .05 level of significance. P-value is (to 4 decimals). We that the two variables are related. e. Did the estimated regression equation provide a good fit? Rsq is (to 4 decimals). The estimated regression equation provided a fit. \begin{tabular}{|r|r|} \hline Weight (oz) & Price (\$) \\ \hline 64 & 238 \\ \hline 64 & 280 \\ \hline 64 & 195 \\ \hline 64 & 200 \\ \hline 58 & 292 \\ \hline 47 & 706 \\ \hline 49 & 904 \\ \hline 59 & 341 \\ \hline 66 & 202 \\ \hline 58 & 303 \\ \hline 58 & 300 \\ \hline 52 & 488 \\ \hline 52 & 480 \\ \hline 63 & 362 \\ \hline 62 & 361 \\ \hline 54 & 555 \\ \hline 63 & 240 \\ \hline 63 & 272 \\ \hline \end{tabular}