Statistical Process Control issue

1. The supplied spreadsheet contains historic data recording the temperature of combined effluent discharged by a fictional brewery, Waterside Lager Limited (WLL). The data comprises temperatures recorded four times a day over the month of September 2022. 

The brewery’s discharges are normally controlled within the range 25oC to 35oC. The maximum legally permitted temperature is 40oC. 

Regular maintenance is performed on the balancing system (which neutralises the pH of the effluent at the expense of heating the discharge in the process), normally on a weekly basis.

Use the data to visualise the performance of the effluent control process, describing your analytical approach in detail. Include any graphs generated.

In your view, how well has the plant performed?

What priorities for quality improvements should the plant management set?