>Biology homework help.
• The data are provided in the Excel file, “Lab 8_Courtship vs Abundance”. The data represents summed calling intensity per evening for silver perch, spotted seatrout, and red drum at station 37M during 2018. In addition, I have included the summed abundance from seines on respective dates from sites near station 37M. Cells colored in grey correspond to missing data.
• Your goal is to create a time series that plots summed calling intensity as the primary y-axis and summed YOY abundance as the secondary y-axis for the year 2018. You will create three separate figures for each fish species (i.e. silver perch, spotted seatrout, and red drum).
• The chart type should be “Combo”. Select “Area” for calling. Select the secondary axis for abundance and “Scatter”. Silver perch “light green”, spotted sea trout “light blue”, and red drum “orange”. Please make sure to include labeled x-y axes; however, please do not include a title since you will create a figure legend. Please make sure that your font size is at least 10.
• Insert your figures into a Word document. Below each figure, provide a figure legend. The legend should provide: (i) a general description of the figure; and (ii) provide your interpretation of the figure.
• Completion of the figure, correct format – 40 points.
• Completion of figure legend below figure – 30 points.
• Figure legend content and writing – 30 points.