Question: Excel actually buries the statistical functions because, as you may have guessed, most people just don't use them for anything. Locate the statistical functions -
Excel actually buries the statistical functions because, as you may have guessed, most people just don't use them for anything. Locate the statistical functions - depending on your version (old or new), they're under "formulas" and "other." Cut and paste this table into Excel and determine the mean, median, and mode for these numbers. (All of them, not each column individually.) Upload your file.
| 3056 | 941 | 554 | 7472 | 1744 |
| 823 | 2230 | 679 | 8600 | 8271 |
| 4390 | 1461 | 866 | 5987 | 832 |
| 7786 | 2080 | 7401 | 5500 | 1187 |
| 1640 | 3412 | 5973 | 4101 | 2567 |
| 4034 | 3625 | 5129 | 7891 | 8332 |
| 5857 | 5397 | 924 | 8496 | 4738 |
| 7091 | 972 | 7265 | 9116 | 8291 |
| 7102 | 9344 | 9832 | 5768 | 6088 |
| 2624 | 1670 | 4020 | 414 | 6849 |
| 9340 | 7927 | 1910 | 7222 | 4847 |
| 1118 | 9351 | 8582 | 9971 | 1692 |
| 488 | 9084 | 8999 | 9923 | 6803 |
| 7472 | 1877 | 3143 | 1831 | 3138 |
| 8138 | 493 | 7472 | 5811 | 9876 |
| 3365 | 9171 | 4134 | 8196 | 6644 |
| 407 | 7996 | 2186 | 293 | 3226 |
| 7723 | 7470 | 6182 | 6009 | 587 |
| 5128 | 9222 | 5146 | 8252 | 9390 |
| 6949 | 1651 | 9473 | 9218 | 882 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
