How do I force a line of best fit to go through the origin?
My teacher is requesting that we “force” the line of best fit for our graphs to go through the origin. I cannot get the correct value for slope of the best fit line without doing so.
Also, I am using Numbers on an Apple computer but if you just give me a general Excel way to do it I could probably figure it out.
Thank you!
August 10th, 2010 at 3:58 am
use the line of best fit by your eyes
August 10th, 2010 at 4:40 am
This is an option of the Excel regression function. Read the Help to see what the value should be to force the offset to zero.
m