Question 14 1/ 1 point Bone mineral density and cola consumption has been recorded for a sample of patients. Let x represent the number of colas consumed per week and y the bone mineral density in grams per cubic centimeter. Assume the data is normally distributed. Bone Mineral Density (g) 0.8777 0.8925 0.8898 0.8769 0.8999 0.8634 0.8762 0.8888 0.8552 10 0.8546 11 0.8762 Cola Consumed NV 00NN O BWN e Using the estimated regression equation found by using Colas Consumed as the predictor variable, find a point estimate for Bone Mineral Density when the number of Colas Consumed is 12? v e 0.8630 0.8767 0.8089 0.8081 w Hide question 14 feedback Copy and Paste the Data into Excel. Data -> Data Analysis -> Scroll to Regression Highlight Bone Mineral Density for the Y Input: Highlight Colas Consumed for the X Input: Make sure you click on Labels and Click OK If done correctly then you look under the Coefficients for the values to write out the Regression Equation Coefficients Intercept 0.891716364 Cola -0.002389091 Consumed Bone Mineral Density = 0.891716 - 0.002389(Colas Consumed) Plug in 12 for Colas Consumed Bone Mineral Density = 0.891716 - 0.002389(12)
