misterwhale2051 misterwhale2051
  • 11-02-2020
  • Computers and Technology
contestada

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.

Respuesta :

majocgonzalez majocgonzalez
  • 13-02-2020

Answer:

=(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.

Answer Link

Otras preguntas

Why do tides happen every 50 minuets?
What processes occur durring light dependent reactions in photosynthesis?
what is the significance of Odysseus telling the Cyclops his name is nobody
Which of these factors did Spencer ignore in his theories of social Darwinism: social variables that result in unequal opportunities. human ambition, which enab
each genus of organisms contains one or more what
rewrite 4% as a decimal
real world situation to explain the relationship between work and power
how should monologues be structured
A solution that contains equal numbers of hydrogen and hydroxyl ions would be called _____.
which word best describes the soilders in the charge of the light brigade