Question: Excel is a useful and powerful data manipulation and graphing tool. You will be well served by knowledge of its use no matter what your


Excel is a useful and powerful data manipulation and graphing tool. You will be well served by knowledge of its use no matter what your eventual major may be. In the current age, being able to use an Excel spreadsheet is as much a "life skill" as using a word processor, so you may already know how to use Excel. If you will be learning it for the first time for this class, you will be able to use the skills you acquire in other classes in the future. EXERCISE A student conducted an experiment to determine what factors are important in the rate of a reaction between potassium carbonate and hydrochloric acid. The student diluted 2.000mL of 4.000MK2CO3 to 75.00mL, then combined that solution with 75.00mL of 4.000MHCl. The student tabulated the amount of CO2 gas collected over time and recorded the results in the following data set: 1. Use a rearrangement of the ideal gas law PV=nRT to solve for the number n of moles of CO2 produced. You may assume atmospheric pressure and room temperature. Enter (and fill down) your formula in Excel. (NOTE: gas constant R=0.08206Latmmol1K1; pressure P=1 atm; temperature T=294K; volume V in liters) 2. Make a scatter plot of moles of CO2 versus time. Make sure the plot has the following features: a. y axis shows moles CO2,x axis shows time in minutes b. plot created as a separate sheet in the workbook c. a proper title d. labeled axes e. sensible scales on the axes f. no gridlines g. a colorless background to the plot h. solid green squares as data markers i. a line of best fit (trendline) which passes through the origin j. the equation of the line and R2 value in scientific notation to three decimal places 3. Think about what the information in your trendline provides. What does the slope and y-intercept tell you
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
