Question

 

1. For the data below create a table in excel and a graph to accompany. (the table and graph are two separate supplements so make sure each is labeled and formatted properly.) Hint: You are making the table in excel because you can make the graph straight from the data.

Each group recorded the level of carbon monoxide measured (ppm) in a running car every 15 seconds for 2 minutes with a Graywolf indoor/outdoor air quality monitor. They start recording at zero seconds.

Group 1, 1994 Ford Focus: 58, 50, 42, 36, 30, 25, 25, 24, 23

Group 2, 2008 Ford F150: 12, 15, 15, 16, 17, 16, 15, 14, 15

Group 3, 1988 Chevy Nova: 112, 80, 80, 70, 60, 55, 45, 40, 40

Group 4, 2014 Honda Accord: 12, 14, 16, 20, 30, 30, 35, 40, 48

Group 5, 2010 Hyundai Santa Fe: 50, 45, 43, 42, 30, 23, 13, 8, 7

Group 6, 2003 Subaru Forester: 66, 45, 40, 33, 32, 21, 20, 120, 17

2. Create a table in Microsoft word for the following data.

Scientists tracked and observed a Black Bear (Ursus Americanus) named Stachi over the course of 6 years. Once a year they would document her weight and height, geolocation, fetal development, and body condition.

December 1999- 97 lbs., 55 in., (39.7576202, -74.1062466), No, Average

December 2000- 135 lbs., 55 in., (39.695866, -74.253511), Yes, Fat

December 2001- 102 lbs., 55 in., (39.5585, -74.3706), No, Average

December 2002- 99 lbs., 55 in., (39.7576202, -74.1062466), No, Average

December 2003- 122 lbs, 55 in., (39.695866, -74.253511) Yes, Fat

December 2004- 70 lbs., 54 in., (39.49026, -74.53915), No, Thin

Answer 1

Question 1

2.