Data Analysis Excel for Beginners: Statistical Data Analysis
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.
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 :)
Instructor
- 4.4 Instructor Rating
- 6,374 Reviews
- 168,878 Students
- 8 Courses
Love to see you here.
I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.
I love to make courses in the combination of both theory and practice.
Monthly 2.5 million Excel users visit our Excel blog ExcelDemy (follow the website link in the profile).
I love to learn and teach (teaching from my eighteen)!
Visit my blog.
You will find plenty of useful posts, articles, video tutorials, and important Excel resources.
What I love most is: add some value to people around me, believe me.
Here are some of my working areas:
1. Corporate Budgeting, Planning & Forecasting
2. Mission-critical financial processes
3. Month-end close processes
4. Big Data Analysis using Excel
5. Company Reports (Sales, Marketing, Administrative)
6. Large Projects using Excel VBA
7. Dashboard Design using Excel
8. And Basic Accounting
I am always around you to help and support.
Just contact me.