LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
DWright
 
Posts: n/a
Default Regression Statistics are returned as Rounded to 1 vs. several dec

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
mutiple regression help happycow Excel Discussion (Misc queries) 1 July 30th 05 04:47 AM
Erroneous Regression on Residuals Scott Excel Discussion (Misc queries) 3 July 27th 05 01:53 AM
how do I do statistic (regression) in excel? what's an array? trish Excel Discussion (Misc queries) 1 May 7th 05 02:43 PM
Summing Returned Positions using MATCH Sam via OfficeKB.com Excel Worksheet Functions 10 April 16th 05 11:30 PM
Formatting of the Returned Value of a Formula Q John Excel Worksheet Functions 2 December 7th 04 10:54 AM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"