Question: VBA loop coding Write a code that calculates the average runs across all teams. In the inner loop, you need to get average runs for

VBA loop coding

Write a code that calculates the average runs across all teams.

In the inner loop, you need to get average runs for each team.

In the outer loop, average them across teams.

Make the result pop up in the message box. Do not debug.print.

You only need to report one number, which is the average runs across all teams.

You do not need to report the average of each team.

Submit the excel workbook which contains your code.

Make sure that your code runs without an error.

Make sure to save the file that enables macro. Otherwise, your file will not preserve your code. After saving, close and reopen the file to double check whether your code is saved. If your excel acts funky and does not let you save your code, submit your code in a text file (with extension .txt).

You will not get the full credit if

The code does not properly run (e.g. code has an error, etc.)

The code does not pop up the result (e.g. debug.print)

Or the code does not give me the correct number.

This is the question and below is what the excel file looks like. The team goes until Team 24 and for each teams, the rows are different. VBA loop coding Write a code that calculates the average runs across

64662192 2685375743257000 9 0 0 5 7 319 576 5223 257 275 ,5 65 1811044396557094633724 6968892 32497975664077 50 6472 3842166251561449300 36017351 44230573 80494684 64662192 2685375743257000 9 0 0 5 7 319 576 5223 257 275 ,5 65 1811044396557094633724 6968892 32497975664077 50 6472 3842166251561449300 36017351 44230573 80494684

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!