Descriptive Statistics in Excel
Descriptive Statistics in Excel
How to Calculate Conditional Mean in Excel (With Examples)
You can use the AVERAGEIF function in Excel to calculate a conditional mean.
This function uses the following basic syntax:
=AVERAGEIF(A2:A7, "some value", B2:B7)
This particular formula...
Descriptive Statistics in Excel
How to Add & Subtract Hours from Time in Excel
You can use the following basic formulas to add and subtract hours from a time in Excel:
Formula 1: Add Hours to Time
=A1+(3/24)
This particular...
Descriptive Statistics in Excel
How to Calculate Average Percentage in Excel (With Examples)
Often you may want to calculate an average percentage of some dataset. Fortunately this is easy to do using built-in functions in Excel.
This tutorial...
Descriptive Statistics in Excel
Excel: How to Calculate Average If Cell Contains Number
You can use the following formula to calculate the average in Excel only for the cells that contain a number in a corresponding range:
=SUMPRODUCT(--ISNUMBER(A2:A11),...
Descriptive Statistics in Excel
Excel: How to Use MAX IF with Multiple Criteria
You can use the following basic syntax to use MAX IF with multiple criteria in Excel:
=MAX(IF(A2:A11="Mavs", IF(B2:B11="Forward", C2:C11)))
This particular formula finds the max value...
Descriptive Statistics in Excel
How to Calculate Average by Month in Excel
Often you may want to calculate the average value grouped by month in Excel.
For example, suppose we have the following dataset and we’d like...
Descriptive Statistics in Excel
How to Add & Subtract Weeks to Date in Excel
You can use the following basic formulas to add and subtract weeks from a date in Excel:
Formula 1: Add Weeks to Date
=A1+7*(3)
This particular...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read