Could someone please help me figure out how to calculate the lower/upper limits using Excel? Thanks! A. Choudhury's bowling ball factory in Illinois makes bowling balls of adult size and weight only. The standard deviation in the weight of a bowling ball produced at the factory is known to be 0.39 pounds. Each day for24 days, the average weight, in pounds, of 9 of the bowling balls produced that day has been assessed as follows:Average (lb.)Average (lb.) Average (lb.)9.910.09.910.19.910.110.19.910.110.19.910.110.09.99.910.010.010.1Day123456Day789101112Day131415161718Day192021222324QAverage (lb.)9.910.010.09.910.010.0a) Establish a control chart for monitoring the average weights of the bowling balls in which the upper and lower control limits are each two standard deviations from the mean. What are the values of the control limits?Upper Control Limit (UCL) = lb. (round your response to two decimal places).

Statistical process control (SPC)is applying statistical techniques to determine whether a process…

A. Choudhury's bowling ball factory in Illinois makes bowling balls of adult size and weight only. The standard deviation in the weight of a bowling ball produced at the factory is known to be 0.39 pounds. Each day for 24 days, the average weight, in pounds, of 9 of the bowling balls produced that day has been assessed as follows: D Average (lb.) Average (lb.) Average (lb.) Average (lb.) Day Day 13 19 9.9 9.9 10.0 10.1 10.1 10.0 9.9 10.1 9.9 10.1 10.1 9.9 9.9 10.0 14 15 16 17 9.9 10.1 10.0 10.0 10.0 18 10.1 10.0 Day 1 2 Day 7 8 9 20 21 22 23 24 3 4 9.9 5 9.9 6 10.0 a) Establish control chart for monitoring the average weights of the bowling balls in which the upper and lower control limits are each two standard deviations from the mean. What are the values of the control limits? Upper Control Limit (UCL) = lb. (round your response to two decimal places). 10 11 12

