Free Certification Course Title: Statistics and data analysis with Excel
How to use Excel for statistics calculation and advanced data analysis
What you’ll learn:
-
Basic and advanced univariate statistics in Excel
-
Hypothesis tests (Student’s t-test, chi-square, F-test, Welch test), t-table and z-table
-
Confidence intervals for mean value and proportions
-
Correlation coefficient and linear regression forecast
-
Outlier identification
-
Database operations
-
Pivot tables
Requirements:
-
Basic knowledge of Excel
Who this course is for:
- Data analysts
- Marketing experts
- Data scientists
Description:
In this practical course, we are going to focus on how to perform advanced statistical calculations and data analysis using Microsoft Excel.
Excel is a very used tool in several companies and has very powerful data analysis capabilities that can be used by data analysts and marketing experts. Even if you work with a lot of statistics you’d be surprised at how valuable Excel is for calculating hypothesis tests and the most common metrics you can calculate on a dataset. There are several basic and advanced functions you can use to get the best from your data and that’s why Excel is a very useful tool for anybody who needs to crunch data and perform analyses of various kinds.
This course can be attended by both data analysts and marketing experts who need to work with data and surveys.
With this course, you are going to learn:
- Univariate descriptive analysis (mean, standard deviation, skewness, quantiles, percentiles, IQR)
- Advanced univariate analysis (outlier detection, rolling measures)
- Confidence intervals
- Linear correlation and regression forecasting
- Hypothesis tests (Student’s t-test, chi-square test, F-test, Welch test)
- t tables and z tables
- Database operations and conditional operations
- Vertical lookup
- Pivot tables
This course includes:
-
2.5 hours on-demand video
-
28 downloadable resources
-
Full lifetime access
-
Access on mobile and TV
-
Certificate of completion
How to Subscribe for Statistics and data analysis with Excel?
- Sign Up on Udemy.com
- Subscribe Here(Statistics and data analysis with Excel): Click Here
Apply Coupon Code: D08E132CEA739E8EBB98
Facebook Group(Mandatory to Join): Click Here
Join our Telegram group(Free Certification Courses – 43K Members): Click Here
Join our Telegram group(67,000+ Members: Daily Jobs): Click Here
WhatsApp Group(Only for Indian Users): Click Here to Join