Analyse-it examines the number format applied to the worksheet cells to infer the precision (number of decimal places) of the observations. If no number format, or the Excel General format, is applied Analyse-it will scan the observations and automatically determine the number of decimal places used. Statistics for the variable are then presented based on the precision of the observations (see Presentation precision).
Number formats can be applied to Excel cells as usual, though Analyse-it provides a convenient way to quickly format all the observations of a variable.
To set the number of decimal places:
To apply a custom Excel format to a variable:
We've been developing intuitive high-quality statistical software at an affordable price, backed up by fast friendly customer service for over 25 years...
Read more about us
Office hours: 9am-5pm GMT Mon-Fri