Edit 2: There is no photo. It can't be blurry.

EDIT: We're going from Matlab to Python, and the purpose of the code is to

Part a: Perform linear regression analysis for the relevant 28 wells (against time) to obtain the slopes. - For each concentration (e.g. 10 L), calculate the average slope and the standard deviation of the slope based on the four replicates. - Create a calibration curve by plotting the average slopes standard deviation (the command errorbar might help). Also use linear regression and add the line to the plot. Please report the coefficients.

Part b) Perform linear regression analysis on the relevant dataset and calculate the average slope for the 4 DI-wells. - Use the calibration curve you created in b) to calculate what number of cells (volume equivalent) was alive in the DI-wells. - Calculate the percentage of cells killed considering that initially 200 L of cells were in the wells.

And finally: Complete the same calculation that was done for DI for the 16 new formulations. Present the percent killed for the 16 formulations in a bar graph.

The assignment file is just an excel sheet of all the data we need.

Convert this code to python:

data=xlsread('Assignments3.xls'); data=data(39:end,:); data=data(1:end-4,:); a=ones(96,2); for i = 1:96 a(i,:)=polyfit(data(:,2),data(:,3+i),1); plot(data(:,2),data(:,3+i)) end for i=1:24 average_slopes(i)= mean(a(1+4*(i-1): 4+4*(i-1))); std_slopes(i)= std(a(1+4*(i-1): 4+4*(i-1))); end c_bacteria=[0,10,20,30,40,50,60]; errorbar(c_bacteria, average_slopes(1:7), std_slopes(1:7),'x') P=polyfit(c_bacteria, average_slopes(1:7),1) hold on plot([min(c_bacteria),max(c_bacteria)],polyval(P, [min(c_bacteria),max(c_bacteria)])) hold off % DI C_DI=(average_slopes(8)-P(2))/P(1); DI_percent_killed=100-C_DI/200*100 % formulations C_Fn=(average_slopes(9:24)-P(2))./P(1); Fn_percent_killed=100-C_Fn/200*100 figure(2) bar(Fn_percent_killed)