Intercept and Slope of visible rows, please.

R

RedSkyRoad

Joined
Jul 25, 2014
Messages
2
Reaction score
0
Hi,

I cant seem to get my head around the subtotal function people use to achieve this.

My X-axis values is from H2:H1642 and the Y-axis is J2:J1642. I want to calculate the slope and intercept of this data, AFTER I applied a filter to these rows...

Could someone please help me...

Regards,
B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting intercept to zero with SLOPE/STEYX/etc 3
Anomolous behaviour of slope function. 2
Slope??? help please!!! 1
Regression intercept to 0 2
=SLOPE(OFFSET(INDEX .... Help please 9
regression using set intercept 4
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
hard slope question 2

Top