Share
Explore BrainMass

Utilizing MS Excel and SPSS in Managerial Decision-Making

Research Microsoft Excel, the statistical package for the social sciences (SPSS), and the legal and ethical aspects of surveys and data collection. Answer the following questions separately and completely:
•Describe ways in which MS Excel can be used by a manager of an organization as a tool for interpreting data.
•What are the major benefits to using the statistical package for the social sciences (SPSS) software?
•What potential legal or ethical issues could arise if the information gained in a survey was used to create an ideal profile of characteristics that the company looked for when hiring employees? Include references in APA style.

Solution Preview

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

Microsoft Excel is a powerful application in analyzing and interpreting data.
The application has descriptive and inferential statistics capabilities and can be used by managers to analyze data.
On Descriptive Statistics
- You can create simple to complicated formula such as mean, median, mode, standard deviation.
- Managers can also make use of Pivot Tables or rearranging the data sheet
- Data can also be summarized into charts and graphs.
- Scenario building can also be applied by managers using the what-if-functions.
On Inferential Statistics
- It is also capable of inferential statistical analysis such as t-test, correlation, z-test, among others.

•What are the major benefits to using the statistical package for the social sciences (SPSS) software?

I have been using SPSS for a ...

Solution Summary

These are suggestions on how managers can use MS Excel and SPSS in data analysis and interpretation.

$2.19