How to Understand and Use a Chart Equation in Excel

Hello Experts!!!

In Excel,  I created a Polynomial Trend Line for a column chart.  The equation for this trend line is:

line equation
This may seem like such an easy question, but how do I put this into use in Excel, so that I can plug in X and get Y?  I forget what the "E" is in the equation... I don't know how to read the equation in layman term.

Thanks!!
dunkin1969Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ken ButtersConnect With a Mentor Commented:
When you create a chart... generally you have to have a series of data to put in the chart.

What I did was create a table with your equation in each cell in the "Y" column.

that way it will give you the value for "Y" for any value you plug into the X column.

Then given a series of data points.... you can create an X Y scatter chart that shows the relationship between X & Y.

See attached spreadsheet.
ee-chart.xlsx
0
 
Harry LeeConnect With a Mentor Commented:
dunkin1969,

I always doubt the usefulness of the excel equation myself.

Anyway, the 2E-09 is 0.000000002, and 2E-7 is 0.0000002, and the 3E-05 is the scientific notation of long decimal number. Basically, it's 0.00003.

If X is in column A, and Y is in column B starting in row 2, you can put the following formula in B2 to calculate the Y based on X in A2.

=(0.000000002*A2^4)-(0.0000002*A2^3)+(0.00003*A2^2)+(0.0002*A2)+0.0012
0
 
dunkin1969Author Commented:
Thanks Harry for the explanation !!!

And Thanks Ken for the spreadsheet with the equation put to use!!  That really helped me see how the equation works!!

AAA+++++++
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.