Stat

profileblkxhou
CollegeWeightLabData.xlsx
Home>Mathematics homework help>Statistics homework help>Stat

Recovered_Sheet1

SubjectID Gender Age BMIFresh BMISenior BMIChange BMI_Class BMI_ClassFresh BMI_ClassSenior WeightFresh WeightSenior WeightChange HeightFresh HeightSenior PhysicalActivity DailyCalories AvgSleepHours LivesOnCampus JobStatus RelationshipStatus Commute Commute_catNum
1.0 Male 18 21.71 24.13 2.42 Norm Normal Normal 65.42 74.00 8.58 173.60 175.12 0 2100 6.4 yes yes relationship walk 3
2.0 Female 18 26.02 27.98 1.96 Over Overweight/Obese Overweight/Obese 71.97 77.48 5.51 166.30 166.41 0 2200 8.1 yes yes single drive/bus 2
3.0 Female 19 22.17 25.98 3.82 Norm Normal Overweight/Obese 61.01 72.12 11.12 165.90 166.61 0 2800 6.2 no no single bike 1
4.0 Female 19 25.01 26.56 1.55 Over Overweight/Obese Overweight/Obese 67.15 72.22 5.07 163.86 164.91 0 2100 8.0 no no single drive/bus 2
5.0 Male 20 21.97 25.05 3.07 Norm Normal Overweight/Obese 74.74 85.36 10.63 184.43 184.61 0 2300 8.1 no yes relationship drive/bus 2
6.0 Male 19 22.98 25.05 2.07 Norm Normal Overweight/Obese 79.22 86.42 7.19 185.68 185.74 0 1700 7.1 yes yes relationship drive/bus 2
7.0 Male 20 19.51 21.27 1.77 Norm Normal Normal 60.66 66.81 6.15 176.35 177.22 0 2700 7.0 no yes relationship drive/bus 2
8.0 Female 20 26.55 25.43 -1.12 Over Overweight/Obese Overweight/Obese 72.98 70.38 -2.60 165.80 166.36 64 1900 7.1 yes yes single drive/bus 2
9.0 Female 19 21.16 20.90 -0.27 Norm Normal Normal 58.66 58.68 0.01 166.49 167.57 0 1900 6.6 yes yes relationship drive/bus 2
10.0 Female 19 25.05 26.31 1.27 Over Overweight/Obese Overweight/Obese 73.93 79.02 5.10 171.79 173.29 35 2400 6.7 no yes relationship drive/bus 3
11.0 Female 19 23.01 23.92 0.91 Norm Normal Normal 56.18 59.81 3.63 156.26 158.12 36 2300 8.2 yes yes single drive/bus 2
12.0 Male 20 21.35 24.30 2.95 Norm Normal Normal 63.91 73.27 9.36 173.03 173.65 28 2000 7.2 no yes relationship drive/bus 2
13.0 Male 20 20.70 23.60 2.90 Norm Normal Normal 61.60 70.31 8.70 172.51 172.60 0 2300 7.3 yes yes single walk 3
14.0 Male 19 20.04 21.73 1.69 Norm Normal Normal 65.01 70.76 5.76 180.11 180.44 48 2100 7.8 no yes single walk 3
15.0 Female 20 21.45 21.01 -0.44 Norm Normal Normal 56.96 56.29 -0.67 162.96 163.70 45 2100 6.6 yes yes relationship drive/bus 2
16.0 Female 18 27.30 28.15 0.85 Over Overweight/Obese Overweight/Obese 70.34 74.04 3.71 160.53 162.19 41 2000 7.7 no yes relationship drive/bus 2
17.0 Female 18 22.83 25.00 2.18 Norm Normal Overweight/Obese 59.66 66.68 7.03 161.67 163.31 0 2400 6.6 yes yes single walk 3
18.0 Female 19 24.76 25.26 0.50 Norm Normal Overweight/Obese 73.74 76.90 3.16 172.58 174.48 28 2500 7.4 yes yes relationship drive/bus 2
19.0 Male 19 22.70 23.13 0.43 Norm Normal Normal 70.67 72.45 1.77 176.46 176.98 32 2400 7.3 yes no relationship drive/bus 2
20.0 Female 19 27.13 27.71 0.58 Over Overweight/Obese Overweight/Obese 76.48 78.32 1.84 167.90 168.12 25 2000 6.5 no no relationship walk 3
21.0 Male 18 31.58 36.08 4.49 Over Overweight/Obese Overweight/Obese 95.60 110.47 14.88 173.97 174.99 40 2100 8.0 yes no single walk 3
22.0 Male 19 24.90 23.80 -1.10 Over Overweight/Obese Normal 92.13 89.94 -2.19 192.35 194.39 40 1800 7.1 yes yes relationship drive/bus 2
23.0 Female 18 22.91 22.77 -0.14 Norm Normal Normal 64.97 65.65 0.68 168.39 169.79 32 2000 6.8 yes yes single walk 3
24.0 Female 19 20.93 24.37 3.44 Norm Normal Normal 50.65 60.17 9.51 155.57 157.11 25 3600 6.8 no yes single drive/bus 2
25.0 Male 19 19.98 20.68 0.70 Norm Normal Normal 58.31 62.17 3.86 170.83 173.40 38 1900 7.4 yes yes relationship walk 3
26.0 Female 20 26.27 28.53 2.26 Over Overweight/Obese Overweight/Obese 71.20 77.34 6.14 164.62 164.64 0 2100 7.8 yes yes relationship drive/bus 2
27.0 Female 18 20.87 24.15 3.28 Norm Normal Normal 52.70 61.79 9.09 158.91 159.96 0 2100 7.6 yes no single drive/bus 2
28.0 Male 18 19.05 23.81 4.76 Norm Normal Normal 52.71 66.33 13.62 166.32 166.90 0 2200 7.3 yes yes single walk 3
29.0 Male 21 26.04 29.27 3.23 Over Overweight/Obese Overweight/Obese 89.09 101.25 12.15 184.95 185.97 46 2800 7.4 yes yes single drive/bus 2
30.0 Female 20 19.16 20.85 1.68 Norm Normal Normal 49.60 55.50 5.90 160.87 163.17 57 2500 6.2 yes no single drive/bus 2
31.0 Female 18 32.05 33.02 0.98 Over Overweight/Obese Overweight/Obese 93.53 97.04 3.51 170.84 171.42 32 2600 5.7 yes yes single bike 1
32.0 Male 19 28.22 31.66 3.44 Over Overweight/Obese Overweight/Obese 96.01 109.17 13.17 184.46 185.69 0 1900 7.8 no no single drive/bus 2
33.0 Male 19 27.16 27.87 0.71 Over Overweight/Obese Overweight/Obese 87.79 91.04 3.26 179.80 180.76 39 2000 6.5 yes no single walk 3
34.0 Male 18 23.06 24.01 0.95 Norm Normal Normal 76.08 80.01 3.93 181.64 182.53 25 2000 7.8 no no single walk 3
35.0 Female 19 27.04 26.28 -0.76 Over Overweight/Obese Overweight/Obese 73.42 72.87 -0.54 164.77 166.52 39 1900 7.4 yes no single walk 3
36.0 Female 20 26.71 29.13 2.42 Over Overweight/Obese Overweight/Obese 75.82 83.35 7.54 168.48 169.16 0 2200 6.7 no no single drive/bus 2
37.0 Female 18 19.27 18.88 -0.39 Norm Normal Normal 49.56 49.34 -0.22 160.36 161.66 42 1800 7.4 no no single walk 3
38.0 Female 18 25.86 27.63 1.78 Over Overweight/Obese Overweight/Obese 69.19 74.10 4.91 163.58 163.75 0 1900 7.9 yes no relationship walk 3
39.0 Male 18 30.46 27.06 -3.39 Over Overweight/Obese Overweight/Obese 91.99 83.69 -8.30 173.80 175.85 45 1600 7.5 no no relationship bike 1
40.0 Male 18 24.92 25.44 0.52 Over Overweight/Obese Overweight/Obese 82.76 86.36 3.59 182.26 184.25 0 2700 7.6 yes no relationship walk 3
41.0 Female 20 30.43 33.04 2.61 Over Overweight/Obese Overweight/Obese 82.49 89.76 7.27 164.65 164.83 47 2200 6.2 yes no single drive/bus 2
42.0 Male 20 19.86 23.18 3.33 Norm Normal Normal 62.23 73.41 11.18 177.03 177.94 0 2200 6.0 yes no relationship drive/bus 2
43.0 Female 20 24.56 25.53 0.97 Norm Normal Overweight/Obese 63.81 66.99 3.18 161.20 161.99 37 1900 6.6 yes no single walk 3
44.0 Female 20 22.79 23.11 0.32 Norm Normal Normal 57.36 58.49 1.13 158.64 159.08 0 2400 8.9 yes yes relationship walk 3
45.0 Male 19 20.06 19.91 -0.15 Norm Normal Normal 60.06 60.04 -0.03 173.04 173.64 39 1700 7.7 yes yes single bike 1
46.0 Female 21 23.36 21.11 -2.25 Norm Normal Normal 68.78 62.21 -6.57 171.58 171.65 0 1900 8.2 yes yes single walk 3
47.0 Female 21 25.78 27.24 1.46 Over Overweight/Obese Overweight/Obese 64.89 69.03 4.14 158.66 159.18 0 2000 7.2 yes no single bike 1
48.0 Female 19 26.36 27.96 1.60 Over Overweight/Obese Overweight/Obese 73.45 79.17 5.72 166.92 168.27 54 2500 7.1 no no relationship drive/bus 2
49.0 Female 19 23.72 26.39 2.67 Norm Normal Overweight/Obese 64.23 71.53 7.30 164.55 164.64 0 2200 6.6 yes no single drive/bus 2
50.0 Female 18 23.40 24.83 1.42 Norm Normal Normal 61.68 66.18 4.51 162.33 163.27 0 2400 6.4 no yes single drive/bus 1
51.0 Male 19 22.88 25.58 2.69 Norm Normal Overweight/Obese 75.00 84.42 9.42 181.05 181.68 0 2400 6.6 yes yes single walk 3
52.0 Female 19 19.88 18.32 -1.56 Norm Normal Normal 51.93 48.77 -3.16 161.64 163.17 48 2100 7.7 yes no relationship drive/bus 2
53.0 Male 19 24.18 24.94 0.76 Norm Normal Overweight/Obese 78.47 81.22 2.75 180.12 180.46 25 2100 6.9 no no single walk 3
54.0 Male 18 21.69 22.86 1.18 Norm Normal Normal 68.42 72.22 3.80 177.61 177.73 40 2000 6.0 yes yes single walk 3
55.0 Female 19 22.36 22.68 0.32 Norm Normal Normal 59.30 61.65 2.35 162.87 164.87 43 1800 6.8 no yes single drive/bus 2
56.0 Female 19 22.56 24.39 1.83 Norm Normal Normal 65.40 70.78 5.38 170.27 170.36 0 2000 6.8 no yes single drive/bus 2
57.0 Female 18 35.36 36.52 1.16 Over Overweight/Obese Overweight/Obese 108.09 111.98 3.88 174.84 175.11 37 2500 8.2 yes yes relationship walk 3
58.0 Male 19 25.97 27.36 1.39 Over Overweight/Obese Overweight/Obese 88.92 95.42 6.50 185.04 186.77 0 1900 8.6 yes yes single drive/bus 2
59.0 Male 22 27.24 28.23 1.00 Over Overweight/Obese Overweight/Obese 90.73 94.73 4.00 182.51 183.17 44 3100 5.9 yes yes single drive/bus 2
60.0 Female 18 31.03 32.39 1.36 Over Overweight/Obese Overweight/Obese 87.06 91.00 3.94 167.51 167.62 0 2100 8.2 no no single drive/bus 2
61.0 Female 20 30.16 30.91 0.75 Over Overweight/Obese Overweight/Obese 75.58 77.84 2.26 158.31 158.70 35 2200 6.7 yes yes single walk 3
62.0 Male 20 24.76 26.32 1.56 Norm Normal Overweight/Obese 73.31 80.17 6.87 172.05 174.52 0 2600 7.9 no no single walk 3
63.0 Male 19 18.43 20.05 1.62 Norm Normal Normal 55.29 60.38 5.10 173.18 173.54 28 2400 6.7 yes yes single walk 2
64.0 Female 19 25.37 25.71 0.34 Over Overweight/Obese Overweight/Obese 71.68 73.39 1.71 168.11 168.96 46 2100 7.4 no no relationship drive/bus 2
65.0 Male 18 28.55 30.41 1.86 Over Overweight/Obese Overweight/Obese 88.70 96.30 7.59 176.27 177.94 0 2000 7.7 no no single drive/bus 2
66.0 Female 19 27.59 27.82 0.23 Over Overweight/Obese Overweight/Obese 76.15 77.56 1.41 166.13 166.98 38 2000 5.4 yes yes single drive/bus 2
67.0 Female 18 30.08 34.64 4.57 Over Overweight/Obese Overweight/Obese 87.04 100.71 13.67 170.12 170.50 46 2000 6.8 yes no single walk 3
68.0 Female 18 26.84 24.79 -2.05 Over Overweight/Obese Normal 70.89 66.26 -4.63 162.52 163.49 34 2100 7.1 no no relationship drive/bus 2
69.0 Male 19 24.79 25.73 0.94 Norm Normal Overweight/Obese 75.54 79.59 4.05 174.56 175.86 37 2200 6.2 yes no single drive/bus 2
70.0 Male 19 26.06 28.78 2.72 Over Overweight/Obese Overweight/Obese 86.18 96.41 10.23 181.84 183.03 27 2100 6.7 yes no single drive/bus 2
71.0 Female 20 23.27 24.24 0.98 Norm Normal Normal 61.14 63.72 2.58 162.10 162.12 28 2200 8.4 yes yes single walk 3
72.0 Female 20 25.40 26.07 0.67 Over Overweight/Obese Overweight/Obese 69.99 72.14 2.14 166.00 166.35 0 2600 6.7 no yes relationship drive/bus 2
73.0 Female 18 21.73 24.07 2.34 Norm Normal Normal 57.62 64.23 6.60 162.85 163.35 0 2500 6.8 no no single walk 3
74.0 Female 20 24.11 24.79 0.67 Norm Normal Normal 63.11 65.26 2.16 161.77 162.26 28 2100 7.0 yes yes single drive/bus 2
75.0 Female 18 27.46 26.92 -0.54 Over Overweight/Obese Overweight/Obese 72.48 71.44 -1.04 162.47 162.90 0 1700 7.7 yes yes relationship walk 3
76.0 Male 19 29.42 31.39 1.97 Over Overweight/Obese Overweight/Obese 94.98 102.16 7.18 179.67 180.39 12 2200 6.2 no no relationship drive/bus 2
77.0 Female 18 24.43 23.35 -1.08 Norm Normal Normal 61.27 58.67 -2.60 158.38 158.52 50 1700 7.2 no yes relationship bike 1
78.0 Male 18 26.54 29.27 2.73 Over Overweight/Obese Overweight/Obese 82.22 90.78 8.56 176.01 176.11 0 1900 6.9 no no single drive/bus 2
79.0 Male 18 17.67 20.98 3.32 Norm Normal Normal 50.73 61.15 10.42 169.45 170.71 0 2400 7.4 no yes single drive/bus 2
80.0 Male 19 23.07 25.38 2.31 Norm Normal Overweight/Obese 70.98 79.28 8.30 175.41 176.74 0 1900 6.8 no no single drive/bus 2
81.0 Male 19 25.41 26.52 1.11 Over Overweight/Obese Overweight/Obese 76.51 79.88 3.37 173.52 173.55 0 2000 8.3 yes yes single walk 3
82.0 Female 22 24.76 26.47 1.71 Norm Normal Overweight/Obese 58.84 63.42 4.58 154.17 154.80 0 2200 6.6 yes yes relationship walk 3
83.0 Male 18 24.74 27.69 2.95 Norm Normal Overweight/Obese 78.10 89.15 11.05 177.68 179.44 59 2100 7.2 no no single drive/bus 2
84.0 Female 19 18.62 20.47 1.85 Norm Normal Normal 47.00 51.70 4.70 158.87 158.92 51 2500 7.3 no yes relationship walk 3
85.0 Female 19 28.14 29.83 1.69 Over Overweight/Obese Overweight/Obese 73.38 78.53 5.15 161.49 162.24 41 2500 7.7 no yes single drive/bus 2
86.0 Male 19 23.19 24.79 1.60 Norm Normal Normal 75.40 81.22 5.83 180.32 181.01 0 2200 8.3 yes no single walk 3
87.0 Female 19 23.81 25.45 1.64 Norm Normal Overweight/Obese 63.19 67.95 4.76 162.91 163.40 32 2100 6.6 yes no single walk 3
88.0 Female 19 29.60 30.12 0.52 Over Overweight/Obese Overweight/Obese 88.51 90.16 1.64 172.93 173.02 34 2100 6.8 yes no single walk 3
89.0 Male 19 27.54 28.95 1.41 Over Overweight/Obese Overweight/Obese 84.68 90.01 5.33 175.34 176.31 51 1900 6.2 no no relationship drive/bus 2
90.0 Male 18 26.89 27.86 0.97 Over Overweight/Obese Overweight/Obese 82.88 85.93 3.05 175.57 175.62 21 2100 9.2 yes yes relationship walk 3
91.0 Male 19 21.82 21.64 -0.17 Norm Normal Normal 64.04 63.58 -0.46 171.34 171.39 52 2100 8.9 no yes relationship walk 3
92.0 Male 19 24.00 28.12 4.12 Norm Normal Overweight/Obese 76.68 90.24 13.56 178.74 179.15 0 3500 6.7 no yes relationship walk 3
93.0 Female 19 24.49 26.30 1.81 Norm Normal Overweight/Obese 66.90 72.87 5.97 165.27 166.43 0 2100 7.6 yes no single drive/bus 2
94.0 Male 18 30.58 28.44 -2.14 Over Overweight/Obese Overweight/Obese 94.41 89.15 -5.26 175.72 177.05 0 2200 7.3 yes no single bike 1
95.0 Female 19 23.67 26.40 2.73 Norm Normal Overweight/Obese 63.41 70.79 7.38 163.69 163.76 0 2100 6.8 no yes single walk 3
96.0 Female 19 24.17 26.79 2.63 Norm Normal Overweight/Obese 65.28 73.38 8.10 164.35 165.49 0 2800 7.1 no yes relationship drive/bus 2
97.0 Female 21 27.06 27.32 0.27 Over Overweight/Obese Overweight/Obese 75.25 76.15 0.90 166.77 166.94 55 2100 7.4 yes yes relationship walk 3
98.0 Female 18 24.77 28.19 3.42 Norm Normal Overweight/Obese 69.45 79.47 10.02 167.44 167.89 29 2100 7.8 yes yes relationship walk 3
99.0 Female 22 24.70 26.79 2.09 Norm Normal Overweight/Obese 66.25 72.87 6.61 163.79 164.93 0 1800 8.0 no yes single drive/bus 2
100.0 Male 19 22.49 20.21 -2.29 Norm Normal Normal 72.29 66.16 -6.12 179.27 180.95 30 2100 6.6 yes yes relationship walk 3
101.0 Female 18 19.23 19.72 0.49 Norm Normal Normal 47.80 49.26 1.46 157.67 158.06 46 1900 7.8 no no relationship walk 3
102.0 Male 19 24.95 26.47 1.53 Over Overweight/Obese Overweight/Obese 79.37 84.43 5.06 178.37 178.58 0 2100 6.0 yes no relationship drive/bus 2
103.0 Female 18 21.58 23.61 2.02 Norm Normal Normal 61.06 66.88 5.82 168.19 168.32 0 2800 6.9 yes yes single walk 3
104.0 Female 19 23.53 23.22 -0.31 Norm Normal Normal 58.51 58.73 0.22 157.67 159.03 49 1700 7.3 yes yes relationship walk 3
105.0 Male 18 22.58 25.20 2.62 Norm Normal Overweight/Obese 79.39 88.97 9.59 187.52 187.90 0 2100 7.1 yes yes relationship drive/bus 2
106.0 Male 20 23.18 22.48 -0.70 Norm Normal Normal 64.39 62.77 -1.61 166.67 167.10 0 2000 7.2 yes yes single drive/bus 2
107.0 Male 19 23.67 24.35 0.67 Norm Normal Normal 84.32 86.90 2.58 188.73 188.93 37 1900 6.6 yes yes single drive/bus 2
108.0 Male 18 19.50 21.93 2.43 Norm Normal Normal 51.07 57.96 6.89 161.84 162.59 0 2200 7.1 yes no relationship drive/bus 2
109.0 Female 20 26.32 27.24 0.92 Over Overweight/Obese Overweight/Obese 69.07 71.67 2.60 161.99 162.21 0 2000 6.4 no yes single walk 3
110.0 Female 18 24.91 27.19 2.27 Over Overweight/Obese Overweight/Obese 72.04 78.72 6.68 170.04 170.16 41 1900 6.7 no no relationship bike 1
111.0 Male 18 32.89 32.43 -0.47 Over Overweight/Obese Overweight/Obese 104.27 103.07 -1.21 178.04 178.28 0 3700 7.9 yes no single drive/bus 2
112.0 Male 19 29.13 33.56 4.43 Over Overweight/Obese Overweight/Obese 95.58 112.57 16.99 181.14 183.15 0 2400 7.0 yes yes single drive/bus 2
113.0 Female 18 23.74 24.03 0.29 Norm Normal Normal 64.69 66.47 1.78 165.08 166.33 47 1700 7.1 yes yes single walk 3
114.0 Male 20 29.83 31.63 1.80 Over Overweight/Obese Overweight/Obese 97.39 104.67 7.27 180.70 181.92 38 2400 7.6 yes no relationship drive/bus 2
115.0 Male 19 32.65 32.29 -0.36 Over Overweight/Obese Overweight/Obese 111.95 111.56 -0.39 185.18 185.88 45 1600 7.9 no no single bike 1
116.0 Male 18 25.20 27.64 2.43 Over Overweight/Obese Overweight/Obese 94.19 104.74 10.55 193.31 194.68 48 2200 8.6 yes yes single walk 3
117.0 Male 18 17.91 19.09 1.19 Norm Normal Normal 52.25 55.78 3.52 170.82 170.92 45 2200 7.9 no no relationship walk 3
118.0 Female 18 17.88 19.81 1.93 Norm Normal Normal 46.47 52.51 6.04 161.22 162.82 0 2200 7.2 yes no relationship drive/bus 2
119.0 Male 19 25.58 24.66 -0.92 Over Overweight/Obese Normal 88.55 85.37 -3.18 186.04 186.05 0 1700 7.8 no no single walk 3
120.0 Female 18 21.05 23.74 2.68 Norm Normal Normal 54.28 61.70 7.43 160.57 161.23 49 2100 7.6 no yes relationship drive/bus 2