very large numbers in descriptives

maffydoit

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?

ShortDataSet.csv

Thanks

Gene

vandenman

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

maffydoit

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