Measures of Central Tendency & Excel Percentiles

Statistics- Central Tendency

Note- The following videos talk about a software called SPSS. Please ignore that part.

Measures of Central Tendency

A measurement that indicates where the middle of the data/information lies. The most common measures of central tendency are the mean, the median, and the mode.

Percentiles, Quartiles etc

Box Plots

Just like a histograms, a box plot is another way of representing data graphically.

Excel- Calculating Quartiles

Percentiles in Excel

SQL- Operators

Relational Algebra- Set operators, rename & notation

Excel is a powerful tool which makes data analysis both convenient and fun. Almost all organizations today depend heavily on Excel for their day to day operations and decision making.

Data in Action

Practice Exercises