Jun 26 2019 08:58 PM
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,
Jun 27 2019 11:49 AM
Solution
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.
Jun 27 2019 04:40 PM
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,
Jun 27 2019 11:49 AM
Solution
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.