Forum Discussion
Descriptive stats on aggregate survey data
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...
- Nina KaktinsFeb 09, 2017Copper Contributor
Ha, talk about an unhelpful 'description'!
Descriptive stats are measures of central tendency and variability, e.g. mean, median, SD, etc.