YouTube video guidance: https://youtu.be/SyEEQ2M_JW4

First Report Template
Problem08-06 Data Quality Costs: One detailed paragraph summarizing the data.

Second Report Template
Problem08-18A Statistics & Histogram & Problem08-18B: One detailed paragraph per excel spreadsheet so total of 3 paragraphs explaining the data. Answer the following questions from textbook below using the data.

A. What is its capability for producing within acceptable limits?Explain

B. Adjustments were made in the process and 25 more samples were taken and measured, as shown in the worksheet tab Prob. 8-18. What can you observe about the process? Is it now capable of producing within acceptable limits?

Third Report Template
Problem08-25 X-bar-R-Data and calculations: One detailed paragraph Answer the question from textbook using the data.

A. Compute the mean and range of each sample, calculate control limit, and plot them on x and r control charts.

Fourth Report Template
Problem08-39 Data and Calculation: One detail paragraph Answer the question below from textbook using the data.

A. Compute control limits for an x-chart (chart for individuals) using the statistic as an estimate of the standard deviation with a 3-period moving range.

B. Construct an x-chart for individuals, using the data. Interpret the results.

 

 

 

Fifth Report Template
Problem08-42 Data and Calculations: One detail paragraph Answer the question below from textbook using the data.

One hundred insurance claim forms are inspected daily at Full Life Insurance Co. over 25 working days, and the number of forms with errors have been recorded in the worksheet. Construct a p-chart. If any points occur outside the control limits, assume that assignable causes have been determined. Then construct a revised chart.

Sixth Report Template
Problem08-44 Data and Calculations: One detailed paragraph Answer the question below form textbook using the data.

Construct an np-chart using the data in Prob.8-42, the Full Life Insurance Co. What does the chart show?