R-squared: Comparing Values?
830085
I don't know all that much about it, but it appears that things got confused in the answers to the earlier question. The r2 statistic seems to have been mixed up with the correlation coefficient. The two are completely different. What r2 measures is the explained variance (the unexplained variance being the square of the residuals after the fit). A low r2 may come from an inadequacy of the model (e.g. fitting a straight line to a fundamentally nonlinear relationship), but it may also come purely from random noise. In a noisy series, it is quite possible to have a highly significant trend and a low r2.
186891
you do not need to have an r^2 value to determin if two values are correlated\n\nyou just look at the sctter plot\n\nif there is a a clear trend (ie as I increase one value the other value generally decrease  or genrally decrease)\nthis can be seen in a simple scatter plot one need no statistics to to see if there is correlation\n\nif ther eis no correlation the scatterplot will be totally random and no  pattern. Correlation you are generelaly looking for a linear pattern)\n\nif you wnat to technically test and  to have a significane value you can test Ho: R^2= zero  vs   H1: R^2 ~= zero\n\nthe problem you will encounter her is when you calculate R^2 you will only be able to get a point estimate. \n\nIf you wish to test the value of R^2 equal to zero then you will need to somehow to guage the variance.\n\nTo guage the variance of R^2 you will have to utilize the jacknife variance estimator or the bootstrap variance estimator\n\nthes are methods to compute variances for thing besides the mean ie the median, the max , the min, R^2\n\n\nto jacknife you compute the R^2 n times always leaving the nth observation out of the calculation. this gives you a range of R^2's. now you can compute a variance to test or use that set to define a CI to do your test.\n\nThe bootstrap is similar in that you compute the same value multiple times, but here you will take random samples with replacement from your samples until you have chossen n observations (not with replace ment so you get a differnt sample than you started with) now compute the value of intereest (R^2) off of this sample. this will give you another estimate for the same value. Now reapeat this exercise until you have a sufficent number of estimatess (say n) then we can now compute a variance for R^2 or use the set to define a 95% CI to do our test jsut as with the jacknife method
830317
f1>f3>f2>f5>f4\nJust replace the variable n in  Excel's function and compare the result.
1027060
=IF(AND(A=[condition], B=[condition]),X,Y)\n\nAND will return true if both conditions are satisfied.
869140
Just graph it like an equality, and then your answer is everything either above (>) or below (<) the line.  For example, in the last inequality, the answer is everything above the line y = -2, not including the line itself.
612102
you DONT get the same value back !\n\nyou get TWO different values back whenever you obtain the square root of ( s^2 ).  for example the sq rt of 25 is 5 or (-5) .\n\nthus, solution to a square root always involves TWO values ( +/- ).\n\nin other words, "s"  can be positive or negative only but the solution is not unique ( +s or -s ) and unspecifiable.\n\nthanks gore .... :)
887169
You're getting into logarithm.  If X/D = R^Y, then Y = log(X/D), where log is the logarithm in base R.
540085
(a-2)(a+2)  \n(difference of squares)
432008
t=rho/(sqr((1-rho^2)/(n-2)))\nwhere:\n\nrho: correlation coefficient\nn: number of observations
329632
{x: x inequal to 2}\nor\n{x: x=/= 2}
976565
chi-sq is 5.964  this is like the arithmetic mean\ndf or degrees of freedom (n-1)  is for your t test\np-value is given the null is true that is the probability of obtaining an extreme value from the sample
470569
The formula would be: =IF(A2="A", 10)\n\nThis would be pasted into another cell, like B2 for example.  Thus, if A2 is A, then B2 would display a 10 - if it is not, it will display FALSE.\n\nIf you don't want FALSE to appear, change the formula to: =IF(A2="A", 10, 0)  You can substitute the value of 0 for whatever you want the cell B2 to display if A2 is not A.
623677
Analysis of variance or ANOVA checks for the variation contributed by teh population in question
211268
Regression analysis is very complicated mathematical/statistic analysis that is very difficult to describe easily.  R-squared is a measure of how closely an investment tracks the S&P 500 or other index.  While I am not a great fan of investopedia.com, they give some answers in this case.\n(These comments refer to investment analysis, regression analysis is also used in other fields.)
189782
It's a calculation called the r value.  The link below shows how to calculate it.  If you take a college level statistics class you'll learn how to do it with a good calculator.
192819
I think you mean the "R" value!
870658
If 1/R=1/r1+1/r2 you can convert the equation conveniently/        1/R=(r1+r2)/r1r2  Or,R=(r1r2)/(r1+r2)  [by inversing] ,Now just put the values of r1 and r2 and you get the value of R.That was the way we were solving 50 years back when we were in college and remember, calculator was not invented at that time.