Similar line
Users questions: Thank you for your participation, see specific annex. May have misunderstood, I do not know before the line (so close to the line filled in), now know, is to solve the regression line. Find the linear equation (substitution X = 0, get the value in paragraph 0), and the straight line drawn in the XY two-dimensional coordinates within. Thank you smhf_ 6 answers Sister school to find a long EXCEL instructions, finally found the regression line formula "= FORECAST (0, D2: M2, D12: M12)", but still learning the formula sister fully answer questions, Thanks again.
Experts answer: linear equations have been listed, picture fear Fear no need of it. To comment you write: I understand that, under normal circumstances is seeking a line under 2:00 is absolutely correct, the current landlord mean that, according to demand more in a straight line equation. Of course, the point more, the overall error can only come to two parameters most hours, the implementation of specific to a certain point, Error will feel great, but this is inevitable, is also landlord to provide the X * Y value does not rule making. Landlord would have to line drawn, whether this can be: 1, according to the known equation, two points (selected larger span) of x, y values into the 4 cell 2, using the "Insert - Chart - Stitches map "according to the known values to be completed by Annex 4: similar to a straight line. Xls