Math 1050 GA 2 Creating Charts in Excel (2) [Compatibility Model- Word Reference
ID: 3271624 • Letter: M
Question
Math 1050 GA 2 Creating Charts in Excel (2) [Compatibility Model- Word References Mailings Review View Tell me what you want to do | A . . ii I ts . | a-.-. . L Nonnal Heading, Heading 2 Title Subtitle Subtle En. Paragraph Styles 62.1 68.5 58.3 1.12 1.24 1.00 a. Graph the data and add a trendline with equation b. Compute the percentage error for this best fitting line. c. What is the bone mass density predicted by the model for a girl who weighs 60 kg? d. According to the model, what is the weight of a woman who has bone mass density 1.39 e/cm2? Should you use this model to predict bone mass density for a girl who weighs 45 kg? Why or why not? Give a reason for your answer. e. Make sure you show your work. You can do the computations for part c. and d. by hand in your write-up. Page 1 13 01 o e @#a.Explanation / Answer
Sola:
Body mass density=0.0094(weight)+0.5584
slope=0.0094
y intercept=0.5584
Solutionc:
weight=60
substitute in the regression eq below:
Body mass density=0.0094(weight)+0.5584
Body mass density=0.0094(60)+0.5584
=1.12
For a girl who weighs 60 kg BMI is 1.12
Solutionc:
Body mass density=1.39
substitute in the regression eq obtaines
Body mass density=0.0094(weight)+0.5584
1.39=0.0094(weight)+0.5584
weight=1.39-0.5584/0.0094
=0.8316/0.0094
=88.5 kg
SUMMARY OUTPUT Regression Statistics Multiple R 0.347967 R Square 0.121081 Adjusted R Square 0.053472 Standard Error 0.155141 Observations 15 ANOVA df SS MS F Significance F Regression 1 0.043105 0.043105 1.7909 0.203754 Residual 13 0.312895 0.024069 Total 14 0.356 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 0.558401 0.466212 1.19774 0.252401 -0.44879 1.565591 weight 0.009436 0.007051 1.338245 0.203754 -0.0058 0.02467