Forum Discussion
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,
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.
2 Replies
- SergeiBaklanDiamond Contributor
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.
- calof1Iron 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,