8/4/2023 0 Comments Deltagraph linear regressionFor plotting and simple curve fitting, I'll echo a previous poster and suggest DeltaGraph (I believe it's actually It is spreadsheet-based, offers a great deal of flexibility, such as saving plot templates (good if you plot the same things over and over), and it permits user-defined functions (so that if it doesn't have a curve fit you want, you can define it yourself). I haven't even been able to figure out how to change the symbol size in a line or scatter chart!Īlthough Excel has some of the features you want, I've always found Excel very unpleasant and painful to use for plotting scientific data. Trend lines, error bars, connecting lines, and other simple but important aspects of scientific data plotting are not available in Numbers. Unfortunately, as pointed out above, Numbers is not suited to scientific applications at all. I'm also a scientist - I spend a great deal of time visualizing spectral data. In each cell under the "predicted Y values" column, multiply the data in the "X" column times the value in the "SLOPE" cell and add the value in the "INTERCEPT" cell.įinally, select all 4 columns of your data and choose scatter plot and two superimposed graphs should emerge - one with your data and the other with the regression line. The second will be the "predicted Y values" based on the slope and intercept. The first additional column should be a copy of your "X" column. Third, go back to your data and create two more columns adjacent to the first ones. These 2 values will create the intercept and slope of your regression line (Y = slope * X + intercept). Then, in the next column (or a separate table if you choose) use the functions INTERCEPT (y range, x range) for one cell and SLOPE (y range, x range) in the next cell. This can be done relatively easy in Numbers.įirst make two columns of your data (X and Y). Sounds like you are trying to make a regression line - a line which represents the correlation between x and y which you can use visually to determine how close your data approximates that prediction. Even still how can I use numbers to detect points of inflection or other significant mathematical occurances in graphs. Is this possible and I'm missing something? Or is numbers really not that useful to me?Īlso how would I take this line, which generally represent the trend of my data, and find things such as the derivative or tangent equation of a range of data. I can't figure out how to do this in numbers, and it is absolutely essential for almost every reason I use spreadsheets. Normally when you create a scatter plot you can select to add a Trendline, namely a line which seeks to match the pattern of your data, giving you an equation for this line. Seems like this is a pretty annoying issue with ease of use, since even if I did take those 2 said columns and copied them to be next to each other this is only cluttering and disorganizing the tables.Īnother issue I have, which is much larger and could possibly make me not use numbers past the trial is chart and data analysis ability. It seems as though this is trivial, and that it might just be better to arrange the columns manually, but the bigger issue is that there will be instances when two columns need to be graphed and they are not even next to each other. I spent about an hour trying to figure out how to switch this, that is to directly specify which column is on which axis rather than simply having the first column be the x-axis. This doesn't make any significant sense, since it needs to be the other way around (pH on the y-axis). When I highlighted these and selected a scatter plot, it placed the pH on the x-axis and the Volume on the y-axis. More specifically one column, say A, is pH and B is Volume Added. So I have 2 columns, each containing numbers that correlate with each other that I want to graph.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |