Provider a meaningful analysis report from a raw data

profilekeneth 1
work.xlsx

INSTRUCTIONS

Instructions:
Please evaluate, display, and interpret the attached dataset (tab=Data)
Your results and discussions should be created and entered on additional worksheets within this Excel file.
Notes:
Use an XmR control chart to evaluate the data
Analyze the results from the control chart.  Please indicate whether the variation in the data is special or common cause, and
If you, as a quality improvement specialist, want to increase this metric of the number of member seen weekly, would you change the system or do cases of special cause variation need to investigated and eliminated first?
What is the result if:
a.       Common cause variation is treated as special cause variation, and visa-versa, if
b.       Systems or processes are changed when special cause variation is present?
Please display and interpret the data using easy to understand format(s)
Please tell a story that the data presents to exective leadership

DATA

DATA
week of the year members seen in office
1 212
2 200
3 195
4 169
5 195
6 229
7 182
8 195
9 179
10 174
11 216
12 186
13 184
14 221
15 196
16 199
17 205
18 210
19 213
20 186
21 210
22 225
23 180
24 197
25 199
26 212
27 221
28 226
29 201
30 212
31 213
32 213
33 208
34 189
35 208
36 184
37 179
38 181
39 196
40 188
41 198
42 200
43 185
44 201
45 217
46 203
47 202
48 195
49 225
50 178
51 190
52 199