Collecting information for reports is simple compared to the more difficult task
ID: 369094 • Letter: C
Question
Collecting information for reports is simple compared to the more difficult task of interpreting data. To make data meaningful and useful, you must accurately sort, analyze, combine, and recombine the information, looking for meanings, relationships, and answers to the questions you posed in your work plan.
Consider the following scenario, and then use the table to help you answer the questions.
Joseph, the president of Hubbard Inc., decided to conduct a survey for a report on employee satisfaction. The information he collected follows.
1. How can Joseph simplify the data in the table?
Delete the total number of responses.
Combine categories.
Add another column.
2. How can Joseph make the data in the table more meaningful?
Cross-tabulate the data.
Design a more complex table.
Eliminate the percent column.
Read the following scenario, and then use the table to help you answer the question.
You are a human resources manager sorting through data for a report on employee satisfaction. Several employees you interviewed mentioned they were experiencing neck and back pain. They suggested the company look into having an ergonomics consultant visit the office and conduct an evaluation. You choose to use a survey to get measurable qualitative and quantitative feedback. You ask the employees to respond to the following statement: “Our company should have an ergonomic consultant conduct an evaluation of all office equipment.” The following table reflects the survey results.
Total
Male
Female
3. What percentage of men do not think an ergonomic consultant should evaluate their office equipment?
35.4 percent
10.2 percent
Consider the following scenario, and then use the table to help you answer the questions.
You work in HR and your supervisor has asked you to prepare a report on starting salaries within your company. You gather the information in the following table.
4. How do you calculate the mean for the starting salary data in the table?
Subtract the lowest salary from the highest, and divide by the total number of positions.
Add up all of the salaries, and divide by the total number of positions.
Add the highest and the lowest salary, and divide by the total number of positions.
5. What is a median?
The low point in a group of figures arranged from lowest to highest (or vice versa)
The high point in a group of figures arranged from lowest to highest (or vice versa)
The midpoint in a group of figures arranged from lowest to highest (or vice versa)
6. What can identifying a correlation do for your research?
Guide the design of grids or decision matrices.
Aid in the calculation of the mean and mode.
Present possible solutions to be explored.
Consider the scenario, and then use the matrix to help you answer the question.
You are interested in hiring an ergonomics consultant to evaluate your employees’ desks and chairs. You research four consultants and then decide to use a decision matrix to help you determine the best one.
7. Which consultant has the highest prices and the lowest positive feedback rating?
#2
#1
#3
Opinion Number Percent Very satisfied 36 17.8 Satisfied 45 22.2 No opinion 25 12.4 Dissatisfied 56 27.6 Very dissatisfied 40 20.0 Total 202 100.0Explanation / Answer
1.Joseph can simplify the data by combining categories. Like marrying very satisfied an satisfied and marrying dissatisfied and very dissatisfied , it will reduce the dimensions for the data.
2.Yes it can be made more meaningful by cross-tabulate the data. Like dicing the responses in to male or female or by age groups.
3.The percentage is 10.2. It is the percentage of man who strongly disagree and count of opinion is 26.
4.I will perform average function on the salary column , which will give me mean of starting salary in the table.