biology181 i need complete asap

profile[email protected]
LastName_FirstName_CB_Act_2_Workbook.xlsx

Q2-8 GF-L and R1

Presence or Absence of GF-L Activity of R1 (%) Dummy Code
Absent 4.9
Absent 3.2
Absent 4.9 Slope:
Absent 4.8 Intercept:
Absent 4.2 Standard Deviation:
Absent 3.1 Absent
Absent 4.0 Present
Absent 4.2
Absent 4.0
Absent 3.6
Present 3.9
Present 3.3
Present 4.0
Present 4.3
Present 4.7
Present 3.8
Present 3.6
Present 3.3
Present 4.7
Present 3.2

Calculate the slope, intercept, and standard deviation of the linear relationship between the categorical independent variable (absence or presence of GF-L) and the activity of Receptor 1 (R1). Now, use the data to estimate the mean activity of Receptor 1 (R1) in both the absence and presence of GF-L. (Hint: Use 𝜇 = aX + b) Create a plot of a linear relationship plot like the graphs is Figure 1 between the categorical independent variable and the calculated activity of Receptor 1 (R1) in the absence or presence of GF-L. (Hint: Notice how there are only two points on figures with standard deviation bars.) Refer to the lab packet for formatting instructions. Use this Excel sheet for calculations. Round all calculated values to the nearest tenth of a decimal place. For example, if you calculate the value as 3.8218, round to 3.8.

Q9-15 GF-L and R2

Presence or Absence of GF-L Activity of R2 (%) Dummy Code
Absent 4.9
Absent 3.7
Absent 4.0 Slope:
Absent 4.6 Intercept:
Absent 4.3 Standard Deviation:
Absent 4.0 Absent
Absent 4.0 Present
Absent 4.9
Absent 3.6
Absent 3.9
Present 66.1
Present 74.6
Present 79.8
Present 71.1
Present 69.0
Present 63.2
Present 63.0
Present 62.5
Present 64.3
Present 69.8

Calculate the slope, intercept, and standard deviation of the linear relationship between the categorical independent variable (absence or presence of GF-L) and the activity of Receptor 2 (R2). Now, use the data to estimate the mean activity of Receptor 2 (R2) in both the absence and presence of GF-L. (Hint: Use 𝜇 = aX + b) Create a plot of a linear relationship plot like the graphs is Figure 1 between the categorical independent variable and the calculated activity of Receptor 2 (R2) in the absence or presence of GF-L. (Hint: Notice how there are only two points on figures with standard deviation bars.) Refer to the lab packet for formatting instructions. Use this Excel sheet for calculations. Round all calculated values to the nearest tenth of a decimal place. For example, if you calculate the value as 3.8218, round to 3.8.

Q25 Cancerous Pathway

Now you will complete the cancerous signaling pathway. This sheet (tab) includes an incomplete diagram of the cancerous signaling pathway in spotted gliders. Follow the five steps in the Mission Memo to complete the pathway when GF-L is present based on the information you found in Appendix 2.

P

Q26-37 Amino Acid Help

Help with Q26-34
Amino Acid Polarity
Alanosine (Alo)
Serine (Ser)
Norvaline (Nor)
Mimosine (Mim)
Valine (Val)
Aminohexanedioic Acid (Hex)
Glycine (Gly)
Pyrrolysine (Pyr)
Canavanine (Can)
Ornithine (Orn)
Tyrosine (Try)
Isoleucine (Ile)
Histidine (His)
Methylglutamic Acid (Mga)
Help with Table 1 Q35-37
1st base 2nd base 3rd base
X C Y G
X XXX Methylglutamic acid (Mga) XCX Serine (Ser) XYX Tyrosine (Tyr) XGX Cysteine (Cys) X
XXC XCC XYC XGC C
XXY XCY XYY XGY Y
XXG XCG XYG XGG Tryptophan (Trp) G
C CXX Methionine (Met) CCX Proline (Pro) CYX Histidine (His) CGX Selenocysteine (Sel) X
CXC CCC CYC CGC C
CXY CCY CYY Glutamine (Gln) CGY Y
CXG CCG CYG CGG G
Y YXX Isoleucine (Ile) YCX Threonine (Thr) YYX Mimosine (Mim) YGX Alanosine (Ala) X
YXC YCC YYC YGC C
YXY YCY YYY Pyrrolysine (Pyr) YGY Canavanine (Can) Y
YXG YCG YYG YGG G
G GXX Valine (Val) GCX Norvaline (Nor) GYX Aminohexanedioic acid (Hex) GGX Glycine (Gly) X
GXC GCC GYC GGC C
GXY Stop GCY GYY Ornithine (Orn) GGY Y
GXG GCG Stop GYG GGG G
Table 1
Binding Site of R2 Amino Acid Codons
1
2
3

Refer to the Amino Acids of Phygaris table and the Chemistry Notes for Cell Biology Act 2 to determine the polarity of each amino acid chain. This information will guide your responses to Appendix 3 questions Identify the three amino acids required for binding to tumor cell receptors (from your answer to Question 32). List all corresponding codons in Table 1. This tab is a resource only and will not impact your Excel workbook grade. It is designed to support you in answering Q26-37 effectively.

TA Sheet

TA Use Only
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A

image1.jpg

image2.jpg

image3.jpg