Posted: February 8th, 2019
Use the following data to answer the following questions
7) Use the following data to answer the following questions.SkinfoldThighMidarmBody Fat19.543.129.111.924.749.828.222.830.751.93718.729.854.331.120.119.142.230.912.925.653.923.721.731.458.527.627.127.952.130.625.422.149.923.221.325.553.524.819.331.156.63025.430.456.728.327.218.746.52311.719.744.228.617.814.642.721.312.829.554.430.123.927.755.325.722.630.258.624.625.422.748.227.114.825.25127.521.1a) Create and display a scatter chart (in Excel) for Body fat (Y axis) and skinfold (x-axis)b) Create and display a scatter chart (in Excel) for Body fat (Y axis) and thigh (x-axis)c) Create and display a scatter chart (in Excel) for Body fat (Y axis) and midarm (x-axis)d) What does each of these charts suggest?e) Run a correlation for each combination of the data (each independent variable with the dependent variable).f) What do the correlations for each combination suggest?8) Run and show linear regressions (in Excel) fora) Body fat as the dependent variable and skinfold as an independent variable.b) Body fat as the dependent variable and midarm as an independent variable.c) Body fat as the dependent variable and thigh as an independent variable.d) Which seems to be a better predictor of the dependent variable body fat. Comment on why you feel this is true.f) Could this be useful in determining body fat?