7.03 Visualizing Data

7.3 Visualizing Data Curriculum Page

1. (Activity 2) Write a spreadsheet formula that calculates the average elevation for the data in this spreadsheet. Write your formula and the result found in your portfolio.
   • Formula: =AVERAGE(J2:J88)
   • Result: 705.29 feet
2. (Activity 2) Are there more male or female butterflies in this data set? Include a screenshot of your chart to answer this question. What kind of data is in your chart?
   • There are more female butterflies in this data set. The kind of data in the chart is text.
   • Screenshot of chart attached below.

3. (Activity 2) Which ecological environment (primary eco column) do these butterflies like to live in? There is no clear winner in this question so give the percentages in each ecological environment in a screenshot of your chart. What kind of data is in your chart?

• The butterflies mostly like to live in the rainforest (40.9%). The kind of data in this chart is textual. The percentages in each ecological environment is shown in the screenshot of the chart attached below.

4. (Activity 2) Come up with a 3rd question and use charting to answer it. Include the screenshot. What kind of data is in your chart?

• Question: What is the most common host plant family?
• Answer: Fabacea (55.8%)
• The kind of data in my chart is textual.

5. (Activity 3) Include a screenshot and link of the map you created for this data.

• https://drive.google.com/open?id=1GJI3CXci4HPQUCAdVs1sBxOcPAW22Hae&usp=sharing