Question: i dont know how to do these in excel? I have a huge chart of numbers and got the mean and standard deviation but I

i dont know how to do these in excel? I have a huge chart of numbers and got the mean and standard deviation but I dont know how else to answer the other questions.

Q14. Calculate the mean and the standard deviation of the bar weights using the data in the table. mean 62.9967 standard deviation 0.098406 Q15. What standard deviation would be required in order for the process to achieve six sigma quality? note: If the mean is not perfectly centered, use the nearer product specification for this calculation standard deviation needed for six sigma quality Q16. Has this process achieved six sigma quality? Q17. Calculate the Cpk index for this process. Cpk Index Q18. Would it be better to have a higher or a lower Cpk index

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!

In the transcripts provided for the final project case study, many legal risks occur through the actions of the characters. Based on the readings for this module, what laws are applicable in this...

Question: Dispute Resolution and Legal Ramifications: In this final section, you will determine the best course of action for resolving the conflict and provide your recommendations for moving...

In the transcripts provided for the final project case study, many legal risks occur through the actions of the characters. Based on the readings for this module, what laws are applicable in this...

Creating a More Effective Organizational Culture: In this section, you will analyze the transcripts provided to determine the influence of cultural differences on the conflict. Question: Recommend...

In the transcripts provided for the final project case study, many legal risks occur through the actions of the characters. Based on the readings for this module, what laws are applicable in this...

Question 18 1pts A Z score is also a percentile rank. True False Flag this Question Question 19 1pts Regression lines are used for comparison of two variables to determine similarity. True False Flag...

In Chapters 11 and 12, you were introduced to the process to follow when summarizing and generalizing your data using XL Data Analyst. It is now time to fine tune your skills. Begin by summarizing...

(i need help with some of the questions, i did questions 1-5 but I am stuck on questions 6-9 and final question. Please be kind and share the step-by-step calculations and explanations for 6-9 and...

Esther's Hypotheses 1. There are stark differences between male and female customers and operators. a. We have identified most of the difference between male and female operators (Thanks Juan)....

1. Callisto is Jupiter's second largest moon and the third largest moon in our solar system. It's about the same size as Mercury. Let's assume that Callisto's icy surface has completely melted when...

Let A be a square matrix. A square root of A is a matrix B of the same order such that B=A How to find a square root for a given matrix? If the matrix is symmetric, positive definite, there is a way...

Question 6 of 7 Points possible: 1 . 0 0 An azeotrope is a mixture that has Choose. composition in the Choose... Therefore, an azeotropic mixture q , Choose... be separated by distillation.

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...