Data and Statistics (For Business and Economics)
Understand the types of data and how to summarize and present it using MS Excel
Data and Information
Types of Data - Qualitative and Quantitative
How to collect data
Frequency distribution
Relative Frequency and Percent Frequency Distributions
How to construct Frequency Distribution using MS Excel
Using Bar Graphs to present the data
How to construct Bar Graph for Qualitative Data using MS Excel
Pie Charts
Discrete Frequency Distribution
Basic Principles for forming a Grouped Frequency Distribution
Rule of thumb for calculating proper number of classes
Equal Sized Class Intervals - Not necessary
Ungrouped Frequency Distribution for Discrete Data using MS Excel
Grouped Frequency Distribution for Discrete Data using MS Excel
Continuous Frequency Distribution
Relative frequency and Percent Frequency Distributions
Simple Bar Graph and Multiple Bar Graph using MS Excel
Histogram Explained
Histogram - Case when you have inclusive classes
Grouped Frequency Distribution for Continuous Data and Histogram using MS Excel
Cumulative Frequency and Cumulative Percent Frequency Distributions
Pie charts - How good are they?
Get your audience's attention : Make the most of graphs and charts
Application - 1
Application-2 (Unsolved)
Introduction to central tendency
Sample and Population
Mean
Why is 'Mean' so popular as a measure
How to calculate mean - Ungrouped Frequency Distribution Case
How to calculate mean - Grouped Data Case
Weighted Mean
Mean and Weighted Mean using MS Excel
Median
Mode
Mean, Median, Mode - Which is Best
Median and Mode using Excel