Mean on Excel

1 year ago
128

There are three ways to put a mean on Excel
1a. Click on an empty box
b. Type =AVERAGE,
c. Click on AVERAGE
d. Then type the opening parenthesis, type the letter and the number of where your first data set is, then colon, type the letter and number of where your last data point is, then the closing parenthesis. Lastly, click Enter. For Example =AVERAGE(A2:A11). You would know that you are doing it correctly because your data set would be highlighted as you go.

2a. Click on an empty box
b. Click on AutoSum, then on the drop-down click on AVERAGE
c. Then type the letter and the number of where your first data set is, then colon, type the letter and number of where your last data point is. For instance =AVERAGE(B2:B11). then click Enter

3a. Click on an an empty box
b. Click on Formulas, then click on More Functions, on the drop down choose Statistical, then AVERAGE.
c. Use only Number1 if you are only using one set of data.
However, if you are using multiple data sets then type the letter and the number of the first and last of your data sets for Number1, Number2, etc.

For instance one data set
Number1 (A2:A11)

Multiple data sets
Number1 A2:A11
Number2 B2:B11

Loading comments...