LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Excel error in R-squared computation in exponential regression

I'd be happy to. Where can I send the details?
--
Bjoern Schellenberg


"Bernard Liengme" wrote:

Could you supply more details?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bjoern" wrote in message
...
Excel computes the R-squared of an exponential regression wrongly: instead
of
thecorrect result it reports the R-squared of the underlying linera
regression of the logarithm of the data. The two numbers are close if the
correlation is good, put far apart if it isn't. This Excel grossly
exaggerates the R-squared.

I am trying to bring this to the attention of Microsoft. It is of some
importance to me as I will be teaching this topic to my Math class in two
weeks.

So far I have not been able to wade through the layers of bureaucracy.
--
Bjoern Schellenberg

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc






 
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
How to use Excel to do likelihood ratio chi-squared test? Michael Excel Worksheet Functions 2 April 23rd 23 03:43 AM
computation error Rajneesh Arora Excel Discussion (Misc queries) 4 August 22nd 07 08:17 PM
Regression - Standard Error X Variable 1 Claude S Excel Worksheet Functions 2 November 19th 05 10:08 AM
MOD function computation error Marian Megami V Excel Worksheet Functions 7 August 24th 05 09:48 PM


All times are GMT +1. The time now is 08:47 AM.

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"