Excel: Descriptive statistics
Автор: Dr. Jayanta Das
Загружено: 2021-05-25
Просмотров: 942
In this tutorial, I have explained how to calculate descriptive statistics like mean, Standard deviation, Skewness and Kurtosis in excel.
1. N – This is the number of valid observations for the variable. The total number of observations is the sum of N and the number of missing values.
2. Minimum – This is the minimum, or smallest, the value of the variable.
3. Maximum – This is the maximum, or largest, the value of the variable.
4. Mean – This is the arithmetic mean across the observations. It is the most widely used measure of central tendency. It is commonly called the average. The mean is sensitive to extremely large or small values.
5.Std. – Standard deviation is the square root of the variance. It measures the spread of a set of observations. The larger the standard deviation is, the more spread out the observations are.
6. Skewness – Skewness measures the degree and direction of asymmetry. An asymmetric distribution such as a normal distribution has a skewness of 0, and a distribution that is skewed to the left, e.g. when the mean is less than the median, has negative skewness.
7. Kurtosis – Kurtosis is a measure of tail extremity reflecting either the presence of outliers in a distribution or a distribution’s propensity for producing outliers (Westfall,2014)
#DescriptiveStatistics #Mean #StandardDeviation #Skewness #Kurtosis #Excel
**************************************************************************************************
Workshop Alert on An Integrated MCDM approach for Drought Vulnerability Assessment in ArcGIS
https://www.aigr.co.in/
**************************************************************************************************
Enrollment link
https://www.aigr.co.in/page/an-integr...
*******************************************************************************************************
UDEMY Course
Rainfall Indices for MCDM models in ArcGIS: how and Why?
Preparation of 10 important rainfall indices for MCDM models and time series analysis using Excel, ArcGIS and QGIS
Click this link only Rs. 390 or 12.99 USD
https://www.udemy.com/course/rainfall...
*******************************************************************************************************
Advances in Geographical Research
Learn research methodology online with courses of Advanced Geospatial technologies, statistical methods, and Machine Learning algorithms.
https://www.aigr.co.in/
*******************************************************************************************************
WhatsApp Group for subscribers:
Group 1
https://chat.whatsapp.com/HnJU2SLXyf7...
Group 2
https://chat.whatsapp.com/CybK5vtqqq6...
***************************************************************************************
Playlist
1. Basics Remote sensing
• Basics Remotesensing
2. MCDM and ML
• MCDM and ML
3. Arc GIS
• Arc GIS
4. Free online data download
• Free online data download
5. Advanced Excel
• Advanced Excel
SUBSCRIBE to the YouTube channel Dr. Jayanta Das, to get notification about our recent lecture uploads on Advances in Geographical Research.
/ drjayantadas
ALL RIGHTS RESERVED.
#DrJayantaDas
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
