Nagel Beverage Company purchases cans from a vendor instead of making their own cans. A can...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Nagel Beverage Company purchases cans from a vendor instead of making their own cans. A can must be able to withstand enough pressure to be carbonated and pressurized without the can bursting or splitting, which is a defective can. When a shipment of cans arrives, the Nagel quality inspector samples several cans and tests them to determine if the shipment should be accepted. The defect rate must be 4% or less to accept the shipment of all cans. Most cans will pass the pressurization test, but if more than 4% fail then the entire shipment is returned to the vendor. Each can must withstand at least 114 psi of pressure. To test the cans, each sampled can is pressurized until it bursts or splits. The psi required to damage the can is measured and recorded. Any can that burst/split under 114 psi is considered to "Fail," otherwise it is considered to "Pass." The defect rate is estimated as the number of cans failing out of the number of cans tested. Place your answers for Question 3 in the worksheet named Nagel 2. You are to determine the sample size required to be 90% confident of the final estimation result within a margin of error of 1%. a. b. C. d. 2 Points: Calculate the appropriate value of Z in cell E4 using a built-in Excel function based off of 90% confidence. 2 Points: Input the maximum allowed margin of error (MOE) in cell E5 (in decimal form). 4 Points: Calculate the necessary sample size (n) in cell E6 by writing a formula that references the appropriate cells. For this question and the question of part d, use the conservative approach discussed in our text. 4 Points: Calculate the necessary sample size (n) using StatTools, Place your StatTools output with an upper left hand cell in cell H3. Place the cell reference for the value from StatTools in cell E7. Sample Size Required for Estimating the True Proportion of Defective 12 OZ Cans Sample Size Inputs Z = E = n = n = Grader a b с d Nagel Beverage Company purchases cans from a vendor instead of making their own cans. A can must be able to withstand enough pressure to be carbonated and pressurized without the can bursting or splitting, which is a defective can. When a shipment of cans arrives, the Nagel quality inspector samples several cans and tests them to determine if the shipment should be accepted. The defect rate must be 4% or less to accept the shipment of all cans. Most cans will pass the pressurization test, but if more than 4% fail then the entire shipment is returned to the vendor. Each can must withstand at least 114 psi of pressure. To test the cans, each sampled can is pressurized until it bursts or splits. The psi required to damage the can is measured and recorded. Any can that burst/split under 114 psi is considered to "Fail," otherwise it is considered to "Pass." The defect rate is estimated as the number of cans failing out of the number of cans tested. Place your answers for Question 3 in the worksheet named Nagel 2. You are to determine the sample size required to be 90% confident of the final estimation result within a margin of error of 1%. a. b. C. d. 2 Points: Calculate the appropriate value of Z in cell E4 using a built-in Excel function based off of 90% confidence. 2 Points: Input the maximum allowed margin of error (MOE) in cell E5 (in decimal form). 4 Points: Calculate the necessary sample size (n) in cell E6 by writing a formula that references the appropriate cells. For this question and the question of part d, use the conservative approach discussed in our text. 4 Points: Calculate the necessary sample size (n) using StatTools, Place your StatTools output with an upper left hand cell in cell H3. Place the cell reference for the value from StatTools in cell E7. Sample Size Required for Estimating the True Proportion of Defective 12 OZ Cans Sample Size Inputs Z = E = n = n = Grader a b с d
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A firehouse must be able to shoot water to the top of a building 35.0 m tall when aimed straight up. Water enters this hose at a steady rate of 0.500 m'/s and shoots out of a round nozzle. (a) What...
-
Part B You must be able to provide effective leadership for a team and facilitate a work team during the implementation of a team project including decision-making, resolving issues and developing...
-
Some hoteliers feel that room attendants must be able to fluently speak the language of the majority of the hotel's guests to do their jobs effectively. They feel that guest contact is an important...
-
Table 2-5 Estonia Finland One Cell Phone 40 hours 16 hours Lumber (per board foot) 8 hours 4 hours Table 2-5 shows the number of labor hours required to produce a cell phone and a board foot of...
-
On January 1, Lambert Corporation purchased a 25% equity investment in Dougherty Corporation for $150,000. At December 31, Dougherty declared and paid a $80,000 cash dividend and reported net income...
-
Given that P(x) = 11.5x - 0.1x2 - 150 and that production is restricted to fewer than 75 units, find the break-even points?
-
If your task was to design a leadership development program, what would you include and what would you emphasize? What would be the focus of your leadership development program? Explain and justify...
-
Designer Wear operates a chain of 10 retail department stores. Each department store makes its own purchasing decisions. Barry Lee, assistant to the president of Designer Wear, is interested in...
-
Advantages and disadvantages of share buybacks vs dividend payments, for both the investor and manager.
-
Katie is a trader. On 1 October 204 she had the following balances in her ledger: $ Capital .................................................. 15000 Inventory...
-
Organization officials have a legal and moral responsibility to ensure that the workplace is free from unnecessary hazards. Employers hold responsibility for understanding what is necessary to keep...
-
When stock prices initially began to fall, what was the reaction by many investors?
-
Smokey Inc. had $500,000 in sales with a $75,000 gross profit. Additionally, the inventory balance for Years 1 and 2 were $35,000 and $50,000, respectively. What is the number of days in inventory...
-
Monday's Technology Inc. has 800 bonds outstanding that are selling at $1,050 each. Bonds with similar characteristics are yielding a pretax 7.25 percent. The firm also has 25,000 shares of common...
-
Brokerage account $ 2,300,000 The basis in the brokerage account is $1,900,000. Assume that the couple lives in a separate property state and IF Louie died this year, what would be the basis for...
-
Trevor Wilson is 27 years old. He works for a company with a good health insurance plan. Indeed, Trevor has heard it's priced better than most plans and has consequently taken out the optional...
-
Suppose Treasury STRIPS are traded for maturities out to 4 years, and the spot rates on these zero coupon bonds are shown below. If the price of a 4-year 9.6% coupon bond with par=$1,000 is $1,063,...
-
State whether each statement is true or false. If false, give a reason. {purple, green, yellow} = {green, pink, yellow}
-
A ball is thrown from the top of a 100-foot tower with a velocity of 28 feet per second. (a) Find the equation that represents the parabolic path. (b) How far does the ball travel horizontally before...
-
Find the missing values by solving the parallelogram shown in the figure. (The lengths of the diagonals are given by c and d.) 1. a =5, b = 8, θ = 450 2. a = 25, b =35, = 1200 3. a =10,...
-
(a) Use a graphing utility to complete the table. (b) Make a conjecture about the relationship between sin and sin(180 ). 0 20 0 40 60 80 sin e sin(180 0)
-
A series of 25 end-of-year deposits is made that begins with $1,000 at the end of year 1 and increases at the rate of $200 per year with a 12 percent interest rate compounded annually. a. What amount...
-
In Problem 106, suppose the positive-valued cash flows are replaced by a positive gradient series. If the cash flow at end-of-year 8 is $10,000, what first year payment and gradient step make the...
-
Maintenance costs on a certain piece of equipment are estimated to be $500, $600, $700, $800, and $900 at the end of years 1, 2, 3, 4, and 5, respectively. The time value of money rate is 8 percent...
Study smarter with the SolutionInn App