Slope -Liner regression

pankajsync

I would like to calculate the slope in linear regression fashion. It should be a column formula. And the slope value should be single value (Averaged) for the below table.

 

Group	Subgroup	Log[V]	Log[T3]	Slope
1	a	1.609438	7.953736	Calculate slope for 1, a
1	a	1.648659	6.777461
1	a	1.686399	5.296072
1	b	1.609438	8.953736	Calculate slope for 1, b
1	b	1.648659	7.777461
1	b	1.686399	6.296072
2	a	1.609438	17.95374	Calculate slope for 2, a
2	a	1.648659	16.77746
2	a	1.686399	15.29607
2	b	1.609438	38.95374	Calculate slope for 2, b
2	b	1.648659	37.77746
2	b	1.686399	36.29607

Mark_Bailey

See the Linear Regression() function in the Help > Scripting Index for your formula. You might need to use a script, though. Subscripting the rows into groups of three might be difficult in a formula.