- #1

- 205

- 0

- Thread starter JamesJames
- Start date

- #1

- 205

- 0

- #2

Dr Transport

Science Advisor

Gold Member

- 2,439

- 582

- #3

russ_watters

Mentor

- 20,127

- 6,644

- #4

- 5,754

- 1,051

- #5

Integral

Staff Emeritus

Science Advisor

Gold Member

- 7,201

- 56

LINEST(yrange,xrange, b, stats)

for the x and y ranges enter the row column information for your data for example if your data is in the first 8 cells of the first 2 columns you would enter a1:a8 for the xrange and b1:b8 for the y range. The b and stats parameters are logical (b=true if you want Excel to compute the y intercept, b=false of you want it to be 0) The last gives more stats if you set it to true.

You need to select a 3x2 block of cells type = in the command line, enter the formula then type ctrl+Shift+enter to enter the Array formula.

You would do well to get into the Excel help system and research array formulas and the Linest command.

- Last Post

- Replies
- 3

- Views
- 23K

- Replies
- 3

- Views
- 6K

- Last Post

- Replies
- 23

- Views
- 10K

- Last Post

- Replies
- 4

- Views
- 2K

- Last Post

- Replies
- 7

- Views
- 27K

- Last Post

- Replies
- 4

- Views
- 3K

- Last Post

- Replies
- 19

- Views
- 2K

- Last Post

- Replies
- 1

- Views
- 5K

- Last Post

- Replies
- 4

- Views
- 906

- Last Post

- Replies
- 3

- Views
- 64K