Assignment:
Create Word document with responses to the following:
Review the locations that were tested by the class. Create a hypothesis to investigate using the class data (these do not have to relate to your individual project or to specific sources of pollution but they can!). They need to be answerable based upon the data the class is collected. Make sure to make it specific, clear and testable.
What are the dependent and independent variables for your hypothesis.
What are confounders in this experiment (be thorough)?
What are constants for this experiment (be thorough)?
Summarize the class data so that you can answer your hypothesis. For example, you will need to graph the data related to your hypothesis and create a summary table with tallies, averages, etc. You must produce at least one graph and one table (both must be electronically generated). Don't forget to properly title and label. See first Module for tutorial about how to sort in Excel. You may need to create a new column in Excel to classify the water bodies depending on your hypothesis.
Is your hypothesis supported by the class data? Answer by referring to specific aspects of the data and explaining how you reached your conclusion.
Form a conclusion. Think about the larger concept of water pollution and implications.
Attachment:- class data.xlsx