Hello, I'm looking to calculate the Interquartile Range (IQR) for responses using a 7pt likert scale (sample size = 26). For some questions, Im noticing a difference in the Median and IQR when I calculate using Excel, compared to when calculated in SPSS. Any explanations??? I think SPSS may be using a 95% CI and removing the outliers. Is this possible?
Note: I checked a few sources and can confirm I calculated it correctly in Excel
o https://spreadsheetplanet.com/find-outliers-excel/
o https://www.statisticshowto.com/probability-and-statistics/interquartile-range/#IQRExcel
People will be better able to help if you upload a file that illustrates the discrepancy. In addition to an Excel file, you'll have to share the command syntax for the method you used in SPSS. HTH.
PS- If you are using the EXAMINE command in SPSS, see if this old thread is relevant.
- https://www.researchgate.net/post/Why-do-descriptive-statistics-answers-differ-in-spss-using-the-explore-menu
The IQR is based on quartiles (a type of quantile). There are different ways to estimate these and arguments exists for each of these in different circumstances. Different packages (not just Excel and SPSS) use different ways. An oft cited and imo good paper on this is:
Hyndman, R. J. and Fan, Y. (1996) Sample quantiles in statistical packages, American Statistician 50, 361--365. 10.2307/2684934.
- Badges
- Science topic
- Similar topics
- Linguistics
- Composition Studies
- Publication