Question 15 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. Cola Sane Mineral Consumed Danslty (i) 0.8777 0.8925 0.8898 0.8769 0.8999 0.8634 0.8762 0.8888 0.8552 0.8546 11 0.8762 NV O N D WN = [y o Approximately what percentage of the variation in Bone Mineral Density is accounted for by Colas Consumed in this model? Place your answer, rounded to 1 decimal place, in the blank. Do not use any stray punctuation marks or a percentage sign. For example, 78.9 would be a legitimate entry. ___% Answer: 28.2 ¥ Hide question 15 feedback The R-squared value is the amount of explained variance in the data points in the model. You convert this decimal to a percent. 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 Multiple R 0.530626122 R Square 0.281564082 28.2% of variation in the Bone Mineral Density is accounted for by Colas Consumed in this model. Note: Correlation is a value between -1 and 1. This STAYS a decimal. R-square gets converted from a decimal to a percentage. The Correlation IS NOT a percent, leave it as a decimal.
