Outlier Detection in Excel Using Average and Standard Deviation
Вставка
- Опубліковано 14 жов 2024
- This video shows Dr. Evan Matthews explaining how to identify potential outliers (outlier data points) in a dataset within an Excel spreadsheet. This video is part of a playlist of videos showing how to set up a large research spreadsheet.
Skip directly to how to use the outlier detection formula:
1:20
Formula Used In Video:
Unfortunately, UA-cam does not allow greater than and less than signs in the description of videos. A comment has been pinned to the top of the comment section of this video containing the formula. Please go there for the formula. Sorry for the inconvenience.
Maximum Value in Excel
• Maximum Value in Excel
Minimum Value in Excel
• Minimum Value in Excel
Average in Excel - Arithmetic Mean
• Average in Excel - Ari...
Standard Deviation of a Data Set in Excel
• Standard Deviation of ...
T test p Value in Excel
• T test p Value in Excel
Link to Downloadable Dataset
digitalcommons...
Link to Published Study Using This Dataset
pubmed.ncbi.nl...
Master Research Spreadsheet Creation Playlist
• Master Research Spread...
Excel Skills Playlist That Goes Beyond The Skills for Setting Up a Master Spreadsheet
• Excel Microsoft Office
Link to Dr. Evan Matthews website.
sites.google.c...
Formula Used In Video:
=IF(AND([Max]>([Average]+3*[SD]),[Min]([Average]+3*[SD]),"yes high",IF([Min]
Awesome video, but you don't need to relink everything. Just do it once :)
Try this (only replace values in brackets with cell references):
=LET(max,[Max],min,[Min],mean,[Average],stdev,[SD],var,[3],bottom,mean-var*stdev,top,mean+var*stdev,IF(AND(max>top,mintop,"yes high",IF(min
can you make a video about how each of the formula work and when do we need to combine it?
If you look through my Excel videos, I have separate videos on most of these functions. It might help you.