Use the following data to answer the following questions
7) Use the next information to reply the next questions.SkinfoldThighMidarmBody Fats19.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 show a scatter chart (in Excel) for Physique fats (Y axis) and skinfold (x-axis)b) Create and show a scatter chart (in Excel) for Physique fats (Y axis) and thigh (x-axis)c) Create and show a scatter chart (in Excel) for Physique fats (Y axis) and midarm (x-axis)d) What does every of those charts recommend?e) Run a correlation for every mixture of the information (every unbiased variable with the dependent variable).f) What do the correlations for every mixture recommend?eight) Run and present linear regressions (in Excel) fora) Physique fats because the dependent variable and skinfold as an unbiased variable.b) Physique fats because the dependent variable and midarm as an unbiased variable.c) Physique fats because the dependent variable and thigh as an unbiased variable.d) Which appears to be a greater predictor of the dependent variable physique fats. Touch upon why you are feeling that is true.f) May this be helpful in figuring out physique fats?