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.

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

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.

omg taking this same test i was stuck on the same question i was too lazy to read the book sadly i cant really give you an answer to this question too complex the answer will be in chapter 5 of the cay