Data and Statistics (For Business and Economics)
Learn how to make sense of data using graphical presentations and numerical measures (Working in MS Excel included)

Instructed by Shubham Kalra



This course is designed for students and businesses who want to learn how to summarize data and communicate the results effectively.

In this course, I will take you through the tabular and graphical methods that one can use to turn data into information using Microsoft Excel.

There are no prerequisites required to take this course as I will start all the concepts from scratch.

How is this course structured?

• First, I will take you through some basics of data - collection techniques and types. Then, I will discuss the tabular and graphical methods available to summarize the data (along with their working in excel) depending on what type of data we have.
• After covering these methods, I will tell you some tips that you should use while deciding which chart type to choose for summarizing your data. (Not every chart or graph is suitable for all kinds of data)
• Finally, we will end the course with some tips on how to get your audience's attention, how to make your data speak and some applications to solidify your learning.

Why should you take this course?

Because, its better to spend a couple of hours learning how to summarize and present your data than spending days to try and make sense of the data without knowing these methods.  

All that said, lets get started..!
What are the requirements?
• Basic knowledge of Excel (Preferred, not necessary)
What am I going to get from this course?
• Understand the graphical and tabular methods available to summarize data
• Use MS Excel to summarize data
• Present your data in a manner so that your audience see what YOU want them to see
• Graph the data to visually communicate the results
What is the target audience?
• Businesses who want to understand how to make sense of data and present it effectively
• Economics and Statistics Students
• Anyone else who wants to learn how to turn data into information

Curriculum

Section 1: Introduction
Lecture 1   Introduction to the course and the instructor

Section 2: Data - Types and Collection
Lecture 2   Data and Information
Lecture 3   Types of data - Qualitative and Quantitative
Lecture 4   How to collect data?

Section 3: How to make sense of Qualitative Data?
Lecture 5   Frequency Distribution
Lecture 6   Relative Frequency and Percent Frequency Distributions
Lecture 7   How to construct Frequency Distribution using MS Excel
Lecture 8   Using Bar Graphs to present the data
Lecture 9   How to construct Bar Graph for Qualitative Data using MS Excel
Lecture 10   Pie Charts

Section 4: Summarizing Quantitative Data using tabular and graphical methods
Lecture 11   Discrete Frequency Distribution
Lecture 12   Basic Principles for forming a Grouped Frequency Distribution
Lecture 13   Ungrouped Frequency Distribution for Discrete Data using MS Excel
Lecture 14   Grouped Frequency Distribution for Discrete Data using MS Excel
Lecture 15   Continuous Frequency Distribution
Lecture 16   Relative Frequency and Percent Frequency Distributions
Lecture 17   Simple Bar Graph and Multiple Bar Graph using MS Excel
Lecture 18   Histogram Explained
Lecture 19   Histogram - Case when you have inclusive classes
Lecture 20   Grouped Frequency Distribution for Continuous Data and Histogram using MS Excel
Lecture 21   Cumulative Frequency and Cumulative Percent Frequency Distributions
Lecture 22   Pie charts - How good are they?
Lecture 23   Get your audience's attention : Make the most of graphs and charts

Section 5: Applications
Lecture 24   Application - 1
Lecture 25   Application - 2 (Unsolved)

Section 6: Measures of Central Tendency
Lecture 26   Introduction to Central Tendency
Lecture 27   Sample and Population
Lecture 28   Mean
Lecture 29   Why is 'Mean' so popular as a measure
Lecture 30   How to calculate mean : Ungrouped Frequency Distribution Case
Lecture 31   How to calculate mean : Grouped Data Case
Lecture 32   Weighted mean
Lecture 33   Mean and Weighted Mean using MS Excel
Lecture 34   Median
Lecture 35   Mode
Lecture 36   Mean, Median, Mode - Which is best?
Lecture 37   Median and Mode using MS Excel