Home

SPSX

Formulas of quartile,Percentile Squre root, power etc on Excel

Posted by Muhammad Taheir | On: , |
Quartile:


=quartile(.....,quar)

Percentile:


=percentile(.....,k)

Addition:
=sum(.....)

Maximum:

=max(.....)

Minimum:


=min(.......)

Squre Root:


=sqrt(....)

Power:

=(..)^n

Skewness:


=skew(..)

  • if => 0 then positive skewness
  • if =< 0 then negitive skewness
  • if = 0 then symetric skewness
Kurtosis:

=kurt(.....)
  • if k > 3 laptokaurtic
  • if k < 3 Meso kurtic
  • if k = 3 Platy Kurtic