Question 1 – Will That Be a Table or a Graph? Here are three business scenarios, each one requiring that you determine the most effective design for communicating a quantitative message. For each one, decide whether the message should be presented as a table or a graph. Provide a rough sketch or template of what it should look like. Scenario #1. You’ve been given a contract by a large manufacturing facility to analyze worker productivity data to see whether you can identify the cause of a recent decrease in productivity. What you learn from the new Operations Manager is that no matter how many additional people he hires, the result is reduced productivity. When the Operations Manager was hired six months ago, the General Manager told him that productivity had remained flat for years, and it was his job to increase it by 20% during the coming year. So far it has actually decreased by 20%. After hearing this summary, one of the first things you decide to examine is the possible connection between staff additions and productivity decrease. From your years of experience, you are not surprised to discover that increases in staff were proportionally related to decreases in productivity. You suspect that the addition of workers without changing anything else about the manufacturing process or facilities may have resulted in people simply getting in each other’s way. You decide your first step is to show the Operations Manager the strength of this relationship of increased staff to decreased productivity. You have monthly headcount and productivity statistics for the last year. Both headcount and productivity remained fairly steady until just after the Operations Manager’s arrival. In what form will you present your information? Scenario #2. Your company has a brand new database with comprehensive and reliable sales information. You have been investigating important questions that you have never been able to answer before. One query involved a list of every single order from the past year, sorted by size in dollars from the biggest to the smallest. You divided your list into 10 equal groups of 10,000 orders each and labelled the groups Top 10%, Greater than 10% through 20%, and so on, to the final labelled Bottom 10%. Then you calculated the running percentage of total revenue associated with the orders beginning with the largest order and continuing all the way to the smallest. That way you could easily see the amount of revenue that each group of orders contributed to overall revenue. You were amazed to discover that the top 10% of your orders contributed 87% of your total revenue. After the top 10%, the revenue contribution of the remaining 90% of your orders dropped off dramatically, with the last 50% contributing only 1% of your total revenue. You want to present his message as concisely and clearly as possible to executive management. They have a short attention span so you need to show this important revelation in a single page of information. What form will you give to this information to ensure that it hits the mark? Scenario #3. You have been promoted from Director of Customer Service to Vice President of Services. Before you were able to move full time into your new position, you had to recruit someone to replace you as director. Your company spreads the work of customer service across four different customer service centres, one in each of four major geographical regions. Customers are able to rate their experiences with the service centre by responding to surveys distributed by email. Because you want the new director to focus on improving the centres that are scoring lowest in customer ratings, you need to provide her with the mean rating of service for each service centre during the most recent quarter. In what form will you present these summarized ratings? Q2: a) The final marks in an undergraduate course are normally distributed with a mean of 70 and a standard deviation of 10. The marks must be converted to letter grades. The guidelines require 10% A’s, 30% B’s, 40% C’s, 15% D’s, and 5% F’s. Determine the cut-offs for each letter grade. Round to the nearest integers. Do not use overlapping endpoints. Use the following format. Grade Mark Range A ?? to ?? B ?? to ?? C ?? to ?? D ?? to ?? F ?? to ?? b) For the normal distribution in part a), what percentage of grades are 85% or higher? c) Give a symmetric range within which about 95% of the grades would lie.