Hanna kim Lab 1 Safety Excel Stats Report_Sp24-1

pdf

School

University of California, Berkeley *

*We aren’t endorsed by this school

Course

1AL

Subject

Biology

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by CorporalTankDinosaur33

Lab Report LAB 1: Safety & Intro to Graphing and Stats Bio 1AL Spring 2024 Last Name Kim First Name Hanna Lab Section # 415, Grp 9 Lab 1 Lab Report 1) PAV data graph Graph the PAV taste receptor data from the Bufe data Excel file on the Lab 1 home page. Refer to the directions in the Lab 1 Procedures (in lab procedures reader). See videos on the Excel Graphing Resources page in bCourses. Save the graph in Excel as an image ( Ctrl Click on the graph > Save as Picture or take a screenshot) and paste the image below. (3 pts) When making your graph: Omit the chart title and create a legend Omit grid lines Include major tick marks (outside) Increase the font size for axis labels Use bold font for axis titles Use 1 decimal place for values on the y-axis Figure 1. Cellular response of TAS2R38- PAV variant to increasing PTC concentration (from Bufe, et al, 2005). 1-1

Lab Report LAB 1: Safety & Intro to Graphing and Stats Bio 1AL Spring 2024 2) EC 50 t-test a) State the null hypothesis for the EC 50 t-test. (0.5 pts) There is no statistically significant difference between the mean EC 50 for PTC for PAV variant compared to the mean EC 50 response for PROP for PAV variant. b) Calculate the mean and standard error of the mean (SEM) for the PTC and PROP EC 50 data in the Bufe data Excel file on the Lab 1 home page. Refer to Excel Graphing Resources Video 1 for how to calculate mean and SEM. Input the values in Table 1 below. (1 pt) Table 1. Comparison of EC 50 for PTC vs. PROP for PAV variant of TAS2R38 receptor EC 50 for PTC for PAV variant EC 50 for PROP for PAV variant Mean EC 50 1.14 2.14 SEM 0.53 0.87 c) Run an Independent Sample t-test using VassarStats, and record the relevant values below. See the Comparing Two Means page in bCourses for guidance on performing and interpreting the t-test. (1 pt) t = -0.98, df = 12, p (2-tailed) = 0.346 d) Based on the t-test results, is there a significant difference between the mean EC 50 value for PTC vs. PROP? Which value (t, df or p) indicates whether or not the difference is statistically significant? (1 pt) Significant difference? (Circle/highlight) Value indicating significance (Circle/highlight) YES NO t df p value e) Based on the t-test results, what should you do with regard to the null hypothesis? (circle one) (0.5 pts) Reject the null hypothesis Fail to reject the null hypothesis 3) Chi squared test (Refer to the Chi squared test page in bCourses) a) State the null hypothesis for the Chi squared test for PTC taste intensity. (0.5 pt) There is no association between the TAS2R38-(PAV and AVI) receptor variant and PTC taste perception (intensely bitter vs. not intensely bitter). b) Complete the contingency table in the PTC intensity tab of the Bufe data Excel file. Remember not to 1-2

Lab Report LAB 1: Safety & Intro to Graphing and Stats Bio 1AL Spring 2024 round numbers. Use formulas in Excel to calculate the totals and proportions. Paste a screenshot of your contingency table below. (0.5 pt) c) Complete the Chi squared calculation table and paste a screenshot of it below. (1 pt) d) Circle/highlight the p value range for your calculated Chi squared value. Refer to the Chi Squared Distribution Table (Table 2) on the next page. (0.5 pt) p > 0.100 0.050 < p < 0.100 0.025 < p < 0.050 0.010 < p < 0.025 0.005 < p < 0.010 0.001 < p < 0.005 p < 0.001 e) Based on the results from the Chi squared test, what should you do with the null hypothesis? (0.25 pts) Reject the null hypothesis Fail to reject the null hypothesis f) What can you infer about the association between the TAS2R38 receptor variant and PTC taste perception? (0.25pts) PAV vs AVI and PTC taste perception are dependent and those with the PAV receptor variant are more likely to have an intense PTC taste perception as opposed to cells with the AVI receptor variant. 1-3

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Lab Report LAB 1: Safety & Intro to Graphing and Stats Bio 1AL Spring 2024 Table 2. Chi Squared Distribution Table https://www.di-mgt.com.au/chisquare-table.html 1-4

Related Documents

Lab 6 Cellular Respiration Virtual Lab Worksheet (1) Doc.docx

Exercise 2_Hardy-Weinberg_Modified.docx

straighterline-ap2-circulatory-lab-11.pdf

straighterline-ap2-lymphatic-12-lab.pdf

Hanna Kim Lab 3 - Cells Report_Sp24 (1).pdf

Lab 4 - Enzymes Flowchart_Sp24.pdf

Unit I study guide.docx

425_PS2_2020 4.docx

Cardiovascular Lecture 1 Solutions - PHGY 210 2024 - Copy.docx

Case Study Instructions.docx

Lab 5 BIOL 1120 Homework Animal Kingdom (student) 24S.docx

midterm-2-deferred-bio-1140-2022.pdf

Recommended textbooks for you

Understanding Health Insurance: A Guide to Billin...

Health & Nutrition

ISBN:9781337679480

Author:GREEN

Publisher:Cengage

Surgical Tech For Surgical Tech Pos Care

Health & Nutrition

ISBN:9781337648868

Author:Association

Publisher:Cengage

3-2-1 Code It

Biology

ISBN:9781337660549

Author:GREEN

Publisher:Cengage

Essentials Health Info Management Principles/Prac...

Health & Nutrition

ISBN:9780357191651

Author:Bowie

Publisher:Cengage

SEE MORE TEXTBOOKS

Recommended textbooks for you

Understanding Health Insurance: A Guide to Billin...
Health & Nutrition
ISBN:9781337679480
Author:GREEN
Publisher:Cengage
Surgical Tech For Surgical Tech Pos Care
Health & Nutrition
ISBN:9781337648868
Author:Association
Publisher:Cengage
3-2-1 Code It
Biology
ISBN:9781337660549
Author:GREEN
Publisher:Cengage
Essentials Health Info Management Principles/Prac...
Health & Nutrition
ISBN:9780357191651
Author:Bowie
Publisher:Cengage