Biology181 i need complete asap | Biology homework help

1. Use the sheet (tab) to create a plot of a linear relationship between the categorical independent

variable (absence or presence of GF-L) and the mean activity of Receptor 1 (R1). Your plot should follow the formatting guidelines listed below. Formatting Instructions ● Chart type: Line with Markers ● Quick layout: Layout 4 ● Chart title: “Activity of R1 in response to GF-L”, Font = 20 ● Y-axis title: “Activity of R1 (%)”; Font size = 16 ● Y-axis numbers: Font size = 14 ● Y- axis minimum = 0, maximum =100 ● X-axis title: “Absence or presence of GF-L”; Font size = 16 ● X-axis numbers: Font size = 14 ● Line: No line ● Note: Make sure that your categories are labeled “Absence” and “Presence,” not “0” and “1.” Refer to Figure Pairs A-D as examples of what you should see. Marker ● Marker options: Built-in, Filled in circles, Size = 10 Error bars → Standard deviation ● Direction: Both ● End Style: Cap ● Error amount: Custom → Select the cell in which you calculated the standard deviation in Excel. You should select this cell for the positive and negative error values. ● Line: Solid line ● Color: Black ● Width: 1 pt ● Note: It is okay if the bars are not visible.