Question

im writing a lab report and in the picture is the data we pulled the professor wants us to have the data sheet and also a graph what type of graph should i use? im guessing the only information important is the chip color and # of survivors after each round column. im on excel and ive tried highlighting columns and making a graph but never makes sense please let me know what columns to high light and what graph to choose.

A D E G H M Initial Population After Predation Round # 2 After Predation Round #1 After Predation Round #3 Chip Color Starting # Starting #after # of of each%of Each Survivorsreproduci color in new Survivors #after after % of each % of each reproduci color in new % of each reproduci color in new #of #of (survivors (survivors (survivors population Survivors population population Chip Chip x4) x4) x4) 1 Red 10 10% 0 0 0 0 0 2 10 10% 0 0 orange 0 0 0 0 0 0 3 yellow 10 10% 4% 0 0 0 0 4 10 10% 3 green 12 12% 16 16% 5 20 20% 5 blue 10 10% 3 12 12% 2 8% 1 4 4% 6 purple pink brown 10 10% 3 12 12% 3 12 12% 5 20 20% 7 10 10% 4 16 16% 0 0 0 0 10 10% 3 12 12% 32 32% 2 8% black 10 10% 4 16 16% 4 16 16% 7 28 28% 10 white 10 10% 4 16 16% 4 16 16% 5 20 20% Totals: 100 100% 100 % 25 100 25 100 100% 25 100 100%

Answer 1

The columns that are useful and need to be highlighted are Chip Colour, Initial Population, # of survivors in each round with an independent dataset of each of the given 3 predictive rounds with respect to the chip color and initial population, this is going to give you an idea predictive results with the initial data. The clustered columns charts should be used in excel as these will provide effective results in comparing the different data series. Data points should be starting # of each chip and # of survivors in each predictive round and they should be divided based on the color.