Help please The sheet of Problem 1_Template provides a table of data collected over six months in a local grocery store.

[answerhappygod]

Help please
The sheet of Problem 1_Template provides a table of data
collected over six months
in a local grocery store. Construct a simple Pareto analysis of the
data, and determine
the two most common categories and their corresponding cumulative
percentage
contributing to the total number of complaints.
(1) Our Family Hospital surveys all outgoing patients by means
of a
patient satisfaction questionnaire. The number of patients
surveyed
each month varies. Construct a p-chart for the data in the sheet
of
Problem 2_Template which represents responses to a question
on
satisfaction with hospital meals. The p-chart should have an
upper
control limit, lower control limit, center line, and a connected
line of
plotted sample points (Note: use 𝑧=3 for constructing the
p-chart).
(2) After having completed part (1), make an assessment as to
whether
the process is in control or not in control. Further, explain how
you
reached this conclusion and provide this along with your average
p
value, standard deviation, UCL and LCL value.
Complaint Type # of complaints
All other 71
Checker 59
General 58
Service Level 55
Policy/Procedures 40
Price Marking 45
Product Quality 87
Product Request 105
Checkout Queue 33
Stock Condition 170
Month Number of

Patients


Number

Unsatisfied Unsat Rate, p




Average




Unsat Rate,




p_bar






UCL LCL
1 549 20
2 402 25
3 334 22
4 507 20
5 380 17
6 498 25
7 531 32
8 361 19
9 514 22
10 423 16
11 500 23
12 345 32
13 424 19
14 378 26
15 515 20
16 487 26
17 334 19
18 410 27
19 485 37
20 451 18
p_bar:
AverageSample
Size (n)
Standard
Deviation (Sp)