FAQ/E - CBU statistics Wiki

Upload page content

You can upload content for the page named below. If you change the page name, you can also upload content for another page. If the page name is empty, we derive the page name from the file name.

File to load page content from
Page name
Comment
Type the odd letters out: ONlY twO thinGs aRE infiNite

location: FAQ / E

What does 'E' stand for?

Numerical output from SPSS and other packages sometimes features a numeric decimal followed by an 'E' which in turn is followed by a number. This simply means 'to the power of 10'. e.g. $$2.3E-1 = 2.3 x 10text{-1}$$ = 0.23 and, conversely, $$2.3E+1 = 2.3 x 10text{+1}$$ = 23.0.

Some programs also output a 'D' which means the same thing.

  • There is a scripting program available. Just cut and paste the syntax into a scripting window, click on pivot table with the 'E' notation and run.

In EXCEL 2007 you can remove the single precision 'E' in a cell and convert to a more interpretable decimal by going to the cell (or highlighting a range of cells) and clicking Home, choosing format in the 'cells' section, choosing format cells in the resulting toolbar and clicking the Number tab. Choose the number of decimal places you would like and then click Custom, choose 0.00 and click OK.