Gauge I. Directions: Read Carefully each item. Use a separate sheet for your answers. Write only the letter of the best answer for each item. For items 1-5, analyze and interpret the graph in figure 1 Annual Sales Growth 30.0% 20.0% 10.0% 0.0% -10.0% -20.0% -30.0% -40.0% Figure 1 2011-12 sales growth % 2012-13 sales growth % 2013-14 sales growth % 2014-15 sales growth % -Co. A -Co. B -Co. C -Co. D -Co. E 1. Which company have 0% increase in sales? A. Company A B. Company B C. Company C D. Company D 2. Which company is at risk of bankruptcy? A. Company B B. Company C C. company D D. Company E 3. Which company is the best choice if you are to invest based on annual sales growth? A. Company A B. Company B C. Company D D. Company E 4. Which company had a constant decrease of sales growth for the past 4 years? A. Company A B. Company B C. Company D D. Company E 5. Which company have experienced fluctuating annual sales growth? A. Company A B. Company B C. Company C D. Company E II. Directions: Write TRUE if the statement is correct, write FALSE if otherwise. 6. One of the main reasons why business owners use Excel is for handling data, 7. The intersection of the column and row is called Cell. 8. A workbook is also called spreadsheet. 9. When you click the menu bar, you will see the toolbar. 10. The filename of the spreadsheet can be seen in the title bar. 11. The column heading is named by a letter or a combination of letters. 12. A workbook has three worksheets as default setting. 13. The menu bar displays all the menus in vailable for use in excel. 14. The name box shows the information in a current cell. 15. The Formula bar shows the address of the current selection or active cell. III. Give at least 5 advantages of using Excel in computing and presenting business data.
Added by Shan C.
Close
Step 1
Without the graph, it's impossible to answer questions 1-5. II. Show more…
Show all steps
Your feedback will help us improve your experience
Shu Naito and 95 other Probability educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
Circle the most appropriate answer from the multiple choices: 2.1) What is the ARMI model used for a. Helps the team identify threats and opportunities b. Helps to form the team c. To ensure the team has identified critical people with respect to the project d. Identifies what problems to address first with respect to the team 2.2) Stakeholders that could help define a project charter include: (a) Customers, suppliers, and management (b) Work breakdown structure and planning (c) Metrics and project plan elements (d) Benchmark partners and risk takers 2.3) Problem and goal statements should (a) Include the customers CTQ (b) Address a possible solution (c) Specifically define the problem (d) Be based on assumption since it’s early on in the project 2.4) By integrating Six sigma methods and tools with their design, companies have experienced the following: (a) Reduced warranty cost after launch (b) Reduced early-life failures (c) Increased customer satisfaction (d) All the above 2.5) Which of the following best describes a team that has members with different skills or roles from different areas within the organization? (a) Self-directed (b) Cross-functional (c) Parallel (d) Process 2.6) When selecting a project, priority should first be given to a project that: (a) Only affects employees in the work cell (b) Has objectives that align with organizational goals (c) Is expected to be completed within one week (d) The solution is readily apparent before the project is started 2.7) The SIPOC process map provides a high-level view of the process which preferably should contain how many steps? (a) 21-40 steps (b) 16-20 steps (c) 6-15 steps (d) 4-5 steps 2.8) You are attempting to improve the customer experience provided by a call center for a budget airline (telephone support). As a result, you should build a list of CTQs based on: (a) Size of unit (b) Cost (c) Service benefits defined by customers (d) The Voice of the Business 2.9) The boundaries of a project are contained in the: (a) Problem statement (b) Project scope (c) Goal statement (d) Resources required 2.10) In order for a problem to be solved correctly, which of the following must occur first? (a) The problem must be defined (b) Relevant data must be gathered (c) The measurement system must be validated (d) The process must be mapped 2.11) One of the most common measures of variability in a data set or population: (a) Process capability (b) Specification limits (c) Mean (d) Standard Deviation 2.12) An improvement process in which a company measures its performance against that of best-in-class companies, determines how those companies achieved their performance levels, and uses the information to improve its own performance (a) Control Chart (b) Six Sigma (c) Benchmarking (d) Cause and Effect Diagram 2.13) The Define phase is the first phase of Six Sigma's DMAIC process. If this phase is not planned for and carried out thoroughly, a project may stall and not transition to other phases successfully. Which of the following project statements is well-defined? (a) Reduce the reject rate of service B from 30% to 10% within 2 calendar years (b) Improve employee morale by increasing cooperation (c) Encourage vendors to pay their invoices on time by threatening legal action (d) Launch a nationwide CEO recruitment campaign 2.14) The most important aspect of functional requirements is that they (a) describe a single, measurable performance (b) describe how a product or service should operate (c) be traceable to the voice of the customer (d) provide upper and lower performance limits 2.15) The number of calls that arrives at a call center each day has a normal distribution with an average of 500 and a standard deviation of 25. The number of incoming calls for 1000 consecutive days is recorded. What is true about the collected data? (a) In roughly 95% of days, the amount of calls is between 475 and 575 (b) The standard deviation is roughly equal to the median (c) In roughly 68% of days, the amount of calls is between 495 and 505 (d) In roughly 50% of days, the amount of calls is below 500 2.16) The purpose of a QFD is to (a) Relate the customer CTQ to measurable sub-processes or product characteristics (b) To create a shared view of the process (c) To provide a structure for finding the causes of an effect (d) To provide a quantitative view used to identify a focus area 2.17) In the Measure phase, one of the things you do is (a) Develop a team charter (b) Establish Process Capability (c) Define performance standards (d) Define performance objectives 2.18) In a QFD, who prioritizes the customers’ needs? (a) A cross-functional team of you and the customer (b) The project team (c) The stakeholder who has to pay for the improvements (d) The customer 2.19) A process map is used in the Define stage to identify/document: (a) Defects (b) Top-Level Process (c) Stakeholders (d) A & B (e) B & C 2.20) Key Methods/tools for Voice of the Customer (VOC) are: (a) Brainstorming, Surveys, Interviews (b) Surveys, Brainstorming, Benchmarking (c) Benchmarking, Surveys, Interviews (d) Interviews, SIPOC, Benchmarking
Ameer S.
For Problems $7-18$, please do the following. (a) Draw a scatter diagram displaying the data. (b) Verify the given sums $\Sigma x, \Sigma y, \Sigma x^{2}, \Sigma y^{2}$, and $\sum x y$ and the value of the sample correlation coefficient $r$. (c) Find $\bar{x}, \bar{y}, a$, and $b$. Then find the equation of the least-squares line $\hat{y}=a+b x$ (d) Graph the least-squares line on your scatter diagram. Be sure to use the point $(\bar{x}, \bar{y})$ as one of the points on the line. (e) Interpretation Find the value of the coefficient of determination $r^{2}$. What percentage of the variation in $y$ can be explained by the corresponding variation in $x$ and the least-squares line? What percentage is unexplained? Answers may vary slightly due to rounding. Research: Patents The following data are based on information from the Harvard Business Review (Vol. 72, No. 1). Let $x$ be the number of different research programs, and let $y$ be the mean number of patents per program. As in any business, a company can spread itself too thin. For example, too many research programs might lead to a decline in overall research productivity. The following data are for a collection of pharmaceutical companies and their research programs: $$ \begin{array}{l|cccccc} \hline x & 10 & 12 & 14 & 16 & 18 & 20 \\ \hline y & 1.8 & 1.7 & 1.5 & 1.4 & 1.0 & 0.7 \\ \hline \end{array} $$ Complete parts (a) through (e), given $\Sigma x=90, \Sigma y=8.1, \Sigma x^{2}=1420$, $\Sigma y^{2}=11.83, \Sigma x y=113.8$, and $r \approx-0.973 .$ (f) Suppose a pharmaceutical company has 15 different research programs. What does the least-squares equation forecast for $y=$ mean number of patents per program?
Correlation and Regression
Linear Regression and the Coefficient of Determination
When presenting data graphically, you can choose from many types of graphics. Different graphic types, such as tables and charts, can be used to effectively highlight and depict different types of data in your report or presentation. As a professional communicator, you need to know which type of graphic is appropriate for different data. What type of graphic best illustrates changes in quantities over time? - Table - Line graph - Flow chart Read the scenario, and then answer the question. Sandeep is a researcher who has been studying healthcare costs. He has looked at the average cost of healthcare for residents of Colorado for the past five years. He is presenting his findings about healthcare costs over time in a report. For greater impact, Sandeep wants to show this information graphically. 1A. What would be the best type of graphic for Sandeep to use? Map Bar Chart Pie Chart Line Graph Pie Chart Map Bar Chart Line Graph 1B. Which of the following are important points to remember when creating tables? Check all that apply. - Indent the second line of a label for rows two or three spaces. - Include a source note beneath the visual. - Always write the title in all caps. - Number tables and other graphics consecutively throughout the report. Read the scenario about improving graphics, and then answer the question. Sheila is the national sales manager for a chain of retail stores that sell beds and bedding. She is preparing a report on annual sales and created the following chart to show that quilt sales have been falling in every region. Her boss tells her the chart is confusing and inaccurate. 1C. What can Sheila do to improve the chart? Check all that apply. - Start the horizontal axis at zero, so the differences in the numbers are not exaggerated. - Make it a pie chart instead of a bar chart. - Change the title to "Quilt Sales Fall in Every Region." - Use several different fonts. 1D. What should you do when creating an infographic? Check all that apply. - Write clear, simple text to explain the data. - Make sure your most important point is prominently displayed. - Use as many attractive colors as possible.
Recommended Textbooks
Probability with Applications in Engineering, Science, and Technology
Probability and Statistics for Engineers and Scientists
Applied Statistics and Probability for Engineers
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD