DUE TODAY! REPOST. Due to person who accepted the bid didnt do the work.

Attributes Chart Assignment

The housekeeping supervisor in a major hotel checks n items in each room and records the number that are non-conforming (i.e., not adequately cleaned or arranged). The n values vary with the quality (price) of the room. Using the Excel spreadsheet titled P-CHART.XLS, make two p charts using the given data in the file Attributes Chart data.xls. Paste the charts into this document. Create one p chart using the variable subgroup size (n) and the other using constant subgroup size (average n).

1. Attach the p chart using variable subgroup size (unequal n) during submission. Note: you will need to adjust the cells that the chart uses to plot the data so that only 14 subgroups (n) show on the chart.

2. Attach the p chart using constant subgroup size (average n) during submission.

3. Interpret both p charts, including their process capability. Which chart is more sensitive to variation?

-----

4. Using the np chart data from the Excel file Attributes Chart Data.xls, create an np chart (number nonconforming chart) using NP-CHART.XLS and interpret. The sample size = 400. Attach the completed chart during submission.

5. Calculate the process capability; i.e., (1) the number nonconforming units (np) and (2) the percent of non-conforming units (p) using both np and p values. Interpret the np chart.

-----

6. Using the u chart data from the Excel file Attributes Chart Data.xls, create a u chart using U-CHART.XLS and interpret. Attach the completed chart during submission. Note: you will need to adjust the cells that the chart uses to plot the data so that only 20 subgroups (n) show on the chart.

7. Interpret the u chart. What is the average number of nonconformities (defects) per unit?

-----

8. Using the c chart data from the Excel file Attributes Chart Data.xls, create a c chart using C-CHART.XLS and interpret. The sample size = 1. Attach the completed c chart during submission.

9. Interpret the c chart. What are the nonconformities (defects) per unit?