Question

Suggest a variables control chart in the Education field. Provide the metric and how it is calculated along with how this information would be tracked and interpreted. Include the graph

Year	Biology	Business Administration	Psychology	Economics	Nursing	Computer Science
2013	389	342	310	220	211	150
2014	396	365	302	224	217	146
2015	420	350	343	226	201	138
2016	416	341	332	233	204	155
2017	405	353	322	241	209	152

Answer 1

Creating X -bar and S chart for variables in excel

Step - by step procedure

1. first bring data in to excel sheet.

find the control chart table of contents (Biasing Constraints) from internet. This will help to calculate Lower and upper control limit.

3. Our sample size is 8 . so A3 = 1.427, B3 = 0, B4 = 2.089 (Refer the biasing table)

4. Now we need to calcluate X-bar,St.dev,UCL's,LCLx,X bar-bar, and UCLx

5.X-bar is an average of week (calculation in row wise) "formula = "=IF(C5="","",AVERAGE(C5:N5))"

6. st.dev = =IF(C5="","",STDEV(C5:N5))

7.S-bar = average(st.dev)

8. LCLs = B3* S-bar

9.UCLs = B4* St.dev

10. LCLx = (X bar-bar) - (A3 * S-bar)

11 X bar-bar = Average (S-bar)

12 UCLx = (X bar-bar) + (A3 * S-bar)

Does it appear that the process is in control? Explain

As per the chart , education process is in perfect control

both x-bar and x double are under the upper control.