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
calof1
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