10 Procedure Part A A good way to practice setting up an Excel spreadsheet is to create a molar mass calculator. This will come in handy over the course of the semester. Figure 1.13 shows what such a file might look like. It demonstrates the calculation for sulfuric acid, H,SO, Column B contains atomic masses copied from a periodic chart or atomic mass table. In column C the user enters the number of atoms in the mol- ecule. Column D contains a formula multiplying the number in column B by the number in column C (e.g., =B4C4). The formula in cell D2 sums all the numbers in column D. Using the information above create your own molar mass calculator. Print and hand in screen shots of your calculator and the functions/equations that you used to show it works correctly. a. H 2 Home 19 una Parte D2 1 Molar mass Calculator Molar Mass Clement 3 4 Hydrogen Son Carbon Nitrogen Oxygen 10 Fluorine 11 Sodium 12 Magnesium 11 Aluminum 34 Silicon 15 Phosphorous 16 Sulfur 17 Carie PL Atomic Mass of m 2 0 0 O = 1.008 6.941 10.811 12.011 14.001 14.000 www www 15.999 18.998 ww 22.99 P (torr) 1.00 10.00 40.00 100.00 400.00 www 24.305 wwwww 26.98 www 28.086 30.974 32.06 35.453 0 1 4 1 Creating Graphs by Hand and Using Excel 0 X 0 0 0 1 SUM04.034) 0 D 0 94.096 2016 0 D 0 63.996 0 - 0 Figure 1.13. A molar mass calculator. Part B The vapor pressure of a pure liquid was measured at several temperatures and is given in the table below. 0 28.086 0 0 0 T (C) -15.0 Create a table of In P, temperature in K, and reciprocal temperature in K. Graph In P vs. 1/T. Add a trend line and obtain the slope in units of K. Make sure to label your graph ap- propriately for full points and include your data tables. b. Solve for AH = -m XR, where m is the slope of the line and R = 8.314J X mol" X K C. 14.7 36.4 52.8 82.0 Print and hand in your completed spreadsheet and graph. Include printed screenshots and show the Excel functions/equations that you have used.