function computation

[Maguin, Eugene]

All,

Does spss have (i think the answer to this is No) or can spss be used to
compute the following: complete beta function, incomplete beta function,
complete gamma function?

Thanks, Gene Maguin

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[tricia_444]

Hello! I have been having an issue with SPSS 20 and when I copy a Custom Table to Excel and run my Excel Macro it doesn't work correctly.  Any idea why??  If anyone knows a way to automatically export a layered table into separate excel worksheets, that would be great to know, also! ;o)

Thanks!
Tricia



The information contained in this email may be confidential and/or legally privileged. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its content, is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. Thank you.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Alex Reutter]

There aren't specific functions to compute these; though looking at:

http://publib.boulder.ibm.com/infocenter/spssstat/v20r0m0/topic/com.ibm.spss.statistics.help/syn_transformation_expressions_random_variable_distribution_functions.htm

it seems like you should be able to get the incomplete beta function using CDF.BETA.  To get the complete beta and complete gamma functions, you would need to do something like

completeBeta = (1/PDF.BETA(x,a,b))*(x^(a-1))*((1-x)^(b-1))
completeGamma = (b^a/PDF.GAMMA(x,a,b))*(x^(a-1))*exp(-b*x)

Alex




From:        Gene Maguin <[hidden email]>
To:        [hidden email]
Date:        02/07/2012 10:25 AM
Subject:        function computation
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

All,

Does spss have (i think the answer to this is No) or can spss be used to
compute the following: complete beta function, incomplete beta function,
complete gamma function?

Thanks, Gene Maguin

[David Marso]

Note that SPSS has the LNGAMMA function and CDF.Beta

LNGAMMA(arg)Logarithm of complete Gamma function
CDF.BETA(q,a,b)Return probability that the beta random variate falls below q (0≤q≤1; a>0; b>0).

From Wikipedia:
Complete Beta Value = Exp(GammaLn(a) + GammaLn(b) - GammaLn(a + b))
Incomplete Beta Value = CDF.Beta(x, a, b) * Exp(GammaLn(a) + GammaLn(b) - GammaLn(a + b)).

Gene Maguin wrote

All,

Does spss have (i think the answer to this is No) or can spss be used to
compute the following: complete beta function, incomplete beta function,
complete gamma function?

Thanks, Gene Maguin

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Ryan]

Gene,

SPSS 19 offers CDF.Beta and CDF.Gamma. I wonder, however, if this is what you're after. 

Ryan

On Tue, Feb 7, 2012 at 11:04 AM, Gene Maguin <[hidden email]> wrote:

All,

Does spss have (i think the answer to this is No) or can spss be used to
compute the following: complete beta function, incomplete beta function,
complete gamma function?

Thanks, Gene Maguin

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[David Marso]

Define *work correctly*.  Isn't this really an Excel programming/Macro question and completely specific to your macro?  AFAIK to paste the layered table you most likely will have to study the PivotManager object in the scripting API and tinker with it!

tricia_444 wrote

Hello! I have been having an issue with SPSS 20 and when I copy a Custom Table to Excel and run my Excel Macro it doesn't work correctly.  Any idea why??  If anyone knows a way to automatically export a layered table into separate excel worksheets, that would be great to know, also! ;o)

Thanks!
Tricia



The information contained in this email may be confidential and/or legally privileged. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its content, is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. Thank you.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD