Excel Activity in VBA, Exercises of Computer science

About VBA in excel. Using VBA in Excel

Typology: Exercises

2021/2022

Uploaded on 09/16/2023

jhezarie-amsiwen
jhezarie-amsiwen 🇵🇭

1 document

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Jhezarie S. Amsiwen 12-Perseverance
A. A turmeric extract was proposed to be used as an anti-bacterial. Thus, different
concentrations of the said extract were used to see the zone of inhibitions of two bacteria (E.
Coli & S. Aureus).
Statistical tool used: Anova: Single Factor
Table 1. Zone of the inhibitions of the bacteria with different turmeric
extract concentrations (e-coli)
FACTORS
MEAN
P-VALUE
INTERPRETATION
25%
8.5
0.0000196
768436153
325
There is a significant difference among the zone of
inhibitions of the bacteria with different turmeric
extract concentrations.
50%
6.33333
3
75%
6.16666
7
100%
6.66666
7
Table 1. Zone of the inhibitions of the bacteria with different turmeric
extract concentrations (S.aureus)
FACTORS
MEAN
P-VALUE
INTERPRETATION
25%
8
0.1265649
27
There is no significant difference among the zone
of inhibitions of the bacteria with different turmeric
extract concentrations.
50%
6.4
75%
6.4
100%
6.6
Question 1a: Is there a significant difference among zone of the inhibitions of the bacteria with
different turmeric extract concentrations? Give some implications.
In order to find out if there is a significant difference among the zone of inhibitions of
the bacteria with different turmeric extract concentrations, Anova was the most appropriate to
use. Based on the data analysis on samples with E-coli, the P-value is less than the accepted
value of 0.05, which means that the null hypothesis will be rejected, while the samples with the
S.aureus bacteria is greater than the value of 0.05, thus accepting the null hypothesis. This
pf3

Partial preview of the text

Download Excel Activity in VBA and more Exercises Computer science in PDF only on Docsity!

Jhezarie S. Amsiwen 12-Perseverance A. A turmeric extract was proposed to be used as an anti-bacterial. Thus, different concentrations of the said extract were used to see the zone of inhibitions of two bacteria (E. Coli & S. Aureus). Statistical tool used: Anova: Single Factor Table 1. Zone of the inhibitions of the bacteria with different turmeric extract concentrations (e-coli) FACTORS MEAN P-VALUE INTERPRETATION 25% 8.

768436153 325 There is a significant difference among the zone of inhibitions of the bacteria with different turmeric extract concentrations.

Table 1. Zone of the inhibitions of the bacteria with different turmeric extract concentrations (S.aureus) FACTORS MEAN P-VALUE INTERPRETATION 25% 8

27 There is no significant difference among the zone of inhibitions of the bacteria with different turmeric extract concentrations.

Question 1a: Is there a significant difference among zone of the inhibitions of the bacteria with different turmeric extract concentrations? Give some implications. In order to find out if there is a significant difference among the zone of inhibitions of the bacteria with different turmeric extract concentrations, Anova was the most appropriate to use. Based on the data analysis on samples with E-coli, the P-value is less than the accepted value of 0.05, which means that the null hypothesis will be rejected, while the samples with the S.aureus bacteria is greater than the value of 0.05, thus accepting the null hypothesis. This

means that there is a significant difference among the zones of inhibition of the samples with different turmeric concentrations on the E Coli bacteria while there is no significant difference between the zones of inhibitions of the samples with the S.aureus bacteria. This indicates that the difference in turmeric concentration has also a different effect as an antibacterial only on E-coli, its effect as an antibacterial will differ depending on the concentration of turmeric, while the mean value of the zone of inhibition of the s.aureus bacteria has no difference, which means that its effect won’t differ as much. Question 2: Which concentration of the turmeric extract has the best anti-bacterial property for each of the bacteria? It is mentioned that having a lower zone of inhibition means that it has a better antibacterial property, and looking at the mean value of each concentration for the bacteria E.coli, 75% turmeric concentration is the most effective as an antibacterial, while 25% turmeric concentration would be the least effective on E-coli bacteria. On the other hand, a concentration of 50% and 75% of turmeric is the most effective on the S.aureus bacteria. Question 3: Compare the zone of inhibitions of bacteria with turmeric extract having the lowest mean from the E. Coli & S. aureus group. Give some implications. The turmeric concentration zone of inhibition with the lowest mean in the e-coli bacteria is 75%, while the turmeric concentration with the lowest mean on the s.aureus is 50% and 75%. Comparing these two, the amount of concentration needed for both bacterias is almost the same. This means that using the same accepted amount for both will have no difference on its effectiveness. B. Another group suggested using Gumamela leaves and flowers as an anti-bacterial. Statistical tool used: t-Test: Paired Two Sample for Means Table 2. The zone of inhibition of bacteria with two Gumamela extracts (E.coli) FACTORS MEAN P-VALUE INTERPRETATION Gumamela Leaves 6.

65 There is a significant difference between the zone of inhibition of bacteria with two gumamela extracts. Gumamela flowers 9. Table 2. The zone of inhibition of bacteria with two Gumamela extracts (S. Aureus)