Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Data and Statistics (For Business and Economics) to your Wishlist.

Add to Wishlist

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)
4.7 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
806 students enrolled
Created by Shubham Kalra
Last updated 8/2016
$10 $50 80% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 4 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
  • Basic knowledge of Excel (Preferred, not necessary)

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..! 
Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 38 Lectures Collapse All 38 Lectures 02:59:01
1 Lecture 01:13
Data - Types and Collection
3 Lectures 07:36
How to make sense of Qualitative Data?
6 Lectures 25:29
Frequency Distribution

How to construct Frequency Distribution using MS Excel

How to construct Bar Graph for Qualitative Data using MS Excel

Pie Charts
Summarizing Quantitative Data using tabular and graphical methods
13 Lectures 01:26:28
Discrete Frequency Distribution

Basic Principles for forming a Grouped Frequency Distribution

Ungrouped Frequency Distribution for Discrete Data using MS Excel

Grouped Frequency Distribution for Discrete Data using MS Excel

Relative Frequency and Percent Frequency Distributions

Continuous Frequency Distribution

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
2 Lectures 06:43
Application - 1

Application - 2 (Unsolved)
Measures of Central Tendency
13 Lectures 51:43
Introduction to Central Tendency

Sample and Population


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



Mean, Median, Mode - Which is best?

Median and Mode using MS Excel

Bonus Lecture
About the Instructor
4.5 Average rating
139 Reviews
6,982 Students
7 Courses
Business Analyst,M.A. Economics ,Certified Financial Planner

M.A. Economics, Business Analyst, Certified Financial Planner (CFP)

Shubham Kalra has a Masters in Economics from Delhi School of Economics and has worked as a Business Analyst in one of the largest banking and financial services organizations in the world.

He has done research projects in Education and Infrastructure Sector in India involving field work and analysis of data. He holds a diploma in Financial Planning and has good understanding of Risk Management concepts and Financial Instruments as well.

He loves teaching and has been teaching since his college days in  one way or another. It was in 2015, when he started teaching full time and is now teaching Economics and Statistics to many students online.His areas of specialization include Economics, Statistics, Finance and Game theory.

Report Abuse