Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(c) Construct a table that summarizes basic statistics (n, mean, std dev, median, max, min) for each month as well as the for entire data

image text in transcribed
(c) Construct a table that summarizes basic statistics (n, mean, std dev, median, max, min) for each month as well as the for entire data set Hint: first create a new column to store the month in which the defect data was recorded; the modeling type of this column should be Ordinal (as the months 1, 2, ...6 will be used as a categorical variable rather than continuous). The data in this new column is extracted using a Formula: use the function Month( ) to extract the month of the DateRecorded. Once you have the "month data", use Analyze > Tabulate and add aggregate statistics. (d) To provide the CEO with a clear executive summary of the process's history, construct the two following visuals: . a Time Series Plot . Comparative box plots: side by side boxplots - one for each month Provide a short description of insights from the above two visuals regarding the percentage of defects in each of the 6 months as well as general observations about the quality problems for the product during the 6 months. Comment on whether these visuals provide new insights and/or strengthens conclusions from pervious visuals or stats. To gain insights about monthly defect rates you can also use Rows > Data Filter on "month' and re-examine the output you constructed in (a) and (c) above; if needed, refer back to CW-02 for instructions on how to use data filters and dynamic plots

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_2

Step: 3

blur-text-image_3

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

A Cp-Theory Problem Book Functional Equivalencies

Authors: Vladimir V Tkachuk

1st Edition

3319243853, 9783319243856

More Books

Students also viewed these Mathematics questions