Question

how to use excell to Using excel, You will need to plot the log of the copy number (x axis) against the CT values (Y-axis) and generate a line of best fit together with an R2 value (which measures the goodness of fit).

copies per UL		cq(Value)
10,000,000		28.87
1,000,000		32.01
100,000		35.27
10,000		38.87

Answer 1

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.9995003
R Square	0.99900084
Adjusted R Square	0.99850127
Standard Error	0.16631296
Observations	4
ANOVA
	df	SS	MS	F	Significance F
Regression	1	55.31138	55.31138	1999.688	0.000499703
Residual	2	0.05532	0.02766
Total	3	55.3667
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	52.048	0.417442212	124.6831	6.43E-05	50.25189113	53.8441089
log (x)	-1.4444634	0.032301701	-44.7179	0.0005	-1.58344645	-1.3054804