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:
Create a Basic Attendance Sheet in Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Create a relative frequency distribution in MS Excel
-
How To:
Find range and interquartile range in Microsoft Excel
-
How To:
Extract records that meet certain criteria in Excel
-
How To:
Create an Excel inventory template with running totals
-
How To:
Calculate proportions and percentages in Excel
-
How To:
Change Excel options directly in the Registry
-
How To:
Conditionally format at every change in value in Excel
-
How To:
Create dynamic sub tables in Microsoft Excel
-
How To:
Calculate hours worked while subtracting lunch hours in Excel 2010
-
How To:
Clear data & cell contents in Excel using a macro
-
How To:
Build a 15-minute schedule in Microsoft Excel
-
How To:
Format numbers to display exponents in Microsoft Excel
-
How To:
Grade test responses with formulas in Microsoft Excel
-
How To:
Create custom charts with Microsoft Publisher
-
How To:
Remove tabs & scroll bars from an Excel spreadsheet
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Cross tabulate categorical data in Microsoft Excel
-
How To:
Find a P-Value with Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Create a relative frequency distribution in MS Excel
-
How To:
Find range and interquartile range in Microsoft Excel
-
How To:
Extract records that meet certain criteria in Excel
-
How To:
Create an Excel inventory template with running totals
-
How To:
Calculate proportions and percentages in Excel
-
How To:
Change Excel options directly in the Registry
-
How To:
Conditionally format at every change in value in Excel
-
How To:
Create dynamic sub tables in Microsoft Excel
-
How To:
Calculate hours worked while subtracting lunch hours in Excel 2010
-
How To:
Clear data & cell contents in Excel using a macro
-
How To:
Build a 15-minute schedule in Microsoft Excel
-
How To:
Format numbers to display exponents in Microsoft Excel
-
How To:
Grade test responses with formulas in Microsoft Excel
-
How To:
Create custom charts with Microsoft Publisher
-
How To:
Remove tabs & scroll bars from an Excel spreadsheet
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Cross tabulate categorical data in Microsoft Excel
Be the First to Comment
Share Your Thoughts