[Solved] LINEST returns only one statistic

Discuss the spreadsheet application
Locked
henrytow
Posts: 25
Joined: Sat Feb 26, 2011 12:25 am

[Solved] LINEST returns only one statistic

Post by henrytow »

My Y-values are in an array N4:N918
My single X vector is in an array O4:O918

I want the constant to be calculated.

I want the full array of statistics.

The command below returns only one statistic.
=LINEST(N4:N918;O4:O918;1;1)

What am I doing wrong?
Last edited by Hagar Delest on Sun Oct 04, 2015 10:16 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 3.3 on Windows 7
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: LINEST returns only one statistic

Post by FJCC »

LINEST() is an array function. Select an array of cells two columns wide and four rows high and enter your formula. As you type, it will only appear in the cell at the end of your selection. When you are done typing, confirm the formula with Ctrl + Shift + Enter. It will then appear in all of the selected cells and surrounded by { }. That should give you what you want.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: LINEST returns only one statistic

Post by acknak »

There are lots of nice example spreadsheets posted on the forum; a search for LINEST should get you some. If you want an example to study and you don't find any, just ask.
AOO4/LO5 • Linux • Fedora 23
henrytow
Posts: 25
Joined: Sat Feb 26, 2011 12:25 am

Re: LINEST returns only one statistic

Post by henrytow »

{q15:r8}=LINEST(N4:N918;O4:O918;1;1)


didn't work either

Just exactly is meant by
Select an array of cells two columns wide and four rows high and enter your formula

When I select an array and move to a formula, the array disappears.

I know that I am missing something very fundamental, but I am..
OpenOffice 3.3 on Windows 7
henrytow
Posts: 25
Joined: Sat Feb 26, 2011 12:25 am

Re: LINEST returns only one statistic

Post by henrytow »

Got it.

After trying for two hours.
OpenOffice 3.3 on Windows 7
henrytow
Posts: 25
Joined: Sat Feb 26, 2011 12:25 am

Re: LINEST returns only one statistic

Post by henrytow »

This really does need better documentation.
Like so many explanations by experts, it isall very simple after you know how to do it.
OpenOffice 3.3 on Windows 7
Locked