8:45AM Wed Mar 20 Xy w @ 9%94% =) < Back Week 7 Test Answer: 0.9831 ¥ Hide question 12 feedback Use =CORREL function n in Excel. Question 13 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 O NN DWW - 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 = 103.3549 - 1.87809(Colas Consumed) ", Bone Mineral Density = 0.008627 + 0.001272(Colas Consumed) ", Bone Mineral Density = 0.201737 +0.01334(Colas Consumed) o Bone Mineral Density = 0.891716 - 0.002389(Colas Consumed)
