This content has been marked as final.
Show 1 reply

1. Re: Mismatch in Skew Value in Excel & Tableau Summary Card
Mahfooj Khan Dec 13, 2016 5:02 AM (in response to Sumeet Bedekar)1 of 1 people found this helpfulThere 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 n1, 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