Question: (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

 (c) Construct a table that summarizes basic statistics (n, mean, std

(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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!