$$Excel-Macros$$ MS EXCEL 2007 and Significance Testing

2011-09-29 Thread Sarah Seager
I have data from two surveys. One survey was completed on 900 people before a certain event happened, and then a second survey was completed on a further 900 people after an event happened. I need to calculate the % difference between the two whilst looking at the demographics of the individuals.

$$Excel-Macros$$ Macro to put singles years of age into five year age bands

2011-06-08 Thread Sarah Seager
Hi, I regularly have to look at raw data that shows me the age of people. However for most of my analysis I have to convert these ages into 5 year age bands (0-4y, 5-9y,.75-59y, 80-84y and 85+) The column that my ages is in is never the same, so I'd like my macro to run on whatever cells I se

$$Excel-Macros$$ Help! Filtering/subtotal issue in Excel2007

2011-06-01 Thread Sarah Seager
I'm not too sure if Excel is the best thing to do this in but I thought I'd ask anyway. What I've got is a spreadsheet of raw data. In one field I have a unique identifier of a person, in the next field I have some codes which refer to the course of immunisations they have had and then there's an