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 each. I have tried to find an iF formula that will work. Example is attached.

 

Can someone please assist.

 

Kind regards,

2 Replies

    • calof1's avatar
      calof1
      Iron Contributor

      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