Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on a data sample in file TOM3010_OM_HW3_Question22_Data.xlsx, you need to construct one Xbar-chart and one R-chart with the following guidelines: Background, equations, lookups

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Based on a data sample in file "TOM3010_OM_HW3_Question22_Data.xlsx", you need to construct one Xbar-chart and one R-chart with the following guidelines: Background, equations, lookups and Excel examples (with videos) are in Module 05. Charts must have titles, labels, and clear presentation of different lines. (a)[5] You need to have one Xbar-chart. The Xbar-chart should have the vertical axis format as: Min = 35; Max = 70; and Major Unit = 5. The horizontal axis has 60 points. Besides the chart, present the following mini table (points will be deducted if you show the big table of full data). Give interpretations of the chart results: the process is in control or out of control, and why. Table 22.1 (first 2 Excel columns) x-2bar (value & unit) SD(all parts) (value & unit) SE(Xbar) (value & unit) (equation, value & unit) (equation, value & unit) UCL-Xbar LCL-Xbar (b)[5] You need to have one R-chart. The R-chart should have the vertical axis format as: Min = 0; Max = 80; and Major Unit = 10. The horizontal axis has 60 points. Besides the chart, present the following mini table (points will be deducted if you show the big table of full data). Give interpretations of the chart results: the process is in control or out of control, and why. Table 22.2 (first 2 Excel columns) R-bar (value & unit) D4 (value) D3 (value) UCL-R (equation, value & unit) LCL-R (equation, value & unit)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: Ulric J. Gelinas, Richard B. Dull

10th edition

9781305176218, 113393594X, 1305176219, 978-1133935940

More Books

Students also viewed these Accounting questions

Question

What is brand repositioning?

Answered: 1 week ago

Question

What is co-branding?

Answered: 1 week ago

Question

Why change product line depth?

Answered: 1 week ago