SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-723197%22%20slang%3D%22en-US%22%3EFind%20KURTOSIS%20with%20excel.%20Need%20formula%20to%20select%20relevant%20data%20for%20KURT()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-723197%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20found%20the%20KURT(data)%20formula%20in%20excel%20can%20find%20the%20kurtosis%20of%20a%20set%20of%20results.%3C%2FP%3E%3CP%3EHowever%20if%20my%20data%20includes%20multiple%20sets%20of%20products%20such%20as%20stock%20codes%2C%20how%20can%20i%20find%20the%20KURT%20for%20each.%20I%20have%20tried%20to%20find%20an%20iF%20formula%20that%20will%20work.%20Example%20is%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20assist.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-723197%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-725866%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20KURTOSIS%20with%20excel.%20Need%20formula%20to%20select%20relevant%20data%20for%20KURT()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-725866%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364226%22%20target%3D%22_blank%22%3E%40calof1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETaking%20into%20account%20what%20KURT%20ignores%20all%20texts%20it%20could%20be%20array%20formula%20(Ctrl%2BShift%2BEnter)%20like%3C%2FP%3E%0A%3CPRE%3E%3DKURT(IF(%24B%244%3A%24B%2416%3DH6%2C%24C%244%3A%24C%2416%2C%22ignore%22))%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20640px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121512iF9EEEAD51F275FC9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAnd%20KURT%20requires%20at%20least%204%20numbers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-726874%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20KURTOSIS%20with%20excel.%20Need%20formula%20to%20select%20relevant%20data%20for%20KURT()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-726874%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20kindly%20for%20the%20response%2C%20it%20has%20worked%20perfectly.%20Very%20much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20noticed%20this%20formula%20selects%20data%20based%20on%20the%20stock%20code%2C%20i%20am%20hoping%20to%20use%20this%20for%20another%20issue%20i%20am%20having%20with%20time%20weighted%20return.%20I%20have%20a%20formula%20(attached)%2C%20but%20want%20it%20to%20select%20values%20on%20for%20the%20relevant%20stock%20code%20and%20between%20dates.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20something%20you%20are%20able%20to%20assist%20with%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent 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
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,

Related Conversations
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Help with minutes/seconds to seconds.
SteveMorley in Excel on
1 Replies