453
Comment:
|
606
|
Deletions are marked like this. | Additions are marked like this. |
Line 7: | Line 7: |
* 1. [:FAQ/Escript:There is a scripting program available to do this.] | * There is a scripting program available at http://pages.infinit.net/rlevesqu/Scripts/PivotTables/UndoSciNotation.txt Just cut and past the syntax into a scripting window, click on pivot table with the 'E' notation and run. |
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 10$$text{-1}$$ = 0.23 and, conversely, 2.3E+1 = 2.3 x 10$$text{+1}$$ = 23.0.
Some programs also output a 'D' which means the same thing.
There is a scripting program available at http://pages.infinit.net/rlevesqu/Scripts/PivotTables/UndoSciNotation.txt Just cut and past the syntax into a scripting window, click on pivot table with the 'E' notation and run.