Question: copy and paste this table onto Excel spreadsheet. Then do the following things. 7 3 8 6 3 6 1 6 9 4 2 5
- copy and paste this table onto Excel spreadsheet. Then do the following things.
| 7 | 3 | 8 | 6 | 3 | 6 |
| 1 | 6 | 9 | 4 | 2 | 5 |
| 5 | 10 | 10 | 4 | 6 | 2 |
| 1 | 7 | 6 | 7 | 0 | 6 |
| 1 | 5 | 6 | 3 | 9 | 7 |
| 1 | 7 | 8 | 8 | 1 | 6 |
| 2 | 8 | 0 | 6 | 0 | 2 |
| 7 | 5 | 10 | 1 | 3 | 0 |
| 8 | 5 | 9 | 9 | 4 | 0 |
| 6 | 4 | 3 | 2 | 4 | 2 |
| 8 | 4 | 7 | 6 | 6 | 9 |
| 6 | 4 | 1 | 4 | 3 | 1 |
| 2 | 3 | 0 | 8 | 8 | 4 |
| 0 | 3 | 5 | 4 | 7 | 6 |
| 7 | 1 | 0 | 0 | 8 | 3 |
| 4 | 1 | 8 | 3 | 9 | 6 |
| 4 | 1 | 1 | 10 | 3 | 5 |
| 7 | 3 | 0 | 4 | 1 | 4 |
| 3 | 6 | 6 | 9 | 6 | 1 |
| 8 | 2 | 3 | 6 | 6 | 8 |
| 0 | 0 | 1 | 10 | 1 | 2 |
| 5 | 2 | 9 | 4 | 3 | 7 |
| 5 | 7 | 3 | 8 | 1 | 6 |
Please:
1) develop one VBA program to put these numbers in ONE row in Excel spreadsheet;
2) develop one VBA program to order the numbers in the above row and put the ordered numbers in another row.
3) develop one VBA program to find the median number among the numbers in the row above.
4) develop one VBA program to find how many tens in the whole data set.
5) develop one VBA program to find in the above 6 columns, which column has the highest occurrences of zeros.
Do NOT use any Excel built-in functions to sort or to get the median or achieve any function. Design your own code to achieve all functions in this question.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help