Question Use the spreadsheet's Average function (look under AutoSum in the Function menu) to calculate

the means.

Enter the correct value in each box. Use numerals instead of words, and round each value to the

nearest hundredth.

The mean value of people who would purchase the red box is

The mean value of people who would purchase the blue box is

Step-by-step explanation:

The question is incomplete.

See attachment for data sheet and the calculated mean

Required

The average of both colors using average function

For the red box, the data starts from cell B4 and ends at cell B48

Using the average function, the average is:

The above returns 15.11

So, we have:

For the blue box, the data starts from cell E4 and ends at cell E63

Using the average function, the average is:

The above returns 16.85

So, we have:

investment b is an ordinary annuity with $3,909.64 in the account after one year.

step-by-step explanation: