|
Size: 607
Comment:
|
Size: 607
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 3: | Line 3: |
| 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 10$$text^{-1}$$ = 0.23 and, conversely, $$2.3E+1 = 2.3 x 10^text{+1}$$ = 23.0. | 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 10^text{+1}$$ = 23.0. |
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 [http://pages.infinit.net/rlevesqu/Scripts/PivotTables/UndoSciNotation.txt scripting program available]. Just cut and paste the syntax into a scripting window, click on pivot table with the 'E' notation and run.