Home / Computer / 4 Ways to Calculate Average Value of Various Data in Excel 2016 – iSumsoft

4 Ways to Calculate Average Value of Various Data in Excel 2016 – iSumsoft

calculate average value of data

In the process of making tables, we may use Excel to perform various calculations on the data such as sum, difference, product, and average to complete our calculation. Calculating the average of all kinds of data is a very important parameter in analysis data. If we usethe traditional calculator to calculate the average, we need to repeatedly enter, and it is extremely easy to get the input data wrong during the input process.

However, calculating the average is one of the simplest and fastest method in Excel, which can not only calculate the answer accurately, but also check whether the data of each step is correct. Even in the face of massive data, we can easily calculate. Here’s how to calculate the average of various data in Excel 2016.

4 ways to calculate average value of various data in Excel 2016

Way 1: Insert function to calculate average value

Step 1: Open the Excel table that requires to calculate average value.

open the target Excel table

Step 2: Move the mouse into the first cell under the “Average Values“, then click the “Formula” in the menu bar and select the “Insert Function” in the popular menu bar.

select the Insert Function

Step 3: When the Insert Function dialog box pops up,  choose “AVERAGE” in the Select a function, you can see the detailed description of its function below, and then click OK.

choose Average

Step 4: In the Function Arguments window, click the red arrow button behind “NUMBER1“. Click OK. Or just type B2: D2 behind “NUMBER1” and click OK.

click the red arrow button

Step 5: Select the B2: D2 cell, and then B2: D2 will be displayed in the Function Arguments box. Click the red arrow button again.

select the B2:D2 cell

Step 6: You’ll see a dialog box with B2: D2 pops up and click OK.

click ok

Step 7: At this point, the average of B2: D2 appears in the E2 cell.

average of B2:D2 appeared

Step 8: After calculating the average value of B2: D2, move the mouse into the lower right corner of the E2 cell, which will show the black “+” symbol. And just going to keep dragging it down until all of the data averages show up.

the data averages show up

Way 2: Using Average to calculate average value

Step 1: Select the cell of B2: D2 and click the small arrow to select Average.

select Average

Step 2: Move the mouse into the lower right corner of the E2 cell, and a “+” symbol appears, drag it all the way down to E7.

Step 3: As you can see, the average value of column E has been calculated.

Way 3: Enter the function formula to calculate average value

Enter the formula “=AVERAGE(B2: D2)” in the E2 cell and press “Enter” to display the average value.  And go to Step 7-Step 8 in way 1.

enter the function formula

Way 4: Enter the intricacy formula to calculate average value

Enter the formula “=SUM(B2: D2)/COUNT(B2: D2)” in the E2 cell, and press “Enter” to display the average value. And go to Step 7-Step 8 in way 1.

enter the intricacy formula

Loading...

>> Source Link

Check Also

Laptop Can't Connect Wifi, Here's How to Fix It!

At this time, who does not need a WiFi connection? With WiFi, we can access …

%d bloggers like this: