Menu ENN Search
Language: English Français

Existing excell spreadsheets for cross tabulation of nutrition data?

This question was posted the Assessment forum area and has 1 replies. You can also reply via email – be sure to leave the subject unchanged.

» Post a reply

Anonymous 1722

Normal user

21 Nov 2012, 10:26

Hi there,

I am about to start analysing a large amount of nutrition data, and would like to prepare an excel spreadsheet with cross tabulations between one question and another, for example analysing the household food security score with levels of acute malnutrition in children U5. Are there existing nutrition-specific spreadsheets which take this into consideration, or any recommendations about how to begin the analysis? My experience is limited, and appreciate support/recommendations. Thank you

Mark Myatt

Consultant Epideomiologist

Frequent user

21 Nov 2012, 21:57

I would not use Excel for data analysis of large datasets. Such analyses are prone to error that can often go unnoticed and there are quality issues with Excel's numeric libraries. Analysis of data using Excel is not acceptable by regulatory authorities. I think it is OK for simple analyses but would avoid it for multi-variable analyses. I think that you would be much better off using a package such as SPSS or (for free) EpiData ANALYSIS or EpiInfo.

Back to top

» Post a reply