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:
Posting Komentar