Statistical Analysis of Microtitre Lab Data Assignment

Statistical Analysis of Microtitre Lab Data - Assignment ExampleIn order to answer them you must have conducted the summary 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 pass by and sized to fit the allotted space. The aim of this naming 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 occasion SPSS for the ANOVA.1. Construct a calibration curve using all of the data provided (i.e. all replicates for for each one concentration NOT the mean absorbance values). You must conduct bilinear 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 lo ok 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 1As 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