Showing posts with label Kurtosis. Show all posts
Showing posts with label Kurtosis. Show all posts

Friday, October 3, 2014

R Statistical Software Basics – Descriptive Statistics - Kurtosis

The practice sheet titled StatisticMarks Data.csv downloaded from Link. – Download Sheet

About the Data Sheet - The data in this sheet is related to marks scored by 100 Students in a Statistical Test.

Based on the data, we will use R Software Statistical functions to analyze the descriptive statistics.
 
In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. I have stored the StatisticMarks.csv file in Working Directory on my Desktop.

setwd("C:/Users/Rajesh Prabhakar/Desktop/R")

For inputting or reading Data from “StatisticMarks.csv” file, R Command would be

StatMarks=read.csv("StatisticMarks.csv")

Kurtosis
A statistical measure used to describe the distribution of observed data around the mean. It is sometimes referred to as the "volatility of volatility."
Used generally in the statistical field, kurtosis describes trends in charts. A high kurtosis portrays a chart with fat tails and a low, even distribution, whereas a low kurtosis portrays a chart with skinny tails and a distribution concentrated toward the mean.

In R Statistical Software, Skewness is represented by function “kurtosis”. For kurtosis Load e1071 package or PerformanceAnalytics Package

kurtosis(   )

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data titled StatisticsMarks. 

kurtosis(StatMarks$StatisticsMarks)

StatMarks is the name of the variable in which we stored the data followed by $ sign and column header of the Data i.e. StatisticsMarks.

Remember the title of the column should be exactly same including the large caps & small caps or else it will give error.

In R the file names, column headers and row headers should exactly match the same or else the function will give errors

The result of this function in R Console is
kurtosis(StatMarks$StatisticsMarks)
[1] 1.556244 

Sunday, September 14, 2014

KURTOSIS - Descriptive Statistics using Microsoft Excel Statistical Functions

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet

About the Data Sheet - The data in this sheet is related to marks scored by 100 Students in a Statistical Test. 

Based on the data, we will use Microsoft Excel Statistical functions to analyse the descriptive statistics. 

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

KURTOSIS

A statistical measure used to describe the distribution of observed data around the mean. It is sometimes referred to as the "volatility of volatility."

Used generally in the statistical field, kurtosis describes trends in charts.

Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution.

= KURT(number1,number2,...)

Kurtosis is defined as:

where s is the sample standard deviation.

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

=KURT(A2:A101)

Result is 1.6994

The result is positive highlights peaked distribution.

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet