Title: Correlation between Leg Strength and Body Weight

Perform the following data analysis using MS Excel using the data provided. Your submission document should be a single Excel file. 
Please use the data attached in files below and create a plot graph and follow instructions below 
Quantify the correlation using the the Rank-Difference Correlation method.
Interpret the correlation using the descriptors provided in the lab handout. Write in a complete sentence
Create a plot in MS Excel of leg strength (y-axis) vs. body weight (x-axis) using the data provided (see link below). Use a scatter plot and make sure to label your axes.
Add a “Trendline” (linear).

Comments

Leave a Reply