Question

Write a sub that computes the averages for each two rows (Jan and Feb) of a...

  1. Write a sub that computes the averages for each two rows (Jan and Feb) of a table where the data starts in cell B1 on worksheet “Operations” and there are five years worth of data in each row..
    1. Store the average at the end of each row. (NOTE this is shown in the example table below)

Customer ID

1001

1002

1003

1004

1005

Row Average

Jan

10

20

14

15

18

15.4

Feb

12

22

13

16

19

16.4

Homework Answers

Answer #1

The average can be computed using the Average excel function.

Customer ID 1001 1002 1003 1004 1005 Row Average
Jan 10 20 14 15 18 15.4
Feb 12 22 13 16 19 16.4

WORKINGS

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT