Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I am trying to apply linear regression analysis to test the "effectiveness" of swap transactions (but that's beside the point). I have 2 columns of %'s as my x and y data, and I am trying to see if they correlate. So I am interested in the R Square statistic. For some reason, the resulting statistics are all rounded to 1 (hard-entered w/out decimals), instead of formatted several decimal places (see below). Regression Statistics Multiple R 1 R Square 1 Adjusted R Square 1 Standard Error 2.40655E-18 Observations 20 Anyone know why or how I can adjust the resulting format? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
mutiple regression help | Excel Discussion (Misc queries) | |||
Erroneous Regression on Residuals | Excel Discussion (Misc queries) | |||
how do I do statistic (regression) in excel? what's an array? | Excel Discussion (Misc queries) | |||
Summing Returned Positions using MATCH | Excel Worksheet Functions | |||
Formatting of the Returned Value of a Formula Q | Excel Worksheet Functions |