Question: For each of the five variables, process, organize, present, and summarize the data. Analyze each variable by itself using graphical and numerical techniques of summarization.
- For each of the five variables, process, organize, present, and summarize the data. Analyze each variable by itself using graphical and numerical techniques of summarization. Use Excel as much as possible, explaining what the results reveal. Some of the following graphs may be helpful: stem-leaf diagram, frequency/relative frequency table, histogram, boxplot, dotplot, pie chart, bar graph. (Caution: Not all of these are appropriate for each of these variables, nor are they all necessary. More is not necessarily better.) In addition, be sure to find the appropriate measures of central tendency, the measures of dispersion, and the shapes of the distributions (for the quantitative variables) for the previous data. Where appropriate, use the five number summary (the Min, Q1, Median, Q3, Max). Once again, use Excel as appropriate and explain what the results mean.
| 37 | 131 | 16.9 | 2 | GROUP |
| 44 | 134 | 19.4 | 3 | GROUP |
| 33 | 139 | 19.3 | 3 | GROUP |
| 40 | 145 | 14.7 | 2 | GROUP |
| 35 | 149 | 15.6 | 1 | GROUP |
| 47 | 149 | 15.8 | 1 | GROUP |
| 26 | 150 | 14.9 | 2 | GROUP |
| 39 | 150 | 15.3 | 3 | GROUP |
| 47 | 151 | 16.6 | 2 | GROUP |
| 25 | 152 | 15.0 | 3 | GROUP |
| 41 | 152 | 14.5 | 4 | GROUP |
| 49 | 153 | 19.0 | 3 | GROUP |
| 42 | 154 | 14.3 | 2 | GROUP |
| 42 | 154 | 15.3 | 1 | GROUP |
| 25 | 155 | 17.9 | 1 | GROUP |
| 45 | 156 | 13.2 | 3 | GROUP |
| 50 | 157 | 15.9 | 3 | GROUP |
| 44 | 159 | 14.6 | 2 | GROUP |
| 42 | 161 | 13.2 | 1 | GROUP |
| 48 | 162 | 14.5 | 4 | GROUP |
| 41 | 164 | 17.8 | 3 | GROUP |
| 67 | 166 | 18.9 | 1 | GROUP |
| 44 | 168 | 12.4 | 2 | GROUP |
| 43 | 169 | 14.0 | 5 | GROUP |
| 22 | 170 | 14.3 | 4 | GROUP |
| 46 | 172 | 14.7 | 3 | GROUP |
| 43 | 175 | 13.6 | 5 | GROUP |
| 49 | 178 | 18.3 | 2 | GROUP |
| 44 | 192 | 16.7 | 1 | GROUP |
| 25 | 130 | 12.8 | 2 | NONE |
| 36 | 131 | 11.7 | 3 | NONE |
| 35 | 131 | 21.6 | 1 | NONE |
| 36 | 131 | 18.5 | 0 | NONE |
| 49 | 131 | 14.6 | 1 | NONE |
| 37 | 132 | 10.0 | 3 | NONE |
| 38 | 135 | 18.5 | 3 | NONE |
| 22 | 139 | 16.9 | 4 | NONE |
| 39 | 140 | 12.4 | 0 | NONE |
| 42 | 140 | 17.5 | 3 | NONE |
| 37 | 142 | 13.9 | 2 | NONE |
| 25 | 143 | 15.4 | 1 | NONE |
| 50 | 144 | 15.8 | 2 | NONE |
| 22 | 145 | 19.0 | 2 | NONE |
| 50 | 148 | 16.0 | 0 | NONE |
| 67 | 155 | 17.9 | 1 | NONE |
| 37 | 159 | 18.1 | 0 | NONE |
| 39 | 160 | 14.3 | 4 | NONE |
| 45 | 138 | 15.3 | 2 | ONLINE |
| 36 | 140 | 15.7 | 1 | ONLINE |
| 39 | 144 | 17.7 | 1 | ONLINE |
| 41 | 149 | 17.3 | 0 | ONLINE |
| 45 | 149 | 13.5 | 1 | ONLINE |
| 42 | 152 | 14.6 | 1 | ONLINE |
| 44 | 153 | 15.3 | 2 | ONLINE |
| 41 | 155 | 16.0 | 2 | ONLINE |
| 44 | 156 | 20.0 | 0 | ONLINE |
| 40 | 157 | 15.4 | 1 | ONLINE |
| 34 | 158 | 14.2 | 3 | ONLINE |
| 41 | 159 | 18.8 | 2 | ONLINE |
| 43 | 160 | 10.9 | 4 | ONLINE |
| 44 | 160 | 14.8 | 2 | ONLINE |
| 43 | 161 | 17.3 | 3 | ONLINE |
| 46 | 163 | 16.6 | 2 | ONLINE |
| 44 | 165 | 15.7 | 3 | ONLINE |
| 44 | 165 | 12.4 | 3 | ONLINE |
| 48 | 167 | 14.8 | 3 | ONLINE |
| 42 | 168 | 16.4 | 0 | ONLINE |
| 44 | 168 | 11.0 | 5 | ONLINE |
| 41 | 170 | 12.3 | 0 | ONLINE |
| 45 | 170 | 14.2 | 1 | ONLINE |
| 48 | 170 | 17.4 | 5 | ONLINE |
| 46 | 171 | 14.9 | 5 | ONLINE |
| 48 | 171 | 13.0 | 5 | ONLINE |
| 30 | 173 | 17.5 | 1 | ONLINE |
| 43 | 174 | 12.7 | 2 | ONLINE |
| 45 | 174 | 13.6 | 2 | ONLINE |
| 40 | 176 | 12.6 | 1 | ONLINE |
| 21 | 177 | 17.0 | 0 | ONLINE |
| 41 | 178 | 13.4 | 2 | ONLINE |
| 49 | 178 | 15.1 | 3 | ONLINE |
| 49 | 178 | 16.4 | 2 | ONLINE |
| 51 | 178 | 16.5 | 1 | ONLINE |
| 41 | 180 | 14.0 | 2 | ONLINE |
| 42 | 181 | 11.5 | 4 | ONLINE |
| 48 | 182 | 13.0 | 2 | ONLINE |
| 46 | 183 | 15.4 | 4 | ONLINE |
| 46 | 184 | 12.7 | 5 | ONLINE |
| 52 | 184 | 11.4 | 4 | ONLINE |
| 21 | 185 | 18.9 | 2 | ONLINE |
| 47 | 186 | 13.5 | 3 | ONLINE |
| 48 | 186 | 14.2 | 1 | ONLINE |
| 48 | 188 | 13.6 | 0 | ONLINE |
| 48 | 188 | 11.3 | 2 | ONLINE |
| 50 | 189 | 14.3 | 1 | ONLINE |
| 56 | 189 | 15.0 | 3 | ONLINE |
| 40 | 191 | 19.0 | 5 | ONLINE |
| 52 | 193 | 13.7 | 5 | ONLINE |
| 42 | 194 | 13.6 | 2 | ONLINE |
| 41 | 198 | 13.2 | 2 | ONLINE |
| 48 | 201 | 12.5 | 1 | ONLINE |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
