Using Microsoft Excel for survey data.?

Question

I'm doing a survey in school and I've got hundreds of responces. The basic idea of the survey is to identify a specific type of music the person listens to then analyze behavior characteristics. I'm thinking about doing this on Microsoft Excel, since most of my data is numerical, and putting it on a spreadsheet. Can you give me some general help and suggestions, as I don't regularly use Excel and am not especially familiar. I think you can do stuff like averages but I'm not totally sure...Thanks for the help.

Answer 1

I know that this is going to sound like a cop out, but what i would really suggest for you is to go to the library and checkout excel for dummies. there are so many great ideas in that book that it'll have you setting up your tables in no time.

Honest!!

Answer 2

Excel includes some statistical analysis functions for Marketing Research. These may be a little cumbersome if you do not know how to fill in the data. However, there are simple functions you can use. These functions are accessible by clicking the dropdown arrow on the greek "E" button. Normally the formulas you click on will show you what data is needed.

You want to layout your information in columns such as:

Name Rock Jazz Blues ....

At the bottom of each Genre you can do


=Average(start_cell:end_cell)

The ":" is very important between the starting and ending cell names.

Answer 3

to verify that the alternative pointers to no longer become unattached, you ought to bypass with each and all the tips purely before you do the "sort..." choose ultimate left cellular, keep down shift and ctrl, press the final suited arrow key, then down arrow key. it is quickest answer to bypass with all of it.