Question

please help me construct a graph by using data Table 1, Trials 1-9 normalized AP activity

E. In the following space, construct a graph that summarizes the information in Table 1. Trials 1 9. normalized %AP activity. The graph should meaningfully and accurately communicate the results of your experiments. (You are welcome to use a graphing program and print your response, but please TAPE your response to this assignment so that it fits in the space.) 6. (9pts) SNAREs exist as complementary partners that carry out membrane fusions between appropriate vesicles and their target membranes. In certain cases, membrane vesicles destined to fuse contain both v- and 1-SNARES. You conduct a series of experiments to test how V- and t-SNAREs function by mating two strains of yeast. If the vesicles from the two strains fuse successfully, that activates an enzyme called alkaline phosphatase (AP), whose activity can be measured in arbitrary units). In each trial, the two strains will express on their vesicles either no SNARES (-) V-SNAREs only (v); t. activity of alkaline phosphatase over three replicates. Your results for average values +/- standard errors are listed in the 4 column of Table 1. (For this question, you might consider using a spreadsheet program like Excel or Google Sheets.) Table 1 Trial # Strain 1 Strain 2 AP activity 1 vt t vt t vt vt V vt % AP activity, (normalized) TOO. 101. 41- 67. 507. +/- 10. 461.+/- 167 81.+/-61. 121.+/-41. 87.-94. 401.4-128. 3 6 7. +/-10% 50 +/- 3 5 +/-3 25 +/- 10 23 +/- 8 4 +/-3 6 +/-2 4 +/- 2 20 +/- 6 18 +/- 9 V vt Vt 1. AP activity Trall 1 50/-3/50/3 100 Tal 2 5 -3/50+/-3 = 10%/.6% Trall 3 -25+/-10/50/-3-50 - 10% Thal 4 23+/-8/50+/-3 -46% -16% . -3/50/-3-0- • 6-6 -2750+/-3 12 -4% • Thal T 41-2/50+/- +/- 45 T 2 0/-6/50+/- 340+/-12% Trial 9164-9/504- 3 36 -10

Answer 1

For this data MS excel is used to make a graph.

%AP_act 120 100 vt-vt t- t t-vt vt- t v-v vt vt t-v vt
This graph properly summarises the data.
As there Is high AP activity when both v and t SNARE interacts. The first data could be used a control.
steps involved in making this graph on MS excel are

STEP 1.

make a table with columns of strain interactions, %AP activity, Negative standard error and positive standard error.

STEP 2.

select the first two columns and click the column option and choose clustered column. You will get a graph without standard error.

STEP 3

now select layout option and then error bars option. Click more error bar at the bottom.

Click vertical error bar and click custom option.

STEP 4

select the positive standard error column and insert the values in the positive error value in custom error bars.

do the same with negative values.

click ok and close. You will get the following graph.

i am not being able to upload the screenshots of the procedure right now due to very poor internet connection. But I will upload it in the comment sections if you need them. Please let me know.