regression line

[kong]

hi to everybody
wich is the formula (?) in B that give me the regression line to put on a graph with the column A.... i know the formula is y=ax+b ...but what a , what b , what x ?
thanks to who can

A B
1 3435 ?
2 343 ?
3 3435 ?
4 2344
5 324565
6 5443
7 43566
8 345
9 34566
10 355445
11 4335
12 34434
13 66578
14 99765
15 57899

 

[kong]

better
in A i got casual nember
in B i got the formula (?)

hope to be clear
thanks

 

[tusharm]

1) Create a chart with the existing data. Then, create a trendline with Chart | Add Trendline...

2) Use the LINEST function.

3) See
Trendline Coefficients and Regression Analysis
http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm

 

[kong]

right!!!
very clear
thankyou a lot!!!!
by