Normality Test Using Excel: Kolmogorov-Smirnov Test & Skewness and Kurtosis in Excel & SPSS

Normality Test Using Excel: Kolmogorov-Smirnov Test & Skewness and Kurtosis in Excel | Data Analysis Using Excel Series E05
SUBSCRIBE to my channel: https://youtube.com/shivanandthorat?s...

This episode demonstrates how to test normality using the Kolmogorov-Smirnov test of normality and skewness and kurtosis values in Microsoft Excel.

The first episode demonstrates how to enable the Data Analysis ToolPak in Microsoft Excel.
Link for the first episode:    • Data Analysis ToolPak in Excel: How t...  

The second episode demonstrates how to compute descriptive statistics in Microsoft Excel.
Link for the second episode:    • Calculate Descriptive Statistics in E...  

The third episode elaborates on the descriptive statistics computed in Microsoft Excel using the Data Analysis option available under the Data tab.
Link for the third episode:    • Descriptive Statistics Explained in E...  

The fourth episode demonstrates how to detect and remove outliers using the boxplot method also known as the interquartile method or IQR method in Microsoft Excel.
Link for the fourth episode:    • How to Remove Outliers Using Excel: B...  

References:
George, D., & Mallery, M. (2010). SPSS for Windows step by step: A simple guide and reference, 17.0 update (10th Ed.). Pearson.

Critical Values Table for Kolmogorov-Smirnov Test Statistic:
https://docs.google.com/spreadsheets/...

Thanks for watching. See you soon.

Take good care,
Shivanand Thorat

Chapters in the Video (Key Moments):
00:00 What is Normal Distribution
00:50 What is the Normality Test
01:28 Kolmogorov Smirnov Test in Excel
09:03 Kolmogorov Smirnov Test in SPSS
10:33 Normality test using Skewness and Kurtosis


Reach out to me on:
Email: [email protected]
Telegram: https://t.me/shivanand_thorat
Facebook:   / shivanand.thorat.7  
Instagram:   / shivanandthorat  
LinkedIn:   / shivanand-thorat-021b7b1b6  

Music in this video:
Track 1: Parachute BGM
Track 2: Summer Time

Video Recorder: OBS Studio v27.0.1
Video Editor: Wondershare Filmora X v10.1.20
Audio Editor: Audacity v3.0.2

#normalitytestusingexcel #normality #kolmogorov-smirnovnormalitytestinexcel #skewnessinexcel #kurtosisinexcel #skewness #kurtosis #dataanalysis #splithalfreliabilityinexcel #psychometricsinexcel #shivanandthorat ‪@ShivanandThorat‬