Copy of Lab 1 Safety Excel Stats Report_Sp24

.pdf

School

University of California, Berkeley *

*We aren’t endorsed by this school

Course

1A

Subject

Biology

Date

Feb 20, 2024

Type

pdf

Pages

4

Uploaded by allthingsabby03

Report
Lab Report LAB 1: Safety & Intro to Graphing and Stats Bio 1AL Spring 2024 Last Name Daniyan First Name Abigail Lab Section # 217 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 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 significant difference between the mean EC50 values for PTC and PROP. 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.32 2.49 SEM .053 .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.346431_____ 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 receptor variant and PTC taste perception. b) Complete the contingency table in the PTC intensity tab of the Bufe data Excel file. Remember not to 1-2
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