How can I set my y-intercept (b) equal to zero retina macbook 2014

Question

Level 1

0 points

How can I set my y-intercept (b) equal to zero retina macbook 2014

Hello everyone,

I hope you can reply to my question before 11:55p.m. today because that is when my report is due. I graphed my scatter plot and got my trend line, but my professor wants the class to set the y-intercept, the (b) from y=mx+b to zero. Can you guide me step by step on how to do that? I tried clicking on the Data section, then x-value, typed zero, but my graph disappeared. I am supposed to be using Excel for this, but I only have numbers. Can you set the y-int equal to zero using Numbers as well?

MacBook Pro with Retina display, y-intercept

Posted on Oct 10, 2014 9:07 PM

Reply

Answer 1

Yellowbox

Level 7

21,987 points

Oct 10, 2014 10:06 PM in response to Theonlymary

Hi Theonlymary,

The LINEST function returns an array of the statistics for a straight line that best fits the given data using the least squares method.

LINEST(known-y-values, known-x-values, nonzero-y-intercept, more-stats)

Type = in a spare cell to bring up the Function Panel. Type LINEST in the search box to see help on that function.

I don't use LINEST but it seems you can get extra stats from an array that it returns.

It won't change your graph (it doesn't need a graph).

Regards,

Ian.

Reply