Forum Discussion
Descriptive stats on aggregate survey data
Hello,
I am trying to run descriptive stats on aggregate pre and posttest survey data. I highlighted the pretest data, and selected descriptive statistics. However, instead of providing descriptive stats on the entire survey, the results only give descriptives on each item in the survey.
In Excel, is there a way to obtain descriptive stats on all the columns/rows combined, i.e. aggregate data; I need the group descriptive statistics on the entire survey.
I did try to use the 'group' function prior to running descriptives, but this didn't work...
Thank you in advance for any help you can give.
3 Replies
Okay, I think I figured out how to do this.
I obtained the average for each survey item by highlighting item data, and selecting average. The calculation appears in the cell below each column of data. Then, I selected descriptive statistics, and highlighted the 'averages' in the row at the bottom of survey data. I selected 'row' in the descriptive statistics choices of column or row. This provided the descriptive stats for the entire survey...
Yea!!! Perhaps there are other ways of doing this...but if so, I couldn't figure it out. I'm used to working with SPSS, where you can just highlight all the survey data to obtain descriptive stats on group, multiple item surveys.
I hope this helps someone else...I didn't give the locations of where to find average, descriptive stats, etc., but thinking folks who need the answer to my question probably already know this. I'm just happy to have a relatively simple way to do this in Excel...
- I even asked Google what the descriptive stats is. The best definition was "Descriptive statistics are just descriptive"
Ha, talk about an unhelpful 'description'!
Descriptive stats are measures of central tendency and variability, e.g. mean, median, SD, etc.
