Question

In an Excel spreadsheet, a set of numbers is stored in cells B1, B2, B3, , B9. Write an Excel formula that would calculate the mean of this data.

Answer 1

=(B1+B2+B3+B9)/4

Step-by-step explanation:

The mean is the average of a group of data and it is calculated by adding all the numbers and dividing by the amount of numbers. So, according to this, the formula in Excel that would allow you to calculate the mean of this data is:

=(B1+B2+B3+B9)/4

You have to add the numbers by indicating the cells in which they are contained and divide by 4 that is the amount of numbers given.