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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies