Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Data Analysis Excel for Beginners: Statistical Data Analysis

Data Analysis with Excel 2013 for Beginners. Business Data Analysis. Statistical Data Analysis with Case Studies.

Created byKawser Ahmed

Last updated 2/2018

English

What you'll learn

Calculate Mean, Median, Mode, Minimum, Maximum, Quartiles, Variance and Standard Deviation from some numbers.
Get an idea about Central Limit Theorem.
Analyze a population using data samples.
Identify and minimize Margin of Errors
Group data, build XY charts, apply Logarithmic Scale and Trend Line on a chart, forecast from some data, and calculate running averages.
Formulate hypothesis, interpret your analysis, and get an idea of the limitations of building hypothesis.
Learn Normal Distribution, Exponential Distribution, Uniform Probabilities, Binomial Distribution, and Poisson Distribution.
Calculate Co-variance and Co-relation among data.
Perform Bayesian Analysis.

Course content

16 sections • 82 lectures • 6h 55m total length

Welcome to the Data World :)3:20
Welcome to the course. The instructor of this course is thankful to you that you have joined in this course.
Know which versions of Microsoft Excel has been used to create this course and get an idea which versions you can use to follow this course.
Have an idea how to use this course to get the best from it.
What you should know before joining this course0:24
Get an idea on what you should know before joining this course. You can call them the pre-requisites of this course.
Download Course Resources from Here0:13
Download the course resources from this lecture.
How to Get Support & Instantly Contact Me0:31
Get to know how to instantly contact me when you face an Excel, Statistics or course related problems.

0201 Operators Used in Formulas and How to Build Basic Formulas10:28
In this video lecture,

You will be introduced with the operators that are used by Excel.
You will also learn how to use different operators in Excel.
0202 Operator Precedence in Formulas9:31
The operators have a working hierarchy. All the operators in a formula do not work at the same time.
In this lecture,
You have learned all about Excel operator precedence.
0203 How Built in Excel Functions Make Your Job Easier7:17
In this video lecture,

You will learn how to insert a built-in function into a formula.
0204 Inserting Functions into Formulas Effectively9:40
Excel is nothing but a word processor if you deduct Excel's capability to use functions. Functions are the hearts of Excel. In this video, you will learn how to insert Excel functions into a formula.
You will also learn how to use effectively the Insert Function dialog box.
0205 Relative Cell References - Using Relative Cell References to Copy Formulas5:23
In this video lecture,

You will learn with examples how relative referencing works in Excel formula.
0206 Handling Circular References3:23
In this video lecture,

You will learn how to work with Circular Reference in Excel.
0207 Using Named Cells and Ranges in the Formulas7:48
In this video lecture,

You will learn how to give a name to a cell or a range.
0208 Using Names for Constants & Formulas & Applying Names to Existing Reference8:01
In this video lecture,

You will learn how to give a name:
To a constant
And to a formula.
0209 Union and Intersection of Ranges5:28
In this video lecture,

You will learn how to use Union (,) and Intersect ( ) operators in Excel.
0210 SUM(...) Function - The Most Useful Function in Excel7:51
In this video lecture,

You will learn about Excel’s one of the most important functions. The function is SUM function.
0211 Mathematical Functions: Average(), Max() and Min()6:54
In this video lecture,

You will learn Excel’s AVERAGE, MAX and MIN Functions.
0212 Mathematical Functions: INT(), MOD(), ROUND(), RAND(), and RANDBETWEEN()7:09
In this video lecture,

You will learn about 5 Excel important functions:
INT
MOD
ROUND
RAND
And RANDBETWEEN Functions.
0213 Count Functions in Excel3:17
In this video lecture,

You will learn about three count related Excel functions. They are:
COUNT Function
COUNTA Function
COUNTBLANK Function.
0214 Learn About 3-D Reference in Excel7:06
In this video lecture,

You will learn
How to make a 3D-Referencing,
How 3D-Referecning works in different ways
And how to define a name for a 3D-Reference.
0215 Introducing Array Formulas - How to Enter Arrays into Worksheet Cells7:35
In this video lecture:

You will be introduced to the basic concept of Excel array formula.
You will learn how to enter array formula into cells in different ways.
And you will learn how to edit array formula.
0216 Introducing Array Formulas - How to Create Array Formulas with Examples5:42
In this video lecture:

You will see in step by step by procedure how an array formula works internally in Excel.
To demonstrate the process, I have used Excel’s AVERAGE() and IF() functions.
0217 INDEX(...) Function in Excel8:11
In this video lecture,

We shall learn the syntax and use of the INDEX() function.
INDEX() function is the only function that has two types of syntax; you will work with both of them.
0218 VLOOKUP(...) Function in Excel4:32
VLOOKUP() is one of the top 10 Excel functions.

In this video lecture: you will learn VLOOKUP() function with multiple examples.

0301 What is a Table? How a Table Differs from a Normal Range6:42
Topics covered in this lecture

In this video tutorial, you will learn the basics of a table.
You will learn how to create a table.
You will learn the differences between a table and a range.
0302 Adding and Deleting Rows or Columns, and Working with the Total Row7:22
Topics covered in this lecture

