SOLVED

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

Iron Contributor

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
best response confirmed by calof1 (Iron Contributor)
Solution

@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"))

image.png

And KURT requires at least 4 numbers.

Hi @Sergei Baklan 

 

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,

1 best response

Accepted Solutions
best response confirmed by calof1 (Iron Contributor)
Solution

@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"))

image.png

And KURT requires at least 4 numbers.

View solution in original post