10 Procedure Part A A good way to practice setting up an Excel spreadsheet is to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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., =B4°C4). 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. 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., =B4°C4). 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.
Expert Answer:
Answer rating: 100% (QA)
This is an easy enough to make make molecular mass calculator Here are the steps 1 Name the cells as ... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these programming questions
-
Please help with the discusin questions ! I give thumbs up Case #1: Hailing a New Era: Haier in Japan As one of the most valuable brands in China, Haier designs,manufactures, and sells various home...
-
Identify the process evaluation article that you chose and explain why you selected this example. Describe the purpose of the evaluation, the informants, the questions asked, and the results of the...
-
A machine was sold in December 20x3 for $13,000. It was purchased in January 20x1 for $19,000, and depreciation of $16,000 was recorded from the date of purchase through the date of disposal....
-
Using the data from Exercise 15-15, record the entries using the straight-line method for amortization of discounts and premiums. In exercise 15-15 Journalize the entries to record the following...
-
Lars Linken opened Lars Cleaners on March 1, 2020. During March, the following transactions were completed. Mar. 1 Owner invested 15,000 cash in the company. 1 Borrowed 6,000 cash by signing a...
-
Barbara Vigil, Chief Justice, New Mexico Supreme Court Ken Badilla bought a pair of Brahma brand work boots from Wal-Mart on October 19, 2003. The boots packaging had these express descriptions: iron...
-
You are performing the year-end audit of Halvorson Fine Foods, Inc. for December 31, 2007.The client has prepared the following schedule for the fixed assets and related allowance for depreciation...
-
A combined solar and auxiliary energy system is used to meet the same load as in Example 12.5. The total cost of the system to cover 65% of the load (solar fraction) is $20,000. The owner will pay a...
-
For the circuit shown in Fig. P1.78, first evaluate Ti (s) = Vi (s)/Vs (s) and the corresponding cutoff (corner) frequency. Second, evaluate To (s) = Vo (s)/Vi (s) and the corresponding cutoff...
-
Consider the following model of the demand for beer by households. q=B1 + B2pb+ B3pl + B4x + e Here q= quantity of beer consumed (liters), pb= price of beer, pl-price of liquor, and x = real income...
-
Answer the following questions: 1. Prepare a list of any four (4) methods of extending and developing individual creative thinking skills. 2. Identify and document two (2) tools you can use to extend...
-
In one-hundred words or less using Richard Daft and Robert Lengel's Media Richness Theory, define the theory then explain a situation where the inappropriate medium was used by YOU and what would...
-
A and B have decided to form a partnership. A is going to contribute a depreciable asset to the partnership as his contribution to the partnership. The following information regarding the asset to be...
-
I have an assignment for ACCT 320 6980Fraud Detection and Deterrence course where, can you please answer the following question below: 1. Can you please Select a current event fraud-related topic you...
-
A municipality needs funding for upcoming infrastructure ( water and sewer line ) repair or replacement. They issue a series of $ 1 , 0 0 0 , 6 % semiannual, 1 0 - year bonds. The bonds are initially...
-
Determine the reactions and draw the shear and bending moment diagrams for the two span continuous beam shown by using moment-distribution method or slope-deflection method (EI is constant). Explain...
-
Chicago Company sold merchandise to a customer for $1,500 cash in a state with a 6% sales tax rate. The total amount of cash collected from the customer was $558. $600. $642. $636. Nevada Company...
-
Carolyn Falgout accompanied William Wardlaw as a social guest to Wardlaws brothers camp. After both parties had consumed intoxicating beverages, Falgout walked onto a pier that was then only...
-
A State statute empowered public school principals to suspend students for up to ten days without any notice or hearing. A student who was suspended for ten days challenges the constitutionality of...
-
Civil Code 1719, subdivision (a) provides in part that any person who draws a check that is dishonored due to insufficient funds shall be liable to the payee for the amount owing upon the check and...
-
The simplified financial statements of Titanium Ltd appear below. Additional information 1. Dividends declared and paid were $26 400. 2. During the year equipment was sold for $10 200 cash. The...
-
An analysis of the accounts of Beautiful Bottles Pty Ltd reveals the following manufacturing cost data for the month ended 30 June 2019. Required (a) Prepare the cost of goods manufactured schedule...
-
The following accounts and amounts (balances are normal balances) were taken from the records of Prider Manufacturers Ltd at 30 June 2019. Required (a) Prepare a cost of goods manufactured statement...
Study smarter with the SolutionInn App