Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |