Purchase Solution

# Utilizing MS Excel and SPSS in Managerial Decision-Making

Not what you're looking for?

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 Summary

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

##### 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 ...

##### Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

##### Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

##### Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

##### Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.