Formula to implement a regression equation

[dross]

I created a scatter chart of some data and the equation returned was:

y = 7E-24x12.666 <tbody> </tbody> <style>table { }.font5 { color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { color: black; font-size: 11pt; text-align: center; vertical-align: middle; }</style>

<tbody>

^</tbody>

^{I'm having trouble constructing a formula for this equation. What would the Excel formula be if I wanted to solve for y with an x of say 94?}

 

[Momentman]

I created a scatter chart of some data and the equation returned was:

y = 7E-24x12.666 <tbody> </tbody> <style>table { }.font5 { color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { color: black; font-size: 11pt; text-align: center; vertical-align: middle; }</style>

<tbody>

^</tbody>

^{I'm having trouble constructing a formula for this equation. What would the Excel formula be if I wanted to solve for y with an x of say 94?}

<sup>Does SUP mean Superscript?

Then Y = 7e-24*(X^12.666), so if X is cell A1, then place 94 in A1</sup>

 

[dross]

Yes, SUP is Superscript. Thanks for your help, that did it.

 

[Momentman]

Yes, SUP is Superscript. Thanks for your help, that did it.

You are welcome