For this problem make the 3 excel graphs as directed, First, Copy the below experimental data into and Excel spreadsheet

[answerhappygod]

For This Problem Make The 3 Excel Graphs As Directed First Copy The Below Experimental Data Into And Excel Spreadsheet 1 (71.92 KiB) Viewed 43 times

For this problem make the 3 excel graphs as directed, First, Copy the below experimental data into and Excel spreadsheet. Then, Determine spreadsheet box number that corresponds to the yellow box. You will use the box number to format the values in the last two columns. Let's say it is A2. Next, Have Excel format the box that corresponds to the blue box in the below table by entering "=1/A2" and then enter. Excel will automatically calculate the value of 1 N. Do the same thing for the remaining boxes in that column either manually or by hovering over the bottom right corner of the box to see the black + then click and drag down the column. Next, For the box corresponding to the orange box in the below table, enter the formula "=In(A2)" and enter. Do the same thing for the remaining boxes in that column. Now for Making the three plots: Rate vs. [A], Rate vs. 1/[A], and Rate vs. ln[A]. Use the options under the Chart Design tab to add axis titles and chart title for all three plots, and trendline for the most linear plot. For the linear plot, right-click on the trend line to format the trendline and display the equation and R2 value on chart. When done w the graph Identify the slope and its units and the y-intercept?