A. Choudhury's bowling ball factory in Illinois makes bowling balls of adult size and weight only. The standard deviation in the weight of a bowling ball produced at the factory is known to be 0.39 pounds. Each day for 24 days, the average weight, in pounds, of 9 of the bowling balls produced that day has been assessed as follows: D Average (lb.) Average (lb.) Average (lb.) Average (lb.) Day Day 13 19 9.9 9.9 10.0 10.1 10.1 10.0 9.9 10.1 9.9 10.1 10.1 9.9 9.9 10.0 14 15 16 17 9.9 10.1 10.0 10.0 10.0 18 10.1 10.0 Day 1 2 Day 7 8 9 20 21 22 23 24 3 4 9.9 5 9.9 6 10.0 a) Establish control chart for monitoring the average weights of the bowling balls in which the upper and lower control limits are each two standard deviations from the mean. What are the values of the control limits? Upper Control Limit (UCL) = lb. (round your response to two decimal places). 10 11 12

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Bill Kime's bowling ball factory makes bowling balls of adult size and weight only. The standard deviation in the weight of a bowling ball produced at the factory is known to be 0.39 pounds. Each day for 24 days, the average weight, in pounds, of 9 of the bowling balls produced that day has been assessed as follows Day 1 2 3 4 5 6 Average (lb) 9.9 9.9 10.1 10.1 99 99 Day 7 8 9 10 11 12 Average (lb) Day Average (b) 13 14 15 16 17 18 10.1 10.0 10.0 10.1 10.1 10.0 9.9 10.1 10.1 10.0 10.1 10.1 Day 19 20 21 22 23 24 Average (lb) 99 10.0 10.1 9.9 10.0 10.0 a) Establish a control chart for monitoring the average weights of the bowling balls in which the upper and lower control limits are each two standard deviations from the mean What are the values of the control limits? Upper Control Limit (UCL)=b (Round your response to two decimal places)
Designing an x -Chart Using the Process Standard DeviationThe Sunny Dale Bank monitors the time required to serve customers at the drive-through window because it is an important quality factor in competing with other banks in the city. After analyzing the data gathered in an extensive study of the window operation, bank management determined that the mean time to process a customer at the peak demand period is 5 minutes, with a standard deviation of 1.5 minutes. Management wants to monitor the mean time to process a customer by periodically using a sample size of six customers. Assume that the process variability is in statistical control. Design an x-chart that has a type I error of 5 percent. That is, set the control limits so that there is a 2.5 percent chance a sample result will fall below the LCL and a 2.5 percent chance that a sample result will fall above the UCL. After several weeks of sampling, two successive samples came in at 3.70 and 3.68 minutes, respectively. Is the…
Webster Chemical’s nominal weight for filling tubes of caulk is 8.00 ounces ± 0.60 ounces. The target process capability ratio is 1.33. The current distribution of the filling process is centered on 8.054 ounces with a standard deviation of 0.192 ounces. Compute the process capability ratios Cp and Cpk to assess whether the filling process is capable and set properly.
Suppose that material hardness is normally distributed with a mean of 52 and a standard deviation of 1. Specification limits for hardness are from 45 to 55. What is Cp?
A. Choudhury’s bowling ball factory in Illinois makes bowling balls of adult size and weight only. The standard devia-tion in the weight of a bowling ball produced at the factory is known to be 0.12 pounds. Each day for 24 days, the averageweight, in pounds, of nine of the bowling balls produced that dayhas been assessed as follows: a) Establish a control chart for monitoring the average weights of the bowling balls in which the upper and lower control lim-its are each two standard deviations from the mean. What are the values of the control limits?b) If three standard deviations are used in the chart, how do thesevalues change? Why?
The following data was recorded while observing the increase in the number of butterflies in two different ponds, Pond A and Pond B. Number of Butterflies Present Over 5 Years Year Pond A Pond B 0 50 65 85 1 2 3 4 5 100 O 110 121 133 146 161 110 143 186 What is the rate of growth, r, for each pond and which pond has the fastest average rate of growth over the five years? TA = 1.1, TB = 1.3, mg = 3.72 butterflies/yr TA=0.9, TB=0.8, mg = 3.72 butterflies/yr TA=0.9, TB=0.8, mg=27.2 butterflies/yr TA = 1.1, TB = 1.3, mg=27.2 butterflies/yr
The specifications for a gasket that installs between two engine parts calls for a thickness of 6.0 mm ± .2 mm. The standard deviation of the process is estimated to be 0.05 mm. The process is known to operate at a mean thickness of 6.1 mm What are the upper and lower specification limits for the gasket? What are the Cp and Cpk values for this process? Is this process capable of producing the desired part?
The IRS is concerned with improving the accuracy of tax information given by its representatives over the telephone. Previous studies involved asking a set of 25 questions of a large number of IRS telephone representatives to determine the proportion of correct responses. Historically, the averageproportion of correct responses has been 72 percent. Recently, IRS representatives have been receiving more training. On April 26, the set of 25 tax questions were again asked of 20 randomly selected IRS telephone representatives. The numbers of correct answers were 18, 16, 19, 21, 20, 16,21, 16, 17, 10, 25, 18, 25, 16, 20, 15, 23, 19, 21, and 19. a. What are the upper and lower control limits for the appropriate p-chart for the IRS? Use z = 3. b. Is the tax information process in statistical control?
73) please please help me with this question I don't know how to do it A metal fabricator produces connecting rods with an outer dlameter that has a 1 0.05 inch specification. A machine operator takes several sample measurements over time and determines the sample mean outer diameter to be 1.004 inches with a standard deviation of 0.020 inch. Calculate the process capability index for this example. Note: Round your answer to 3 decimal places.
Discuss the basic differences between the mean absolute deviation and mean absolute percent error.
Sam's Long Life 75-watt light bulbs are designed to have a life of 1,150 hours with tolerances of +205 hours. The process that makes light bulbs has a mean of 1,040 hours, with a standard deviation of 55 hours. Compute the process capability ratio and the process capability index, and comment on the overall capability of the process. (Round answers to 2 decimal places, e.g. 2.75.) Process capability ratio 1355 Process capability index 945 1.24 .057 shorter lived While Cp = bulbs will be generated. indicates the process саpable, Cpk D indicates that
Auto pistons at Wemming Chung's plant in Shanghai are produced in a forging process, and the diameter is a critical factor that must be controlled. From sample sizes of 5 pistons produced each day, the mean and the range of this diameter have been as follows: Day Mean (mm) Range R (mm) 158 4.3 151.2 4.4 155.7 4.2 153.5 4.8 156.6 4.5 What is the UCL using 3-sigma?(round your response to two decimal places). 1. 2. 4.