Re: [R] Inverse Student t-value

2014-10-02 Thread JLucke
) Joe Andre 10/02/2014 07:27 AM To jlu...@ria.buffalo.edu, cc Duncan Murdoch , "r-help@r-project.org" , r-help-boun...@r-project.org Subject Re: [R] Inverse Student t-value Dear All, The manual formula mean that how to calculate that value by hand for TINV(0.408831, 1221) a

Re: [R] Inverse Student t-value

2014-10-02 Thread S Ellison
> The manual formula mean that how to calculate that value by hand for > TINV(0.408831, 1221) and the resulted is 4.0891672 This is not really an R help question - you're specifically asking for something that _doesn't_ use R - but if you want to know how R does it the full C and R code for

Re: [R] Inverse Student t-value

2014-10-02 Thread Andre
e >* > > 09/30/2014 11:54 PM > To > jlu...@ria.buffalo.edu, > cc > Duncan Murdoch , "r-help@r-project.org" < > r-help@r-project.org>, r-help-boun...@r-project.org > Subject > Re: [R] Inverse Student t-value > > > > > Hi JLucke, >

Re: [R] Inverse Student t-value

2014-09-30 Thread Andre
..@r-project.org > > 09/30/2014 02:45 PM > To > Duncan Murdoch , > cc > "r-help@r-project.org" > Subject > Re: [R] Inverse Student t-value > > > > > Hi Duncan, > > Let me explain again, I just need a manual expression for inverse student t &

Re: [R] Inverse Student t-value

2014-09-30 Thread JLucke
Andre Sent by: r-help-boun...@r-project.org 09/30/2014 02:45 PM To Duncan Murdoch , cc "r-help@r-project.org" Subject Re: [R] Inverse Student t-value Hi Duncan, Let me explain again, I just need a manual expression for inverse student t value. You could go to web page h

Re: [R] Inverse Student t-value

2014-09-30 Thread Nordlund, Dan (DSHS/RDA)
> -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- > project.org] On Behalf Of jlu...@ria.buffalo.edu > Sent: Tuesday, September 30, 2014 11:49 AM > To: Andre > Cc: r-help@r-project.org > Subject: Re: [R] Inverse Student t-value > &

Re: [R] Inverse Student t-value

2014-09-30 Thread Andre
Hi Duncan, Actually, I am trying trace the formula for the "Critical value of Z" and manual formula is =(I7-1)/SQRT(I7)*SQRT((TINV(0.05/I7,I7-2))^2/(I7-2+TINV(0.05/I7,I7-2))) So, I got new problem for TINV formula. I just need a manual equation for TINV. Hope solve this problem. Cheers! On We

Re: [R] Inverse Student t-value

2014-09-30 Thread Andre
Hi Duncan, Let me explain again, I just need a manual expression for inverse student t value. You could go to web page http://www.danielsoper.com/statcalc3/calc.aspx?id=10 That's inverse student t value calculator. Do you know a manual expression use it. Cheers! On Wednesday, October 1, 2014,

Re: [R] Inverse Student t-value

2014-09-30 Thread Andre
Hi Duncan, No, that's correct. Actually, I have data set below; N= 1223 alpha= 0.05 Then probability= 0.05/1223=0.408831 degree of freedom= 1223-2= 1221 So, TINV(0.408831,1221) returns 4.0891672 Could you show me more detail a manual equation. I really appreciate it if you may give mo

Re: [R] Inverse Student t-value

2014-09-30 Thread peter dalgaard
On 30 Sep 2014, at 20:36 , Duncan Murdoch wrote: >> TINV(0.408831,1221) Just for the record: The above _does_ give 4.117456652 in Excel for Mac OS X. -- Peter Dalgaard, Professor, Center for Statistics, Copenhagen Business School Solbjerg Plads 3, 2000 Frederiksberg, Denmark Phone: (

Re: [R] Inverse Student t-value

2014-09-30 Thread Marc Schwartz
t.org > 09/30/2014 02:36 PM > > To > Andre , > cc > r-help@r-project.org > Subject > Re: [R] Inverse Student t-value > > > > > > > On 30/09/2014 2:26 PM, Andre wrote: >> Hi Duncan, >> >> Actually, I am trying trace the formula fo

Re: [R] Inverse Student t-value

2014-09-30 Thread JLucke
My Excel (2013) returns exactly what R does. I used both T.INV and T.INV.T2There is no TINV. Has Excel been updated? Duncan Murdoch Sent by: r-help-boun...@r-project.org 09/30/2014 02:36 PM To Andre , cc r-help@r-project.org Subject Re: [R] Inverse Student t-value On 30/09

Re: [R] Inverse Student t-value

2014-09-30 Thread Duncan Murdoch
On 30/09/2014 2:26 PM, Andre wrote: Hi Duncan, Actually, I am trying trace the formula for the "Critical value of Z" and manual formula is =(I7-1)/SQRT(I7)*SQRT((TINV(0.05/I7,I7-2))^2/(I7-2+TINV(0.05/I7,I7-2))) So, I got new problem for TINV formula. I just need a manual equation for TINV.

Re: [R] Inverse Student t-value

2014-09-30 Thread Ted Harding
And, with 1221 degrees of freedom, one cannot be far off a Normal distribution. So: abs(qnorm(0.408831/2)) [1] 4.102431 which is nearer to Duncan's answer (4.117, and a bit smaller, as it should be) than to yours (4.0891672, which, if accurate, should be greater than the Normal value 4.10

Re: [R] Inverse Student t-value

2014-09-30 Thread Duncan Murdoch
On 30/09/2014 2:11 PM, Andre wrote: Hi Duncan, No, that's correct. Actually, I have data set below; Then it seems Excel is worse than I would have expected. I confirmed R's value in two other pieces of software, OpenOffice and some software I wrote a long time ago based on an algorithm publ

Re: [R] Inverse Student t-value

2014-09-30 Thread Duncan Murdoch
On 30/09/2014 1:31 PM, Andre wrote: Dear Sir/Madam, I am trying to use calculation for two-tailed inverse of the student`s t-distribution function presented by Excel functions like =TINV(probability, deg_freedom). For instance: The Excel function =TINV(0.408831,1221) = returns 4.0891672.

[R] Inverse Student t-value

2014-09-30 Thread Andre
Dear Sir/Madam, I am trying to use calculation for two-tailed inverse of the student`s t-distribution function presented by Excel functions like =TINV(probability, deg_freedom). For instance: The Excel function =TINV(0.408831,1221) = returns 4.0891672. Would you like to show me a manual ca