发帖
雷达卡
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
本帖隐藏的内容
Data and Statistics (For Business and Economics).part1.rar
(90 MB, 需要: 5 个论坛币)
Data and Statistics (For Business and Economics).part2.rar
(90 MB, 需要: 5 个论坛币)
Data and Statistics (For Business and Economics).part3.rar
(90 MB, 需要: 5 个论坛币)
Data and Statistics (For Business and Economics).part4.rar
(90 MB, 需要: 5 个论坛币)
Data and Statistics (For Business and Economics).part5.rar
(49.43 MB, 需要: 5 个论坛币)
京公网安备 11010802022788号
