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