I received an error message “Error: Empty variables; attempt to divide by zero.” Whats wrong?
A. If your spreadsheet has rows or columns that are all zeros, many analyses will fail because in the underlying math, something is divided by sums or sums of squares that equal zero. In general you should check for empty rows and columns before running analyses. The easiest way to spot these is to run the Row & Column Summary under “Summary”. A related problem is when a column has a variance of zero (all values are the same in that column). Any analysis requiring division by the variance or standard deviation of that column will, therefore, produce an error message.
Related Questions
- In my first attempt to attend a webinar, I received an error message that said my computer is not configured to receive the Elluminate software. What do I do?
- I received a "Floppy disks fail (40)" error message while booting up the computer. What can be wrong?
- I received an error message "Error: Empty variables; attempt to divide by zero." Whats wrong?
