I have seen how to add a trendline in numbers 2.0 for Apple, is it possible for numbers ios? I have also seen how to use statistics function to find slope and y-intercept; is there a way to graph a line in numbers for IPad?
iPad 2, iOS 5.1.1
You have posted this question in the forum for Numbers on Mac OS X (not iOS). So I will explain using the procedure for Numbers on Mac OS X and provide a link to the iWork for iOS forum (which is here: https://discussions.apple.com/community/app_store/iwork_for_ios)
1) select the chart
2) open the charts inspector
3) select "Series" in the segmented controls
4) Open the advanced section by clicking the expose triangle
5) Select the "Trendline" segment at the bottom, then the type of trendline from the "Type" menu
Thanks Wayne,
Your attached picture shows very clearly how to add a trendline for MacOS (thanks). Unfortunately, there is no advanced tab on iOS. Also, there has been a post in the iOS forum for a year with no response.
jconnell62 wrote:
Thanks Wayne,
Your attached picture shows very clearly how to add a trendline for MacOS (thanks). Unfortunately, there is no advanced tab on iOS. Also, there has been a post in the iOS forum for a year with no response.
Post again, it never hurts. The population of iPad owners in on a steep incline.
Jerry
Good point Jerrold. I will give it a go.
if you want to add a linear best fit line you can get the parameters for that line from your existing data and make a NEW series:
Using my previous charts you can add a new table (in this case below the chart) used to calculate the slope (m) and the y-intercept (b) for each of the original series. Then you can use those two values with the original X values to construct a best fit line. The bottom table is named "Best Fit Constants" and is constructed:
B1=INDEX(LINEST(Data :: C,Data :: B,TRUE), 2)
B2=INDEX(LINEST(Data :: C,Data :: B,TRUE), 1)
D1=INDEX(LINEST(Data :: E,Data :: D,TRUE), 2)
D2=INDEX(LINEST(Data :: E,Data :: D,TRUE), 1)
The original table (which I named "Data") is constructed as follows:
F2=B2
G2=Best Fit Constants :: $B$1+Best Fit Constants :: $B$2*F2
H2=D2
I2=Best Fit Constants :: $D$1+Best Fit Constants :: $D$2*H2
select F2 thru I2 and fill down as needed. Expand the graph range by selecting the chart,
then dragging the data range controls (in the table) to include the best fit data
This helped, I created points from a best fit line on table and included them on chart but they showed as additional, differently colored circles as opposed to a line. Wondering how to plot as a line with no points shown.
select the series on the chart, then open the Charts Inspector and change the series symbol to none, enable "Line between Points":
Nice work around. But, again, something not available on iOS. Thanks 🙂
The INDEX and LINEST functions are available on iOS and do work. I just tried it. I'm not sure how to post pictures to the forum, but once I discover that I will post some pics.
Not the easiest especially when adding a trendline on Excel is a mouse click away.
Just realised that these are the same as the SLOPE and INTERCEPT functions, which IS EASIER.
So, has a trend line option ever been added to Numbers for iOS?!
Could not find one this morning!
(Not interested in work-arounds!)
How do I add a trendline in numbers for IPad?
