Question: Problem Set #3 (Chapter 4, 14 points): a. Worksheet Problem 3a contains defects (per million items received from suppliers). Utilizing the Descriptive Statistics tool in

Problem Set #3 (Chapter 4, 14 points): a.

Problem Set #3 (Chapter 4, 14 points): a. Worksheet Problem 3a contains defects (per million items received from suppliers). Utilizing the Descriptive Statistics tool in the Data Analysis Toolpack. generate descriptive statistics for years 2017 and 2018. Include labels in your range and all summary statistics. Locate your results roughly in the range 16:L20. Change the numeric format of all summary statistics to 0.0 except for Count. Answer the four (4) questions below the data. b. Utilizing the worksheet Problem 2a, use the CORRELQ sample correlation coefficient function to compute the correlation coefficient between variables Overall Service and Satisfaction Level. Locate the function in cell K3. H J K L L M LOCATE SUMMARY STATISTICS BELOW B C D E F 1 Problem Ba 2 3 Defects After Delivery 4 5 Defects per million items received from suppliers 6 Month 2014 2015 2016 2017 2018 7 January 812 828 824 682 571 8 February 810 832 836 695 575 9 March 813 847 818 692 547 10 April 823 839 825 686 542 11 May 832 832 804 673 532 12 June 848 840 812 681 496 13 July 837 849 806 696 472 14 August 831 857 798 688 460 15 September 827 839 804 671 441 16 October 838 842 713 645 445 17 November 826 828 705 617 438 18 December 819 816 686 603 436 19 20 21 Questions: 22 1 Between 2017 & 2018, mean defects per month fell by how much? 23 2 Which year's data are the most varied? 24 3 Which year's data are relatively symmetric? 25 4 Which year has the greated number of defects? 26 27 28 29 30 31 32 ANSWERS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please answer the questions and show what was clicked on and done Problem Set #3 (Chapter 4, 14 points): a. Worksheet Problem 3a contains defects (per million items received from suppliers)....

Create charts to better understand data sets. For cross-sectional data, use a scatter chart. For time series data, use a line chart. Linear y = a + bx Logarithmic y = ln(x) Polynomial (2nd order) y =...

1. Which of the following is not one of the three key measurements of the RPN number in a FMEA? Severity Time Frequency Detection 2. What type of individual in the six sigma organization is...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

MBA 5652, Research Methods Course Syllabus Course Description Business research methods will guide students in advancing their knowledge of different research principles and their applicability in...

MGMT-6082 Domestic and International Sourcing Mid Term Case Smart Phone Corporation (25%) Individual Submission (60%) Students are to submit their individual preparation on the Mid Term Case 72 hours...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

Refer to the data given in Exercise 19, and construct a pie chart. Compare the pie chart to the Pareto chart. Can you determine which graph is more effective in showing the relative importance of job...

1) What is the amount of each equal payment if made at the end of each month? Nominal annual rate of 12 is compounded monthly? What about quarterly? 2) What is the effective annual interest rate when...

Aiden Airlines is evaluating whether to make upgrades to its existing fleet of five specialty airplanes to extend the useful life or purchase a fleet of five new specialty airplanes. The upgrades...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...