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.
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 80494684Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started