Excel Forum
Similar Content
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Select Ranges of Cells in Excel using Macros and VBA
Tutorial: This Excel VBA tutorial focuses specifically on selecting ranges of cells in Excel.  This ...
Quickly Find All Comments in a Spreadsheet in Excel
Tutorial: In Excel, you can create a comment for any cell in the worksheet. The problem is that th...



Excel & Statistics 49: Outliers & Box Plot with Median and Mean


See how to find Outliers with the +/- 3 Z-score rule and the ABS function. See how to do a Box Plot by hand and in Excel. For the Excel Box Plot see how to record MIN, QUARTILE 1, MEDAIN, QUARTILE 3, MAX, AVERAGE on a Stacked Bar Chart with the mean added as an X Y Scatter. Also see the CHAR 10 function to create label for BOX PLOT.

Chapter 03 Busn 210 Business and Economic Statistics and Excel Class. Descriptive Statistics Numerical Measures

This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel Excelisfun Girvin





Got a Question? Ask it Here in the Forum.