Doing Basic Statistical Analysis Using MS Excel

A Step-by- Step Approach
3.3 (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.
1,033 students enrolled
Free
Start Learning Now
  • Lectures 32
  • Length 4 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 12/2015 English

Course Description

Course Description

Descriptive statistics using MS Excel course offers clear cut knowledge of descriptive statistics tools using MS Excel.

Today, as a reseracher or a manager you must know how to convert data into information that may aid in the decision making process.

This course put interpretation and decision making with the help of data at the forefront.

The prime objective of this course is to demonstrate how to use MS Excel 2007 for statistical anlaysis using step by step method.

The following methods of analysis are included:

  • Graphing Techniques
  • Frequency Analysis
  • Numerical Techniques
  • Mean, Median, Mode Analysis
  • Range, Standard Deviation, Variance Analysis
  • Skewness and Kurtosis Analysis
  • Complete Descriptive Analysis with example

This course will be useful for all business professionals, marketing managers, financial analysts, economists, and students doing foundation courses in statistics, perhaps students in their second course or social or business researchers.



What are the requirements?

  • Knowledge of MS Excel is desirable.

What am I going to get from this course?

  • Learn meaning of descriptive statistics
  • Know summarizing data by graphical methods
  • Learn summarizing data by numerical methods

What is the target audience?

  • This descriptive statistics course is meant for those who enrolled in introductory statistics courses.
  • For thos who are familiar with statistics but don't know how to use MS excel for statistical analysis.

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: Overview of Data and Statistics
Introduction
03:08
Meaning of Statistics
15:26
Characteristics of Statistics
12:16
Nature and Scope of Statistics
10:01
Applications in Business and Economics
11:36
Data and Nominal and Ordinal Scale
08:47
Interval and Ratio Scale
06:37
Types of Data
10:07
Types of Statistics
03:39
Limitations of Statistics
06:06
Role of Computer in Statistical Analysis
01:30
Review Excercise
Article
Section 2: Descriptive Analytics: Summarizing Data by Graphical Methods
Introduction
02:14
Introduction to Summarizing data by Graphical Methods
05:16
Line Graph
05:49
Simple Bar Graph and Multiple Bar Graph
11:28
Simple Bargraph Excel Demonstration
04:54
Multiple Bar graph Excel Demonstration
05:15
Subdivided Bar Graph and Percentage Bar Graph
17:01
Subdivided Bar Graph Excel Demonstration
04:06
Percentage Bar Graph Excel Demonstration
04:46
Pie Chart
08:15
Pie Chart Excel Demonstration
08:24
Scatter Diagram
06:26
Frequency Distribution
10:07
Section 3: Descriptive Analytics: Summarizing Data by Numerical Methods
Introduction to Summarizing data by numerical methods
01:06
Measures of Central Tendency
09:44
Measures of Dispersion
18:28
Measures of Shape
08:55
Numerical Summary Excel Demonstration
05:09
Descriptive Statistics using data analysis
11:48
Review Excercise
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dr. Ash Narayan Sah, Data Scientist

I am Ash Narayan Sah working as assistant professor in the area of Economics and Econometrics in Thapar University, Patiala. I am a doctorate in Economics. I started doing my specilization in the economics area after my 12th. I completed my graduation in economics with honours from Utkal University in 1997. I did my master in economics from Hyderabad Central University, Andhra Pradesh in 2000. I also did my M.Phil in Economics and after M.Phil, I enrolled for my PhD in Financial Economics in Hyderabad Central University. After completion of my PhD, I joined as an assistant professor in University of Petroleum and Energy Studies, Dehradun in January 2007. I worked for 5 years in University of Petroleum and Energy Studies and taught basic econometrics course and mangerial economics to MBA students. During my stay at University of petroleum and Energy Studies, I realized the need of data analysis book using MS Excel for students of business studies. And then I decided to author my first book titled 'data Analysis using MS Excel', which published in 2009. after that I published another book titled ' Statistics for Management using MS Excel', which got published in 2013. I am having eight years teaching experience. In addition, I have also published few research papers. My expertise also extends in doing econometric and statistical analysis using several softwares like SPSS, Eviews, and MS Excel.

Ready to start learning?
Start Learning Now