If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 19th installment in his "Excel Statistics" series of free video lessons, you'll learn how to group categories in a frequency distribution with a formula (2 COUNTIF) and the pivot table (PivotTable) grouping feature.
- Hot
- Latest
-
How To:
Find a P-Value with Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Calculate Commission Based on Varying Rates in Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Do matrix multiplication and inverse in MS Excel
-
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
-
How To:
Align & group objects & use gridlines in MS Word 2007
-
How To:
Create a pass-fail grade formula in Microsoft Excel
-
How To:
Use conditional formatting for a student grading report in Microsoft Excel
-
How To:
Create an Excel spreadsheet to calculate your GPA
-
How To:
Create an Excel inventory template with running totals
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Create a simple database in Excel with a list or table
-
How To:
Create a stem & leaf chart with Excel's REPT & COUNTIF
-
How To:
Create a multiuser login system in Microsoft Access
-
How To:
Graph the probability density function in an Excel file
-
How To:
Calculate APR, EAR & period rates in Microsoft Excel 2010
-
How To:
Calculate monthly retirement income in Microsoft Excel
-
How To:
Measure the spread of a data set with Excel's AVEDEV
-
How To:
Summarize survey results with a pivot table in Excel
-
How To:
Find a P-Value with Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Calculate Commission Based on Varying Rates in Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Do matrix multiplication and inverse in MS Excel
-
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
-
How To:
Align & group objects & use gridlines in MS Word 2007
-
How To:
Create a pass-fail grade formula in Microsoft Excel
-
How To:
Use conditional formatting for a student grading report in Microsoft Excel
-
How To:
Create an Excel spreadsheet to calculate your GPA
-
How To:
Create an Excel inventory template with running totals
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Create a simple database in Excel with a list or table
-
How To:
Create a stem & leaf chart with Excel's REPT & COUNTIF
-
How To:
Create a multiuser login system in Microsoft Access
-
How To:
Graph the probability density function in an Excel file
-
How To:
Calculate APR, EAR & period rates in Microsoft Excel 2010
-
How To:
Calculate monthly retirement income in Microsoft Excel
-
How To:
Measure the spread of a data set with Excel's AVEDEV
-
How To:
Summarize survey results with a pivot table in Excel
Be the First to Comment
Share Your Thoughts