๐ŸŒ
Ablebits
ablebits.com โ€บ ablebits blog โ€บ excel โ€บ average โ€บ calculating mean, median and mode in excel
Calculating Mean, Median and Mode in Excel
March 20, 2023 - In Microsoft Excel, the mean can be calculated by using one of the following functions: AVERAGE- returns an average of numbers. AVERAGEA - returns an average of cells with any data (numbers, Boolean and text values). AVERAGEIF - finds an average of numbers based on a single criterion. AVERAGEIFS - finds an average of numbers based on multiple criteria. For the in-depth tutorials, please follow the above links. To get a conceptual idea of how these functions work, consider the following example.
๐ŸŒ
Microsoft Support
support.microsoft.com โ€บ en-us โ€บ office โ€บ average-function-047bac88-d466-426c-a32b-8f33eb960cf6
AVERAGE function - Microsoft Support
Note: The AVERAGE function measures ... central tendency are: Average, which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers....
๐ŸŒ
Indeed
indeed.com โ€บ career guide โ€บ career development โ€บ how to calculate mean in excel in 4 steps (plus its uses)
How To Calculate Mean in Excel in 4 Steps (Plus Its Uses) | Indeed.com
July 2, 2024 - Syntax: =AVERAGE(array of numbers)For example: Say you will be calculating the mean for column A, rows two through 20. Your formula will look like this: =AVERAGE(A2:A20).When you hit enter, Excel will automatically calculate the mean, but will ...
๐ŸŒ
MyExcelOnline
myexcelonline.com โ€บ home โ€บ how to calculate mean in excel โ€“ step by step guide
How to Calculate Mean in Excel - Step by Step Guide | MyExcelOnline
January 3, 2025 - Utilize the formula =SUMPRODUCT(B2:B7,C2:C7)/SUM(B2:B7), where B2:B7 contains the quantites and C2:C17 the price per unit. SUMPRODUCT multiplies corresponding values and weights and sums the results, while SUM adds the total weights.
๐ŸŒ
SimonsezIt
simonsezit.com โ€บ article โ€บ how-to-calculate-mean-in-excel
How to Calculate Mean in Excel? 2 Useful Ways.
May 19, 2025 - For example, to calculate the Mean of all the values in column A, you could use the formula โ€œ=AVERAGE(A:A)โ€. To calculate the Mean of all the values in row 1, you could use the formula โ€œ=AVERAGE(1:1)โ€. Calculating the Mean in Excel is ...
๐ŸŒ
Microsoft Support
support.microsoft.com โ€บ en-us โ€บ office โ€บ calculate-the-average-of-a-group-of-numbers-e158ef61-421c-4839-8290-34d7b1e68283
Calculate the average of a group of numbers - Microsoft Support
Find the average of a group of numbers by clicking the AutoSum button to use the Average function, or use the Average and the AverageIF functions in formula to find the average of a group of numbers.
๐ŸŒ
How To Excel
howtoexcel.org โ€บ calculate-mean
10 Ways to Find the Mean in Microsoft Excel | How To Excel
... Now, you can click on the numerical ... values in your dataset and you would like to include all of those when calculating the mean, you can use an array formula....
๐ŸŒ
Pba
answers.library.pba.edu โ€บ faq
How do I use Excel to find the Mean, Median & Mode of two columns of numbers? - Answers
This will give you the Mean of the two columns. To find the Median and the Mode, select a new blank cell and enter the formula as above, but change AVERAGE to MEDIAN. Repeat for the Mode, but change AVERAGE to MODE. http://smallbusiness.chron.com/use-excel-mean-median-mode-ranges-28868.html
๐ŸŒ
Microsoft Support
support.microsoft.com โ€บ en-us โ€บ office โ€บ calculate-an-average-c68b2803-c6d8-4faf-bea4-02b7c55fe768
Calculate an average - Microsoft Support
Select the box next to array1, and then on the sheet, select cells B2 through B7 (the values in the Price Per Unit column).
Find elsewhere
๐ŸŒ
Reddit
reddit.com โ€บ r/excel โ€บ how to find the mean of data with multiple variables?
r/excel on Reddit: How to find the mean of data with multiple variables?
April 24, 2024 -

SOLVED: I ended up just reformatting my entire dataset with pivot tables and going from there!

I need to find the mean # of calls that are both INCOMING/OUTGOING calls on WEEKDAYS/WEEKENDS (see the codebook below) and I can't figure out how to fiddle w/ =AVERAGEIF formulas atm TTv

I've included a screenshot of my excel data, the codebook, and the questions.

(MeanOutWD stands for Mean Outcoming Calls on Weekdays and so forth)

