A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Formula in A2 is: =-0.078*A2^2+22.59*A2-125.52
best wishes
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello all, I hope you can help me, as this problem is driving me up the wall!
I have a series of quadratic (2nd Order polynomial) equations that I want to plot as a graph.
For example, I have one which is -0.078x^2 +22.59x - 125.52 between the x-values of say 0 and 180
Is there a way to do this? Any help would be greatly appreciated.
Thank
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Formula in A2 is: =-0.078*A2^2+22.59*A2-125.52
best wishes
Answer accepted by question author
> I have one which is -0.078x^2 +22.59x - 125.52 between the x-values of say 0 and 180
Hi. A slightly different way is to pick 3 points for a polynomial.
A good axis for your range might be 0, 50, 100. (or 0, 100, 200)
Use the equation to get the y value.
Do a scatter chart, but select the choice that does "Not" connect the lines.
Now, add the polynomial Trend line. Forecast it out another 80 points to get to 180.
The idea here is that you can extend the graph forward and back without having to add any additional calculated cells. Just the 3 cells above. :>)
Answer accepted by question author
Hi,
an alternative option, through geogebra app. and spreadsheet.
pic1
pic2
pic3
pic4
Another alternative to Excel is Microsoft Mathematics 4 - a free application.
best wishes