Answer:
See explanation
Step-by-step explanation:
Required
The average weight produced
The question is incomplete, as the required cells are not given and there are other missing details.
However, I will give a general explanation of calculating average in Excel
The required formula is:
=AVERAGE(Cell Range)
Assume the cells that contain the boxes are: cells A10 to A10010
The average will be calculated as:
=AVERAGE(A10:A10010)
xkxpvYGkutafumys6idod
345235235232352352353523523535
9514 1404 393
$6307.95
The compound interest formula can help with that.
A = P(1 +r/n)^(nt) . . . . value of principal P at rate r for t years, compounded n times per year.
P = A(1 +r/n)^(-nt) = $8000(1 +0.04/2)^(-2·6) = $8000(1.02^-12) = $6307.95
Momba needs to deposit $6307.95 today to have $8000 in 6 years.
