Quantitative Estimation of Sugars to Soft Drinks
Biology IA: Quantitative Estimation of Sugars to Soft Drinks
Trials
Data Collection and Processing: Percentage Transmissions of Light through a Glucose Solution after a Benedicts Treatment
| Trial 1 | Trial 2 | Trial 3 | Trial 4 | Trial 5 | Trial 6 | Trial 7 | | Glucose Concentration | Transmission (%)± 0.1 | Transmission (%)± 0.1 | Transmission (%)±0.1 | Transmission (%)± 0.1 | Transmission(%)±0.1 | Transmission (%)±0.1 | Mean (anomalous data not included) ±0.1 | Standard Deviation | 0.00 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 0.0 | 0.25 | 83.8 | 99.9 | 85.9 | 80.9 | 5.8 | 90.9 | 88.3 | 7.5 | 0.50 | 84.8 | 73.0 | 75.5 | 52.4 | 5.2 | 83.3 | 73.8 | 13.0 | 0.75 | 85.1 | 90.6 | 67.3 | 71.5 | 5.9 | 56.7 | 74.3 | 13.7 | 1.00 | 71.9 | 82.0 | 64.9 | 64.1 | 4.1 | 59.2 | 68.4 | 8.8 | 1.25 | 70.6 | 80.2 | 54.5 | 33.5 | 6.2 | 63.4 | 60.4 | 17.8 | 1.50 | 66.0 | 93.8 | 56.7 | 28.9 | 6.3 | 52.8 | 59.6 | 23.5 | 1.75 | 62.2 | 90.7 | 48.0 | 56.1 | 5.6 | 48.9 | 62.3 | 17.5 | 2.00 | 62.2 | 67.6 | 38.6 | 28.3 | 5.0 | 38.7 | 47.1 | 16.9 | X | 6.8 | 67.5 | 64.0 | 6.8 | 100.7 | 64.9 | 74.3 | 37.4 | Y | 6.0 | 69.8 | 79.5 | 5.7 | 88.5 | 63.0 | 75.2 | 36.8 |
*The data highlighted in blue are anomalous data; they do not correspond with the majority of the results and has been excluded from all the calculations. Ones highlighted in orange is the data collected by ourselves
** The wavelength used is 636nm
Method of Calculation
Mean= Total value of numbersTotal number of data sets e.g. for concentrations of 0.25, (83.8 + 99.9 + 85.90+ 80.9 + 91.0)/ 5= 88.3
Standard Deviation=
Conclusion and Evaluation: Analysis of trends in the graph and results and possible improvements to the method
As it can be seen from the graph above, the general trend is the higher the percentage glucose concentration, the lower the percentage light transmission. It can be said that there is a negative correlation between glucose concentration
Trials
Data Collection and Processing: Percentage Transmissions of Light through a Glucose Solution after a Benedicts Treatment
| Trial 1 | Trial 2 | Trial 3 | Trial 4 | Trial 5 | Trial 6 | Trial 7 | | Glucose Concentration | Transmission (%)± 0.1 | Transmission (%)± 0.1 | Transmission (%)±0.1 | Transmission (%)± 0.1 | Transmission(%)±0.1 | Transmission (%)±0.1 | Mean (anomalous data not included) ±0.1 | Standard Deviation | 0.00 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 0.0 | 0.25 | 83.8 | 99.9 | 85.9 | 80.9 | 5.8 | 90.9 | 88.3 | 7.5 | 0.50 | 84.8 | 73.0 | 75.5 | 52.4 | 5.2 | 83.3 | 73.8 | 13.0 | 0.75 | 85.1 | 90.6 | 67.3 | 71.5 | 5.9 | 56.7 | 74.3 | 13.7 | 1.00 | 71.9 | 82.0 | 64.9 | 64.1 | 4.1 | 59.2 | 68.4 | 8.8 | 1.25 | 70.6 | 80.2 | 54.5 | 33.5 | 6.2 | 63.4 | 60.4 | 17.8 | 1.50 | 66.0 | 93.8 | 56.7 | 28.9 | 6.3 | 52.8 | 59.6 | 23.5 | 1.75 | 62.2 | 90.7 | 48.0 | 56.1 | 5.6 | 48.9 | 62.3 | 17.5 | 2.00 | 62.2 | 67.6 | 38.6 | 28.3 | 5.0 | 38.7 | 47.1 | 16.9 | X | 6.8 | 67.5 | 64.0 | 6.8 | 100.7 | 64.9 | 74.3 | 37.4 | Y | 6.0 | 69.8 | 79.5 | 5.7 | 88.5 | 63.0 | 75.2 | 36.8 |
*The data highlighted in blue are anomalous data; they do not correspond with the majority of the results and has been excluded from all the calculations. Ones highlighted in orange is the data collected by ourselves
** The wavelength used is 636nm
Method of Calculation
Mean= Total value of numbersTotal number of data sets e.g. for concentrations of 0.25, (83.8 + 99.9 + 85.90+ 80.9 + 91.0)/ 5= 88.3
Standard Deviation=
Conclusion and Evaluation: Analysis of trends in the graph and results and possible improvements to the method
As it can be seen from the graph above, the general trend is the higher the percentage glucose concentration, the lower the percentage light transmission. It can be said that there is a negative correlation between glucose concentration