Question 14 1/ 1 poini Bone mineral density and cola consumption has been recorded for a sample of patients. Let x represent the number of colas consumed per wecek and y the bone mincral 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 ONOU DA WN - Using that data, find the estimated regression equation which can be used to estimate Bone Mineral Density when using Colas Consumed as the predictor variable. « » Bone Mineral Density = 0.891716 - 0.002389(Colas Consumed) Bone Mineral Density = 0.008627 + 0.001272(Colas Consumed) Bone Mineral Density = 103.3549 - 1.87809(Colas Consumed) Bone Mineral Density = 0.201737 +0.01334(Colas Consumed) 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 s -0.002389091 Bone Mineral Density = 0.891716 - 0.002389(Colas Consumed)
