Descriptive statistics tools

Descriptive statistics tools include

1.Mean
2.Median
3.Mode
4.Skewness
5.Kurtosis
6.Normal plots
7.Turf analysis
8.Cross tabulation
9.Test of linearity
10.Tests of normality
11.standard deviation
12.Variance
13.Maximum value
14.Minimum value

R for MBA's- Calculating quartiles/quantiles using R

Coding

> x<-c(97,92,104,189,156,156,125)


> quantile(x)

Output

   0%      25%       50%       75%     100% 
 92.0     100.5     125.0      156.0    189.0 

R for MBA's: Calculating Range of numbers using R

 Coding: 

> x<-(97,92,104,189,156,156,125)

> range(x)

Output

[1]  92 189

R for MBA's- Calculating Standard Deviation and Variance using R

Coding and output

> x<-c(97,92,104,189,156,156,125)

> sd(x)

Standard deviation: [1] 36.64112

> var(x)

 variance: [1] 1342.571

Learn SPSS- Linearity tests

Learn SPSS- Turf Analysis

Turf Analysis

Learn SPSS- Normality Tests

Normality tests- An Overview

Normality tests- Overview

Advanced Excel for MBA's - Calculating the Mean using Excel

Calculating mean of the datasets using Excel.

Problem1 :

Calculate the mean sales of Prasad industries's sales executive for the month MAY 2020.

Company : Prasad Industries.
	Sales for May 2020(in '000s)
Sales Executive 1	72
Sales executive 2	35
Sales Executive 3	45
Sales Executive 4	52
Sales Executive 5	61
Sales Executive 6	63
Sales Executive 7	48
Sales Executive 8	59
Sales Executive 9	71
Sales Executive 10	74

Answer

 Step 1: Click on formula

 Step 2: Insert functions

Step 3:

Step 4: Click on Average

Step 5; 

Select the sales executive 1 to 10 sales data

Step 6; The answer 58 will appear on the window.