Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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. image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Relational Model A Retrospective Review And Analysis

Authors: C. J. Date

1st Edition

0201612941, 978-0201612943

More Books

Students also viewed these Databases questions