In this video tutorial, you will learn how to Insert and Delete columns and rows in a table.
You will also learn how to add Total Row in a table and how to work with the Total Row.
0303 Removing Duplicate Rows from a Table or a Range6:12
In this video lecture, you will learn basically two topics:

How to highlight duplicate values from a table or a range.
And how to remove duplicate values from a table or a range.
0304 Sorting and Filtering a Table and Introducing Custom AutoFilter10:44
In this video tutorial, you will learn how to Sort a Single Column or Multiple Columns of a Table.
You will also Learn how to Filter a Column or Multiple Columns of a Table.
And finally you will be introduced with the Custom Auto-filter dialog box that you can use to Filter more options.
0305 Using Slicer to Filter a Table4:16
In this video tutorial, you will learn how you can Insert Slicer to Filter a Table.
You will learn how to Delete a Slicer.
You will also learn how you can Remove Filtering from a Slicer.
And you will be introduced with different Slicer Settings.
0306 Using Formulas in Tables - Summarizing and Referencing Data in a Table12:44
In this video lecture,

You will learn all the ways to use structured references with Excel tables.
0307 Use Structured References in Excel Tables8:31
In this video lecture,

You will learn how to use structured references in an Excel table.

0401 - Calculating Mean and Median Values7:10
To calculate centrality of a data set, you need to find out the Mean, Median and Mode values from a data set. This lecture will teach you how to calculate them using Excel functions.
0402 - Measuring Maximums, Minimums, and Other Data Characteristics6:01
Calculating maximum, minimum, and quartile values from a data set is easy using Excel. This lecture will teach you those topics.
0403 - Analyzing Data Using Variance and Standard Deviation10:35
Variance and Standard deviation are the two most important ways to figure out the dispersion of a data set. You will learn here not only how to calculate them, but also you will visualize them.
0404 - Introducing Central Limit Theorem3:30
In this lecture, you will get the concept of Central Limit Theorem with a real life example.
0405 - Analyzing a Population Using Data Samples8:34
This lecture is very important. You will get a brief and effective method for analyzing a population using data samples. Get the concepts of this lecture very well.
0406 - Identifying and Minimizing Sources of Error3:22
Statistics is not a pure science. When you will come up with a decision using the principles of statistics, you have to keep in mind that your analysis might be wrong in many ways. This lecture will teach you to identify and minimize the sources of error while you are working with statistical analysis.

0501 - Grouping Data Using Histograms5:20
Creating histogram from a data set is one of the main focus when you're working with data distributions. In this lecture, you will build histogram using Excel's Data Analysis ToolPak.
0502 - Identifying Relationships Using XY Scatter Charts2:36
XY Charts show the trend between two data sets. Creating XY charts are not tough. This lecture will teach you XY chart in details.
0503 - Visualizing Data Using Logarithmic Scales5:36
When you work with a data set having extreme large and small number and you make charts using that data set, reading that chart will be not so easy. Converting an Axis using Logarithmic Scale will make your chart readable and effective. This lecture will teach you how to do that.
0504 - Adding Trend Lines to Charts2:43
This lecture will teach you how to add trend lines to a chart. Even if you want to forecast values from existing values, you can do that using trend line. This is the topic of this lecture.
0505 - Forecasting Future Results7:09
Forecasting future results can be performed in two ways: using Excel's AutoFill Handle Tool and FORECAST() function. Both of these ways are discussed in this lecture.
0506 - Calculating Running Averages6:03
The calculating of running average is simple. This lecture will teach you how to calculate running average and 3-day running average.

0601 - Formulating a Hypothesis7:23
Formulating hypothesis based on a data is set is not tough, but you have to be very careful to do that. This lecture will teach you to do that.
0602 - Interpreting the Results of Your Analysis5:23
This lecture will teach you how to interpret the results of your hypothesis.
0603 - Considering the Limits of Hypothesis Testing3:08
In this video lecture, you will learn about the limits of testing a hypothesis.

0701 - Using the Normal Distribution7:57
Normal distribution or Bell Curve or Gaussian Curve is one of the most important topics in Statistics. This lecture will cover the topic in great details.
0702 - Using the Exponential Distribution7:22
In this lecture, you will learn how to calculate exponential distribution in Excel.
0704 - Using the Binomial Distribution6:56
This lecture will teach you how to calculate binomial distribution. You will also learn how to use it with a proper example.

0801 - Visualizing What Co-variance Means4:54
This lecture will teach you how to visualize Covariance with an example.
0802 - Calculating Co-variance between Two Columns of Data5:37
Learn how to calculate covariance between two columns of data pairs.
0803 - Calculating Co-variance among Multiple Pairs of Columns4:14
0804 - Visualizing What Correlation Means9:11
0805 - Calculating Correlation Between Two Columns of Data3:50
This lecture will teach you how to calculate correlation between two columns of data pairs.

