In: Statistics and Probability
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)
II) Given the plot what is the estimated slope? (10 points)
III) What does each dot represent? (10 points)
IV) On your chart, there should be a dot that is furthest on the right. What is its approximate X-coordinate? (10 points)
data set:https://www.limes.one/Content/DataFiles/Man_body.txt
(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
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 |