My Excel Data the questions asked the codebook
Top answer
1 of 3
1
u/cuttlefishgirl - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2 of 3
1
I don't think AVERAGEIF (or AVERAGEIFS) is where you want to start. That's a good guess because the questions ask for a mean, but each row is one phone call. AVERAGEIFS is for when there are different values in different rows and you want to calculate the average of those values. What you want here is COUNTIFS instead of AVERAGEIFS Mean number of calls on a weekday would look something like CountOfNumberOfCallsWhereDOWIsAWeekday / CountOfUniqueWeekdays E.g. you get multiple calls on 4/10 so if that's a weekday it will add to the numerator multiple times, but it's only a single day so it will only add to the denominator one time. I recommend first working it out by hand. If that's your whole data set, that's totally doable. (If your data set is much bigger, then work it out by hand for only the data in your screenshot - that example data can still set you down the right path.) But working it out by hand will establish what your actual calculation is, and once you have that you can think about what formula you will try to write.
๐ŸŒ
Microsoft Support
support.microsoft.com โ€บ en-us โ€บ office โ€บ averageif-function-faec8e2e-0dec-4308-af69-f5576d8ac642
AVERAGEIF function - Microsoft Support
This article describes the formula syntax and usage of the AVERAGEIF function in Microsoft Excel. Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
๐ŸŒ
Uconn
researchbasics.education.uconn.edu โ€บ home โ€บ calculating the mean and standard deviation with excel
Calculating the Mean and Standard Deviation with Excel | Educational Research Basics by Del Siegle
September 6, 2015 - Finding the Mean Enter the scores in one of the columns on the Excel spreadsheet (see the example below). After the data have been entered, place the cursor ...
๐ŸŒ
WPS Office
wps.com โ€บ home โ€บ blog โ€บ excel resources โ€บ how to calculate mean in excel (a step-by-step guide)
How to Calculate Mean in Excel (A Step-by-Step Guide)
August 29, 2023 - In Excel, the mean is calculated by adding up a group of numbers and then dividing the sum by the count of those numbers. It provides a single number that represents the center point or typical value within a dataset.
๐ŸŒ
GeeksforGeeks
geeksforgeeks.org โ€บ excel โ€บ how-to-calculate-mean-in-excel
How to Calculate Mean, Median and Mode in Excel - GeeksforGeeks
July 3, 2024 - This middle number divides the group into two halves, with half the numbers being smaller and half being bigger. In Microsoft Excel, you can find the median using the MEDIAN function. To illustrate, if you want to determine the median of all the sales amounts in our report, apply this formula: Follow the below steps to calculate Median in Excel:
๐ŸŒ
YouTube
youtube.com โ€บ watch
Calculate Mean Median Mode and Standard Deviation in Excel - YouTube
Learn how to calculate mean, median, mode, and standard deviation in Microsoft Excel. Watching this video will equip you to be able to generate this crucial ...
Published ย  December 13, 2021
๐ŸŒ
Excel Tip
exceltip.com โ€บ home โ€บ statistical formulas
How to Calculate Mean in Excel
February 29, 2020 - ... Here first SUM function adds all the non numeric value in the given range. Then ROWS returns the number of rows in the range. Eventually we divide the sum by number of rows to calculate the mean in excel.
Top answer
1 of 2
5

If one has Office 365 with the dynamic array formula use:

=MEDIAN(INDEX(A2:A6,MATCH(SEQUENCE(SUM(B2:B6),,0),SUMIF(OFFSET(B1,0,,ROW(B2:B6)-MIN(ROW(B2:B6))+1,),"<>"))))

and

=MODE.SNGL(INDEX(A2:A6,MATCH(SEQUENCE(SUM(B2:B6),,0),SUMIF(OFFSET(B1,0,,ROW(B2:B6)-MIN(ROW(B2:B6))+1,),"<>"))))


If not then this array formula:

=MEDIAN(INDEX(A2:A6,MATCH(ROW($ZZ1:INDEX($ZZ:$ZZ,SUM(B2:B6)))-1,SUMIF(OFFSET(B1,0,,ROW(B2:B6)-MIN(ROW(B2:B6))+1,),"<>"))))

and

=MODE.SNGL(INDEX(A2:A6,MATCH(ROW($ZZ1:INDEX($ZZ:$ZZ,SUM(B2:B6)))-1,SUMIF(OFFSET(B1,0,,ROW(B2:B6)-MIN(ROW(B2:B6))+1,),"<>"))))

Being array formula, then need to be confirmed with Ctrl-Shift-Enter instead of Enter when exiting edit mode.

2 of 2
2

Assuming that each Quantity only appears once alongside its Frequency, then you could use an INDEX MATCH on the MAX Frequency to find the Mode:

=INDEX(A2:A6,Match(Max(B2:B6), B2:B6, 0))

This will, of course, only return the first number should there be multiple Quantities which share the same maximum frequency (such as if Quantity 12 also occurred with Frequency 10)

Further assuming that your Quantities are in Ascending Order, you can use Matrix Multiplication (MMULT) to calculate the running total for each row, and use AGGREGATE to get the smallest row where the running total greater-than-or-equal-to half the overall total. This is the Median:

=AGGREGATE(15, 6, A2:A6/(MMULT(--(TRANSPOSE(ROW(B2:B6))<=ROW(B2:B6)), B2:B6)>=0.5*SUM(B2:B6)), 1)

(For reference, MMULT(--(TRANSPOSE(ROW(B2:B6))<=ROW(B2:B6)), B2:B6) is the bit which works out the Running total)

๐ŸŒ
The Bricks
thebricks.com โ€บ resources โ€บ how-to-do-mean-in-excel
How to Calculate the Mean in Excel
Here's how: Click on the cell where youโ€™d like the average to appear. Type =AVERAGEIF(range, "<>0"). For example, =AVERAGEIF(A1:A10, "<>0"). Press Enter. This function tells Excel to average only the cells that are not equal to zero.