1001 - Overview of the section0:44
1002 - How to Get Descriptive Statistics Using Excel's Data Analysis ToolPak2:56
1003 - What defines a typical value (or centrality) for a data set?6:16
1004 - How can I measure how much a data set spreads from its typical value?3:26
1005 - What do the mean and standard deviation of a data set tell me about?5:19
1006 - How can I use descriptive statistics to compare data sets?2:57
1007 - How to easily find the second largest or second smallest number in a data1:32
1008 - How can I rank numbers in a data set?7:44
1009 - What is the trimmed mean of a data set?3:28
1010 - Alternative of Data Analysis ToolPak1:53
1011 - Why financial analysts use Geometric mean instead of arithmetic average?4:39

Requirements

First, you must know how to gather and organize data efficiently. A business generates a lot of data and it is your duty to bring those data into Excel so you can perform your analysis with them.
Next, you should have a good grasp on creating and using Excel formulas. Most of the analysis in this course will involve Excel formulas. Specifically, you should be comfortable with creating relative, absolute and mixed formula referencing.
And finally, you should have a working knowledge of creating and modifying charts in Excel. Charts help to understand your data insight quickly.

Description

Teaching 11 Courses in Excel and Data Analysis!

OVER 100,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 134,141 successful students have already taken my online courses since November 2015 with 8,019 total Reviews!!!

**************************************************************************************

What students are saying about this course?

~ Very clear, concise explanation of basic and more advanced statistical Excel functions - Donna M Knapp

~ This is an excellent well taught course. The explanations are clear and concise. The course moves at a comfortable pace. I learned a lot from this course and shouldn't have any difficulty applying the concepts to future projects. Well done. - Bill Hengen

**************************************************************************************

Welcome to my brand new course on Data Analysis in Excel with Statistics: Get Meanings of Data.

I want to start with a quote from Daniel Egger. He is a professor at Duke University.

He says: “No commercial for-profit company that is in a competitive market can remain profitable or even survive over the next five years without incorporating best practices for business data analytics into their operations.”

So learning how to analyze data will be the most valuable expertise in your career in the next five years.

Excel will analyze and visualize data easily – this is why Excel is created and this is why Excel is the most popular spreadsheet program in the world.

Microsoft Company has added new data analysis features, functions, and tools in every new version of Excel.

Before going into the course: I want to warn you about something. Excel is just a tool. To analyze data you will use this tool. But analyzing data requires that you know some basic statistics and probability theories.

Most of the statistics and probability concepts that are necessary to analyze data effectively are covered in your undergraduate level courses. But in this course, at first, I have discussed the theory at first, then I have advanced to teach you how to use that theory in business with the help of Excel.

Let’s discuss now what I will cover in this course. It is tough to build a course on data analysis using Excel as so many topics are there to be covered. So I have used the guidelines of the Project Management Institute (PMI) to create this course.

The topics I am going to cover in this course are:

Overview of Data analysis: I will start with an overview of the data analysis. I will describe how you will calculate common measures of your data, I will introduce you to the central limit theory and then I will provide my advice for minimizing error in your calculations.
Visualizing Data: Then I will teach you how to visualize your data using histograms, how to identify relationships among data by creating XY Scatter charts and forecast future results based on Existing data.
Building Hypothesis: Then I will show you how to formulate a null and alternative hypothesis, how to interpret the results of your analysis, and how to use the normal, binomial, and Poisson distributions to model your data.
Relationships between data sets: Finally I will show you how to analyze relationships between data sets using co-variance, how to identify the strength of those relationships through correlation, and then I will introduce you to Bayesian analysis.
Case Study: Summarizing Data by Using Histograms
Case Study: Summarizing Data by Using Descriptive Statistics
Case Study: Estimating Straight-line Relationships
Case Study: Modeling Exponential Growth
Case Study: Using Correlations to Summarize Relationships
Case Study: Using Moving Averages to Understand Time Series

Analyzing Business data is a must need expertise for every employee of a company. Your company will not survive another five years if it does not take serious business data. And you could be the best employee in your company to direct the business in the smartest way. So keep learning business data analysis with this course.

Who this course is for:

Business professionals who regularly try to find out the insights from their data.
Statistics lovers like me who think people behavior can be measured with statistics.
Aspiring data analysts.
Want to add a new expertise in their CV
Not for someone who hates data and Excel :)

Data Analysis Excel for Beginners: Statistical Data Analysis

What you'll learn

Explore related topics

Course content

Welcome to the Course!4 lectures • 4min

[Essential Excel Knowledge 1] - Excel Formula Basics & Important Excel Functions18 lectures • 2hr 5min

[Essential Excel Knowledge 2] - Excel Tables & Using Structured References7 lectures • 57min

Foundational Concepts of Statistical Data Analysis6 lectures • 39min

Visualizing Data6 lectures • 29min

Testing a Hypothesis3 lectures • 16min

Utilizing Data Distributions3 lectures • 22min

Measuring Co-variance and Correlation5 lectures • 28min

Case Study: Summarizing Data by Using Histograms3 lectures • 8min

Case Study: Summarizing Data by Using Descriptive Statistics11 lectures • 41min

Requirements

Description

Who this course is for: