Purchase Solution

Interpreting and Using Survey Data from Excel

Not what you're looking for?

Ask Custom Question

1. Describe ways in which the use of MS Excel as a tool for interpreting data can be used by a manager of an organization.

2. What potential legal and ethical issues could arise if the information gained in this survey (attached - job satisfaction survey) was used to create an ideal profile of characteristics that the company looked for when hiring employees?

- Survey database attached
- Cite any sources used

Purchase this Solution

Solution Summary

This Solution contains over 1000 words to aid you in understanding the Solution to these questions.

Solution Preview

Good Morning from Cleveland, Ohio.

Glad to help you out amd let's see if we can shed a little light on the issue you have presented with respect to Excel. However, before delving right into the matter a little pre-emtive information is necessary. Don't worry it won't hurt! :-) The information I am about to share with you will help you in future issues dealing with all sorts of questions regarding the broad area of data interpretation. OKAY..hang on because here we go.

Whenever you are confronted with a situation involving numeric data of any kind you must first decide if you want to "describe" what is going on from the numeric data you collected or you want to "infer" from what is going on. When you want to describe what is going on from the numeric data you have collected you can use what are called "descriptive statistics. On the other hand when you want to infer or determine what differences occur in a situation that you are investigating you must use what are called "Inferential Statistics". With me so far? :-) Each of these methods, thanks to our wonderful wolrd of advanced computer programming, uses specially designed computer programs. To infer for the numerical measurement data what is available are programs suck as SPSS, SAS, and a host of other closely related computer programs. Now...if you want only to describe what the numerical data looks like without drawing inferences from the data you have collected you can use the tried but true good ole Excel! Sure wish all these programs were available when I was in graduate school as it would have made my life a lot easier and more time to party ;-) Oh well...I am making up for it now! :-) lol Okay...are you clear now when and what to use when you collect a bunch of numeric data? Good...let's go on.

Follow closely now as what I am about to present about Excel will include both the pros and cons of using this program when dealing with surveys.

What's the best way to analyze survey data with Excel? My advice: don't try! A statistical program is much better: something like SPSS, Statistica, Epi Info, SAS, Minitab, or many others. But, I don't advise you to tell your professor this or he/she might not like ...

Purchase this Solution

Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.