Statistical Analysis of Microtitre Lab Data Assignment

Statistical Analysis of Microtitre science lab Data - Assignment ExampleIn order to answer them you must have conducted the abbreviation and mute how to interpret the information and the statistical analysis. You may therefore refer to the proforma during the test.Graphs should be constructed in Excel and coat 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. lay down a calibration curve using all of the data provided (i.e. all replicates for individually concentration not the mean absorbance grades). You must conduct Linear Regression Analysis using Excel and provide the R2 value and the comparability of the line of best fit (y=mx +c, where y represents absorbance, x is the concentration of protein, m is the hawk of the line of best fit and c is the intercept of the line on the y-axis).2. Refer to the quality delay 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 be sick of the calibration curve, you will only conduct your analysis on the absorbance values to determine whether each of the detergents has an imprint 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