Forum Discussion

calof1's avatar
calof1
Iron Contributor
Jun 27, 2019
Solved

Find KURTOSIS with excel. Need formula to select relevant data for KURT()

Hi,   I have found the KURT(data) formula in excel can find the kurtosis of a set of results. However if my data includes multiple sets of products such as stock codes, how can i find the KURT for...
BI & Data Analysis
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 27, 2019

    calof1 

     

    Taking into account what KURT ignores all texts it could be array formula (Ctrl+Shift+Enter) like

    =KURT(IF($B$4:$B$16=H6,$C$4:$C$16,"ignore"))

    And KURT requires at least 4 numbers.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 27, 2019

calof1 

 

Taking into account what KURT ignores all texts it could be array formula (Ctrl+Shift+Enter) like

=KURT(IF($B$4:$B$16=H6,$C$4:$C$16,"ignore"))

And KURT requires at least 4 numbers.

  • calof1's avatar
    calof1
    Iron Contributor
    Jun 27, 2019

    Hi SergeiBaklan 

     

    Thank you kindly for the response, it has worked perfectly. Very much appreciated.

     

    I have noticed this formula selects data based on the stock code, i am hoping to use this for another issue i am having with time weighted return. I have a formula (attached), but want it to select values on for the relevant stock code and between dates.

     

    Is this something you are able to assist with?

     

    Thanks again,

Resources