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.