Modern Business Statistics with Microsoft Excel (MindTap Course List)
Modern Business Statistics with Microsoft Excel (MindTap Course List)
5th Edition
ISBN: 9781285433301
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 19, Problem 16SE

a.

To determine

Find the estimate of the mean when the process is in control.

a.

Expert Solution
Check Mark

Answer to Problem 16SE

The estimate of the mean for the production process that is in control is 95.4.

Explanation of Solution

Calculation:

The means for 20 samples of a production process are provided.

The estimate of the mean for the production process is given below:

μ=x¯n=(95.72+95.44+95.40+95.50+95.56+95.72+95.60+95.24+95.46+95.44+95.80+95.22+94.82+95.78+95.18+95.32+95.08+95.22+95.04+95.46)20=1,90820=95.4

Thus, the estimate of the mean for the production process that is in control is 95.4.

b.

To determine

Construct a x¯ control chart for the production process.

b.

Expert Solution
Check Mark

Answer to Problem 16SE

Output obtained using MINITAB software is given below:

Modern Business Statistics with Microsoft Excel (MindTap Course List), Chapter 19, Problem 16SE

Explanation of Solution

Calculation:

Upper control limits for the x¯chart:

UCL=μ+3σn=95.4+30.505=95.4+0.6696=96.07

Lower control limits for the x¯chart:

LCL=μ3σn=95.430.505=95.40.6696=94.73

X-bar chart:

Software procedure:

Step-by-step software procedure to obtain the X-bar chart using EXCEL:

  • Open an EXCEL file.
  • Enter the observation.
  • Enter X-double bar in a new cell B1, in cell B2 enter a formula “=Average(A2:A21)”.
  • Click Enter.
  • Click on Insert > select Insert Line chart icon.
  • Click on the chart > select Layout from the Chart Tools.
  • Select Chart Title > Above Chart.
  • Enter X-bar Chart in the dialog box.

Thus, the control limits for the x¯ chart are UCL=96.07andLCL=94.73.

c.

To determine

Explain whether any of the 20 sample means indicate that the process is out of control or not.

c.

Expert Solution
Check Mark

Explanation of Solution

From the x¯ chart, it is observed that all the sample means lie within UCL and LCL.

Thus, the 20 sample means do not indicate that the process was out of control.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
The following are suggested designs for group sequential studies. Using PROCSEQDESIGN, provide the following for the design O’Brien Fleming and Pocock.• The critical boundary values for each analysis of the data• The expected sample sizes at each interim analysisAssume the standardized Z score method for calculating boundaries.Investigators are evaluating the success rate of a novel drug for treating a certain type ofbacterial wound infection. Since no existing treatment exists, they have planned a one-armstudy. They wish to test whether the success rate of the drug is better than 50%, whichthey have defined as the null success rate. Preliminary testing has estimated the successrate of the drug at 55%. The investigators are eager to get the drug into production andwould like to plan for 9 interim analyses (10 analyzes in total) of the data. Assume thesignificance level is 5% and power is 90%.Besides, draw a combined boundary plot (OBF, POC, and HP)
Please provide the solution for the attached image in detailed.
20 km, because GISS Worksheet 10 Jesse runs a small business selling and delivering mealie meal to the spaza shops. He charges a fixed rate of R80, 00 for delivery and then R15, 50 for each packet of mealle meal he delivers. The table below helps him to calculate what to charge his customers. 10 20 30 40 50 Packets of mealie meal (m) Total costs in Rands 80 235 390 545 700 855 (c) 10.1. Define the following terms: 10.1.1. Independent Variables 10.1.2. Dependent Variables 10.2. 10.3. 10.4. 10.5. Determine the independent and dependent variables. Are the variables in this scenario discrete or continuous values? Explain What shape do you expect the graph to be? Why? Draw a graph on the graph provided to represent the information in the table above. TOTAL COST OF PACKETS OF MEALIE MEAL 900 800 700 600 COST (R) 500 400 300 200 100 0 10 20 30 40 60 NUMBER OF PACKETS OF MEALIE MEAL
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Continuous Probability Distributions - Basic Introduction; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=QxqxdQ_g2uw;License: Standard YouTube License, CC-BY
Probability Density Function (p.d.f.) Finding k (Part 1) | ExamSolutions; Author: ExamSolutions;https://www.youtube.com/watch?v=RsuS2ehsTDM;License: Standard YouTube License, CC-BY
Find the value of k so that the Function is a Probability Density Function; Author: The Math Sorcerer;https://www.youtube.com/watch?v=QqoCZWrVnbA;License: Standard Youtube License