x,y axis common point(linear regression)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

x,y axis common point(linear regression)

Author

Topic

samsun125
Yak Posting Veteran

63 Posts

Posted - 2009-06-04 : 08:24:05

hi all,

I have one query ,
in my x-axis i have(a,b,c,d,e)and in y-axis(1,2,3,4,5) values are there, i want to draw a line for common points like(a,1),(b,2).....

can u please check and let me know

Thanks & Regards
Rama

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-04 : 08:28:39

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77311

E 12°55'05.63"
N 56°04'39.26"

samsun125
Yak Posting Veteran

63 Posts

Posted - 2009-06-04 : 08:35:03

Hi Peso,

Thank you very much ,i tried this one .
ex:table with 6 rows
same steps i have followed but it is returning A,b,R2.values.
What is A,b,R2?
AND IT IS GIVING ONLY ONE VALUE FOR WHOLE TABLE.
for 6 rows ,so how to draw a slope line for decreasing and increasing business for that particular product.

Regards
Rama

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-04 : 08:41:27

The link above gives you the FORMULA for drawing the line.
With the variable coefficients above, you can calculate every Y value for any given X value.

Do you know what Linear Regression is?

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources