Part 1 - Beer's Law Scatter Plot and Linear Regression  |
| Beer's Law Graph |
|
|
|
| Conc.(M) | Absorbance |
| 0.00E+00 | 0.0000 |
| 4.00E-05 | 0.0958 |
| 8.00E-05 | 0.1820 |
| 1.20E-04 | 0.2760 |
| 1.60E-04 | 0.3430 |
| 2.00E-04 | 0.4130 |
| unknown 1 | 0.1370 | 6.07655E-05 |
| unknown 2 | 0.3650 | 0.000170809 |
|
|
|
Part 2 - Titration Data Plotting
 |
| Titration |
 |
| Chart Axis Scale have been modified |
Tittration of 50mL of 0.1M HCL
| NaOH added (mL) | pH |
| 0.00 | 1.00 |
| 10.00 | 1.17 |
| 25.00 | 1.48 |
| 45.00 | 2.28 |
| 49.50 | 3.30 |
| 49.75 | 3.60 |
| 50.00 | 7.00 |
| 50.25 | 10.40 |
| 55.00 | 11.68 |
| 60.00 | 11.96 |
KOS1110 – COMPUTER IN SCIENCE TUTORIAL ON EXCEL
- Finding the line of best fit
Temperature (in °C) | 8 | 22 | 15 | 13 | 12 | 21 | 20 | 9 |
Percentage injured p | 4.7 | 12.3 | 6.5 | 5.9 | 6.6 | 10.3 | 8.4 | 4.0 |
| percentage of runners that would be injured at 27°C | 13.174 |
| temperature in which 10% of the runners were injured. | 20.48255 |
Year (x) | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 |
Housing starts (y) | 1193 | 1014 | 1200 | 1288 | 1457 | 1354 | 1477 | 1474 |
|
| number of new housing starts in 2001 | -404405351 |
For further reading about the scatter plot please go those website
No comments:
Post a Comment