Embedded Files
SEE BELOW FOR CHARTS/ SCREENSHOTS
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.
Answer
ELEVATION=(J2:J88) = 705.2873563
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?
Answer
There are more female butterflies. This Is quantitative data- it measures the quantities of butterflies.
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?
Answer Primarily, the butterflies prefer rain forests. 39% prefer cloud forests whereas 20.7 prefer dry forests and 40.2 prefer rainforests. This is qualitative data.
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?
Answer
What year was the data about each butterfly collected? The data that is in this chart is qualitative.
5. (Activity 3) Include a screenshot and link of the map you created for this data. (SEE BELOW)
https://drive.google.com/open?id=1NsYFlN6c9wL-eYx_1triXbbOX4LpwjwU&usp=sharing
Google Sites
Report abuse