Question

Use the following convention table for R-square.

From 0.0 to 0.2	Poor
From 0.2 to 0.4	Decent
From 0.4 to 0.6	Good
From 0.6 to 0.85	Very Good
From 0.85 to 1.0	Excellent

Upload the ManBody data. Check which of the following four categories (BODYFAT, WEIGHT, HEIGHT, and KNEE) is the most correlated to AGE category. Make a scattered plot chart with X representing the most correlated category and Y representing the AGE, plot the line and compute the R-square. Answer the questions:

I) What category did you choose for X? (10 points)

• a. WEIGHT
• b. BODYFAT
• c. HEIGHT
• d. KNEE

II) Given the plot what is the estimated slope? (10 points)

• a. Between 0 and 0.1
• b. Between 0.1 and 0.3
• c. Between 0.3 and 1.3
• d. Between 1.3 and 10.5
• e. Between 10.5 and 40

III) What does each dot represent? (10 points)

• a. AGE
• b. WEIGHT
• c. HEIGHT
• d. PERSON
• e. BODY FAT

IV) On your chart, there should be a dot that is furthest on the right. What is its approximate X-coordinate? (10 points)

• a. Between 0 and 100
• b. Between 100 and 200
• c. Between 200 and 300
• d. Between 300 and 400

data set:https://www.limes.one/Content/DataFiles/Man_body.txt

Answer 1

(I)right choice is b. BODYFAT

following correlation matrix is generated using ms-excel and found that BODYFAT IS MOST CORRELATED WITH AGE out of the given four variable

(II) right choice is c. Between 0.3 and 1.3

here slope is 0.472 from the given scatter plot information which was created using ms-excel

(III) right choice is a. AGE

(IV) right choice is a. Between 0 and 100

following scatter plot is generated using ms-excel

Scatter plot 90 80 70 60 50 40 30 20 10 y:0.472x + 35.96 R0.085 10 20 30 40 50 Bodyfat(x)

	BODYFAT	DENSITY	AGE	WEIGHT	HEIGHT	ADIPOSITY	NECK	CHEST	ABDOMEN	HIP	THIGH	KNEE	ANKLE	BICEPS	FOREARM	WRIST
BODYFAT	1
DENSITY	-0.98622	1
AGE	0.292334	-0.27764	1
WEIGHT	0.609576	-0.59406	-0.01275	1
HEIGHT	-0.08928	0.097881	-0.17165	0.308279	1
ADIPOSITY	0.72664	-0.71473	0.118851	0.887352	-0.02489	1
NECK	0.490186	-0.47297	0.113505	0.830716	0.25371	0.777857	1
CHEST	0.700514	-0.6826	0.17645	0.894191	0.134892	0.911799	0.784835	1
ABDOMEN	0.813783	-0.79895	0.230409	0.887995	0.087813	0.92388	0.754077	0.915828	1
HIP	0.623558	-0.60933	-0.05033	0.940884	0.170394	0.883269	0.734958	0.82942	0.874066	1
THIGH	0.559871	-0.55309	-0.2001	0.868694	0.148436	0.812706	0.695697	0.729859	0.766624	0.89641	1
KNEE	0.509603	-0.49504	0.017516	0.853167	0.286053	0.71366	0.672405	0.719496	0.737179	0.823473	0.79917	1
ANKLE	0.269971	-0.26489	-0.10506	0.613685	0.264744	0.500317	0.477892	0.482988	0.453223	0.558387	0.539797	0.611608	1
BICEPS	0.491296	-0.48711	-0.04116	0.800416	0.207816	0.746384	0.731146	0.727907	0.684983	0.739273	0.761477	0.678709	0.484855	1
FOREARM	0.354495	-0.35165	-0.08506	0.630301	0.228649	0.558594	0.62366	0.580173	0.503316	0.545014	0.566842	0.555898	0.41905	0.678255	1
WRIST	0.341286	-0.32572	0.213531	0.729775	0.322065	0.625907	0.744826	0.660162	0.619832	0.63009	0.558685	0.664507	0.566195	0.632126	0.585588	1