statistic excel
kayladolan
homework.xlsxRaw Data
| Age (months) | Distance (miles) | GPA | Major | Year | Stat Class ? | Anxiety | Work Hours | # Other Classes | Study Hours | Year | |||||||||||||||||||
| 216 | 0 | 3.85 | Bus. | 1 | No | 3 | 0 | 5 | 35 | Freshman | Age (months) | Your age converted to months (e.g., 20 years and 3 months would be 243 months): | |||||||||||||||||
| 217 | 0 | 3.41 | CIS | 2 | Yes | 1 | 0 | 5 | 15 | Sophmore | Distance (miles) | Distance in miles from where you lived during high school to UofL: | |||||||||||||||||
| 219 | 0 | 4.00 | Acct. | 1 | Yes | 2 | 0 | 6 | 10 | Freshman | GPA | Your GPA: | |||||||||||||||||
| 224 | 1 | 3.20 | Mktg. | 1 | No | 4 | 0 | 6 | 10 | Freshman | Major | Your major or planned major: | |||||||||||||||||
| 224 | 2 | 4.00 | Econ. | 1 | No | 3 | 0 | 5 | 100 | Freshman | Year | Your class year at UofL (F=freshman, S=sophomore, J=junior, R=senior, G=grad, O=other): | |||||||||||||||||
| 224 | 2 | 3.10 | Acct. | 1 | No | 4 | 0 | 5 | 15 | Freshman | Stat Class ? | Have you taken statistics previously, either in high school or college? (Yes or No) | |||||||||||||||||
| 224 | 3 | 4.00 | Mktg. | 1 | No | 3 | 0 | 5 | 10 | Freshman | Anxiety | Your level of anxiety about this course on a 1-5 scale with 1 = None and 5 = very high: | |||||||||||||||||
| 225 | 5 | 3.40 | Bus. | 1 | No | 4 | 17.5 | 5 | 5 | Freshman | Work Hours | Average number of hours per week you work (for pay): | |||||||||||||||||
| 227 | 6 | 3.00 | Equine | 2 | No | 2 | 0 | 6 | 10 | Sophmore | # Other Classes | Number of other classes currently enrolled in: Indicate number (indicate 0, 1, 2 etc.) | |||||||||||||||||
| 228 | 8 | 4.00 | Other | 1 | No | 3 | 0 | 6 | 14 | Freshman | Study Hours | The average number of hours per week you study during a Normal semester. | |||||||||||||||||
| 228 | 8 | 2.90 | Mktg. | 2 | No | 3 | 15 | 4 | 20 | Sophmore | |||||||||||||||||||
| 228 | 9 | 2.90 | Acct. | 2 | No | 3 | 30 | 4 | 10 | Sophmore | |||||||||||||||||||
| 228 | 10 | 3.72 | Fin. | 2 | No | 5 | 12 | 5 | 18 | Sophmore | |||||||||||||||||||
| 228 | 10 | 3.80 | Fin. | 2 | Yes | 3 | 26 | 4 | 28 | Sophmore | |||||||||||||||||||
| 228 | 10 | 3.58 | Equine | 2 | Yes | 3 | 0 | 6 | 10 | Sophmore | |||||||||||||||||||
| 228 | 11 | 2.80 | CIS | 2 | Yes | 5 | 30 | 3 | 8 | Sophmore | Age (months) | Distance (miles) | GPA | Anxiety | Work Hours | # Other Classes | Study Hours | Year | |||||||||||
| 229 | 12 | 2.81 | CIS | 1 | No | 4 | 0 | 4 | 12 | Freshman | |||||||||||||||||||
| 229 | 12 | 3.00 | CIS | 2 | No | 3 | 12 | 4 | 16 | Sophmore | Mean | 243.43 | Mean | 263.5789 | Mean | 3.28205 | Mean | 2.91 | Mean | 12.585 | Mean | 4.3 | Mean | 16.65 | Mean | 2.33 | |||
| 230 | 12.8 | 3.45 | Econ. | 2 | No | 3 | 11 | 5 | 10 | Sophmore | Standard Error | 2.2154305052 | Standard Error | 74.2038816292 | Standard Error | 0.0466243951 | Standard Error | 0.1028335912 | Standard Error | 1.2748748206 | Standard Error | 0.0915633026 | Standard Error | 1.3082778409 | Standard Error | 0.0752839742 | |||
| 230 | 13 | 3.97 | Acct. | 2 | No | 2.5 | 0 | 4 | 15 | Sophmore | Median | 238 | Median | 45 | Median | 3.2085 | Median | 3 | Median | 10.5 | Median | 4 | Median | 14 | Median | 2 | |||
| 230 | 13 | 3.00 | Bus. | 2 | No | 3 | 0 | 4 | 10 | Sophmore | Mode | 236 | Mode | 20 | Mode | 4 | Mode | 3 | Mode | 0 | Mode | 4 | Mode | 10 | Mode | 2 | |||
| 231 | 14.5 | 3.86 | Econ. | 2 | No | 3 | 0 | 4 | 10 | Sophmore | Standard Deviation | 22.1543050517 | Standard Deviation | 742.0388162924 | Standard Deviation | 0.4662439509 | Standard Deviation | 1.0283359118 | Standard Deviation | 12.7487482055 | Standard Deviation | 0.915633026 | Standard Deviation | 13.0827784094 | Standard Deviation | 0.7528397418 | |||
| 231 | 15 | 3.10 | Fin. | 2 | No | 4 | 27 | 5 | 15 | Sophmore | Sample Variance | 490.8132323232 | Sample Variance | 550621.604884636 | Sample Variance | 0.2173834217 | Sample Variance | 1.0574747475 | Sample Variance | 162.5305808081 | Sample Variance | 0.8383838384 | Sample Variance | 171.1590909091 | Sample Variance | 0.5667676768 | |||
| 231 | 15 | 3.60 | Acct. | 2 | No | 3 | 15 | 4 | 10 | Sophmore | Kurtosis | 8.8154873565 | Kurtosis | 28.6073886037 | Kurtosis | 0.2517774956 | Kurtosis | 0.3136740188 | Kurtosis | -0.716328278 | Kurtosis | 0.0224828093 | Kurtosis | 18.1574334568 | Kurtosis | 1.0624546415 | |||
| 231 | 15 | 2.85 | Fin. | 2 | No | 2 | 20 | 3 | 15 | Sophmore | Skewness | 2.7355762073 | Skewness | 5.1804662071 | Skewness | -0.3389379507 | Skewness | -0.0015241221 | Skewness | 0.6154746368 | Skewness | 0.2497395514 | Skewness | 3.5227191447 | Skewness | 0.6729328025 | |||
| 231 | 15 | 3.43 | Econ. | 2 | Yes | 3 | 8 | 4 | 15 | Sophmore | Range | 128 | Range | 5000 | Range | 2.161 | Range | 5 | Range | 45 | Range | 5 | Range | 97 | Range | 4 | |||
| 233 | 15 | 3.30 | Mktg. | 2 | No | 3 | 15 | 5 | 10 | Sophmore | Minimum | 216 | Minimum | 0 | Minimum | 1.839 | Minimum | 0 | Minimum | 0 | Minimum | 2 | Minimum | 3 | Minimum | 1 | |||
| 233 | 15.3 | 3.25 | Fin. | 2 | No | 1.5 | 0 | 7 | 5 | Sophmore | Maximum | 344 | Maximum | 5000 | Maximum | 4 | Maximum | 5 | Maximum | 45 | Maximum | 7 | Maximum | 100 | Maximum | 5 | |||
| 233 | 16 | 3.00 | Mktg. | 2 | No | 1 | 0 | 4 | 10 | Sophmore | Sum | 24343 | Sum | 26357.89 | Sum | 328.205 | Sum | 291 | Sum | 1258.5 | Sum | 430 | Sum | 1665 | Sum | 233 | |||
| 233 | 16.7 | 2.19 | CIS | 2 | No | 3 | 10 | 4 | 10 | Sophmore | Count | 100 | Count | 100 | Count | 100 | Count | 100 | Count | 100 | Count | 100 | Count | 100 | Count | 100 | |||
| 233 | 17 | 3.00 | Acct. | 2 | Yes | 1 | 25 | 4 | 15 | Sophmore | CV | 0.091008935 | CV | 2.8152436189 | CV | 0.1420587593 | CV | 0.3533800384 | CV | 1.0130113791 | CV | 0.212937913 | CV | 0.785752457 | CV | 0.3231071853 | |||
| 233 | 18 | 2.30 | Bus. | 2 | Yes | 3 | 10 | 4 | 28 | Sophmore | RCV | 221-240 | RCV | 11-20 | RCV | 2.5-3.5 | RCV | RCV | 0-10 | RCV | 4-5 | RCV | 16-18 | RCV | 2 | ||||
| 234 | 18 | 2.90 | SPAD | 2 | No | 3 | 15 | 5 | 30 | Sophmore | Outliners | Outliners | 30,005,000 | Outliners | 1.84 | Outliners | 0 | Outliners | 45 | Outliners | 7 | Outliners | 100 | Outliners | 5 | ||||
| 235 | 18.4 | 3.76 | Mktg. | 2 | No | 2 | 7 | 6 | 20 | Sophmore | |||||||||||||||||||
| 235 | 20 | 4.00 | CIS | 2 | Yes | 2 | 0 | 4 | 6 | Sophmore | |||||||||||||||||||
| 235 | 20 | 3.91 | Fin. | 2 | Yes | 2 | 0 | 4 | 30 | Sophmore | |||||||||||||||||||
| 236 | 20 | 4.00 | Fin. | 2 | No | 3 | 0 | 5 | 10 | Sophmore | |||||||||||||||||||
| 236 | 20 | 3.00 | Mktg. | 2 | No | 1 | 0 | 5 | 10 | Sophmore | |||||||||||||||||||
| 236 | 20 | 4.00 | Fin. | 2 | No | 2 | 0 | 4 | 15 | Sophmore | |||||||||||||||||||
| 236 | 20 | 3.10 | Acct. | 2 | No | 2 | 40 | 6 | 20 | Sophmore | |||||||||||||||||||
| 236 | 20 | 3.90 | Acct. | 2 | No | 2 | 12 | 5 | 20 | Sophmore | |||||||||||||||||||
| 236 | 23 | 3.00 | Fin. | 2 | No | 2 | 40 | 4 | 30 | Sophmore | |||||||||||||||||||
| 236 | 25 | 2.72 | Eng. | 2 | No | 3 | 20 | 5 | 30 | Sophmore | |||||||||||||||||||
| 236 | 30 | 3.50 | Econ. | 2 | No | 4 | 15 | 4 | 20 | Sophmore | |||||||||||||||||||
| 236 | 30 | 3.60 | Acct. | 2 | No | 3 | 6 | 5 | 9 | Sophmore | |||||||||||||||||||
| 236 | 30 | 3.33 | Mktg. | 2 | Yes | 3 | 20 | 5 | 25 | Sophmore | |||||||||||||||||||
| 237 | 35 | 3.20 | Acct. | 2 | No | 3 | 0 | 5 | 17 | Sophmore | |||||||||||||||||||
| 237 | 35 | 3.55 | Acct. | 2 | No | 2 | 15 | 3 | 20 | Sophmore | |||||||||||||||||||
| 238 | 41 | 4.00 | Acct. | 2 | No | 3 | 3 | 4 | 8 | Sophmore | |||||||||||||||||||
| 238 | 45 | 3.79 | Mktg. | 2 | No | 3 | 30 | 4 | 8 | Sophmore | |||||||||||||||||||
| 238 | 45 | 4.00 | Acct. | 2 | No | 3 | 3 | 4 | 8 | Sophmore | |||||||||||||||||||
| 239 | 45 | 3.50 | Econ. | 3 | No | 2 | 10 | 4 | 30 | Junior | |||||||||||||||||||
| 239 | 48 | 3.57 | Acct. | 2 | No | 3 | 0 | 5 | 25 | Sophmore | |||||||||||||||||||
| 239 | 55.8 | 3.57 | Acct. | 2 | No | 3 | 0 | 5 | 25 | Sophmore | |||||||||||||||||||
| 239 | 60 | 4.00 | CIS | 2 | No | 2 | 0 | 3 | 10 | Sophmore | |||||||||||||||||||
| 239 | 60 | 3.07 | Bus. | 2 | No | 4 | 32.5 | 4 | 10 | Sophmore | |||||||||||||||||||
| 239 | 65 | 2.80 | Fin. | 2 | Yes | 4 | 20 | 5 | 25 | Sophmore | |||||||||||||||||||
| 240 | 75 | 3.05 | Comm. | 3 | No | 5 | 15 | 5 | 20 | Junior | |||||||||||||||||||
| 240 | 79 | 3.10 | Other | 2 | No | 1 | 30 | 4 | 30 | Sophmore | |||||||||||||||||||
| 240 | 79 | 3.72 | Fin. | 2 | No | 3 | 20 | 3 | 10 | Sophmore | |||||||||||||||||||
| 240 | 80 | 3.47 | Mktg. | 2 | Yes | 3 | 0 | 5 | 6 | Sophmore | |||||||||||||||||||
| 241 | 82.3 | 3.60 | Acct. | 3 | No | 2 | 20 | 5 | 10 | Junior | |||||||||||||||||||
| 241 | 90 | 3.71 | Other | 3 | No | 4 | 10 | 6 | 30 | Junior | |||||||||||||||||||
| 241 | 92.4 | 3.38 | Mktg. | 3 | No | 3 | 0 | 4 | 8 | Junior | |||||||||||||||||||
| 241 | 93 | 3.20 | Bus. | 3 | Yes | 3 | 25 | 4 | 6 | Junior | |||||||||||||||||||
| 241 | 94 | 3.22 | Mktg. | 2 | No | 2 | 0 | 5 | 20 | Sophmore | |||||||||||||||||||
| 241 | 96 | 3.60 | Econ. | 2 | No | 2 | 0 | 4 | 20 | Sophmore | |||||||||||||||||||
| 243 | 100 | 3.01 | CIS | 3 | No | 2 | 15 | 4 | 5 | Junior | |||||||||||||||||||
| 243 | 100 | 2.92 | Acct. | 3 | Yes | 3 | 0 | 4 | 10 | Junior | |||||||||||||||||||
| 243 | 100 | 2.92 | Acct. | 3 | Yes | 3 | 0 | 4 | 10 | Junior | |||||||||||||||||||
| 244 | 107 | 3.52 | Mktg. | 3 | No | 4 | 8 | 4 | 20 | Junior | |||||||||||||||||||
| 244 | 110 | 3.10 | SPAD | 3 | No | 5 | 16.5 | 5 | 7 | Junior | |||||||||||||||||||
| 244 | 110 | 3.07 | Acct. | 3 | No | 3 | 0 | 5 | 18 | Junior | |||||||||||||||||||
| 244 | 135 | 3.20 | Fin. | 3 | Yes | 4 | 24 | 4 | 20 | Junior | |||||||||||||||||||
| 245 | 135 | 2.88 | Bus. | 3 | No | 3 | 26 | 4 | 45 | Junior | |||||||||||||||||||
| 245 | 169 | 2.80 | Eng. | 3 | No | 2 | 45 | 3 | 10 | Junior | |||||||||||||||||||
| 246 | 185 | 2.60 | Fin. | 3 | Yes | 3 | 0 | 3 | 8 | Junior | |||||||||||||||||||
| 247 | 193 | 3.26 | SPAD | 3 | No | 4 | 30 | 4 | 5 | Junior | |||||||||||||||||||
| 248 | 196 | 3.22 | Econ. | 3 | No | 3 | 10 | 4 | 15 | Junior | |||||||||||||||||||
| 248 | 264 | 3.10 | Bus. | 2 | No | 4 | 36 | 3 | 3 | Sophmore | |||||||||||||||||||
| 249 | 274 | 3.10 | Fin. | 3 | No | 3 | 15 | 5 | 10 | Junior | |||||||||||||||||||
| 252 | 300 | 2.70 | Mktg. | 4 | No | 3 | 36 | 4 | 15 | Senior | |||||||||||||||||||
| 252 | 315 | 3.10 | Acct. | 4 | Yes | 5 | 18 | 3 | 10 | Senior | |||||||||||||||||||
| 255 | 383 | 3.46 | Acct. | 3 | Yes | 3 | 0 | 5 | 9 | Junior | |||||||||||||||||||
| 255 | 418 | 3.10 | Fin. | 2 | No | 3 | 0 | 5 | 6 | Sophmore | |||||||||||||||||||
| 256 | 427 | 3.00 | Mktg. | 3 | No | 3 | 20 | 4 | 12 | Junior | |||||||||||||||||||
| 259 | 500 | 3.30 | Bus. | 3 | No | 3 | 25 | 2 | 20 | Junior | |||||||||||||||||||
| 260 | 545 | 2.80 | Equine | 4 | No | 5 | 21 | 4 | 15 | Senior | |||||||||||||||||||
| 263 | 595 | 1.84 | Acct. | 2 | No | 1 | 20 | 3 | 14 | Sophmore | |||||||||||||||||||
| 265 | 673.69 | 4.00 | Fin. | 3 | No | 5 | 40 | 3 | 5 | Junior | |||||||||||||||||||
| 266 | 709 | 3.13 | Acct. | 3 | No | 4 | 20 | 4 | 10 | Junior | |||||||||||||||||||
| 267 | 709 | 2.80 | Acct. | 2 | No | 2 | 20 | 3 | 12 | Sophmore | |||||||||||||||||||
| 272 | 765 | 2.90 | Comm. | 4 | Yes | 3 | 25 | 4 | 15 | Senior | |||||||||||||||||||
| 273 | 767 | 3.00 | Mktg. | 3 | No | 3 | 36 | 3 | 7 | Junior | |||||||||||||||||||
| 280 | 780 | 1.98 | Mktg. | 3 | Yes | 3 | 0 | 3 | 25 | Junior | |||||||||||||||||||
| 288 | 800 | 3.60 | Other | 5 | No | 2 | 0 | 3 | 6 | Graduate | |||||||||||||||||||
| 313 | 920 | 2.90 | Acct. | 3 | No | 5 | 0 | 3 | 40 | Junior | |||||||||||||||||||
| 329 | 3000 | 3.00 | Fin. | 3 | No | 1 | 25 | 3 | 18 | Junior | |||||||||||||||||||
| 337 | 4543 | 3.80 | CIS | 4 | No | 3 | 35 | 4 | 25 | Senior | |||||||||||||||||||
| 344 | 5000 | 3.53 | Acct. | 3 | No | 0 | 0 | 4 | 70 | Junior | |||||||||||||||||||
| AGE | Work Hours | MAJOR | Class Year | Stat Class ? | |||||||||||||||||||||||||
| BINS | FREQUENCY | Relative frequency | Cumulative relative frequency | Intervals | BINS | FREQUENCY | Relative frequency | Cumulative relative frequency | Intervals | BINS | FREQUENCY | Relative frequency | Cumulative relative frequency | BINS | FREQUENCY | Relative frequency | Cumulative relative frequency | BINS | FREQUENCY | Relative frequency | Cumulative relative frequency | ||||||||
| 200 | 0 | 0 | 0 | 0-200 | 10 | 50 | 0.5 | 50 | Below 10 | Bus. | 9 | 0.09 | 9 | Freshman | 9 | 0.09 | 9 | Yes | 22 | 0.22 | 22 | ||||||||
| 220 | 3 | 0.03 | 3 | 201-220 | 15 | 13 | 0.13 | 63 | 11-15 | CIS | 9 | 0.09 | 18 | Sophmore | 56 | 0.56 | 65 | No | 78 | 0.78 | 100 | ||||||||
| 240 | 58 | 0.58 | 61 | 221-240 | 20 | 13 | 0.13 | 76 | 16-20 | Acct. | 26 | 0.26 | 44 | Junior | 29 | 0.29 | 94 | ||||||||||||
| 260 | 27 | 0.27 | 88 | 241-260 | 25 | 7 | 0.07 | 83 | 21-25 | Mktg. | 17 | 0.17 | 61 | Senior | 5 | 0.05 | 99 | ||||||||||||
| 280 | 7 | 0.07 | 95 | 261-280 | 30 | 8 | 0.08 | 91 | 26-30 | Econ. | 8 | 0.08 | 69 | Graduate | 1 | 0.01 | 100 | ||||||||||||
| 300 | 1 | 0.01 | 96 | 281-300 | 35 | 2 | 0.02 | 93 | 31-35 | Equine | 3 | 0.03 | 72 | ||||||||||||||||
| 320 | 1 | 0.01 | 97 | 301-320 | 40 | 6 | 0.06 | 99 | 36-40 | Other | 4 | 0.04 | 76 | ||||||||||||||||
| 340 | 2 | 0.02 | 99 | 321-340 | 45 | 1 | 0.01 | 100 | 41-45 | Fin. | 17 | 0.17 | 93 | ||||||||||||||||
| 360 | 1 | 0.01 | 100 | 341-360 | SPAD | 3 | 0.03 | 96 | |||||||||||||||||||||
| Eng. | 2 | 0.02 | 98 | ||||||||||||||||||||||||||
| Comm. | 2 | 0.02 | 100 |
Age
FREQUENCY 0-200 201-220 221-240 241-260 261-280 281-300 301-320 321-340 341-360 0 3 58 27 7 1 1 2 1 Relative frequency 0-200 201-220 221-240 241-260 261-280 281-300 301-320 321-340 341-360 0 0.03 0.57999999999999996 0.27 7.0000000000000007E-2 0.01 0.01 0.02 0.01 Cumulative relative fre quency 0-200 201-220 221-240 241-260 261-280 281-300 301-320 321-340 341-360 0 3 61 88 95 96 97 99 100
Work Hours
FREQUENCY Below 10 11-15 16-20 21-25 26-30 31-35 36-40 41-45 50 13 13 7 8 2 6 1 Relative frequency Below 10 11-15 16-20 21-25 26-30 31-35 36-40 41-45 0.5 0.13 0.13 7.0000000000000007E-2 0.08 0.02 0.06 0.01 Cumulative relative frequency Below 10 11-15 16-20 21-25 26-30 31-35 36-40 41-45 50 63 76 83 91 93 99 100
Major
FREQUENCY Bus. CIS Acct. Mktg. Econ. Equine Other Fin. SPAD Eng. Comm. 9 9 26 17 8 3 4 17 3 2 2 Relative frequency Bus. CIS Acct. Mktg. Econ. Equine Other Fin. SPAD Eng. Comm. 0.09 0.09 0.26 0.17 0.08 0.03 0.04 0.17 0.03 0.02 0.02 Cumulative relative frequency Bus. CIS Acct. Mktg. Econ. Equine Other Fin. SPAD Eng. Comm. 9 18 44 61 69 72 76 93 96 98 100
Class Year
FREQUENCY Freshman Sophmore Junior Senior Graduate 9 56 29 5 1 Relative frequency Freshman Sophmore Junior Senior Graduate 0.09 0.56000000000000005 0.28999999999999998 0.05 0.01 Cumulative relative frequency Freshman Sophmore Junior Senior Graduate 9 65 94 99 100
Stat Class ?
FREQUENCY Yes No 22 78 Relative frequency Yes No 0.22 0.78 Cumulative relative frequency Yes No 22 100
