Basic Statistical Functions: Variance, z-Score, Correlation, Excel For Statistics Analysis

In this Excel Statistics training course, we will explore statistical concepts using excel as a tool. In this tutorial, learn about average, variance, standard deviation, correlation and standard score aka z score using Excel 2016.
These four basic concepts variance, average , standard deviation and standard score are shown using excel.

▶️Part 1: Sum, Sum of Squares, Sum of Products Learn Basic Statistics https://youtu.be/7E69WEeplBo

▶️ Excel Graphs and Data Analysis ToolPak https://youtu.be/IgWPj4GJtF8

▶️ Types of Data - Nominal Data - Ordinal Data - Interval Data - Ratio Data https://youtu.be/Z1kyUysyIYU

▶️ Calculating Probability - Compound Events - Trial - Sample Space https://youtu.be/ERWjEqM0dFc

▶️ Conditional Probability - Bayesian Probability - Counting Rules Excel https://youtu.be/jE6AC-uuFLw

▶️ Central Tendency - Mean - Median - Mode Using Excel In Statistics https://youtu.be/RXsQtt7qncw

▶️ Variance - Standard Deviation Using Excel - Properties of Variance https://youtu.be/8nZ15bVFUsc

▶️ Frequency Distribution - Cumulative Frequency Distribution - Graph Frequency Polygons https://youtu.be/09TcuwAdebQ

▶️ Probability Distribution - Distribution Properties, Discrete Probability Distribution https://youtu.be/9L1TiYtZB-8

▶️ Normal Distribution, Standard Normal Distribution - Probability Density https://youtu.be/WaBWPYF9qmw

▶️ Sampling Distribution of statistics - Central Limit Theorem - t Distribution https://youtu.be/qioZ-kRDb2M

▶️ Confidence In Estimation - Calculating Confidence Intervals & Limits https://youtu.be/aPshZi1agkY

▶️ Logic Of Hypothesis Testing - Type I Error , Type II Errors In Statistics - Inferential Statistics https://youtu.be/2k8XenvaEVM

▶️ Central Limit Theorem - z Test - t Test - Statistics - Conditions for Central Limit Theorem https://youtu.be/Czkf2slbhNc

▶️ Chi-square Distribution Introduction | Hypothesis Testing about Standard Deviations & Variances https://youtu.be/d5kAK5nCHGk

▶️ Sampling Distribution for Two Independent Samples - Difference of Sample Means Distribution https://youtu.be/0g9WqKFkE5A

▶️ Z-statistics Vs. T-statistics for Two Means | Z- Test vs T- Test statistics https://youtu.be/t1tTY2hs9mI

▶️ Two Populations | Matched Samples t- Test, Sampling Distribution for Matched Samples https://youtu.be/XbF8gzeILsk

▶️ F- Test for Two Variances | Hypothesis Testing and F Distribution | F- Statistics https://youtu.be/owjUtkuZkDo

▶️ Understand Analysis of Variance (ANOVA), F- Test (F- Ratio), Inferential Statistics https://youtu.be/m2taXNpI2co

▶️ Types of Post ANOVA Testings, Analysis of Variance planned Comparisons || t- Tests https://youtu.be/ZD7fjoL-BpQ

▶️ Repeated Measures ANOVA, Analysis of Variance, F- Ratio https://youtu.be/mhyAJbcf1k0

▶️ Two Way ANOVA (Factorial) with Replication, Hypothesis Testing with Two Factors https://youtu.be/k-MeZSnQAzI

▶️ Regression Analysis and Regression Line https://youtu.be/mV_k3OKp4NY

▶️ ANOVA for Regression Analysis | Multiple Regression Analysis https://youtu.be/UHmf93BKihI

▶️ Correlation & Regression Analysis, Hypothesis Testing Correlation Coefficient https://youtu.be/lrms61KSFYo


#statistics
#excel
#statisticsusingexcel
#statisticstutorial
#variance
#zscore
#correlation
#excel2019

-~-~~-~~~-~~-~-
Please watch: "How to Calculate Age from Date of Birth in Excel in Years Months and Days (Simple Formula)"
https://www.youtube.com/watch?v=Jy-EO724its
-~-~~-~~~-~~-~-