Outlier Detection in Excel Using Average and Standard Deviation

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, YouTube 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 https://youtu.be/WQDbPsHyW_o Minimum Value in Excel https://youtu.be/b6qDq3GdpW4 Average in Excel - Arithmetic Mean https://youtu.be/YbdZ-waMRNA Standard Deviation of a Data Set in Excel https://youtu.be/jFQP08CCcj8 T test p Value in Excel https://youtu.be/20Zb8aKDUyk Link to Downloadable Dataset https://digitalcommons.montclair.edu/data/8/ Link to Published Study Using This Dataset https://pubmed.ncbi.nlm.nih.gov/33417732/ Master Research Spreadsheet Creation Playlist https://youtube.com/playlist?list=PLf85BhZ0yM_sItPJ_UZWEc65prIy0ibFJ Excel Skills Playlist That Goes Beyond The Skills for Setting Up a Master Spreadsheet https://www.youtube.com/playlist?list=PLf85BhZ0yM_siy9l4nDMG1kOveyTcWYBs Link to Dr. Evan Matthews website. https://sites.google.com/site/evanmatthewseportfolio/home