I was wondering, if, in whatever the newest version of ios, numbers, and/or pages, it is possible to force a trendline through a point on a 2D scatter graph (e.g. the origin (0,0)). I was hoping to not have to buy excel just because one teacher wants this specific thing.
Edit: Here is a list of what my teacher requires me to do (its a college biology class):
1) Show numbers to 1-2 spaces past decimal point.
2) Adjust document page setup so all cells of a table appear on the same page.
3) Always plot the independent variable on the X-axis
4) Always plot the dependant variable on the Y-axis
5) Label both axes with the quantity being measured
6) Except where data is processed as a ratio, the numbers must be associated with specific units. Include on the graph axes or in table cells.
7) Number the axes appropriately at regular intervals
8) Show the equation for the trend line.
9) There must be a good title [insert long explanation here]
10) If there is more than a single data set plotted on a graph, distinguish between them via shapes or colours.
11) Adjust the scales of the X- and Y- axes so that: a) All data points fit on the graph b) Both axes are reasonably close to the same length. c) You are using a reasonable portion of the overall page of graph paper.
12) a) For a standard curve, from which values will be extrapolated (which I am doing in this case), draw a best-fit straight line. In a linear graph the line is typically forced to go through the origin. 1 b) For graphs that aren't standard curves, if the points seem to line up in a straight line or if the relationship is known to be linear, dea a best-fit straight line (which may or may not go through the origin)
c)....(not applicable to my question)
d)....(not applicable to my question)
e) Smoothing curves for aesthetic reasons "MUST" be avoided.
f) Adding portions of lines on graphs for which there is no data must be avoided.