Help to explain Regression equation

[D_Spark]

I have complied a regression analysis and the chart has provided me with and equation

y = 5E+06x - 5E+06


can some please explain this and also what simple excel formula will provide me with the Y value if "x" where to equal 4

 

[VoG]

The slope is 5,000,000 and the intercept is -5,000,000. Example

Excel Workbook
	A	B
1	10	45000000
Sheet1

 

[D_Spark]

thanks for the input, but where is the reference to "x" value which is "4"

 

[VoG]

For x=4

Excel Workbook
	A	B
1	4	15000000
Sheet1

 

[D_Spark]

thanks VOG

y = 5E+06x - 5E+06


so the 06 is the power of 10 that the 5 needs

eg (5 with 6 zeros behind it ?)
i.e 5000000

then multiplying this value with 4
then subtracting 5000000

 

[VoG]

Yes, exactly.

If you right click the equation displayed on the chart you can select Format Trendline Label and display as number instead of in scientific notation.