regression line

kong

New Member
Joined
Aug 4, 2005
Messages
23
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
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

kong

New Member
Joined
Aug 4, 2005
Messages
23
better
in A i got casual nember
in B i got the formula (?)

hope to be clear
thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,114,401
Messages
5,547,740
Members
410,810
Latest member
thepinkbird
Top