Computing Assessment

1
Computing Assessment
Name:
University Name:
Professor Name:

2
Problem 1
According to Manfroid J, Selman F et al.001, the photometric accuracy is
viewed as how close to the correct value is the measured absorbance of a
sample. This requires material of exactly known absorbance. A solution has
to be made up from the solid hence leading to potential errors and
variances.
Given the data from spectrophotometric test of a sample, you are to use the
ANOVA test to perform the quantitative analysis of the samples.
Hence statistical analysis was performed by one-way (or one-factor) analysis
of variance (ANOVA) using Excel 2010.It was assumed that (p<0.05) .
Hypothesis:
Ho: the null hypothesis that there is variation in the test result of the three
samples of the antiviral drugs i.e EMT, TDF, RPV.
H1: the alternative hypothesis that there is no variation in the test result of
three samples. Figure A below shows a line graph of Wavelength against the
concentration of the three samples: EMT, TDF and RPV
EMT TDF RPV
0
50
100
150
200
250
300
350
Concentration( μg/ml)
Wavelengthʎ/n
From the graph, the distribution is higher in terms of wavelength than in
concentration in all the three samples. MT depicts the lowest concentration
and wavelength, followed by TDF and highest in RPV where the
concentration is optimum and equal.

3
Anova: Single Factor
SUMMARY
Groups Count
Su
m
Avera
ge
Varian
ce
ʎ/nm 3
80
4 268
1130.
88
3 0 0 0
EMT 3
0.8
57
0.285
667
0.032
35
TDF 3
0.4
89 0.163
0.020
307
RPV 3
0.3
19
0.106
333
0.004
666
TBL 3
1.2
74
0.424
667
0.046
566
ANOVA
Source of
Variation SS df MS F
P-
valu
e F crit
Between
Groups
17929
7.9 5
35859
.57
190.2
392
5.4E
-11
3.105
875
Within
Groups
2261.
968 12
188.4
973
Total
18155
9.8 17

4
0.5 1 1.5 2 2.5 3 3.5
0
50
100
150
200
250
300
350
Wavelengthʎ/n
Concentration( μg/ml)
FIGUREB:The Line graph of Wavelength against the concentration of the
three samples.
ʎ/nm EMT TDF RPV
240.8 0.435 0.264 0.062
257.6 0.336 0.225 0.072
305.6 0.086 0 0.185