case-study代写 – Scottish Water’代写 – 研究报告代写 – PM011

case-study代写 – Scottish Water’代写 – 研究报告代写 – PM011

PM011 Case Study

‘Scottish Water’



case-study代写 Before you start your assignment, please check: case-study代写Data analysis tool pack is installed in your version of Microsoft Excel.READ···


Before you start your assignment, please check: case-study代写

  1. Data analysis tool pack is installed in your version of Microsoft Excel.




  • This assignment is worth 30% of your PM011 module total.
  • You are required to analyse and evaluate the data provided in this case study.
  • You may use any pre-existing knowledge which is appropriately referenced.
  • Your analysis output should take the form of a short report (maximum 600 words) which will be presented to the Director of Scottish Water.
  • Your report will offer supported conclusions and recommendations in order that decisions can be made by the Director.
  • Your word count does not include: Figures, Diagrams, Tables, Calculations or any short (one sentence) statements in support of your calculations. All of these should be contained within an Appendixattached to your report.
  • Your submission is limited to a maximum of 7 pages of A4and all Appendix diagrams and figures should be clearly readable.
  • The deadline for this project is Sunday, April 14th, 2019 at 11:59pm.


Assessment:  case-study代写

The Director of Scottish Water has commissioned a pilot study of the water quality in the reservoirs supplying the Greater Glasgow area. In total, 89 reservoirs supply the area with fresh drinking (potable) water. This system has evolved and adapted over more than a century whilst Glasgow’s needs have changed significantly in terms of water volumes and quality. Historical metrics also strongly indicate that the current distribution of reservoirs is inefficient in terms of operational cost. In particular, the use of a variety of ‘inherited’ reservoirs with varying surface areas and chemical treatment policies has come under some scrutiny.

The pilot study aims to develop an understanding of the key factors affecting water cost and quality. One possible outcome of the study is a programme of re-building the reservoirs to modify their surface areas. However, this outcome is only likely if the results are extremely significant.

The overall quality of the water is measured using the ‘Index of Biotic Integrity’ or IBI. The highest quality of water will have an IBI score of 100, whereas a score of 0 represents the lowest water quality. Some reservoirs are also ‘treatment sites’ where the water is treated using chemicals to remove impurities prior to storage in the reservoir. The other ‘non treatment’ reservoirs use chemicals after the water has left the reservoir.

AND  case-study代写

The data collected for the study is shown below for all 89 reservoirs and is arranged in order of increasing surface area. A ‘T’ next to the data indicates that the sample was taken from a ‘treatment site’. The water samples were all taken at a standard mean depth of 3 meters however the data collector reported that a small batch of measurements were taken before a fault was detected (and resolved) in the depth gauge. The fault led to some readings being taken at a mean depth of 1 meter. Any analysis will need to take account of any suspected anomalies and state their possible impact on any conclusions.

Your task is to analyse the study data and present your recommendations to the Director in the form of a short, non-technical report (400 – 600 words only). Your results should be clear enough to allow the director to make the best decision. Some examples of possible decisions the director might make are:

  • Commission a more detailed study  case-study代写

  • Do nothing
  • Re build some or all reservoirs

Whatever your recommendations are – they must be clearly supported by your calculations using the supplied study data (and possibly secondary research if you choose to use additional relevant sources).

You should include a full numerical summary of the data in the pilot study. You should include an explanation of the factors, treatments and any lurking variables which may be present in the pilot study and any future research. You should highlight any possible errors in measurement, data anomalies or outliers and describe their effect on your conclusions. You should describe any correlation between the variables, if present.

Clearly you will need to carefully prioritise what you consider is most important if you are to stay within the 600 word limit!

You should summarize any findings in the form of supported recommendations that allow the Director to decide policy for the future. The clarity of these recommendations and their reasons are paramount. Therefore you should not use any statistical ‘jargon’ in your recommendations or in your justification for your recommendations. The Director of Scottish Water knows the business very well. The Director does not know statistics.

Assessment Approach and Limitations.  case-study代写

Any calculations must only use the methods and techniques described to you on this course. You may only use any two of the following four tests (with the given limits in brackets).

  1. Linear Regression (with a maximum of 3 scatter plots and 3 residual plots)
  2. Confidence Intervals (a maximum of 3 intervals)
  3. Hypothesis Test (a maximum of 3 tests)
  4. Chi Squared Test (a maximum of 4 two way tables)

All calculations and statistical tests must be conducted using Microsoft Excel. Use of any other software is not permitted.

After submission, any spreadsheets you use (your .xls or .xlsx files) must be available to your tutor upon request however your report only requires the output graphs and tables printed within a Microsoft Word (.docx) file, in your Appendix.


Assessment Form.  case-study代写

This is a formal academic report and should be written in a formal academic style employing all the standards expected in UK academic institutions. Including:

  • Use of Academic Sources (citations and properly formatted references) to support points and help with assumptions where detail is lacking.
  • Numbered paragraphs and sub sections.
  • No use of personal pronouns (I, we, us, they etc.).
  • Topic sentences and linking within and between paragraphs.
  • Use of cautious language and hedging terms throughout.

Finally  case-study代写

The 400 – 600 words limit means you will have to focus hard on the most important aspects of the data. The more practical, reasonable and explainable your recommendations are then the more marks you can achieve.


The pilot study data is below:

Area        (km sq.)

Km per squared

IBI Treated     (T) Area        (km sq.) IBI Treated     (T)
2 89 T 26 76 T
3 86 T 26 69 T
5 82 T 26 48
6 12 T 27 75 T
6 60 27 70
7 65 28 65 T
8 70 28 40
8 65 28 46
8 61 29 53
9 88 T 30 58
9 84 T 31 63 T
9 76 31 42
9 72 31 45
10 69 31 47
10 62 case-study代写 31 59
10 56 32 71 T
11 79 T 32 49
11 71 33 60
12 63 34 72 T
14 86 T 34 40
14 64 37 66 T
15 77 T 37 70 T
16 82 T 39 64 T
16 73 41 64
17 72 43 65 T
18 75 T 47 68 T
18 80 T 47 52
18 73 48 40
19 60 T 49 53 T
19 79 T 49 42
19 77 49 32
20 75 T 49 38
20 72 50 33
20 75 case-study代写 52 30
21 78 T 54 60 T
21 69 54 61 T
21 59 55 54 T
21 50 57 8
22 83 T 58 59 T
22 81 59 54 T
23 80 T 64 57 T
23 59 69 58 T
24 62 70 55 T
25 66 T 73 40 T
26 76 T      


Introduction be brief  case-study代写



更多其他:代写作业 数学代写 物理代写 生物学代写 程序编程代写 ECON

合作平台:天才代写 幽灵代  写手招聘  paper代写