1 Reply Latest reply on Dec 13, 2016 5:02 AM by Mahfooj Khan

# Mismatch in Skew Value in Excel & Tableau Summary Card

Hi Tableau Lovers,

A measure of the tendency of your data to have extreme values to one side. Positive skewness means the extreme values are to the right, while negative skewness means the extreme values are to the left.

I have sample data set as shown below  and wanted to compute on this sample data set.

Formula:-

-

First Result in Excel :-  Skew = - 0.64052

Second Result in Tableau:-  Skew = - 0.641

Third Result in Tableau Summary Card :-  Skew = -0.54

Thus,

From above snap shot, we came to know that Skew in Tableau Summary card is showing different value.

Mahfooj Khan Kindly have a look into this

Regards,

Sumeet

• ###### 1. Re: Mismatch in Skew Value in Excel & Tableau Summary Card

There are two function it takes - SKEW() and SKEW.P() and the difference is that incase of SKEW only, it considers the distribution of the data as a sample and incase of SKEW.P, it considers the data as the entire population. Mathematically, in place of n if you take n-1, the formula will take the data as a population distribution. So your -0.64 comes when you apply sample skew function, and -0.54 is observed when you calculate skewness of a population.

SKEW() on a sample

SKEW.P() on a population

Hope this help.

Mahfooj

1 of 1 people found this helpful