Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Supported by

very large numbers in descriptives

Hi all. I have a data set which includes country population. I run a descriptives, getting sum of population split by arearegion. The output table has the sums in scientific notation, e.g., Africa shows as 1.375e+9. If I copy the table to a spreadsheet, the number underlying the one showing in scientific notation is rounded, in this case 1375000000. The sum -should- be 1375397882. I'll (try to) attach the data set. Can JASP show the numbers without scientific notation or rounding?

Thanks

Gene

Comments

  • Hi Gene,

    Thanks for reporting this and thanks for adding a helpful example!


    When you copy a table, the idea is that you can directly copy it to a manuscript. As such, the copying preserves the exact formatting as done in the table. So when you see this table:

    if you copy it, you get exactly that table. To obtain more decimals, you can go to the menu->Preferences->Results and check `Fix the number of decimals` and set the value to 50:

    After you do this, all tables in the JASP file are updated to reflect this change. In your example, I now see this table in JASP:

    If I copy this table to Libreoffice Calc, I get non-rounded values:

    It would make sense to make a distinction between "copy table with formatting" and "copy table values", I'll discuss that with the team.


    It is not possible to disable scientific notation entirely, because otherwise values like 1e+300 can no longer be displayed on a normal screen.


    I hope this helps, if you have any more questions let me know!


    Cheers,

    Don

  • Thanks very much. It takes me several steps to get the table with the actual values, but i got there, and it looks good. Thanks.

    Gene

Sign In or Register to comment.