Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
trish
 
Posts: n/a
Default how do I do statistic (regression) in excel? what's an array?

I know I can do fancy statistics in excel but the direction I got from the
program was not too helpful. I would like to do linear regression and
logistic regression in excel. So the direction tells me to highlight the
array, I thought it means to highlight all the fields with the numbers I want
to calculate but apparently I was wrong.
So the important question is. what is an array and how do I highlight it to
calculate it. In the example, the array went BEYOND the cells with numbers
inside it. It includes blank cells at the end. why is that, and how do i
know how many blank cell to highlight?
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

There are a lot of gaps in your description. Have you tried to do the
examples in Help for the LINEST() and LOGEST() worksheet functions? How
did your results compare what Help told you to expect? How does your
current problem differ from the Help examples?

Note that for LINEST() and LOGEST(), there can be no non-numeric cells
in the input ranges.

LOGEST() fits models like y = b*m^x, which can be transformed into
ln(y) = ln(b)+x*ln(m). Thus you could use EXP(SLOPE()) and
EXP(INTERCEPT()) to regress LN(y) on x, and reproduce the results from
LOGEST.

The preceding ignores questions of whether the assumed random error
structure is satisfied by the linear or nonlinear form, but it does
match the calculations that Excel does.

Jerry

trish wrote:

I know I can do fancy statistics in excel but the direction I got from the
program was not too helpful. I would like to do linear regression and
logistic regression in excel. So the direction tells me to highlight the
array, I thought it means to highlight all the fields with the numbers I want
to calculate but apparently I was wrong.
So the important question is. what is an array and how do I highlight it to
calculate it. In the example, the array went BEYOND the cells with numbers
inside it. It includes blank cells at the end. why is that, and how do i
know how many blank cell to highlight?


Reply
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
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 04:44 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 09:07 PM


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

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

About Us

"It's about Microsoft Excel"