Water analysis report | Statistics homework help


Please read the following very carefully:

· This is your first summative assessment on this course. It is worth 50% of your total marks.

· You have 3 weeks to work on your report which must be submitted no later than 11:59 pm on Sunday 21st February.

· Your report must be Your Work Only. It has been designed such that each student chooses their own strategy. If the strategy you choose is similar to any other students’ strategy, then you will be asked to attend an interview and explain why. If you cannot explain why, you will be penalized. It must be your work only.

· You may discuss the report with your tutor over the three weeks before submission. Your tutor will help you with the interpretation and quality of your Report statistics, but they will not help you with your strategy. You must decide on the best strategy and there is no preferred strategy.

· It is a short report. Only 600 words. So, you will need to focus on what is most important. There is no room for repetition or redundant material.

· You should put all your Excel calculations and diagrams in an appendix. Your appendix must be no more than 4 pages – all with a font size of no less than 11pt.

· Please read the Report assessment scenario very carefully and make sure you understand the primary task. Do this before starting to analyse the data provided.

· Lastly, your Report must be tidy and well presented with clearly labelled tables and charts. This is a formal report, and it should be designed to impress.

Assessment Scenario:

There has been a pilot study of the water quality in the water reservoirs supplying the local area. In total, 89 reservoirs supply the area with fresh drinking water. In recent times, the area’s needs have changed significantly in terms of water volumes and quality. 

The pilot study aims to understand the key factors affecting water cost and quality. One possible outcome of the study is a programme of re-building the reservoirs to aid water quality. 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 before storage in the reservoir. The other ‘non treatment’ reservoirs use chemicals after the water has left the reservoir.

The data collected for the study is shown below for all 89 reservoirs. 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. Your analysis will need to take account of any possible anomalies and state their possible impact on any conclusions.

Your task is to analyse the study data and write your recommendations for the Director of Water Supplies in a short, non-technical report (approx. 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:

· Ask for a more detailed study

· Start new construction

· Change water treatment policies

· Do nothing

Whatever your recommendations are – they must be clearly supported by your calculations using the supplied study data.

You should include a full numerical summary of the data in the 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.

You should summarize any findings in the form of clear, supported recommendations that allow the Director to decide policy for the future. 

Assessment Approach 

Any calculations must only use the methods and techniques described to you on this course.

You must produce a maximum of 2 graphical representations of the given data from the following options:

1. Histogram

2. Box Plot

3. Modified Box Plot

4. Cumulative Relative Frequency Curve

[For example, you may choose: 1 Box Plot and 1 CRF – or – 1 Modified Box Plot and 1 Histogram but no more than 2 in total]

You must also conduct the following two tests (with the given limits in brackets).

1. Linear Regression (with a maximum of 2 correlations, 2 scatter plots and 2 residual plots)

2. 2 Sample Confidence Interval (with a maximum of 2 [2 sample] intervals)(two-sample intervals)

· Note: depending on circumstance or purpose, there is no ‘best’ confidence level, your choice of confidence level must be justified based on your purpose.

You should comment on the validity and meaning of any test you conduct in the context of the test result.

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 an Appendix.

End of scenario, the Pilot study data is below:

Punctual Essays
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.


Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.


Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.


Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.


Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.