Regression Analysis

[AndrewKent]

Hi there,

I have just created a Regression Analysis Graph in Excel and it has given me the following formula:


y = -4E-05x2 + 0.0005x + 0.2848
R² = 0.5639

How do I express "4E-05" in a cell? What actual number is this as I don't know what the "E-" section dictates?

Kind regards,

Andy

 

[VoG]

You can just enter that. It equals -0.00004

 

[shg]

If you instead use LINEST, you can get the whole precision of the coefficients on the worksheet. In a 3-cell wide range, array-enter

=LINEST(y, x^{1,2})

... where x and y are named ranges that refer to your independent and dependent variables.