How to Perform a Q Test to Find Outliers in Excel 2016
FBTwitterReddit
video description
Rating: 4.0; Vote: 1
were going to show you how to perform a Q test to find outliers in Excel 2016.
Don't forget to check out our main channel for more free how-to videos!
Join us on Facebook
Our App
The measurements or values must first be in ascending order according to which possible outlier to test.
To calculate gap, use the formula given in the screenshot.
Calculating the range of the data is fairly simple as shown.
Calculating Q is even simpler. Just divide the gap by the range.
You will need a confidence interval and critical value, this table can be looked up online.
Finally, I created a quick IF statement to check to see whether or not the value is an outlier or not. If the Q is less than the critical value, it is not an outlier. If it is greater than, it is an outlier
Jonathan: You really need to change the title of this video. Its very misleading and does not show people how to perform a Q-Test. Awful job. Date: 2023-07-08
