I'm using Microsoft Office Excel 2007 for some statistics work for school. I made a linear trendline on a graph corresponding to a data set. This is what it looks like:
The data set in question is 4pcmm. All looks well.
However, the equation of the trendline is off. For example, if we calculate it at an X position of 50:
y = (4538.1 * 50) + (1 * 10^6)
Punch this into Excel (or just a calculator) and we get 1,226,905. However the graph clearly shows that at 50, the line is above 1,600,000. Hell, the line never even goes below 1,400,000.
So what's going on? Have I screwed something up or is it Excel which is at fault? And how do I fix this?
81 Answer
I would guess that the format of the trendline number is just funny.
Under layout tab on ribbon select 4pcmm trendline label and click format selection.
In the box that comes out go to number (up by default) and it should have general selected. Change this to scientific (or whatever you want) and set the demimal places to 4. It should change your formula to
4.5381+E03+1.4500+E06 or something similar. If you only want one number behind the E change format code to 0.0000E+0 and then click add.
Number format with less decimals (0 or 1) would also be a good selection
1
