In: Statistics and Probability
1. A doctor’s office wants to predict Body fat based on tight fat content, mid-arm circumference, and triceps fat electric conductivity. A research was conducted and the following information was obtained.
| 
 Fat  | 
 Triceps  | 
 Midarm  | 
 Thigh  | 
| 
 11.9  | 
 19.5  | 
 29.1  | 
 43.1  | 
| 
 22.8  | 
 24.7  | 
 28.2  | 
 49.8  | 
| 
 18.7  | 
 30.7  | 
 37  | 
 51.9  | 
| 
 20.1  | 
 29.8  | 
 31.1  | 
 54.3  | 
| 
 12.9  | 
 19.1  | 
 30.9  | 
 42.2  | 
| 
 21.7  | 
 25.6  | 
 23.7  | 
 53.9  | 
| 
 27.1  | 
 31.4  | 
 27.6  | 
 58.5  | 
| 
 25.4  | 
 27.9  | 
 30.6  | 
 52.1  | 
| 
 21.3  | 
 22.1  | 
 23.2  | 
 49.9  | 
| 
 19.3  | 
 25.5  | 
 24.8  | 
 53.5  | 
| 
 25.4  | 
 31.1  | 
 30  | 
 56.6  | 
| 
 27.2  | 
 30.4  | 
 28.3  | 
 56.7  | 
| 
 11.7  | 
 18.7  | 
 23  | 
 46.5  | 
| 
 17.8  | 
 19.7  | 
 28.6  | 
 44.2  | 
| 
 12.8  | 
 14.6  | 
 21.3  | 
 42.7  | 
| 
 23.9  | 
 29.5  | 
 30.1  | 
 54.4  | 
| 
 22.6  | 
 27.7  | 
 25.7  | 
 55.3  | 
| 
 25.4  | 
 30.2  | 
 24.6  | 
 58.6  | 
| 
 14.8  | 
 22.7  | 
 27.1  | 
 48.2  | 
| 
 21.1  | 
 25.2  | 
 27.5  | 
 51  | 
Answer: Using R-Code with Produce a scatter plot matrix

Interpretation : Strong positive correlation between Triceps and Flat, Thigh and Triceps, Fat and Triceps.
Answer using Excel:

In both outputs there is strong positive correlation between Triceps and Flat, Thigh and Triceps, Fat and Triceps.
Hope this will be helpful. Thanks and God Bless You :)