What variable do you insert for X-cel if there is missing data?
We are entering data on questionnaires completed by parents and drawing
graphs from these. However, where data is missing X-cel gives a value of 0 which is scewing results. We are wanting to know what variable to use for missing data. |
If you enter "#N/A" (without quotes) or the formula =NA(), then that
will be ignored in the chart display. In article , "Iop.kcl" wrote: We are entering data on questionnaires completed by parents and drawing graphs from these. However, where data is missing X-cel gives a value of 0 which is scewing results. We are wanting to know what variable to use for missing data. |
All times are GMT +1. The time now is 08:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com