Worksheet 4

A series of measurements were made on a sample. The target value for the measurement was 48.
Data set 1a contains all of the raw data obtained via the measurement
The final datum of 60.51 is suspected of being an outlier. Data set 1b is the raw data minus the suspected outlier. You need to choose which data set you can work with to carry out an
appropriate t-test at 95% confidence levels. For the t-test you want to compare the calculated average for the chosen data set against the target value. The question you are being asked is :
is there is a significant difference between the calculated average of the measured data and the target value of 48? Complete the following steps and answer the questions in the online quiz.
Step 1 Complete the calculatations (highlighted in yellow) for data sets 1a and 1b.
Step 2 Determine whether 60.51 is an outlier for data set 1a using the calculated value of Q and the Table of Critical values below
Step 3 Further to the answer to step 2, decide whether data set 1a or data set 1b should be used to calculate the true average value for the data.
put this calculated average value into cell I20 (green cell)
Step 4 complete the calculations for the t-test (blue cells)
Step 5 determine the value of tcritical from the statistical tables provided in the folder accompanying lecture 5. (red cell)
Step 6 Complete the relevant questions (1-11) in the online quiz.
Data Set 1a 1b Target Value 48

44.00 44.00
44.13 44.13 Mean for Data Set 46.48
44.99 44.99 Std Deviation 2.11
45.57 45.57 n 9
46.36 46.36 SEM 0.703
46.72 46.72 DOF 8
47.58 47.58 tcalculated -2.16
48.72 48.72 t critical (table) 2.31
50.29 50.29
60.51
stat 2.16
Mean 47.89 46.48 crit 2.31
std dev 4.86 2.11
variance 23.63 4.45
CoV 0.10 0.05
Range 6.30
Gap 10.22
Qcalc 1.622
A series of measurements were made in experiment 1 on a sample and the raw data are presented in data set 2a. The final datum of 1.795 is suspected of being an outlier.
Data set 2b is the raw data minus the suspected outlier. You need to choose which data set you can work with.
A second experiment carried out by a different group provided the raw data for data set 3a.
You need to decide on an appropriate t-test. For the t-test you want to compare the calculated average for the chosen data set for experiemnt 1 against the average value for experiment 2.
The question you need to answer is:
is there is a significant difference between the calculated average values from the two experiments? Complete the following steps and answer the questions in the online quiz.
Step 1 Complete the calculatations (highlighted in yellow) for data sets 2a, 2b and 3a
Step 2 From these calculations determine whether you are going to choose either data set 2a or 2b for experiment 1.
Step 3 Decide on an appropriate t- test and determine the value of tcritical (you will need this for the quiz)
Step 4 Using the same data sets, calculate the value of F for the comparison of both experiments. (hint when calculating the ratio the calculation should give an answer greater than 1)
Step 5 Complete the relevant questions (12-17) in the online quiz.
Data Set : 2a 2b Data Set : 3a

0.323 0.323 0.71
0.326 0.326 0.716
0.331 0.331 0.744
0.39 0.39 0.745
0.398 0.398 0.755
0.469 0.469 0.839
0.498 0.498 0.868
0.553 0.553 0.938
0.564 0.564 1.015
1.795
Mean 0.565 0.428 Mean 0.814 Mean

std dev 0.442 0.096 std dev 0.108 std dev
variance 0.195 0.009 variance 0.012 variance
CoV 78.2 22.5 CoV 13.2 CoV
Range 0.241 0.305 Range

Gap 1.231 0.077 Gap
Qcalc 5.108 0.252 Qcalc
Use the tables below to answer the relevant question 18 in the online quiz.
Table 4a
Absorbance Values 0.028 0.03 0.014
0.022 0.021 0.027
0.018 0.024 0.021
Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
Column 1 3 0.068 0.023 0.000025
Column 2 3 0.075 0.025 0.000021
Column 3 3 0.062 0.021 0.000042
ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 2.822222222E-05 2 1.411111111E-05 0.48 0.64 5.14
Within Groups 0.000177333333 6 2.955555556E-05
Total 0.000205555556 8
Table 4b
Absorbance Values
0.04 0.007 0.014 0.056 0.132 0.112 0.12 0.198
0.034 0.011 0.004 0.108 0.128 0.088 0.084 0.178
0.054 0.021 0.036 0.084 0.13 0.072 0.096 0.268
Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
Column 1 3 0.13 0.04 0.0001
Column 2 3 0.04 0.01 0.0001
Column 3 3 0.05 0.02 0.0003
Column 4 3 0.25 0.08 0.0007
Column 5 3 0.39 0.13 0.0000
Column 6 3 0.27 0.09 0.0004
Column 7 3 0.30 0.10 0.0003
Column 8 3 0.64 0.21 0.0022
ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 0.0916963 7 0.0130995 25.64 0.0000 2.66
Within Groups 0.0081736 16 0.0005109
Total 0.0998699 23
Two strains of bacteria, 81-176 and RM1221, were investigated for the effect of contamination by chicken juice in their growth medium. Table 5a contains the results obtained for both strands both in the absence and presence of the contamination.
Using this information complete Table 5a and Table 5b by following steps 1-5 and answer the relevant questions in the quiz in line with step 6.
Space for Histogram

Table 5a Step 1 - Complete Table 5a (complete calculations for yellow cells)
81-176 RM1221 (note: this will automatically fill in the blue cells in Tables 5a and 5b)
0% Juice 5% Juice 0% Juice 5% Juice
0.069 0.581 0.032 0.555 Step 2: using the calculated mean values (blue cells Table 5a) insert a histogram into the space provided.
0.072 0.651 0.040 0.582
0.109 0.678 0.042 0.605 Step 3 - add the error bars to the histogram
0.120 0.691 0.044 0.647
0.129 0.703 0.051 0.670 Step 4 - complete Table 5b by calculating the variance for both columns (green cell).
mean 0.100 0.661 0.042 0.612 Step 5 - calculate tsample and tcritical for the following question: is the mean value for 81-176 (5% Juice)
n 5 5 5 5 significantly greater than the mean value for RM1221 (5% Juice)
std dev 0.028 0.049 0.007 0.047
sem 0.012 0.022 0.003 0.021 Step 6 - Answer Q19 and 20 in the quiz
CV 28 7 16 8
81-176 RM1221
0% Juice 5% Juice 0% Juice 5% Juice
mean 0.100 0.661 0.042 0.612
sem 0.012 0.022 0.003 0.021
Table 5b
81-176 RM1221
5% Juice 5% Juice
0.581 0.555
0.651 0.582
0.678 0.605
0.691 0.647
0.703 0.670
mean 0.661 0.612
n 5 5
std dev 0.049 0.047
variance 0.0024 0.0022
CV 7 8
t sample 1.62
tcritical

Worksheet 4

Uploaded by

Copyright:

Available Formats

Worksheet 4

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Worksheet 4

Uploaded by

Copyright:

Available Formats

A series of measurements were made on a sample. The target value for the measurement was 48.

Step 4 complete the calculations for the t-test (blue cells)

Step 6 Complete the relevant questions (1-11) in the online quiz.

Data Set 1a 1b Target Value 48

Step 5 Complete the relevant questions (12-17) in the online quiz.

Data Set : 2a 2b Data Set : 3a

Mean 0.565 0.428 Mean 0.814 Mean

Range 0.241 0.305 Range

Anova: Single Factor

Anova: Single Factor

Space for Histogram

You might also like