Data and Statistics (For Business and Economics)
4.3 (16 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.
817 students enrolled
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.3 (16 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.
817 students enrolled
Created by Shubham Kalra
Last updated 8/2016
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 4 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • Basic knowledge of Excel (Preferred, not necessary)
Description

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
38 Lectures
02:59:01
+
Introduction
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
02:34


How to construct Frequency Distribution using MS Excel
06:11


How to construct Bar Graph for Qualitative Data using MS Excel
03:41

Pie Charts
07:45
+
Summarizing Quantitative Data using tabular and graphical methods
13 Lectures 01:26:28
Discrete Frequency Distribution
05:39

Basic Principles for forming a Grouped Frequency Distribution
08:44

Ungrouped Frequency Distribution for Discrete Data using MS Excel
06:28

Grouped Frequency Distribution for Discrete Data using MS Excel
09:15

Relative Frequency and Percent Frequency Distributions
00:28

Continuous Frequency Distribution
04:11

Simple Bar Graph and Multiple Bar Graph using MS Excel
08:12

Histogram Explained
04:58

Histogram - Case when you have inclusive classes
04:31

Grouped Frequency Distribution for Continuous Data and Histogram using MS Excel
13:15

Cumulative Frequency and Cumulative Percent Frequency Distributions
09:28

Pie charts - How good are they?
07:55

Get your audience's attention : Make the most of graphs and charts
03:24
+
Applications
2 Lectures 06:43
Application - 1
06:20

Application - 2 (Unsolved)
00:23
+
Measures of Central Tendency
13 Lectures 51:43
Introduction to Central Tendency
01:06

Sample and Population
00:19

Mean
04:25

Why is 'Mean' so popular as a measure
02:17

How to calculate mean : Ungrouped Frequency Distribution Case
03:28

How to calculate mean : Grouped Data Case
06:39

Weighted mean
05:00

Mean and Weighted Mean using MS Excel
07:35

Median
04:58

Mode
03:10

Mean, Median, Mode - Which is best?
07:00

Median and Mode using MS Excel
04:55

Bonus Lecture
00:51
About the Instructor
Shubham Kalra
4.4 Average rating
182 Reviews
7,917 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.