You are viewing part of the Analyse-it for Microsoft Excel user-guide. When you have read this topic we recommend you view contents of the user-guide or you can read more about Analyse-it, our statistical analysis software for Microsoft Excel.

---

Open topic with navigation

Presenting a proportion as a percentage

By default proportions and probability values, since they range between 0 and 1 only, are presented to 3 and 4 decimal places respectively. They can be presented as percentages if necessary.

To show a proportion or probability as a percentage:

1. Select the cell containing the statistic.
2. Click on the Home tab/Standard toolbar.
3. The statistic is presented as a percentage. The number of decimal places shown can be changed if necessary (see Changing the presentation decimal places).

NOTE Changes to cell formatting will be lost when the report is updated.

Add to: del.icio.us | digg it! | Stumble upon

Part of the Analyse-it for Microsoft Excel user guide. For more information about Analyse-it, the statistics add-in for Microsoft Excel, or to download a free 30-day trial please visit http://www.analyse-it.com/. © Analyse-it Software, Ltd. Analyse-it® is a registered trademark. Microsoft® Excel® is a registered trademark of Microsoft.