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
Business   Finance   
0 0
Add a commentTranscribed image text
Next >

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

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
For each account of the previous question, compute the Balance, and return a table that shows...
For each account of the previous question, compute the Balance, and return a table that shows the account number, type, and balance for each account (hint: use UNION). The list of customer names that have transactions greater than or equal to one thousand dollars. A) Answer this question using only nested queries (i.e., each select is over only one table). B) Answer this query using joins. Bank.sql is under this statement. DROP DATABASE IF EXISTS Bank; CREATE DATABASE Bank; USE...
Complete a Java program named ARMgr that maintains customer accounts receivable in a database. The code...
Complete a Java program named ARMgr that maintains customer accounts receivable in a database. The code to initialize the CustomerAccountsDB database table and add a set of customer accounts is provided. Finish the code in these 3 methods in CustomerAccountDB.java to update or query the database: -purchase(double amountOfPurchase) -payment(double amountOfPayment) -getCustomerName() Hint: For getCustomerName(), look at the getAccountBalance() method to see an example of querying data from the database. For the purchase() and payment() methods, look at the addCustomerAccount() method...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT