how do I do statistic (regression) in excel? what's an array?

[Guest]

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?

 

[Jerry W. Lewis]

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