ZOOM + 2 Page < > of 6 3. Use an Excel formula and fill across to calculate all trials in the set in the appropriate row

[answerhappygod]

Zoom 2 Page Of 6 3 Use An Excel Formula And Fill Across To Calculate All Trials In The Set In The Appropriate Row 1 (52.3 KiB) Viewed 34 times

Zoom 2 Page Of 6 3 Use An Excel Formula And Fill Across To Calculate All Trials In The Set In The Appropriate Row 2 (52.3 KiB) Viewed 34 times

Zoom 2 Page Of 6 3 Use An Excel Formula And Fill Across To Calculate All Trials In The Set In The Appropriate Row 3 (48.02 KiB) Viewed 34 times

ZOOM + 2 Page < > of 6 3. Use an Excel formula and fill across to calculate all trials in the set in the appropriate row: Calculate the initial mmoles of each reactant using its initial volume and initial molarity and equation 2. Remember that your units must cancel out to give the desired unit! The initial mmoles of each product is? - Calculate the final number of mmoles of each of the four substances from the total volume and final molarity Calculate the change in mmoles for each of the four substances, using the fact that initial mmoles + change in mmoles - final mmoles Note that the change in mmoles will have either a + or - sign; however initial and final mmoles cannot be negative 4. Format the table to make it easy to read. Format to show correct sig figs and follow our guidelines. You may choose to add borders, shading, or other formatting your goal is to make the table as straightforward and visually easy to read as possible. $. Make two graphs as scatterplots - choose dots with connecting straight lines for this graph: M Make sure each plot has a Figure Caption and properly labeled axes. - Your first plot will be of Set 1: plot the final mmoles of one of the products vs. initial mmoles of Reactant I. (Reactant I should be the substance being varied in Set I.) - Your second plot will be of Set 1: plot the final mmoles of the same product vs. initial mmoles of Reactant 2. (Reactant 2 should be the substance being varied in Set II.) Hints -- Remember it's always y vs. x. Make a working table (one you don't have to show) of just the data to be used for the graph, with x values in the first column and y in the second column then it's easy to select the x & y columns together and insert chart. Neat trick-move your completed graph over the working table so it doesn't show.
OV Paste Format BIU Merge & Carter $_1 Conditional format Forens Tobile R10 XX 1 u к L M N o р -R 1 2 3 4 5 6 Run 1 2.00 1.00 3.00 1.00 1.00 0.500 0.000 0.167 0.167 Run 2 2.00 2.00 4.00 1.00 1.00 0.250 0.000 0.250 0.250 Run 3 2.00 3.00 5.00 1.00 1.00 0.100 0.000 0.300 0.300 Run 4 2.00 4.00 6.00 1.00 1.00 0.000 0.000 0.333 0.333 Run 5 2.00 5.00 7.00 100 1.00 0.000 0.143 0.286 0.286 Run 6 2.00 6.00 8.00 100 1.00 0.000 0.250 0.250 0.250 ONS 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Table 6: Set 2 Volume Of Reactant A (ml) Volume Of Reactant C (ml) Total Volume (mL) Initial Molarity of Reactant A (M) Initial Molarity of Reactant C(M) Final Molarity A (M) Final Molarity CM) Final Molarity B (M) Final Molarity D (M Initial mmoles of A Initial mmoles of C Initial mmoles of B Initial mmoles of D Final mmmoles A Final mmmolesc Final mmmoles B Final mmmoles D Change in mmole of A Change in mmole of C Change in mmole of B Change in mmole of D 9 ೩ ಸ ನಿ ೩ X 2