Question: using excel VBA ) You have been hired by a very secretive company. As it is, you have not been given a job title, your

using excel VBAusing excel VBA ) You have been hired by a very secretive

) You have been hired by a very secretive company. As it is, you have not been given a job title, your office changes location every 8 days, and all coworkers are referred to by code instead of using their real name (you are given the code name JuiceWeasel). At first, you assume you are employed by some military black-ops outfit, however, some details of your first project indicate that your employer is much worse than any shady defense contractor you are working for the militant wing of Egg Board (this is a group that the tobacco companies describe as soulless). Your first project is to analyze data collected by the marketing group, whose goal is to expound on the virtues of a diet consisting mainly of eggs. The data you will be operating upon has been given to you (and is shown below). 1 Raw Data Definitely not cholesterol related deaths/yr 2.80 12.20 30.64 32.21 7.95 16.59 37.01 22.27 31.72 40.78 4.47 34.46 7.94 33.55 19.02 34.14 34.62 39.11 30.22 15.04 39.69 23.75 34.85 26.74 Your program should input the data from the spreadsheet into a two-dimensional array. (The data to be input is only the deaths -do not input the Eggs/day column). .Pass the array to a subprocedure. Within the subprocedure, sort the data in each row (or by "definitely not cholesterol related deaths/yr") by applying the sort algorithm to the array passed as an argument. Output the data to the spreadsheet using a set of nested loops. The output will look like the figure below 1 Raw Data Definitely not cholesterol related deaths/yr 2.80 12.20 16.59 40.78 30.64 37.01 32.21 7.94 33.55 19.02 34.14 34.62 39.11 30.22 15.04 39.69 23.75 34.85 26.74 7.95 31.72 4.47 34.46 22.27 8 Sorted Data 10 Definitely not cholesterol related deaths/yr 31.72 33.55 7.95 7.94 2.80 55 23.75 16.59 12.20 37.01 34.8530.64 30.22 19.02 4.47 26.74 22.27 15.04 39.69 34.62 40.7839. 12 13 11 34.46 34.14 32.21 ) You have been hired by a very secretive company. As it is, you have not been given a job title, your office changes location every 8 days, and all coworkers are referred to by code instead of using their real name (you are given the code name JuiceWeasel). At first, you assume you are employed by some military black-ops outfit, however, some details of your first project indicate that your employer is much worse than any shady defense contractor you are working for the militant wing of Egg Board (this is a group that the tobacco companies describe as soulless). Your first project is to analyze data collected by the marketing group, whose goal is to expound on the virtues of a diet consisting mainly of eggs. The data you will be operating upon has been given to you (and is shown below). 1 Raw Data Definitely not cholesterol related deaths/yr 2.80 12.20 30.64 32.21 7.95 16.59 37.01 22.27 31.72 40.78 4.47 34.46 7.94 33.55 19.02 34.14 34.62 39.11 30.22 15.04 39.69 23.75 34.85 26.74 Your program should input the data from the spreadsheet into a two-dimensional array. (The data to be input is only the deaths -do not input the Eggs/day column). .Pass the array to a subprocedure. Within the subprocedure, sort the data in each row (or by "definitely not cholesterol related deaths/yr") by applying the sort algorithm to the array passed as an argument. Output the data to the spreadsheet using a set of nested loops. The output will look like the figure below 1 Raw Data Definitely not cholesterol related deaths/yr 2.80 12.20 16.59 40.78 30.64 37.01 32.21 7.94 33.55 19.02 34.14 34.62 39.11 30.22 15.04 39.69 23.75 34.85 26.74 7.95 31.72 4.47 34.46 22.27 8 Sorted Data 10 Definitely not cholesterol related deaths/yr 31.72 33.55 7.95 7.94 2.80 55 23.75 16.59 12.20 37.01 34.8530.64 30.22 19.02 4.47 26.74 22.27 15.04 39.69 34.62 40.7839. 12 13 11 34.46 34.14 32.21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!