QUESTION $4$

$4\mathrm{.}1$ For the past $6$ days, data was taken $($in Hundreds$)$ for the Covid Omicron infection rates in three South African Provinces namely, Gauteng, Limpopo and Western Cape. Using the data shown below, create mean and range control charts for the data.

$\backslash$table$[[$Day of Observation,Observation Values$],[,$Gauteng,Limpopo,Western Cape$],[$Saturday$,25,22,23],[$Sunday$,24,23,20],[$Monday$,19,20,21],[$Tuesday$,23,19,24],[$Wednesday$,26,23,23],[$Thursday$,22,19,24]]$

Use the factors for computing control charts limits provided in the additional resource's slides.

$4\mathrm{.}2$ After constructing the control Charts, assume that Friday's observations were $18,17$ and $24.$

PRDEAPS$/2024$

Using the charts constructed, is the process in control?

$(4)$

Hint: Use the F$4$ key to make a cell a fixed reference in Excel

$[20]$

Totals Marks $=[68]$