Statistical Analysis of Microtitre Lab Data Assignment

Statistical Analysis of Microtitre Lab Data - Assignment Example In order to answer them you must have conducted the analysis and understood how to interpret the data and the statistical analysis. You may therefore refer to the proforma during the test. Graphs should be constructed in Excel and sized to fit the allotted space. The aim of this assignment is for you to demonstrate the ability to conduct a statistical analysis on a set of data and report the findings in a scientific manner. You should use SPSS for the ANOVA. 1. Construct a calibration curve using all of the data provided (i.e. all replicates for each concentration NOT the mean absorbance values). You must conduct Linear Regression Analysis using Excel and provide the R2 value and the equation of the line of best fit (y=mx +c, where y represents absorbance, x is the concentration of protein, m is the slope of the line of best fit and c is the intercept of the line on the y-axis). 2. Refer to the quality control data set on the Excel spreadsheet, below the calibration curve data. Using the values of the equation of the line of best fit from the calibration curve, take each absorbance value for the quality control data and calculate the concentration of protein for each replicate. You should then calculate the mean, standard deviation and coefficient of variation (see notes from Statistics Lecture 1) for each concentration and insert them into Table 1: As the absorbance values of the data are beyond the range of the calibration curve, you will only conduct your analysis on the absorbance values to determine whether each of the detergents has an effect upon the absorbance produced for a set concentration of protein (0.5mg/cm3)). From the above table (ANOVA table), we observe p-value=0.000