Excel Graphing

.docx

School

Xavier University *

*We aren’t endorsed by this school

Course

160

Subject

Biology

Date

Feb 20, 2024

Type

docx

Pages

3

Uploaded by DeaconGuanaco3910

Excel Graphing Basics & Statistical Analysis Name: Grace Heringer Section: Instructions: Use Excel to make appropriate graphs for the following sets of data. Copy and paste your completed graphs back in this document. Remember: You need to select the appropriate type of graph, make sure the Y and X axis are properly labeled, give a graph title and a figure legend (if needed). Then complete the questions around statistical analyses. (18 pts total) Reading Assignment: Read sections 5.2 - 5.5 in Writing in The Biological Sciences. Watch this video tutorial ( https://app.vidgrid.com/view/q5HYeWdhW1bJ/?sr=LRBR757qqS6V ) before beginning. DATA SET 1: This lab conducted a research project to compare how air pollution in 2020 compared to 2019. The purpose is to see if the global pandemic affected pollution. Pollution is measured as the number of pollutant molecules suspend in the air per million molecules sampled or (ppm). The data below is looking at the monthly average. Jan 2019 = 10ppm Jan 2020 = 11ppm Feb 2019 = 8ppm Feb 2020 = 10ppm March 2019 = 14ppm March 2020 = 11ppm April 2019 = 16ppm April 2020 = 12ppm May 2019 = 30ppm May 2020 = 16ppm June 2019 = 89ppm June 2020 = 20ppm July 2019=102ppm July 2020 = 45ppm
DATA SET 2: A research group has developed a new disinfectant called Ridex. To test the efficiency of the chemical they measure how many live bacteria they recovered after treating a bacteria laced surface with the chemical for 2 minutes. Ridex was tested against 2 different bacteria species, E. coli and S. epidermidis . For comparison the also repeated the experiment by treating the bacteria with Clorox (positive control) or with water (negative control). E. coli treated with water = 2400 live bacteria E. coli treated with Clorox = 400 live bacteria E. coli treated with Ridex = 300 live bacteria S. epidermidis treated with water = 2400 live bacteria S. epidermidis treated with Clorox = 200 live bacteria S. epidermidis treated with Ridex = 40 live bacteria
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help