Overview
For each molecule in your equation:
1. Create a column calculating the difference between your calculated data (your actual calculated [not copied] data must be on the page, meaning your coefficients will need to be on the same tab as well) and the NIST values for each heat (q), entropy, and DG-DH298/T.
2. Using the difference column from step 1, create a % error column based on the NIST value. See video for help here if you need it. You should not have values with error percentages above 10%.
3. Recalculate your Gibbs energy of reaction data column and your equilibrium constant column. Graph each vs. T as well as lnK vs 1/T.
**Must be on excel
Answer the following questions with respect to your completed excel data from this week. Answer to the best of your ability, sometimes you are being asked what you think. Cite any resources that you use.
- Tabulate your error percent ranges for each molecule and for each heat capacity, q (heat), entropy and DG-DH298/T. Do the tabulation in your excels and do not include those columns in this data analysis submission. Here, tabulate or list the high value only for each molecule and property, labeled and as percents. (maximum error).
- What is the mandatory T1 value for all integrated formulas used for calculations?