I’m choosing the data set Male Health Data. I chose to use the weight and waist.
2. Next, using Excel, calculate the relationship (r value) between the two variables. Recall that the Excel “formula” for correlation is “=CORREL.” What is the r value for the two variables that you have chosen? Is it positive or negative? Is it strong, medium, or weak? Note that it is best to have an r value that is medium or strong. It is recommended that you try a few different variables until you find two variables with an r value between .5 and 1 (or between -.5 and -1).
The R value is .95, I believe it is positive and strong. I predict that the two variables rely heavily on each other and as the waist size goes up so will the weight.
Male Health
119.96226420000001 135.0044268 141.19131909999999 119.22340389999999 142.28929690000001 114.4375618 139.1223177 135.58635469999999 135.8082393 122.9209881 122.06009539999999 124.8414934 127.225424 123.84089109999999 118.7168471 136.3587775 119.9469526 122.6357484 136.0056878 128.89569359999999 137.83491950000001 122.9765491 139.068039 137.8156712 133.7541994 138.76177480000001 119.75264660000001 125.184156 119.8783387 140.4206092 145.3173396 122.3573772 142.6854621 143.74413480000001 145.843414 127.2613503 123.5906377 145.91798059999999 118.9596816 137.250652 38.433652180000003 43.255973959999999 45.624743100000003 37.253182459999998 45.598719490000001 36.884449129999993 45.032341340000002 42.349801380000002 42.840190839999998 39.834869099999992 39.59747187 38.637281489999992 41.29002337 39.557648110000002 38.183893559999987 42.387276959999987 38.214214329999997 39.515691859999997 43.550812219999997 42.900475040000003 44.41314088 37.822132699999997 45.607338759999998 45.551081839999988 43.155114709999999 44.106740930000001 37.340144479999992 40.59829938 38.442786699999999 43.58904613 45.877517249999997 37.579955120000001 44.28848301 44.736077809999998 45.841451879999987 42.34511732 40.17630243 45.377223729999997 38.30346715999999 42.844168519999997
WEIGHT
WAIST