how to use linest to get the result as ARRAY?

F

frank

i am a excel 2007 user, I tried to lrun a regression using inest, i had
expected the result came out as an array containing a set of statistical
measurements, but instead it give me a single value, what do i do? thanks.
 
H

Harlan Grove

frank said:
i am a excel 2007 user, I tried to lrun a regression using inest, i had
expected the result came out as an array containing a set of statistical
measurements, but instead it give me a single value, what do i do? thanks.

One thing you could do is read online help for the LINEST function,
which includes the text: "Formulas that return arrays must be entered
as array formuas." That means if you're trying to return the extended
stats and you have, say, 5 explanatory variables, you need to select a
5 row by 6 column range, type the LINEST formula and press [Ctrl]+
[Shift]+[Enter] rather than just [Enter].
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top