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.6 (13 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.
785 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 38
  • Length 3 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2016 English

Course 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..! 

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction to the course and the instructor
Preview
01:13
Section 2: Data - Types and Collection
Data and Information
01:00
Types of data - Qualitative and Quantitative
Preview
03:04
How to collect data?
Preview
03:32
Section 3: How to make sense of Qualitative Data?
Frequency Distribution
02:34
Relative Frequency and Percent Frequency Distributions
Preview
01:35
How to construct Frequency Distribution using MS Excel
06:11
Using Bar Graphs to present the data
Preview
03:43
How to construct Bar Graph for Qualitative Data using MS Excel
03:41
Pie Charts
07:45
Section 4: Summarizing Quantitative Data using tabular and graphical methods
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
Continuous Frequency Distribution
04:11
Relative Frequency and Percent Frequency Distributions
Article
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
Section 5: Applications
Application - 1
06:20
Application - 2 (Unsolved)
Article
Section 6: Measures of Central Tendency
Introduction to Central Tendency
01:06
Sample and Population
Article
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
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Shubham Kalra, Founder at Eduspred.com , M.A.Economics , Business Analyst

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.





Ready to start learning?
Take This Course