#### Statistics- Introduction

###### Introduction to Types of Data

In order to do data analysis you need data obviously and its important to have a basic understanding of different forms in which data is available. The following videos along with this reading will give you an overview of different types of data.

#### Excel- Types of Referencing

###### Cell Referencing

If a cell refers to another cell, then the reference called 'cell reference'. For example, if in cell D2 you have '=C10' then D2 refers to C10. There are three types of cell references.

Absolute – This means the cell reference stays the same if it is copied or moved to any other cell. To fix the reference we use the '$' symbol. Example '$A$10' fixes both column A and row 10. But 'A$10' fixes only row 10, NOT column A.

Relative – If the cell address changes as you copy or move it, then we use the term relative referencing.

Mixed – This is a combination of both of the above. If we keep the row fixed and column relative in the cell or vice versa, then its called mixed referencing.

###### VLOOKUP function

This is one of Excel's most useful functions and your employer will ask you to use it over and over again- so lets dive right in!

#### SQL- Functions

###### SQL Aliases

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.

###### SQL Functions

Like Excel, even SQL has many inbuilt functions which makes your life easier.