A researcher is analyzing the body fat percentage based on the measurements of triceps, thigh, and mid-arm of a person (in inches). The data is recorded in the Excel file Body Fat Percentage.

a. Use the Correlation tool to develop the correlation matrix and make a conclusion for it. Then use the Regression tool for this set of variables to develop a multiple regression model, and identify which independent variable is not appropriate in the model.

b. Remove the inappropriate independent in part a in the multiple regression model and rerun the process using the Regression tool until the best model is found.

c. Use the best multiple regression model to predict the body fat percentage given the following measurements: 25.1 inches of triceps, 50.78 inches of thigh, and 33.56 inches of mid-arm.