View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lizzystien
 
Posts: n/a
Default How do I use equation of a line to calculate x-values from known .

I have an xy scatter plot constructed and created a polynomial function for
the line. I want to use the equation obtained to calculate the expected x
values from 75 different y values without punching it all into a calculator.
I know there is a way to do this on excel, but it's been awhile, anyone
willing to be a teacher?