Understanding and using descriptive statistics in Microsoft Excel

This is a informative and detailed guiding document that give explanations and instructions for understanding and using descriptive statistics in Microsoft Excel. The file is divided into two parts - The first part explaining concepts and the second part giving instructions for how to use it in Excel. Note that this document only covers for:

• Quartiles
• Interquartile Range and Semi-Interquartile Range
• Outlier detection
• Standard deviation

A description for the median will also be explained. As this file is aimed to help those who are doing their Psychology IA there is also a section about how to plot a column chart showing median/mean values with S.D/SIQR as error bars.