Rabu, 27 Januari 2016

Re: [MS_AccessPros] KURTOSIS

 

OK John, thanks for the helpful hint.

Ade




From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, 27 January 2016, 12:19
Subject: Re: [MS_AccessPros] KURTOSIS

 
Ade-

I sent you both articles because it looks like you have to first calculate the nth Moment to get to the Kurtosis.

BTW, this would be much easier to do if your values were in rows rather than columns.  You have a repeating group, which is bad Relational design.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Jan 27, 2016, at 12:58 PM, Adeboyejo Oyenuga aoye_99@yahoo.co.uk [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

That exactly is the issue. While I was able to convert similar explanations on Skewness to expressions in MSAccess, I was not able to do this for Kurtosis and hence the request for help.

Thanks.

Ade.






From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, 27 January 2016, 11:53
Subject: Re: [MS_AccessPros] KURTOSIS

 
Ade-

Have you looked at:


and


??

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Jan 27, 2016, at 12:39 PM, Adeboyejo Oyenuga aoye_99@yahoo.co.uk [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi All,

regarding some functions in MSExcel not in MSAccess, I am concerned about Skewness and Kurt function which is for Kurtosis.

I was able to figure out the Skewness but need some help with the Kurtosis bit.

Suppose i have a record with the following data and want to calculate the Kurtosis, can you assist ?

                        Clm1 Clm2 Clm3 Clm4 Clm5 Clm6 Clm7

Record 1        10       12      25     40       55      70     95


Thanks.

Ade.








__._,_.___

Posted by: Adeboyejo Oyenuga <aoye_99@yahoo.co.uk>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar