At Westonci.ca, we make it easy for you to get the answers you need from a community of knowledgeable individuals. Get expert answers to your questions quickly and accurately from our dedicated community of professionals. Connect with a community of professionals ready to provide precise solutions to your questions quickly and accurately.

4.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. (16) 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.2 After constructing the control Charts, assume that Friday’s observations were 18,17 and 24. Using the charts constructed, is the process in control? (4) Hint: Use the F4 key to make a cell a fixed reference in Excel