Data Analysis

profilerisele
data_collection.xlsx

ChartDataSheet_

This worksheet contains values required for MegaStat charts.
Boxplot 4/7/2014 21:03.22
2 -4
2 0
3 0
3 1
1 1
3 1
3 3
2 3
2 7
2 3
1 3
1 0
2 0
1 -9
3 -9
1 -4.5
3 -4.5
1 7.5
3 7.5
1 12
3 12

Output

Frequency Distribution - Quantitative
Change in Weight cumulative
lower upper midpoint width frequency percent frequency percent
-4 < -2 -3 2 3 4.5 3 4.5
-2 < -0 -1 2 13 19.7 16 24.2
0 < 2 1 2 21 31.8 37 56.1
2 < 4 3 2 17 25.8 54 81.8
4 < 6 5 2 9 13.6 63 95.5
6 < 8 7 2 3 4.5 66 100.0
7.99
66 100.0
Descriptive statistics
Change in Weight
count 66
mean 1.23
sample standard deviation 2.40
sample variance 5.78
minimum -4.0
maximum 7.0
range 11.0
1st quartile 0.00
median 1.00
3rd quartile 3.00
interquartile range 3.00
mode 0.00
low extremes 0
low outliers 0
high outliers 0
high extremes 0
Descriptive statistics
Change in Weight
count 66
4/7/2014 21:03.22 (1)

Histogram

-4 -2 0 2 4 6 7.99 4.5454545454545459 19.696969696969695 31.818181818181817 25.757575757575758 13.636363636363635 4.5454545454545459

Change in Weight

Percent

BoxPlot

-4 0 0 1 1 1 3 3 7 3 3 0 0 2 2 3 3 1 3 3 2 2 2 1 1 2

Change in Weight

Freshmen Weight

Subject DormsRUs or On-campus (O) Initial Weight (lbs) Final Weight (lbs) Gender Change in Weight
1 D 172 168 M -4
2 O 134 136 F 2
3 O 114 114 F 0
4 D 157 159 M 2
6 O 142 148 F 6
7 O 104 105 F 1
8 D 131 131 F 0
9 D 135 134 M -1
10 O 167 170 M 3
11 D 158 160 M 2
12 O 224 230 M 6
14 D 145 148 F 3
15 D 122 121 F -1
16 O 115 119 F 4
17 O 187 192 M 5
18 D 110 111 F 1
19 O 198 201 M 3
20 D 127 127 F 0
22 O 220 225 M 5
23 D 150 149 F -1
24 D 156 154 M -2
25 D 120 117 F -3
26 O 102 105 F 3
27 O 144 148 M 4
28 D 125 125 F 0
29 D 134 134 F 0
30 O 142 146 M 4
31 D 160 161 M 1
32 O 149 151 F 2
33 D 165 164 M -1
35 D 146 146 F 0
36 O 155 158 M 3
37 O 106 108 F 2
38 D 107 107 F 0
39 D 168 164 M -4
40 O 142 145 M 3
41 D 160 161 M 1
42 O 121 123 F 2
43 O 122 124 F 2
44 D 111 112 F 1
45 D 161 160 M -1
46 O 120 124 F 4
47 D 119 120 F 1
48 D 131 129 F -2
49 D 155 153 M -2
50 O 146 146 F 0
51 O 121 123 F 2
52 O 167 170 M 3
53 O 115 119 F 4
54 D 132 133 M 1
55 D 112 111 F -1
56 D 151 151 F 0
57 D 162 160 M -2
58 O 119 126 F 7
59 O 145 148 M 3
60 D 105 105 F 0
61 O 132 133 F 1
62 D 166 165 M -1
63 O 116 120 F 4
64 O 185 189 M 4
65 D 121 121 F 0
66 O 173 174 M 1
67 D 177 178 M 1
68 D 169 167 M -2
69 O 156 159 M 3
70 O 141 140 F -1

Sheet2

Sheet3