Re: [R] Inverse Student t-value

2014-10-02 Thread Andre
geomodel...@gmail.com geomodel...@gmail.com* 09/30/2014 11:54 PM To jlu...@ria.buffalo.edu, cc Duncan Murdoch murdoch.dun...@gmail.com, 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, Maybe the old excel

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 JLucke
Andre geomodel...@gmail.com 10/02/2014 07:27 AM To jlu...@ria.buffalo.edu, cc Duncan Murdoch murdoch.dun...@gmail.com, r-help@r-project.org 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

Re: [R] Inverse Student t-value

2014-10-01 Thread Andre
-boun...@r-project.org 09/30/2014 02:45 PM To Duncan Murdoch murdoch.dun...@gmail.com, cc r-help@r-project.org 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

[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

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

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

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

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 JLucke
: [R] Inverse Student t-value 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

Re: [R] Inverse Student t-value

2014-09-30 Thread Marc Schwartz
/2014 02:36 PM To Andre geomodel...@gmail.com, 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 for the Critical value of Z and manual formula is =(I7-1)/SQRT(I7)*SQRT

Re: [R] Inverse Student t-value

2014-09-30 Thread peter dalgaard
On 30 Sep 2014, at 20:36 , Duncan Murdoch murdoch.dun...@gmail.com 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

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

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,

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

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 My Excel (2013) returns exactly

Re: [R] Inverse Student t-value

2014-09-30 Thread JLucke
...@gmail.com Sent by: r-help-boun...@r-project.org 09/30/2014 02:45 PM To Duncan Murdoch murdoch.dun...@gmail.com, cc r-help@r-project.org 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