*please use excel and provide the formulas Acme Systems, Inc. produces a very large volume of...

*please use excel and provide the formulas

Acme Systems, Inc. produces a very large volume of plastic rods on a regular basis. These rods require an extremely accurate diameter. Thus, the Quality Control manager wants to know if the production process is producing rods at a consistent diameter. 220 rods have been sampled each day for 10 days. Defects have been recorded. Develop a “p” control chart for the proportion of defects across the 10 days. Assume Z = 2.58. Do any of the rods appear to be “out of control”? Comment on your findings.

Day	Defects
1	12
2	29
3	18
4	10
5	14
6	22
7	7
8	23
9	9
10	10

Solutions

Expert Solution

please check the excel worksheet

as we can see there is only day 2 which have proportion value greater than upper control limit

now showing formula

orchestra answered 1 year ago

Next > < Previous

Related Solutions

*please use excel and provide formulas Super Markets Inc. is considering expanding into the Scottsdale, Arizona,...

*please use excel and provide formulas Super Markets Inc. is considering expanding into the Scottsdale, Arizona, area. You as director of planning must present an analysis of the proposed expansion to the operating committee of the board of directors. As a part of your proposal, you need to include information on the amount people in the region spend per month for grocery items. You would also like to include information on the relationship between the amount spent for grocery items...

please use excel and provide the formulas The Times-Observer is a daily newspaper in Metro City....

please use excel and provide the formulas The Times-Observer is a daily newspaper in Metro City. Like many city newspapers, the TimesObserver is suffering through difficult financial times. The circulation manager is studying other papers in similar cities in the United States and Canada. She is particularly interested in what variables relate to the number of subscriptions to the paper. She is able to obtain the following sample information on 25 newspapers in similar cities. Ignore the data in the...

I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to...

I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to solve problem #31 (the PUTZ, Inc. project) for Chapter 10 in the textbook. 2) Conduct a sensitivity analysis that focuses on the sales price by increasing the price by 10% above the best estimate, and then by decreasing the price by 10% below the best estimate. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case,...

***Excel is required to solve this problem. Please use excel and show all formulas used in...

***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...

Please use excel and show formulas ( formula auditing mode) please: Climate Control, Inc. makes expedition-quality...

Please use excel and show formulas ( formula auditing mode) please: Climate Control, Inc. makes expedition-quality rain gear for outdoor enthusiasts. Management prepared a forecast of sales (in suits) for next year and now must prepare a production plan. The company has traditionally maintained a level workforce strategy. All nine workers are treated like family and have been employed by the company for a number of years. Each employee can produce 2,000 suits per month. At present, finished goods inventory...

please provide me work book(Excel) with formulas in Excel to value options based on block sholes...

please provide me work book(Excel) with formulas in Excel to value options based on block sholes model

5. Use either R or Excel for the following. Provide the formulas or code that you...

5. Use either R or Excel for the following. Provide the formulas or code that you are using. Let x1 be a random variable that is N(100, 225). Let x2 be a random variable that is U(50,150) and let x3 be a random variable that is U(500,1500). Set Y = (X1)(X2)/ (X3) a) Use R to create 500 random numbers of each type (X1, X2, X3 and Y). b) Estimate P(0.1 < Y < 0.25) c) Estimate E(Y) and the...

1) (note: Please also provide the excel formulas used to solve it ) You work for a...

1) (note: Please also provide the excel formulas used to solve it ) You work for a soft-drink company in the quality control division. You are interested in the standard deviation of one of your production lines as a measure of consistency. The product is intended to have a mean of 12 ounces, and your team would like the standard deviation to be as low as possible. You gather a random sample of 18 containers. Estimate the population standard deviation at...

(Please answer this question in an excel format if possible.) Please provide very detailed explanation and...

(Please answer this question in an excel format if possible.) Please provide very detailed explanation and answers if possible. The Poster Bed Company believes that its industry can best be classified as monopolistically competitive. An analysis of the demand for its canopy bed has resulted in the following estimated demand function for the bed: P ¼ 1760 12Q The cost analysis department has estimated the total cost function for the poster bed as TC ¼ 1 3 Q3 15Q2 þ...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for the problem in the first worksheet named LightbulbLife of the data table down below It gives the data on the lifetime in hours of a sample of 50 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for...

Subjects