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?
Sheet1
| celcius Degrees | celcius Degrees | celcius Degrees | ||||||
| 27.508 | Day 1 | 33.6692 | Day 11 | 37.1615 | Day 21 | |||
| 33.19 | 27.508 | 41.1681 | ||||||
| 30.0649 | 23.7561 | 33.9659 | ||||||
| 30.0102 | 34.3809 | 31.4491 | ||||||
| 27.6475 | Day 2 | 24.4551 | Day 12 | 29.0525 | Day 22 | |||
| 32.4864 | 30.8515 | 33.2361 | ||||||
| 24.1237 | 29.792 | 28.9381 | ||||||
| 26.5117 | 36.7611 | 28.3651 | ||||||
| 33.9747 | Day 3 | 31.2412 | Day 13 | 33.5726 | Day 23 | |||
| 25.8427 | 26.8945 | 30.9505 | ||||||
| 31.5985 | 36.4552 | 34.6799 | ||||||
| 27.9439 | 33.5425 | 36.5684 | ||||||
| 34.7521 | Day 4 | 36.5443 | Day 14 | 34.7634 | Day 24 | |||
| 31.0639 | 31.8286 | 28.6535 | ||||||
| 33.2517 | 32.9976 | 31.4899 | ||||||
| 31.5985 | 29.8895 | 35.5593 | ||||||
| 32.8441 | Day 5 | 30.5261 | Day 15 | 34.4278 | Day 25 | |||
| 25.2503 | 38.2822 | 28.3744 | ||||||
| 26.3891 | 32.4421 | 30.2776 | ||||||
| 24.5012 | 36.1361 | 26.8801 | ||||||
| 27.9969 | Day 6 | 32.6263 | Day 16 | 33.4373 | Day 26 | |||
| 29.4594 | 35.158 | 23.7654 | ||||||
| 28.2322 | 40.73 | 22.4613 | ||||||
| 31.756 | 38.294 | 31.0189 | ||||||
| 23.7669 | Day 7 | 43.2163 | Day 17 | 30.7144 | Day 27 | |||
| 27.6435 | 43.8389 | 27.0994 | ||||||
| 23.0705 | 40.5347 | 26.3009 | ||||||
| 24.8471 | 38.1259 | 27.9834 | ||||||
| 23.7561 | Day 8 | 45.2167 | Day 18 | 20.6646 | Day 28 | |||
| 25.3579 | 36.6261 | 23.5196 | ||||||
| 34.3809 | 44.9231 | 26.6281 | ||||||
| 27.1621 | 39.5582 | 19.8736 | ||||||
| 27.8763 | Day 9 | 40.6913 | Day 19 | 24.9148 | Day 29 | |||
| 26.8852 | 39.8205 | 26.8165 | ||||||
| 24.9195 | 38.4995 | 28.8493 | ||||||
| 32.045 | 40.2643 | 24.6247 | ||||||
| 33.669 | Day 10 | 32.3862 | Day 20 | 25.5761 | Day 30 | |||
| 27.508 | 40.14 | 25.0189 | ||||||
| 23.7561 | 36.1144 | 19.1047 | ||||||
| 34.3809 | 36.5583 | 22.5525 |