BUSINESS STAT CHARTS
retred
data_analysis_project_1_data_16t2.xlsxRaw Data
| Enter the last four digits of your student number, one digit per column in the following row: | Likert Scales | Likert Value | Wall? | |||||||||||||||||
| Example: Student number = 1442017 | 6 | 5 | 4 | 6 | ||||||||||||||||
| 1 | Adult | Spa | 5 | Very satistifed | ||||||||||||||||
| Your data: | Age | # visits YTD | Fees YTD | Plan | Add-on | Likert Q1 | Likert Q2 | Likert Q3 | Q4 | Week # | Advertising | # New | 2 | Family | Studio | 4 | Satisfied | |||
| 51 | 40 | 264 | Silver | Racquet | 4 | 3 | 5 | No | 1 | $ 84.42 | 4 | 3 | Silver | Trainer | 3 | Neutral | ||||
| 64 | 80 | 276 | Family | Spa | 3 | 3 | 1 | No | 2 | $ 66.86 | 1 | 4 | Gold | Racquet | 2 | Dissatisfied | No | |||
| 60 | 21 | 169 | Silver | Trainer | 5 | 3 | 2 | No | 3 | $ 192.34 | 4 | 1 | Very dissatisfied | YES | ||||||
| 38 | 24 | 235 | Gold | Spa | 3 | 3 | 1 | YES | 4 | $ 108.93 | 3 | |||||||||
| 26 | 69 | 212 | Family | Studio | 3 | 4 | 5 | YES | 5 | $ 120.12 | 1 | Q1: | Overall satisfaction with fitness package | |||||||
| 33 | 78 | 270 | Silver | Studio | 2 | 3 | 2 | YES | 6 | $ 72.59 | 3 | Q2: | Overall satisfaction with gym facilities | |||||||
| 34 | 128 | 144 | Silver | Spa | 5 | 5 | 2 | No | 7 | $ 66.12 | 2 | Q3: | Satisfaction with fitness staff | |||||||
| 30 | 68 | 264 | Silver | Spa | 3 | 4 | 4 | No | 8 | $ 216.02 | 4 | Q4: | Interest in climbing wall YES/NO | |||||||
| 44 | 22 | 297 | Silver | Spa | 4 | 3 | 4 | YES | 9 | $ 198.82 | 5 | |||||||||
| 32 | 163 | 230 | Gold | Trainer | 5 | 3 | 4 | YES | 10 | $ 126.63 | 2 | Adversiting = Weekly Advertising Expenditure | ||||||||
| 64 | 121 | 202 | Silver | Studio | 5 | 4 | 5 | No | 11 | $ 300.76 | 6 | # New = number of new memberships | ||||||||
| 43 | 36 | 277 | Gold | Spa | 5 | 5 | 2 | YES | 12 | $ 150.24 | 3 | |||||||||
| 68 | 76 | 301 | Gold | Spa | 3 | 5 | 1 | No | 13 | $ 102.33 | 3 | |||||||||
| 57 | 41 | 185 | Silver | Trainer | 1 | 2 | 1 | No | 14 | $ 282.52 | 6 | |||||||||
| 59 | 40 | 201 | Family | Racquet | 1 | 3 | 4 | No | 15 | $ 96.80 | 2 | |||||||||
| 34 | 56 | 133 | Adult | Spa | 2 | 4 | 3 | No | 16 | $ 186.08 | 3 | |||||||||
| 50 | 85 | 133 | Gold | Spa | 5 | 2 | 1 | No | 17 | $ 186.84 | 4 | |||||||||
| 21 | 61 | 103 | Family | Racquet | 2 | 2 | 1 | YES | 18 | $ 294.94 | 6 | |||||||||
| 33 | 70 | 195 | Gold | Studio | 2 | 4 | 3 | YES | 19 | $ 150.62 | 3 | |||||||||
| 29 | 101 | 242 | Gold | Studio | 1 | 3 | 4 | No | 20 | $ 240.67 | 5 | |||||||||
| 28 | 29 | 261 | Gold | Studio | 5 | 1 | 4 | No | 21 | $ 204.42 | 4 | |||||||||
| 29 | 100 | 199 | Gold | Racquet | 5 | 3 | 5 | YES | 22 | $ 60.90 | 3 | |||||||||
| 60 | 22 | 283 | Gold | Studio | 1 | 5 | 3 | YES | 23 | $ 90.43 | 4 | |||||||||
| 46 | 98 | 286 | Family | Studio | 2 | 5 | 1 | No | 24 | $ 138.13 | 4 | |||||||||
| 46 | 23 | 116 | Family | Trainer | 5 | 1 | 1 | No | 25 | $ 102.76 | 2 | |||||||||
| 58 | 66 | 245 | Gold | Studio | 2 | 4 | 1 | No | 26 | $ 198.18 | 6 | |||||||||
| 39 | 64 | 259 | Family | Racquet | 2 | 5 | 3 | YES | 27 | $ 66.76 | 0 | |||||||||
| 57 | 96 | 149 | Family | Racquet | 5 | 2 | 1 | YES | 28 | $ 108.15 | 1 | |||||||||
| 33 | 128 | 295 | Adult | Racquet | 4 | 5 | 1 | No | 29 | $ 276.56 | 6 | |||||||||
| 54 | 46 | 209 | Adult | Racquet | 3 | 1 | 2 | YES | 30 | $ 198.30 | 6 | |||||||||
| 55 | 97 | 242 | Family | Spa | 2 | 3 | 3 | No | 31 | $ 138.66 | 5 | |||||||||
| 29 | 140 | 234 | Gold | Trainer | 2 | 1 | 4 | YES | 32 | $ 114.06 | 4 | |||||||||
| 33 | 106 | 276 | Adult | Trainer | 1 | 5 | 5 | YES | 33 | $ 276.87 | 6 | |||||||||
| 19 | 155 | 187 | Family | Spa | 1 | 3 | 1 | No | 34 | $ 132.13 | 2 | |||||||||
| 29 | 155 | 207 | Silver | Studio | 3 | 2 | 1 | No | 35 | $ 252.04 | 5 | |||||||||
| 66 | 126 | 236 | Gold | Studio | 3 | 3 | 5 | No | 36 | $ 252.23 | 5 | |||||||||
| 59 | 150 | 231 | Silver | Trainer | 2 | 3 | 1 | YES | 37 | $ 102.42 | 3 | |||||||||
| 24 | 155 | 134 | Gold | Studio | 5 | 3 | 5 | YES | 38 | $ 216.12 | 4 | |||||||||
| 31 | 103 | 273 | Silver | Trainer | 5 | 2 | 3 | YES | 39 | $ 216.97 | 5 | |||||||||
| 37 | 101 | 159 | Gold | Studio | 4 | 2 | 5 | YES | 40 | $ 138.17 | 4 | |||||||||
| 61 | 103 | 222 | Gold | Spa | 3 | 1 | 1 | No | 41 | $ 114.53 | 3 | |||||||||
| 29 | 106 | 111 | Gold | Spa | 3 | 3 | 3 | No | 42 | $ 108.05 | 2 | |||||||||
| 32 | 45 | 251 | Gold | Studio | 1 | 2 | 4 | No | 43 | $ 114.96 | 3 | |||||||||
| 50 | 92 | 247 | Gold | Studio | 2 | 3 | 4 | YES | 44 | $ 84.51 | 3 | |||||||||
| 34 | 75 | 259 | Adult | Studio | 4 | 5 | 4 | YES | 45 | $ 192.29 | 4 | |||||||||
| 39 | 70 | 186 | Gold | Trainer | 3 | 3 | 2 | No | 46 | $ 168.73 | 5 | |||||||||
| 49 | 29 | 301 | Family | Racquet | 1 | 5 | 3 | No | 47 | $ 216.29 | 6 | |||||||||
| 33 | 146 | 156 | Silver | Spa | 3 | 3 | 3 | YES | 48 | $ 252.42 | 5 | |||||||||
| 33 | 50 | 244 | Silver | Racquet | 2 | 4 | 4 | YES | 49 | $ 416.75 | 9 | |||||||||
| 34 | 56 | 135 | Family | Studio | 5 | 3 | 4 | No | 50 | $ 525.17 | 12 | |||||||||
| 58 | 147 | 247 | Silver | Studio | 2 | 4 | 3 | YES | 51 | $ 449.68 | 10 | |||||||||
| 51 | 61 | 106 | Family | Studio | 1 | 1 | 4 | No | 52 | $ 375.52 | 7 | |||||||||
| 56 | 45 | 274 | Gold | Spa | 3 | 4 | 5 | YES | 53 | $ 545.63 | 12 | |||||||||
| 25 | 138 | 158 | Silver | Studio | 5 | 5 | 4 | YES | 54 | $ 84.07 | 1 | |||||||||
| 33 | 96 | 258 | Family | Studio | 2 | 4 | 2 | YES | 55 | $ 270.08 | 5 | |||||||||
| 52 | 68 | 261 | Gold | Spa | 1 | 3 | 3 | No | 56 | $ 186.55 | 4 | |||||||||
| 22 | 44 | 279 | Family | Trainer | 5 | 2 | 4 | No | 57 | $ 282.06 | 7 | |||||||||
| 52 | 52 | 299 | Gold | Spa | 3 | 5 | 4 | No | 58 | $ 300.59 | 6 | |||||||||
| 29 | 131 | 187 | Gold | Trainer | 5 | 3 | 5 | YES | 59 | $ 72.26 | 1 | |||||||||
| 42 | 69 | 224 | Family | Racquet | 5 | 1 | 4 | YES | 60 | $ 72.87 | 2 | |||||||||
| 35 | 156 | 236 | Adult | Racquet | 3 | 1 | 4 | No | 61 | $ 198.60 | 4 | |||||||||
| 25 | 108 | 272 | Silver | Studio | 4 | 2 | 2 | YES | 62 | $ 102.68 | 2 | |||||||||
| 36 | 149 | 176 | Silver | Racquet | 5 | 1 | 3 | No | 63 | $ 120.31 | 3 | |||||||||
| 40 | 101 | 282 | Adult | Racquet | 2 | 2 | 3 | No | 64 | $ 132.93 | 3 | |||||||||
| 36 | 71 | 181 | Silver | Racquet | 3 | 3 | 2 | YES | 65 | $ 132.17 | 3 | |||||||||
| 37 | 71 | 299 | Gold | Racquet | 1 | 4 | 1 | No | 66 | $ 276.88 | 7 | |||||||||
| 26 | 145 | 205 | Adult | Racquet | 2 | 5 | 1 | No | 67 | $ 210.30 | 5 | |||||||||
| 28 | 61 | 279 | Family | Trainer | 1 | 3 | 3 | YES | 68 | $ 96.33 | 3 | |||||||||
| 22 | 98 | 127 | Adult | Studio | 2 | 5 | 5 | YES | 69 | $ 138.74 | 3 | |||||||||
| 23 | 116 | 109 | Adult | Racquet | 2 | 5 | 1 | No | 70 | $ 132.63 | 4 | |||||||||
| 29 | 90 | 152 | Adult | Trainer | 5 | 2 | 2 | No | 71 | $ 198.38 | 4 | |||||||||
| 29 | 83 | 268 | Silver | Trainer | 1 | 5 | 2 | YES | 72 | $ 234.09 | 5 | |||||||||
| 18 | 138 | 140 | Family | Trainer | 5 | 1 | 2 | YES | 73 | $ 222.21 | 3 | |||||||||
| 24 | 117 | 152 | Silver | Trainer | 1 | 2 | 5 | No | 74 | $ 300.88 | 7 | |||||||||
| 24 | 120 | 107 | Adult | Spa | 4 | 4 | 3 | No | 75 | $ 78.48 | 1 | |||||||||
| 19 | 80 | 289 | Adult | Racquet | 4 | 3 | 5 | YES | 76 | $ 102.72 | 4 | |||||||||
| 45 | 112 | 121 | Silver | Trainer | 4 | 4 | 4 | No | 77 | $ 192.83 | 6 | |||||||||
| 20 | 61 | 222 | Silver | Racquet | 5 | 5 | 3 | No | 78 | $ 288.43 | 5 | |||||||||
| 33 | 29 | 267 | Adult | Studio | 4 | 4 | 5 | No | 79 | $ 246.71 | 6 | |||||||||
| 22 | 114 | 206 | Gold | Studio | 1 | 1 | 2 | YES | 80 | $ 138.19 | 4 | |||||||||
| 39 | 125 | 188 | Silver | Spa | 5 | 1 | 4 | YES | 81 | $ 102.48 | 2 | |||||||||
| 42 | 146 | 143 | Silver | Trainer | 1 | 1 | 2 | YES | 82 | $ 66.86 | 1 | |||||||||
| 28 | 130 | 174 | Silver | Racquet | 4 | 2 | 4 | YES | 83 | $ 282.73 | 7 | |||||||||
| 50 | 50 | 202 | Adult | Studio | 2 | 5 | 1 | No | 84 | $ 84.33 | 2 | |||||||||
| 28 | 129 | 171 | Gold | Spa | 2 | 1 | 2 | No | 85 | $ 192.74 | 4 | |||||||||
| 35 | 53 | 153 | Silver | Trainer | 1 | 1 | 3 | No | 86 | $ 276.27 | 6 | |||||||||
| 50 | 78 | 293 | Family | Trainer | 2 | 3 | 4 | No | 87 | $ 198.97 | 5 | |||||||||
| 27 | 97 | 246 | Adult | Spa | 3 | 4 | 4 | No | 88 | $ 204.70 | 4 | |||||||||
| 54 | 106 | 298 | Gold | Studio | 2 | 4 | 2 | No | 89 | $ 72.32 | 3 | |||||||||
| 30 | 100 | 182 | Adult | Spa | 4 | 4 | 5 | YES | 90 | $ 241.00 | 6 | |||||||||
| 28 | 29 | 152 | Silver | Racquet | 5 | 2 | 5 | No | 91 | $ 90.14 | 4 | |||||||||
| 54 | 118 | 215 | Silver | Studio | 3 | 3 | 5 | No | 92 | $ 252.37 | 6 | |||||||||
| 44 | 22 | 185 | Gold | Spa | 4 | 2 | 3 | No | 93 | $ 186.30 | 5 | |||||||||
| 18 | 21 | 243 | Adult | Trainer | 5 | 4 | 2 | No | 94 | $ 222.56 | 4 | |||||||||
| 23 | 155 | 136 | Silver | Spa | 1 | 2 | 5 | No | 95 | $ 276.88 | 6 | |||||||||
| 35 | 72 | 278 | Gold | Studio | 1 | 3 | 1 | No | 96 | $ 234.78 | 4 | |||||||||
| 45 | 75 | 213 | Adult | Studio | 5 | 4 | 2 | YES | 97 | $ 234.26 | 5 | |||||||||
| 56 | 65 | 256 | Adult | Trainer | 3 | 1 | 2 | YES | 98 | $ 90.10 | 3 | |||||||||
| 38 | 66 | 265 | Family | Trainer | 3 | 2 | 1 | No | 99 | $ 300.57 | 8 | |||||||||
| 34 | 128 | 153 | Gold | Racquet | 3 | 3 | 3 | YES | 100 | $ 162.83 | 2 | |||||||||
| 39 | 24 | 220 | Gold | Spa | 3 | 4 | 1 | YES | 101 | $ 60.96 | 3 | |||||||||
| 24 | 62 | 273 | Silver | Studio | 1 | 2 | 2 | No | 102 | $ 288.07 | 7 | |||||||||
| 41 | 102 | 210 | Adult | Racquet | 2 | 3 | 3 | No | 103 | $ 78.59 | 2 | |||||||||
| 36 | 129 | 224 | Gold | Studio | 3 | 4 | 4 | No | 104 | $ 198.25 | 5 | |||||||||
| 28 | 22 | 143 | Adult | Racquet | 5 | 4 | 4 | No | 105 | $ 72.87 | 2 | |||||||||
| 54 | 24 | 154 | Adult | Spa | 4 | 2 | 2 | YES | 106 | $ 156.57 | 3 | |||||||||
| 51 | 65 | 228 | Family | Spa | 5 | 4 | 1 | YES | 107 | $ 276.67 | 6 | |||||||||
| 44 | 48 | 137 | Adult | Racquet | 4 | 5 | 2 | No | 108 | $ 132.05 | 3 | |||||||||
| 22 | 23 | 231 | Adult | Racquet | 5 | 4 | 5 | YES | 109 | $ 144.19 | 4 | |||||||||
| 50 | 110 | 172 | Family | Spa | 1 | 2 | 1 | YES | 110 | $ 162.70 | 5 | |||||||||
| 21 | 36 | 252 | Silver | Trainer | 5 | 4 | 4 | YES | 111 | $ 144.59 | 3 | |||||||||
| 60 | 45 | 186 | Family | Spa | 2 | 5 | 1 | No | 112 | $ 66.34 | 2 | |||||||||
| 18 | 101 | 197 | Gold | Trainer | 4 | 3 | 1 | YES | 113 | $ 84.98 | 3 | |||||||||
| 25 | 60 | 181 | Gold | Studio | 2 | 4 | 5 | No | 114 | $ 270.46 | 7 | |||||||||
| 31 | 115 | 293 | Silver | Studio | 1 | 4 | 5 | YES | 115 | $ 282.08 | 7 | |||||||||
| 48 | 156 | 281 | Silver | Trainer | 3 | 4 | 4 | YES | 116 | $ 300.67 | 8 | |||||||||
| 56 | 60 | 183 | Silver | Studio | 4 | 1 | 2 | No | 117 | $ 96.67 | 3 | |||||||||
| 19 | 47 | 258 | Adult | Studio | 2 | 3 | 3 | YES | 118 | $ 204.05 | 3 | |||||||||
| 46 | 133 | 215 | Adult | Studio | 1 | 4 | 1 | No | 119 | $ 90.85 | 1 | |||||||||
| 19 | 60 | 176 | Gold | Racquet | 5 | 5 | 4 | YES | 120 | $ 258.35 | 6 | |||||||||
| 18 | 86 | 149 | Family | Racquet | 1 | 5 | 2 | YES | 121 | $ 72.25 | 1 | |||||||||
| 27 | 52 | 120 | Silver | Spa | 5 | 5 | 5 | No | 122 | $ 108.51 | 1 | |||||||||
| 40 | 113 | 181 | Family | Studio | 4 | 4 | 5 | YES | 123 | $ 174.77 | 3 | |||||||||
| 19 | 129 | 259 | Family | Studio | 2 | 4 | 3 | No | 124 | $ 264.55 | 7 | |||||||||
| 28 | 134 | 274 | Gold | Studio | 3 | 3 | 4 | No | 125 | $ 168.84 | 5 | |||||||||
| 35 | 119 | 101 | Adult | Spa | 5 | 2 | 2 | No | 126 | $ 132.45 | 4 | |||||||||
| 20 | 130 | 181 | Family | Studio | 4 | 4 | 4 | YES | 127 | $ 234.94 | 7 | |||||||||
| 24 | 140 | 279 | Silver | Spa | 3 | 1 | 5 | YES | 128 | $ 180.34 | 5 | |||||||||
| 36 | 84 | 169 | Adult | Trainer | 1 | 5 | 1 | YES | 129 | $ 300.84 | 8 | |||||||||
| 40 | 32 | 229 | Adult | Studio | 5 | 2 | 2 | No | 130 | $ 168.77 | 2 | |||||||||
| 33 | 111 | 291 | Silver | Trainer | 1 | 3 | 4 | No | 131 | $ 276.80 | 5 | |||||||||
| 36 | 66 | 103 | Gold | Spa | 1 | 4 | 3 | No | 132 | $ 66.42 | 1 | |||||||||
| 22 | 57 | 153 | Family | Spa | 3 | 2 | 4 | No | 133 | $ 300.37 | 7 | |||||||||
| 19 | 125 | 134 | Family | Studio | 1 | 4 | 5 | YES | 134 | $ 168.91 | 3 | |||||||||
| 36 | 155 | 143 | Adult | Studio | 5 | 4 | 5 | No | 135 | $ 102.36 | 3 | |||||||||
| 36 | 141 | 256 | Gold | Trainer | 3 | 4 | 4 | YES | 136 | $ 204.51 | 4 | |||||||||
| 27 | 46 | 231 | Family | Studio | 3 | 4 | 4 | No | 137 | $ 156.79 | 4 | |||||||||
| 22 | 41 | 142 | Family | Racquet | 5 | 2 | 5 | YES | 138 | $ 300.87 | 8 | |||||||||
| 26 | 61 | 243 | Gold | Racquet | 1 | 2 | 5 | YES | 139 | $ 234.25 | 6 | |||||||||
| 23 | 40 | 287 | Adult | Spa | 2 | 2 | 2 | No | 140 | $ 156.76 | 5 | |||||||||
| 31 | 56 | 174 | Silver | Trainer | 4 | 5 | 1 | No | 141 | $ 282.41 | 5 | |||||||||
| 39 | 47 | 254 | Family | Spa | 5 | 1 | 4 | No | 142 | $ 150.59 | 5 | |||||||||
| 21 | 70 | 273 | Silver | Trainer | 1 | 4 | 2 | YES | 143 | $ 525.00 | 10 | |||||||||
| 30 | 105 | 269 | Gold | Trainer | 2 | 3 | 2 | No | 144 | $ 102.95 | 1 | |||||||||
| 23 | 69 | 140 | Adult | Racquet | 5 | 5 | 4 | No | 145 | $ 120.84 | 3 | |||||||||
| 26 | 49 | 240 | Family | Trainer | 4 | 2 | 3 | YES | 146 | $ 150.56 | 3 | |||||||||
| 35 | 143 | 140 | Gold | Racquet | 1 | 5 | 3 | No | 147 | $ 78.84 | 3 | |||||||||
| 23 | 108 | 186 | Family | Spa | 4 | 3 | 4 | YES | 148 | $ 126.61 | 3 | |||||||||
| 33 | 56 | 103 | Silver | Spa | 4 | 2 | 5 | No | 149 | $ 126.16 | 3 | |||||||||
| 35 | 107 | 223 | Gold | Trainer | 5 | 5 | 4 | YES | 150 | $ 234.86 | 6 | |||||||||
| 150 | ||||||||||||||||||||
My Data
| Enter the last four digits of your student number, one digit per column in the following row: | Likert Scales | Likert Value | Wall? | |||||||||||||||||
| Example: Student number = 1442017 | 6 | 5 | 4 | 6 | ||||||||||||||||
| 1 | Adult | Spa | 5 | Very satistifed | ||||||||||||||||
| Your data: | Age | # visits YTD | Fees YTD | Plan | Add-on | Likert Q1 | Likert Q2 | Likert Q3 | Q4 | Week # | Advertising | # New | 2 | Family | Studio | 4 | Satisfied | |||
| 23 | 133 | 156 | Family | Studio | 1 | 1 | 5 | No | 1 | $ 174.45 | 3 | 3 | Silver | Trainer | 3 | Neutral | ||||
| 28 | 144 | 178 | Silver | Spa | 2 | 2 | 2 | No | 2 | $ 192.95 | 3 | 4 | Gold | Racquet | 2 | Dissatisfied | No | |||
| 59 | 71 | 301 | Adult | Studio | 5 | 4 | 4 | YES | 3 | $ 270.08 | 6 | 1 | Very dissatisfied | YES | ||||||
| 40 | 144 | 187 | Family | Racquet | 5 | 5 | 1 | YES | 4 | $ 78.79 | 3 | |||||||||
| 37 | 164 | 247 | Adult | Studio | 5 | 3 | 3 | No | 5 | $ 276.18 | 6 | Q1: | Overall satisfaction with fitness package | |||||||
| 51 | 21 | 212 | Gold | Studio | 1 | 5 | 5 | YES | 6 | $ 258.50 | 5 | Q2: | Overall satisfaction with gym facilities | |||||||
| 47 | 132 | 245 | Silver | Trainer | 4 | 1 | 3 | No | 7 | $ 163.00 | 5 | Q3: | Satisfaction with fitness staff | |||||||
| 30 | 137 | 143 | Adult | Spa | 1 | 1 | 2 | No | 8 | $ 108.17 | 4 | Q4: | Interest in climbing wall YES/NO | |||||||
| 24 | 131 | 292 | Adult | Spa | 2 | 5 | 2 | No | 9 | $ 276.69 | 6 | |||||||||
| 53 | 67 | 252 | Family | Spa | 2 | 2 | 1 | YES | 10 | $ 258.28 | 5 | Adversiting = Weekly Advertising Expenditure | ||||||||
| 63 | 114 | 293 | Family | Studio | 3 | 4 | 4 | YES | 11 | $ 180.31 | 5 | # New = number of new memberships | ||||||||
| 33 | 73 | 253 | Silver | Trainer | 1 | 4 | 1 | YES | 12 | $ 108.99 | 1 | |||||||||
| 34 | 98 | 168 | Family | Trainer | 3 | 2 | 2 | YES | 13 | $ 258.88 | 4 | |||||||||
| 43 | 119 | 112 | Gold | Racquet | 2 | 2 | 5 | YES | 14 | $ 156.55 | 4 | |||||||||
| 20 | 114 | 198 | Adult | Racquet | 4 | 1 | 1 | No | 15 | $ 300.02 | 7 | |||||||||
| 34 | 85 | 177 | Adult | Trainer | 3 | 3 | 1 | No | 16 | $ 288.01 | 6 | |||||||||
| 19 | 40 | 128 | Adult | Spa | 5 | 2 | 2 | YES | 17 | $ 108.12 | 3 | |||||||||
| 34 | 137 | 272 | Gold | Racquet | 2 | 4 | 1 | No | 18 | $ 300.85 | 5 | |||||||||
| 40 | 71 | 156 | Gold | Trainer | 4 | 3 | 4 | No | 19 | $ 174.47 | 3 | |||||||||
| 23 | 92 | 136 | Family | Studio | 1 | 5 | 4 | YES | 20 | $ 126.00 | 2 | |||||||||
| 35 | 54 | 265 | Silver | Studio | 2 | 1 | 2 | YES | 21 | $ 96.82 | 2 | |||||||||
| 65 | 139 | 191 | Adult | Racquet | 1 | 1 | 3 | No | 22 | $ 264.21 | 7 | |||||||||
| 20 | 78 | 212 | Adult | Studio | 5 | 3 | 4 | YES | 23 | $ 264.47 | 5 | |||||||||
| 64 | 21 | 253 | Gold | Racquet | 3 | 2 | 2 | No | 24 | $ 78.46 | 3 | |||||||||
| 18 | 62 | 235 | Family | Spa | 1 | 3 | 4 | No | 25 | $ 96.09 | 3 | |||||||||
| 25 | 34 | 288 | Family | Racquet | 5 | 1 | 4 | YES | 26 | $ 84.46 | 2 | |||||||||
| 60 | 82 | 136 | Silver | Trainer | 5 | 5 | 1 | No | 27 | $ 252.87 | 7 | |||||||||
| 62 | 140 | 202 | Adult | Spa | 2 | 2 | 3 | YES | 28 | $ 78.95 | 4 | |||||||||
| 21 | 27 | 287 | Adult | Spa | 1 | 1 | 2 | No | 29 | $ 210.16 | 5 | |||||||||
| 61 | 106 | 263 | Silver | Spa | 5 | 5 | 5 | No | 30 | $ 102.26 | 3 | |||||||||
| 53 | 156 | 301 | Adult | Trainer | 5 | 3 | 4 | No | 31 | $ 90.55 | 4 | |||||||||
| 31 | 18 | 105 | Silver | Studio | 5 | 1 | 1 | YES | 32 | $ 84.76 | 2 | |||||||||
| 20 | 163 | 201 | Family | Spa | 3 | 4 | 4 | No | 33 | $ 222.87 | 3 | |||||||||
| 59 | 74 | 140 | Family | Spa | 4 | 1 | 3 | No | 34 | $ 228.04 | 4 | |||||||||
| 67 | 109 | 141 | Adult | Studio | 2 | 3 | 2 | YES | 35 | $ 78.68 | 2 | |||||||||
| 41 | 23 | 165 | Gold | Trainer | 2 | 5 | 1 | YES | 36 | $ 264.70 | 5 | |||||||||
| 20 | 125 | 282 | Family | Racquet | 5 | 2 | 1 | YES | 37 | $ 198.12 | 3 | |||||||||
| 44 | 63 | 267 | Adult | Trainer | 3 | 2 | 5 | No | 38 | $ 246.78 | 6 | |||||||||
| 54 | 153 | 233 | Silver | Trainer | 4 | 1 | 2 | YES | 39 | $ 258.23 | 7 | |||||||||
| 31 | 122 | 164 | Silver | Studio | 2 | 1 | 4 | No | 40 | $ 198.24 | 5 | |||||||||
| 68 | 144 | 274 | Gold | Racquet | 5 | 1 | 1 | No | 41 | $ 126.13 | 3 | |||||||||
| 24 | 135 | 201 | Gold | Studio | 3 | 1 | 1 | No | 42 | $ 270.25 | 7 | |||||||||
| 61 | 125 | 172 | Family | Spa | 2 | 3 | 1 | YES | 43 | $ 90.06 | 2 | |||||||||
| 65 | 18 | 169 | Silver | Spa | 3 | 2 | 3 | YES | 44 | $ 108.58 | 3 | |||||||||
| 30 | 42 | 285 | Silver | Studio | 5 | 5 | 5 | YES | 45 | $ 246.75 | 6 | |||||||||
| 29 | 132 | 257 | Family | Studio | 4 | 2 | 1 | YES | 46 | $ 126.16 | 5 | |||||||||
| 53 | 25 | 186 | Adult | Trainer | 3 | 2 | 2 | YES | 47 | $ 150.60 | 3 | |||||||||
| 33 | 110 | 202 | Adult | Trainer | 3 | 1 | 2 | No | 48 | $ 198.62 | 4 | |||||||||
| 58 | 63 | 263 | Gold | Spa | 2 | 4 | 4 | No | 49 | $ 416.75 | 9 | |||||||||
| 67 | 49 | 231 | Adult | Trainer | 5 | 3 | 3 | YES | 50 | $ 525.17 | 12 | |||||||||
| 26 | 80 | 128 | Silver | Spa | 5 | 5 | 2 | YES | 51 | $ 449.68 | 11 | |||||||||
| 33 | 76 | 112 | Family | Racquet | 3 | 3 | 2 | No | 52 | $ 375.52 | 7 | |||||||||
| 19 | 97 | 253 | Family | Trainer | 3 | 1 | 5 | YES | 53 | $ 545.63 | 11 | |||||||||
| 30 | 59 | 228 | Family | Spa | 4 | 3 | 5 | No | 54 | $ 240.16 | 7 | |||||||||
| 34 | 57 | 156 | Family | Spa | 5 | 4 | 4 | YES | 55 | $ 120.53 | 2 | |||||||||
| 63 | 163 | 144 | Family | Spa | 4 | 4 | 3 | YES | 56 | $ 84.64 | 1 | |||||||||
| 20 | 138 | 286 | Adult | Spa | 3 | 3 | 5 | YES | 57 | $ 168.72 | 2 | |||||||||
| 68 | 155 | 263 | Adult | Spa | 5 | 1 | 5 | YES | 58 | $ 66.06 | 3 | |||||||||
| 52 | 88 | 214 | Adult | Spa | 1 | 1 | 1 | No | 59 | $ 234.41 | 5 | |||||||||
| 27 | 32 | 195 | Family | Trainer | 3 | 2 | 4 | YES | 60 | $ 216.44 | 3 | |||||||||
| 25 | 79 | 246 | Silver | Spa | 2 | 3 | 3 | YES | 61 | $ 78.91 | 3 | |||||||||
| 19 | 159 | 286 | Family | Trainer | 1 | 3 | 2 | No | 62 | $ 60.58 | 3 | |||||||||
| 32 | 139 | 258 | Adult | Trainer | 2 | 4 | 2 | YES | 63 | $ 264.79 | 5 | |||||||||
| 32 | 41 | 186 | Family | Racquet | 2 | 1 | 5 | YES | 64 | $ 114.67 | 2 | |||||||||
| 37 | 60 | 107 | Family | Studio | 2 | 4 | 5 | YES | 65 | $ 180.59 | 5 | |||||||||
| 27 | 55 | 261 | Adult | Trainer | 1 | 1 | 3 | YES | 66 | $ 66.12 | 0 | |||||||||
| 23 | 126 | 133 | Gold | Trainer | 4 | 3 | 3 | No | 67 | $ 150.77 | 4 | |||||||||
| 34 | 74 | 128 | Gold | Trainer | 3 | 5 | 3 | YES | 68 | $ 96.40 | 3 | |||||||||
| 34 | 134 | 302 | Gold | Racquet | 5 | 2 | 2 | No | 69 | $ 186.30 | 5 | |||||||||
| 33 | 22 | 254 | Gold | Trainer | 5 | 2 | 5 | No | 70 | $ 234.76 | 7 | |||||||||
| 28 | 39 | 213 | Family | Studio | 3 | 3 | 1 | YES | 71 | $ 240.30 | 7 | |||||||||
| 23 | 121 | 175 | Family | Spa | 3 | 1 | 1 | No | 72 | $ 180.87 | 5 | |||||||||
| 32 | 36 | 222 | Adult | Spa | 2 | 4 | 1 | YES | 73 | $ 252.51 | 5 | |||||||||
| 26 | 89 | 224 | Gold | Trainer | 3 | 4 | 5 | YES | 74 | $ 96.27 | 2 | |||||||||
| 37 | 60 | 170 | Gold | Trainer | 1 | 3 | 1 | YES | 75 | $ 270.75 | 7 | |||||||||
| 26 | 60 | 150 | Gold | Spa | 5 | 2 | 3 | No | 76 | $ 150.92 | 2 | |||||||||
| 49 | 82 | 115 | Family | Studio | 5 | 1 | 5 | YES | 77 | $ 240.89 | 6 | |||||||||
| 49 | 93 | 200 | Family | Trainer | 3 | 2 | 4 | YES | 78 | $ 66.81 | 1 | |||||||||
| 24 | 117 | 256 | Family | Spa | 5 | 3 | 3 | YES | 79 | $ 258.49 | 5 | |||||||||
| 32 | 59 | 132 | Family | Studio | 5 | 5 | 4 | No | 80 | $ 102.63 | 4 | |||||||||
| 50 | 23 | 149 | Gold | Racquet | 2 | 5 | 2 | YES | 81 | $ 144.86 | 2 | |||||||||
| 24 | 148 | 300 | Gold | Spa | 2 | 4 | 3 | No | 82 | $ 132.34 | 4 | |||||||||
| 38 | 129 | 146 | Adult | Studio | 4 | 2 | 4 | No | 83 | $ 114.69 | 4 | |||||||||
| 31 | 36 | 149 | Adult | Trainer | 1 | 5 | 3 | YES | 84 | $ 78.40 | 2 | |||||||||
| 29 | 153 | 267 | Gold | Studio | 1 | 2 | 4 | No | 85 | $ 264.58 | 7 | |||||||||
| 45 | 53 | 136 | Gold | Spa | 1 | 4 | 4 | No | 86 | $ 288.57 | 8 | |||||||||
| 43 | 88 | 182 | Gold | Spa | 2 | 2 | 3 | YES | 87 | $ 252.80 | 7 | |||||||||
| 44 | 56 | 202 | Adult | Racquet | 2 | 3 | 5 | No | 88 | $ 162.40 | 4 | |||||||||
| 46 | 92 | 219 | Gold | Studio | 2 | 1 | 1 | No | 89 | $ 222.16 | 3 | |||||||||
| 25 | 142 | 154 | Gold | Spa | 4 | 2 | 2 | YES | 90 | $ 72.58 | 2 | |||||||||
| 50 | 49 | 293 | Gold | Studio | 1 | 3 | 3 | No | 91 | $ 282.28 | 8 | |||||||||
| 40 | 157 | 261 | Gold | Trainer | 2 | 3 | 2 | YES | 92 | $ 234.34 | 7 | |||||||||
| 55 | 36 | 177 | Gold | Spa | 3 | 1 | 4 | No | 93 | $ 258.43 | 6 | |||||||||
| 58 | 153 | 261 | Gold | Trainer | 5 | 2 | 1 | No | 94 | $ 294.69 | 7 | |||||||||
| 31 | 160 | 188 | Family | Trainer | 4 | 4 | 1 | YES | 95 | $ 300.48 | 7 | |||||||||
| 44 | 129 | 282 | Gold | Racquet | 3 | 3 | 2 | YES | 96 | $ 270.43 | 6 | |||||||||
| 54 | 76 | 276 | Adult | Racquet | 1 | 5 | 3 | No | 97 | $ 222.40 | 5 | |||||||||
| 51 | 120 | 210 | Gold | Trainer | 5 | 3 | 2 | No | 98 | $ 180.77 | 5 | |||||||||
| 41 | 105 | 185 | Gold | Spa | 3 | 2 | 3 | YES | 99 | $ 192.73 | 5 | |||||||||
| 48 | 128 | 182 | Gold | Spa | 3 | 1 | 1 | No | 100 | $ 192.47 | 6 | |||||||||
| 19 | 161 | 212 | Adult | Spa | 5 | 2 | 4 | YES | 101 | $ 300.16 | 8 | |||||||||
| 35 | 62 | 108 | Gold | Spa | 3 | 3 | 3 | No | 102 | $ 96.71 | 2 | |||||||||
| 56 | 92 | 256 | Adult | Studio | 2 | 4 | 5 | YES | 103 | $ 186.15 | 3 | |||||||||
| 58 | 137 | 156 | Family | Spa | 5 | 5 | 5 | YES | 104 | $ 288.59 | 8 | |||||||||
| 59 | 25 | 292 | Family | Studio | 3 | 1 | 4 | No | 105 | $ 174.96 | 4 | |||||||||
| 36 | 25 | 163 | Gold | Racquet | 2 | 4 | 2 | No | 106 | $ 108.33 | 3 | |||||||||
| 20 | 65 | 131 | Family | Trainer | 1 | 2 | 1 | YES | 107 | $ 133.00 | 4 | |||||||||
| 27 | 129 | 145 | Family | Spa | 2 | 1 | 3 | No | 108 | $ 264.98 | 7 | |||||||||
| 47 | 89 | 146 | Family | Racquet | 3 | 4 | 3 | YES | 109 | $ 102.66 | 2 | |||||||||
| 49 | 153 | 225 | Silver | Racquet | 5 | 2 | 1 | YES | 110 | $ 150.47 | 5 | |||||||||
| 27 | 95 | 267 | Family | Studio | 1 | 1 | 2 | YES | 111 | $ 186.23 | 5 | |||||||||
| 60 | 30 | 291 | Silver | Racquet | 3 | 1 | 3 | YES | 112 | $ 138.54 | 2 | |||||||||
| 31 | 104 | 227 | Adult | Spa | 2 | 4 | 4 | No | 113 | $ 84.40 | 3 | |||||||||
| 26 | 108 | 236 | Silver | Trainer | 5 | 4 | 1 | No | 114 | $ 300.26 | 6 | |||||||||
| 47 | 114 | 183 | Adult | Studio | 3 | 5 | 4 | No | 115 | $ 102.58 | 2 | |||||||||
| 45 | 110 | 296 | Adult | Studio | 5 | 2 | 4 | No | 116 | $ 150.37 | 3 | |||||||||
| 48 | 99 | 249 | Silver | Studio | 3 | 1 | 3 | YES | 117 | $ 162.79 | 4 | |||||||||
| 33 | 136 | 209 | Family | Trainer | 5 | 4 | 3 | No | 118 | $ 252.52 | 5 | |||||||||
| 24 | 149 | 261 | Family | Trainer | 2 | 4 | 5 | No | 119 | $ 264.35 | 4 | |||||||||
| 28 | 139 | 146 | Silver | Studio | 1 | 5 | 3 | No | 120 | $ 186.92 | 5 | |||||||||
| 40 | 161 | 142 | Silver | Racquet | 5 | 4 | 5 | YES | 121 | $ 294.33 | 6 | |||||||||
| 32 | 156 | 252 | Adult | Studio | 4 | 5 | 2 | YES | 122 | $ 258.61 | 6 | |||||||||
| 39 | 68 | 251 | Silver | Trainer | 2 | 1 | 4 | No | 123 | $ 108.05 | 2 | |||||||||
| 33 | 122 | 298 | Gold | Trainer | 1 | 4 | 5 | No | 124 | $ 288.84 | 5 | |||||||||
| 20 | 51 | 215 | Family | Spa | 2 | 5 | 5 | No | 125 | $ 270.04 | 5 | |||||||||
| 24 | 141 | 215 | Adult | Studio | 4 | 3 | 5 | No | 126 | $ 120.38 | 2 | |||||||||
| 27 | 138 | 160 | Silver | Racquet | 3 | 4 | 4 | YES | 127 | $ 264.98 | 4 | |||||||||
| 30 | 108 | 292 | Silver | Trainer | 3 | 3 | 4 | No | 128 | $ 156.93 | 3 | |||||||||
| 26 | 102 | 171 | Gold | Racquet | 2 | 2 | 3 | YES | 129 | $ 96.13 | 4 | |||||||||
| 27 | 111 | 187 | Family | Studio | 4 | 2 | 4 | YES | 130 | $ 240.59 | 5 | |||||||||
| 27 | 136 | 221 | Adult | Spa | 1 | 1 | 4 | YES | 131 | $ 66.79 | 2 | |||||||||
| 40 | 81 | 173 | Gold | Studio | 3 | 3 | 2 | YES | 132 | $ 150.60 | 2 | |||||||||
| 34 | 123 | 176 | Gold | Trainer | 3 | 3 | 3 | No | 133 | $ 96.85 | 3 | |||||||||
| 40 | 101 | 210 | Silver | Racquet | 2 | 5 | 3 | No | 134 | $ 186.39 | 3 | |||||||||
| 39 | 76 | 243 | Silver | Racquet | 5 | 1 | 1 | YES | 135 | $ 222.85 | 5 | |||||||||
| 34 | 64 | 231 | Silver | Studio | 3 | 4 | 2 | No | 136 | $ 60.53 | 2 | |||||||||
| 21 | 108 | 142 | Adult | Trainer | 4 | 5 | 2 | YES | 137 | $ 258.89 | 5 | |||||||||
| 24 | 51 | 118 | Adult | Studio | 2 | 3 | 5 | No | 138 | $ 192.94 | 6 | |||||||||
| 18 | 129 | 192 | Gold | Spa | 2 | 4 | 1 | YES | 139 | $ 96.69 | 3 | |||||||||
| 27 | 46 | 148 | Silver | Studio | 1 | 4 | 2 | YES | 140 | $ 294.60 | 6 | |||||||||
| 29 | 30 | 242 | Gold | Spa | 3 | 5 | 5 | No | 141 | $ 246.23 | 4 | |||||||||
| 36 | 25 | 226 | Silver | Trainer | 4 | 4 | 3 | YES | 142 | $ 282.90 | 6 | |||||||||
| 33 | 136 | 251 | Family | Studio | 4 | 1 | 5 | YES | 143 | $ 525.00 | 11 | |||||||||
| 30 | 70 | 136 | Family | Studio | 5 | 3 | 1 | No | 144 | $ 228.98 | 6 | |||||||||
| 36 | 134 | 251 | Gold | Studio | 5 | 4 | 2 | YES | 145 | $ 132.62 | 3 | |||||||||
| 36 | 97 | 230 | Family | Trainer | 4 | 2 | 2 | No | 146 | $ 252.47 | 7 | |||||||||
| 34 | 87 | 266 | Gold | Spa | 2 | 2 | 3 | No | 147 | $ 132.10 | 4 | |||||||||
| 21 | 159 | 235 | Silver | Studio | 1 | 3 | 4 | No | 148 | $ 60.97 | 1 | |||||||||
| 29 | 57 | 126 | Silver | Trainer | 4 | 2 | 2 | YES | 149 | $ 192.92 | 5 | |||||||||
| 19 | 111 | 295 | Adult | Trainer | 4 | 4 | 4 | YES | 150 | $ 258.66 | 4 | |||||||||
| 150 | ||||||||||||||||||||
Pivot Table
| Put your pivot tables on this page. Tip: You may wish to copy the values of the variables you are comparing on this page so you can see them next to your pivot tables. | ||||||||||||||||
| This enables you to compare what your pivot table looks like relative to the data to ensure it is set up correctly. Just copy the columns you need from the "My Data" page and paste below. | ||||||||||||||||
| No idea what a pivot table is? Try this tutorial video! They are extremely useful so time spent learning how is worth it. | https://www.youtube.com/watch?v=Y2cIAIJAEWA | (video link also in Blackboard) | ||||||||||||||
| Age | # visits YTD | Fees YTD | Plan | Add-on | Advertising | Age | (All) | |||||||||
| 23 | 133 | 156 | Family | Studio | $ 174.45 | |||||||||||
| 28 | 144 | 178 | Silver | Spa | $ 192.95 | Row Labels | Average of Advertising | Sum of # visits YTD | Sum of Fees YTD | |||||||
| 59 | 71 | 301 | Adult | Studio | $ 270.08 | 18 | $96.67 | 36 | 274.07 | |||||||
| 40 | 144 | 187 | Family | Racquet | $ 78.79 | Silver | $96.67 | 36 | 274.07 | |||||||
| 37 | 164 | 247 | Adult | Studio | $ 276.18 | Spa | $108.58 | 18 | 169.16 | |||||||
| 51 | 21 | 212 | Gold | Studio | $ 258.50 | Studio | $84.76 | 18 | 104.91 | |||||||
| 47 | 132 | 245 | Silver | Trainer | $ 163.00 | 21 | $168.48 | 42 | 464.39 | |||||||
| 30 | 137 | 143 | Adult | Spa | $ 108.17 | Gold | $168.48 | 42 | 464.39 | |||||||
| 24 | 131 | 292 | Adult | Spa | $ 276.69 | Racquet | $78.46 | 21 | 252.80 | |||||||
| 53 | 67 | 252 | Family | Spa | $ 258.28 | Studio | $258.50 | 21 | 211.58 | |||||||
| 63 | 114 | 293 | Family | Studio | $ 180.31 | 22 | $234.76 | 22 | 254.41 | |||||||
| 33 | 73 | 253 | Silver | Trainer | $ 108.99 | Gold | $234.76 | 22 | 254.41 | |||||||
| 34 | 98 | 168 | Family | Trainer | $ 258.88 | Trainer | $234.76 | 22 | 254.41 | |||||||
| 43 | 119 | 112 | Gold | Racquet | $ 156.55 | 23 | $204.78 | 46 | 314.94 | |||||||
| 20 | 114 | 198 | Adult | Racquet | $ 300.02 | Gold | $204.78 | 46 | 314.94 | |||||||
| 34 | 85 | 177 | Adult | Trainer | $ 288.01 | Racquet | $144.86 | 23 | 149.45 | |||||||
| 19 | 40 | 128 | Adult | Spa | $ 108.12 | Trainer | $264.70 | 23 | 165.48 | |||||||
| 34 | 137 | 272 | Gold | Racquet | $ 300.85 | 25 | $179.20 | 100 | 866.96 | |||||||
| 40 | 71 | 156 | Gold | Trainer | $ 174.47 | Adult | $150.60 | 25 | 185.61 | |||||||
| 23 | 92 | 136 | Family | Studio | $ 126.00 | Trainer | $150.60 | 25 | 185.61 | |||||||
| 35 | 54 | 265 | Silver | Studio | $ 96.82 | Family | $174.96 | 25 | 292.45 | |||||||
| 65 | 139 | 191 | Adult | Racquet | $ 264.21 | Studio | $174.96 | 25 | 292.45 | |||||||
| 20 | 78 | 212 | Adult | Studio | $ 264.47 | Gold | $108.33 | 25 | 162.99 | |||||||
| 64 | 21 | 253 | Gold | Racquet | $ 78.46 | Racquet | $108.33 | 25 | 162.99 | |||||||
| 18 | 62 | 235 | Family | Spa | $ 96.09 | Silver | $282.90 | 25 | 225.91 | |||||||
| 25 | 34 | 288 | Family | Racquet | $ 84.46 | Trainer | $282.90 | 25 | 225.91 | |||||||
| 60 | 82 | 136 | Silver | Trainer | $ 252.87 | 27 | $210.16 | 27 | 286.78 | |||||||
| 62 | 140 | 202 | Adult | Spa | $ 78.95 | Adult | $210.16 | 27 | 286.78 | |||||||
| 21 | 27 | 287 | Adult | Spa | $ 210.16 | Spa | $210.16 | 27 | 286.78 | |||||||
| 61 | 106 | 263 | Silver | Spa | $ 102.26 | 30 | $192.39 | 60 | 532.43 | |||||||
| 53 | 156 | 301 | Adult | Trainer | $ 90.55 | Gold | $246.23 | 30 | 241.55 | |||||||
| 31 | 18 | 105 | Silver | Studio | $ 84.76 | Spa | $246.23 | 30 | 241.55 | |||||||
| 20 | 163 | 201 | Family | Spa | $ 222.87 | Silver | $138.54 | 30 | 290.88 | |||||||
| 59 | 74 | 140 | Family | Spa | $ 228.04 | Racquet | $138.54 | 30 | 290.88 | |||||||
| 67 | 109 | 141 | Adult | Studio | $ 78.68 | 32 | $216.44 | 32 | 195.24 | |||||||
| 41 | 23 | 165 | Gold | Trainer | $ 264.70 | Family | $216.44 | 32 | 195.24 | |||||||
| 20 | 125 | 282 | Family | Racquet | $ 198.12 | Trainer | $216.44 | 32 | 195.24 | |||||||
| 44 | 63 | 267 | Adult | Trainer | $ 246.78 | 34 | $84.46 | 34 | 287.61 | |||||||
| 54 | 153 | 233 | Silver | Trainer | $ 258.23 | Family | $84.46 | 34 | 287.61 | |||||||
| 31 | 122 | 164 | Silver | Studio | $ 198.24 | Racquet | $84.46 | 34 | 287.61 | |||||||
| 68 | 144 | 274 | Gold | Racquet | $ 126.13 | 36 | $196.45 | 108 | 547.98 | |||||||
| 24 | 135 | 201 | Gold | Studio | $ 270.25 | Adult | $165.46 | 72 | 371.18 | |||||||
| 61 | 125 | 172 | Family | Spa | $ 90.06 | Spa | $252.51 | 36 | 221.72 | |||||||
| 65 | 18 | 169 | Silver | Spa | $ 108.58 | Trainer | $78.40 | 36 | 149.46 | |||||||
| 30 | 42 | 285 | Silver | Studio | $ 246.75 | Gold | $258.43 | 36 | 176.80 | |||||||
| 29 | 132 | 257 | Family | Studio | $ 126.16 | Spa | $258.43 | 36 | 176.80 | |||||||
| 53 | 25 | 186 | Adult | Trainer | $ 150.60 | 39 | $240.30 | 39 | 213.16 | |||||||
| 33 | 110 | 202 | Adult | Trainer | $ 198.62 | Family | $240.30 | 39 | 213.16 | |||||||
| 58 | 63 | 263 | Gold | Spa | $ 416.75 | Studio | $240.30 | 39 | 213.16 | |||||||
| 67 | 49 | 231 | Adult | Trainer | $ 525.17 | 40 | $108.12 | 40 | 128.07 | |||||||
| 26 | 80 | 128 | Silver | Spa | $ 449.68 | Adult | $108.12 | 40 | 128.07 | |||||||
| 33 | 76 | 112 | Family | Racquet | $ 375.52 | Spa | $108.12 | 40 | 128.07 | |||||||
| 19 | 97 | 253 | Family | Trainer | $ 545.63 | 41 | $114.67 | 41 | 185.88 | |||||||
| 30 | 59 | 228 | Family | Spa | $ 240.16 | Family | $114.67 | 41 | 185.88 | |||||||
| 34 | 57 | 156 | Family | Spa | $ 120.53 | Racquet | $114.67 | 41 | 185.88 | |||||||
| 63 | 163 | 144 | Family | Spa | $ 84.64 | 42 | $246.75 | 42 | 284.70 | |||||||
| 20 | 138 | 286 | Adult | Spa | $ 168.72 | Silver | $246.75 | 42 | 284.70 | |||||||
| 68 | 155 | 263 | Adult | Spa | $ 66.06 | Studio | $246.75 | 42 | 284.70 | |||||||
| 52 | 88 | 214 | Adult | Spa | $ 234.41 | 46 | $294.60 | 46 | 147.95 | |||||||
| 27 | 32 | 195 | Family | Trainer | $ 216.44 | Silver | $294.60 | 46 | 147.95 | |||||||
| 25 | 79 | 246 | Silver | Spa | $ 78.91 | Studio | $294.60 | 46 | 147.95 | |||||||
| 19 | 159 | 286 | Family | Trainer | $ 60.58 | 49 | $403.73 | 98 | 524.62 | |||||||
| 32 | 139 | 258 | Adult | Trainer | $ 264.79 | Adult | $525.17 | 49 | 231.40 | |||||||
| 32 | 41 | 186 | Family | Racquet | $ 114.67 | Trainer | $525.17 | 49 | 231.40 | |||||||
| 37 | 60 | 107 | Family | Studio | $ 180.59 | Gold | $282.28 | 49 | 293.22 | |||||||
| 27 | 55 | 261 | Adult | Trainer | $ 66.12 | Studio | $282.28 | 49 | 293.22 | |||||||
| 23 | 126 | 133 | Gold | Trainer | $ 150.77 | 51 | $231.49 | 102 | 332.58 | |||||||
| 34 | 74 | 128 | Gold | Trainer | $ 96.40 | Adult | $192.94 | 51 | 117.88 | |||||||
| 34 | 134 | 302 | Gold | Racquet | $ 186.30 | Studio | $192.94 | 51 | 117.88 | |||||||
| 33 | 22 | 254 | Gold | Trainer | $ 234.76 | Family | $270.04 | 51 | 214.70 | |||||||
| 28 | 39 | 213 | Family | Studio | $ 240.30 | Spa | $270.04 | 51 | 214.70 | |||||||
| 23 | 121 | 175 | Family | Spa | $ 180.87 | 53 | $288.57 | 53 | 136.18 | |||||||
| 32 | 36 | 222 | Adult | Spa | $ 252.51 | Gold | $288.57 | 53 | 136.18 | |||||||
| 26 | 89 | 224 | Gold | Trainer | $ 96.27 | Spa | $288.57 | 53 | 136.18 | |||||||
| 37 | 60 | 170 | Gold | Trainer | $ 270.75 | 54 | $96.82 | 54 | 265.05 | |||||||
| 26 | 60 | 150 | Gold | Spa | $ 150.92 | Silver | $96.82 | 54 | 265.05 | |||||||
| 49 | 82 | 115 | Family | Studio | $ 240.89 | Studio | $96.82 | 54 | 265.05 | |||||||
| 49 | 93 | 200 | Family | Trainer | $ 66.81 | 55 | $66.12 | 55 | 261.23 | |||||||
| 24 | 117 | 256 | Family | Spa | $ 258.49 | Adult | $66.12 | 55 | 261.23 | |||||||
| 32 | 59 | 132 | Family | Studio | $ 102.63 | Trainer | $66.12 | 55 | 261.23 | |||||||
| 50 | 23 | 149 | Gold | Racquet | $ 144.86 | 56 | $162.40 | 56 | 202.26 | |||||||
| 24 | 148 | 300 | Gold | Spa | $ 132.34 | Adult | $162.40 | 56 | 202.26 | |||||||
| 38 | 129 | 146 | Adult | Studio | $ 114.69 | Racquet | $162.40 | 56 | 202.26 | |||||||
| 31 | 36 | 149 | Adult | Trainer | $ 78.40 | 57 | $156.73 | 114 | 282.51 | |||||||
| 29 | 153 | 267 | Gold | Studio | $ 264.58 | Family | $120.53 | 57 | 156.41 | |||||||
| 45 | 53 | 136 | Gold | Spa | $ 288.57 | Spa | $120.53 | 57 | 156.41 | |||||||
| 43 | 88 | 182 | Gold | Spa | $ 252.80 | Silver | $192.92 | 57 | 126.10 | |||||||
| 44 | 56 | 202 | Adult | Racquet | $ 162.40 | Trainer | $192.92 | 57 | 126.10 | |||||||
| 46 | 92 | 219 | Gold | Studio | $ 222.16 | 59 | $171.40 | 118 | 360.14 | |||||||
| 25 | 142 | 154 | Gold | Spa | $ 72.58 | Family | $171.40 | 118 | 360.14 | |||||||
| 50 | 49 | 293 | Gold | Studio | $ 282.28 | Spa | $240.16 | 59 | 228.05 | |||||||
| 40 | 157 | 261 | Gold | Trainer | $ 234.34 | Studio | $102.63 | 59 | 132.09 | |||||||
| 55 | 36 | 177 | Gold | Spa | $ 258.43 | 60 | $200.75 | 180 | 426.86 | |||||||
| 58 | 153 | 261 | Gold | Trainer | $ 294.69 | Family | $180.59 | 60 | 106.84 | |||||||
| 31 | 160 | 188 | Family | Trainer | $ 300.48 | Studio | $180.59 | 60 | 106.84 | |||||||
| 44 | 129 | 282 | Gold | Racquet | $ 270.43 | Gold | $210.84 | 120 | 320.02 | |||||||
| 54 | 76 | 276 | Adult | Racquet | $ 222.40 | Spa | $150.92 | 60 | 149.97 | |||||||
| 51 | 120 | 210 | Gold | Trainer | $ 180.77 | Trainer | $270.75 | 60 | 170.05 | |||||||
| 41 | 105 | 185 | Gold | Spa | $ 192.73 | 62 | $96.40 | 124 | 343.10 | |||||||
| 48 | 128 | 182 | Gold | Spa | $ 192.47 | Family | $96.09 | 62 | 235.29 | |||||||
| 19 | 161 | 212 | Adult | Spa | $ 300.16 | Spa | $96.09 | 62 | 235.29 | |||||||
| 35 | 62 | 108 | Gold | Spa | $ 96.71 | Gold | $96.71 | 62 | 107.81 | |||||||
| 56 | 92 | 256 | Adult | Studio | $ 186.15 | Spa | $96.71 | 62 | 107.81 | |||||||
| 58 | 137 | 156 | Family | Spa | $ 288.59 | 63 | $331.77 | 126 | 530.77 | |||||||
| 59 | 25 | 292 | Family | Studio | $ 174.96 | Adult | $246.78 | 63 | 267.27 | |||||||
| 36 | 25 | 163 | Gold | Racquet | $ 108.33 | Trainer | $246.78 | 63 | 267.27 | |||||||
| 20 | 65 | 131 | Family | Trainer | $ 133.00 | Gold | $416.75 | 63 | 263.50 | |||||||
| 27 | 129 | 145 | Family | Spa | $ 264.98 | Spa | $416.75 | 63 | 263.50 | |||||||
| 47 | 89 | 146 | Family | Racquet | $ 102.66 | 64 | $60.53 | 64 | 230.99 | |||||||
| 49 | 153 | 225 | Silver | Racquet | $ 150.47 | Silver | $60.53 | 64 | 230.99 | |||||||
| 27 | 95 | 267 | Family | Studio | $ 186.23 | Studio | $60.53 | 64 | 230.99 | |||||||
| 60 | 30 | 291 | Silver | Racquet | $ 138.54 | 65 | $133.00 | 65 | 131.47 | |||||||
| 31 | 104 | 227 | Adult | Spa | $ 84.40 | Family | $133.00 | 65 | 131.47 | |||||||
| 26 | 108 | 236 | Silver | Trainer | $ 300.26 | Trainer | $133.00 | 65 | 131.47 | |||||||
| 47 | 114 | 183 | Adult | Studio | $ 102.58 | 67 | $258.28 | 67 | 251.67 | |||||||
| 45 | 110 | 296 | Adult | Studio | $ 150.37 | Family | $258.28 | 67 | 251.67 | |||||||
| 48 | 99 | 249 | Silver | Studio | $ 162.79 | Spa | $258.28 | 67 | 251.67 | |||||||
| 33 | 136 | 209 | Family | Trainer | $ 252.52 | 68 | $108.05 | 68 | 250.82 | |||||||
| 24 | 149 | 261 | Family | Trainer | $ 264.35 | Silver | $108.05 | 68 | 250.82 | |||||||
| 28 | 139 | 146 | Silver | Studio | $ 186.92 | Trainer | $108.05 | 68 | 250.82 | |||||||
| 40 | 161 | 142 | Silver | Racquet | $ 294.33 | Grand Total | $190.21 | 2059 | 9,514.80 | |||||||
| 32 | 156 | 252 | Adult | Studio | $ 258.61 | |||||||||||
| 39 | 68 | 251 | Silver | Trainer | $ 108.05 | |||||||||||
| 33 | 122 | 298 | Gold | Trainer | $ 288.84 | |||||||||||
| 20 | 51 | 215 | Family | Spa | $ 270.04 | |||||||||||
| 24 | 141 | 215 | Adult | Studio | $ 120.38 | |||||||||||
| 27 | 138 | 160 | Silver | Racquet | $ 264.98 | |||||||||||
| 30 | 108 | 292 | Silver | Trainer | $ 156.93 | |||||||||||
| 26 | 102 | 171 | Gold | Racquet | $ 96.13 | |||||||||||
| 27 | 111 | 187 | Family | Studio | $ 240.59 | |||||||||||
| 27 | 136 | 221 | Adult | Spa | $ 66.79 | |||||||||||
| 40 | 81 | 173 | Gold | Studio | $ 150.60 | |||||||||||
| 34 | 123 | 176 | Gold | Trainer | $ 96.85 | |||||||||||
| 40 | 101 | 210 | Silver | Racquet | $ 186.39 | |||||||||||
| 39 | 76 | 243 | Silver | Racquet | $ 222.85 | |||||||||||
| 34 | 64 | 231 | Silver | Studio | $ 60.53 | |||||||||||
| 21 | 108 | 142 | Adult | Trainer | $ 258.89 | |||||||||||
| 24 | 51 | 118 | Adult | Studio | $ 192.94 | |||||||||||
| 18 | 129 | 192 | Gold | Spa | $ 96.69 | |||||||||||
| 27 | 46 | 148 | Silver | Studio | $ 294.60 | |||||||||||
| 29 | 30 | 242 | Gold | Spa | $ 246.23 | |||||||||||
| 36 | 25 | 226 | Silver | Trainer | $ 282.90 | |||||||||||
| 33 | 136 | 251 | Family | Studio | $ 525.00 | |||||||||||
| 30 | 70 | 136 | Family | Studio | $ 228.98 | |||||||||||
| 36 | 134 | 251 | Gold | Studio | $ 132.62 | |||||||||||
| 36 | 97 | 230 | Family | Trainer | $ 252.47 | |||||||||||
| 34 | 87 | 266 | Gold | Spa | $ 132.10 | |||||||||||
| 21 | 159 | 235 | Silver | Studio | $ 60.97 | |||||||||||
| 29 | 57 | 126 | Silver | Trainer | $ 192.92 | |||||||||||
| 19 | 111 | 295 | Adult | Trainer | $ 258.66 | |||||||||||
| $ 29,350.43 |
Bar+Pie Charts
| Put your bar chart and pie chart on this page. Tip: You may wish to copy the values of the variables you are comparing on this page so you can see them next to your charts. | |||||||||||
| This enables you to compare what your charts look like relative to the data to ensure it is set up correctly. Just copy the columns you need from the "My Data" page and paste below. | |||||||||||
| Not sure how to do this? Try watching this video: | https://www.youtube.com/watch?v=xLmtGk7Ymy8 | (covers lots of chart types -- just fast forward to the types of charts you need) | |||||||||
| Fees YTD | Plan | ||||||||||
| 156 | Family | ||||||||||
| 178 | Silver | ||||||||||
| 301 | Adult | ||||||||||
| 187 | Family | ||||||||||
| 247 | Adult | ||||||||||
| 212 | Gold | ||||||||||
| 245 | Silver | ||||||||||
| 143 | Adult | ||||||||||
| 292 | Adult | ||||||||||
| 252 | Family | ||||||||||
| 293 | Family | ||||||||||
| 253 | Silver | ||||||||||
| 168 | Family | ||||||||||
| 112 | Gold | ||||||||||
| 198 | Adult | ||||||||||
| 177 | Adult | ||||||||||
| 128 | Adult | ||||||||||
| 272 | Gold | ||||||||||
| 156 | Gold | ||||||||||
| 136 | Family | ||||||||||
| 265 | Silver | ||||||||||
| 191 | Adult | ||||||||||
| 212 | Adult | ||||||||||
| 253 | Gold | ||||||||||
| 235 | Family | ||||||||||
| 288 | Family | ||||||||||
| 136 | Silver | ||||||||||
| 202 | Adult | ||||||||||
| 287 | Adult | ||||||||||
| 263 | Silver | ||||||||||
| 301 | Adult | ||||||||||
| 105 | Silver | ||||||||||
| 201 | Family | ||||||||||
| 140 | Family | ||||||||||
| 141 | Adult | ||||||||||
| 165 | Gold | ||||||||||
| 282 | Family | ||||||||||
| 267 | Adult | ||||||||||
| 233 | Silver | ||||||||||
| 164 | Silver | ||||||||||
| 274 | Gold | ||||||||||
| 201 | Gold | ||||||||||
| 172 | Family | ||||||||||
| 169 | Silver | ||||||||||
| 285 | Silver | ||||||||||
| 257 | Family | ||||||||||
| 186 | Adult | ||||||||||
| 202 | Adult | ||||||||||
| 263 | Gold | ||||||||||
| 231 | Adult | ||||||||||
| 128 | Silver | ||||||||||
| 112 | Family | ||||||||||
| 253 | Family | ||||||||||
| 228 | Family | ||||||||||
| 156 | Family | ||||||||||
| 144 | Family | ||||||||||
| 286 | Adult | ||||||||||
| 263 | Adult | ||||||||||
| 214 | Adult | ||||||||||
| 195 | Family | ||||||||||
| 246 | Silver | ||||||||||
| 286 | Family | ||||||||||
| 258 | Adult | ||||||||||
| 186 | Family | ||||||||||
| 107 | Family | ||||||||||
| 261 | Adult | ||||||||||
| 133 | Gold | ||||||||||
| 128 | Gold | ||||||||||
| 302 | Gold | ||||||||||
| 254 | Gold | ||||||||||
| 213 | Family | ||||||||||
| 175 | Family | ||||||||||
| 222 | Adult | ||||||||||
| 224 | Gold | ||||||||||
| 170 | Gold | ||||||||||
| 150 | Gold | ||||||||||
| 115 | Family | ||||||||||
| 200 | Family | ||||||||||
| 256 | Family | ||||||||||
| 132 | Family | ||||||||||
| 149 | Gold | ||||||||||
| 300 | Gold | ||||||||||
| 146 | Adult | ||||||||||
| 149 | Adult | ||||||||||
| 267 | Gold | ||||||||||
| 136 | Gold | ||||||||||
| 182 | Gold | ||||||||||
| 202 | Adult | ||||||||||
| 219 | Gold | ||||||||||
| 154 | Gold | ||||||||||
| 293 | Gold | ||||||||||
| 261 | Gold | ||||||||||
| 177 | Gold | ||||||||||
| 261 | Gold | ||||||||||
| 188 | Family | ||||||||||
| 282 | Gold | ||||||||||
| 276 | Adult | ||||||||||
| 210 | Gold | ||||||||||
| 185 | Gold | ||||||||||
| 182 | Gold | ||||||||||
| 212 | Adult | ||||||||||
| 108 | Gold | ||||||||||
| 256 | Adult | ||||||||||
| 156 | Family | ||||||||||
| 292 | Family | ||||||||||
| 163 | Gold | ||||||||||
| 131 | Family | ||||||||||
| 145 | Family | ||||||||||
| 146 | Family | ||||||||||
| 225 | Silver | ||||||||||
| 267 | Family | ||||||||||
| 291 | Silver | ||||||||||
| 227 | Adult | ||||||||||
| 236 | Silver | ||||||||||
| 183 | Adult | ||||||||||
| 296 | Adult | ||||||||||
| 249 | Silver | ||||||||||
| 209 | Family | ||||||||||
| 261 | Family | ||||||||||
| 146 | Silver | ||||||||||
| 142 | Silver | ||||||||||
| 252 | Adult | ||||||||||
| 251 | Silver | ||||||||||
| 298 | Gold | ||||||||||
| 215 | Family | ||||||||||
| 215 | Adult | ||||||||||
| 160 | Silver | ||||||||||
| 292 | Silver | ||||||||||
| 171 | Gold | ||||||||||
| 187 | Family | ||||||||||
| 221 | Adult | ||||||||||
| 173 | Gold | ||||||||||
| 176 | Gold | ||||||||||
| 210 | Silver | ||||||||||
| 243 | Silver | ||||||||||
| 231 | Silver | ||||||||||
| 142 | Adult | ||||||||||
| 118 | Adult | ||||||||||
| 192 | Gold | ||||||||||
| 148 | Silver | ||||||||||
| 242 | Gold | ||||||||||
| 226 | Silver | ||||||||||
| 251 | Family | ||||||||||
| 136 | Family | ||||||||||
| 251 | Gold | ||||||||||
| 230 | Family | ||||||||||
| 266 | Gold | ||||||||||
| 235 | Silver | ||||||||||
| 126 | Silver | ||||||||||
| 295 | Adult |
Box&Whisker
| Put your box & whisker plots on this page. DO NOT use any version Excel prior to 2016 to complete this section of your project as older versions cannot calculate quartiles with the book's method or do boxplots. | ||||||||||||||||
| All students should have installed and be using Excel 2016 as they have access to it through Office 365. If you have a Mac running Excel 2016, you will NOT see a boxplot option and will have to either create one manually or | ||||||||||||||||
| do this section of the project using a computer running Windows and the Windows version of Excel 2016. Videos showing the manual method are in Blackboard. | ||||||||||||||||
| Instructions: View the video here to see how to create these in Excel 2016 | https://www.youtube.com/watch?v=TxuretcM5Uk | If you have a Mac, use this one: | https://www.youtube.com/watch?v=ed6dy-lHjm8&t=0s | |||||||||||||
| 1. Copy and paste the values of the variables you are going to create your boxplots from in the space below. These should be taken from your My Data page. Include the label I know what the data is. | ||||||||||||||||
| 2. Fill out the table provided for each variable. Be sure to use the "inclusive" method (book's version) of doing quartiles and medians. NOTE: This is available both on Windows and Mac in Excel 2016. | ||||||||||||||||
| 3. Use Excel 2016 to create two boxplots of the variables you selected (pay attention to level of measurement!). Do NOT use Likert variables for this exercise. (Mac users: use the technique shown in the video above) | ||||||||||||||||
| 4. You do not need an title for the X axis but you should add a title to your boxplot as well as a legend to identify each variable. | ||||||||||||||||
| 5. If you have similar variables, you may wish to put both boxplots in the same chart as Excel can do this. Do not attempt if your variables have vastly different number ranges. | ||||||||||||||||
| Variable 1 | Variable 2 | Variable 1 | Variable 2 | Put your box plot below: | ||||||||||||
| <-- say what the variables are here! (e.g., age) | ||||||||||||||||
| Minimum = | <-- Type in your formulas in each box so I can check them. | |||||||||||||||
| Q1 = | ||||||||||||||||
| Median = | ||||||||||||||||
| Q3 = | ||||||||||||||||
| Maximum = | ||||||||||||||||
| Count = |
Histogram-M1
| Put your histogram on this page if you choose Method #1. DO NOT use Excel's new histogram function as you cannot control the bins properly. | |||||||||||||||
| Method #1 - Use this method or Method #2 to create your histogram. You only need to use ONE of the methods. | |||||||||||||||
| 1. View the video above to learn how to set up a histogram using a pivot table. | https://www.youtube.com/watch?v=YfVu7xGHgnA | ||||||||||||||
| 2. Copy and paste the values of the variable you are going to create your histogram from starting in cell A10 below (include LABEL). These should be taken from your My Data page. | |||||||||||||||
| 3. Fill out the yellow boxes in the table to determine the number of classes and inteval width. | |||||||||||||||
| 4. Add titles to the chart as well as the X and Y axis to identify what each is. To add titles, click on the chart and use the plus key, then check the necessary boxes. | |||||||||||||||
| NOTE: If your histogram looks good with the number of bins the 2^k rule suggests, go with it. If you think a larger or smaller number of classes looks better, feel free to adjust. | |||||||||||||||
| Put your Frequency Distribution below: | Put your histogram below: | Sample Size = | |||||||||||||
| k = # classes | |||||||||||||||
| 2^k = | |||||||||||||||
| Maximum | |||||||||||||||
| Minimum | |||||||||||||||
| Range | |||||||||||||||
| Interval Width | |||||||||||||||
| Width Used | |||||||||||||||
Histogram-M2
| Put your histogram on this page if you choose Method #2. DO NOT use Excel's new histogram function as you cannot control the bins properly. | |||||||||||||||
| Method #2 - Use this method or Method #1 to create your histogram. You only need to use ONE of the methods. | |||||||||||||||
| Follow the directions provided below to create your own frequency distribution and histogram. One advantage of this method is that you have great control over the bins used. | |||||||||||||||
| 1. Copy and paste the values of the variable you are going to create your histogram from starting in cell A9 below (include LABEL). These should be taken from your My Data page. | |||||||||||||||
| 2. Sort the values from low to high. Highlight all the numbers you wish to sort, then choose Sort & Filter from the Editing menu above, choose sort from smallest to highest. | |||||||||||||||
| 3. Fill out the yellow boxes in the table to determine the number of classes and inteval width, as where to start and end the classes or bins. | |||||||||||||||
| 4. Set up a frequency distribution in the space below. The first column is for the the bins or classes, and the second column should be labeled frequency. | |||||||||||||||
| 5. Label your classes using the book's method (choose a nice starting place and a convenient bin width as suggested by your calculations in the yellow boxes) | |||||||||||||||
| 6. Now count frequency in each class. An easy way to do this is to use the =count function in Excel. | |||||||||||||||
| 7. Now set up your histogram. Put your cursor first class of your frequency distribution and choose Insert > Stacked Bar Chart. It will set up a bar chart based on your classes. | |||||||||||||||
| 8. Now edit the bar gap width. Click on the bars, then choose Format Data Series > Series Options > Gap Width. Set to 1 or 2%. | |||||||||||||||
| 9. Add a title for your chart, along with axis labels. To do this, click on the chart and click on the plus key that pops up. Check the boxes to add the elements you need. | |||||||||||||||
| NOTE: If your histogram looks good with the number of bins the 2^k rule suggests, go with it. If you think a larger or smaller number of classes looks better, feel free to adjust. | |||||||||||||||
| Put your Frequency Distribution below: | Put your histogram below: | Sample Size = | |||||||||||||
| k = # classes | |||||||||||||||
| 2^k = | |||||||||||||||
| Maximum | |||||||||||||||
| Minimum | |||||||||||||||
| Range | |||||||||||||||
| Interval Width | |||||||||||||||
| Width Used | |||||||||||||||
Descriptive Statistics
| Put your descriptive statistics on this page . You must do one table for a Likert variable and one table for a non-Likert variable. | |||||||||||
| NOTE: You will need to have the data analysis toolpak installed. If you have not yet done so, read this tutorial: | https://support.office.com/en-us/article/Load-the-Analysis-ToolPak-305c260e-224f-4739-9777-2d86f1a5bd89 |
