Share via

How to draw a Quadratic/Polynomial graph when you have the equation

Anonymous
2015-05-11T17:12:06+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments No comments

Answer accepted by question author

  1. Anonymous
    2015-05-11T18:50:51+00:00

    Formula in A2 is: =-0.078*A2^2+22.59*A2-125.52

    best wishes

    2 people found this answer helpful.
    0 comments No comments

Answer accepted by question author

  1. Anonymous
    2015-05-12T01:09:49+00:00

    >  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.  :>)

    1 person found this answer helpful.
    0 comments No comments

Answer accepted by question author

  1. Anonymous
    2015-05-12T17:43:49+00:00

    Hi,

    an alternative option, through geogebra app. and spreadsheet.

    pic1

    pic2

    pic3

    pic4

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2015-05-12T19:02:45+00:00

    Another alternative to Excel is Microsoft Mathematics 4 - a free application.

    best wishes

    0 comments No comments