what is data and statistical analysis in excel

This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category 'Other. The cookies is used to store the user consent for the cookies in the category 'Necessary'. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category 'Functional'. The cookie is used to store the user consent for the cookies in the category 'Analytics'.

Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the 'Advertisement' category.

These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly. All the Excel spreadsheets are attached to each lesson and can be downloaded.

Database operations and conditional operationsĪll the video lessons of this course start with a brief introduction and end with a practical example in Excel.

Hypothesis tests (Student’s t-test, chi-square test, F-test, Welch test).

Linear correlation and regression forecasting.

Advanced univariate analysis ( outlier detection, rolling measures).

Univariate descriptive analysis (mean, standard deviation, skewness, quantiles, percentiles, IQR).

With this course, you are going to learn: This course can be attended by both data analysts and marketing experts who need to work with data and surveys. 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. 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. 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.

What is data and statistical analysis in excel