Lotic (Buell Brook) Lentic (Johnson Park) Team 1 69.4 Team 2 74.8 Team 3 71.6 Team 4 67.8 Team 5 80.8 Team 6 63.71. Use the table below to report the calculated means, standard deviations (SD), and p-value for the results of the class WQI scores analysis. Report the WQI rating for the mean of each water source as well. + Sample WQI Score WQI Rating Mean + SD and WQI rating 70.6 + 0.91 at Buell Brook Mean + SD and WQI rating 68.7 + 26.5 at Pond at Johnson Park p-value comparing the mean WQI at Buell Brook vs. Pond at Johnson Park 2. Create a bar graph ("column chart" in Excel) with error bars and all of the components for a proper figure. Copy and paste the graph and insert the legend below. WHEN PASTING, PASTE A SCREENSHOT (NOT DIRECTLY FROM EXCEL) TO ENSURE THAT YOUR GRAPH DISPLAYS PROPERLY ON CANVAS):Is the difference between the mean WQI at Buell Brook (water sample A) and the Pond at Johnson Park (water sample B) statistically signicant? How did you come to this conclusion? Based on your answer above, which water source has a higher water quality or is the water quality of both sources statistically the same? Using your knowledge of aquatic ecology, give one possible reason why. Based on what you have learned about statistics, give one benet of using data from multiple teams. Part B: Freshwater Ecosystems Research Considering what you learned in Lab 2, how would a change in the pH of a body of water affect the aquatic organisms living there on the molecular level? 7. a. What might high biochemical oxygen demand (BOD) in a body of water indicate? b. What is one human activity that can contribute to the BOD of a body of water? Describe how this activity would cause the change in BOD. 8. a. Discuss two sources of high levels of fecal coliform in a body of water. b. Though most strains of E. coli are non-pathogenic, why might a scientist be concerned by multiple \"positive\" fecal coliform tubes and a high calculated MPN for a sample of water? 9. You are interested in studying the water quality at Lake Hopatcong in New Jersey. You visit the lake at 8:00AM to collect water for your experiment. While you are there, you measure the temperature of the lake at one location and nd that the reading is 233C. You measure the remaining parameters for WQI once you are back at the lab. What is the issue with your data collection? Why? (Be specic)