Skip to main content
Chemistry LibreTexts

5.4: Data Analysis

  • Page ID
    374942
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)

    \( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)

    ( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)

    \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)

    \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)

    \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)

    \( \newcommand{\Span}{\mathrm{span}}\)

    \( \newcommand{\id}{\mathrm{id}}\)

    \( \newcommand{\Span}{\mathrm{span}}\)

    \( \newcommand{\kernel}{\mathrm{null}\,}\)

    \( \newcommand{\range}{\mathrm{range}\,}\)

    \( \newcommand{\RealPart}{\mathrm{Re}}\)

    \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)

    \( \newcommand{\Argument}{\mathrm{Arg}}\)

    \( \newcommand{\norm}[1]{\| #1 \|}\)

    \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)

    \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    \( \newcommand{\vectorA}[1]{\vec{#1}}      % arrow\)

    \( \newcommand{\vectorAt}[1]{\vec{\text{#1}}}      % arrow\)

    \( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vectorC}[1]{\textbf{#1}} \)

    \( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)

    \( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)

    \( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)

    \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)

    \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)

    Data Analysis

    We need to develop three graphs and want to do this with the least number of solutions.

    clipboard_e9926fb774c9691ed92a7697cec01d85f.pngFigure \(\PageIndex{1}\): Three graphs we will be collecting data for. (CC-BY; Belford)

    Cover Page

    As always the first page of the Workbook is the Cover Page (figure \(\PageIndex{5}\)) and on this you will post your answers and Copies of the three graphs (from the other pages of the workbook, which can be accessed via the tabs at the bottom of the page).

    clipboard_e1f834ef62399605bf1e947bdb17ad398.pngFigure \(\PageIndex{5}\): Screen Capture of the Front Page of the Google Sheet's Workbook and Paste Caption here. (Belford)

    Be sure to replace the [Template_[Last_Firstname_Initial] with your lastname and initial, like Belford_B

    Data Page

    The Data tab takes you to the Data Sheet.  The class is pooling data and right after class you must uploaded your data a special Google Sheet (see Downloads and Forms in Section 4.3).  The data sheet allows you to obtain that data from the entire class and insert it into your own workbook.  If your group does not upload your data within 4 hours of the end of the lab your instructor will do it for you and deduct 10 points of off everyone in your groups lab grade.  The instructor will then check the data and once all data is uploaded the instructor will lock the sheet and email the entire class to let you know that all sections have uploaded their data and you can proceed to work up the results.

     

     

    clipboard_e53b588059551fb2e9253fc2312f21c34.png

    Figure \(\PageIndex{6}\): Steps required to transfer transfer data from the class data page to your workbook. (Belford CC-BY)

    Note, do not start working up the data until the instructor notifies you that the entire class's data has been uploaded.

     

    Concentration Page

    You goal is to calculate the Rate at t=0 (moment of mixing) as the reaction starts the moment the two solutions are mixed. Table \(\PageIndex{1}\) gives all volumes and concentrations used. If both of the above flasks have 50 mL the total of the combined solution will be 100 mL. To calculate the concentration of any reagent at the moment of mixing you use the dilution equation, please review section 4.4.3

    \[M_iV_i=M_fV_f\]

    Where Mi is the initial Molarity (added to either reagent flask), Vi is the initial volume (added to either reagent flask), Mf is the final molarity (in the reaction flask) and Vf is the final volume of the mixture (100 ml). So 

    \[M_f=M_i \frac{V_i}{V_f}\]

    note, the term \(\frac{V_i}{V_f}\) is often called the dilution factor, and is dimensionless if both volumes have the same units.

    clipboard_eb408a2d417636964bf5d03c263926cc6.pngFigure \(\PageIndex{7}\): Copy and Paste Caption here. (Copyright; author via source)

    There are actually only 5 different concentrations used as experiment 3,6 and 7 had identical concentrations.  Before proceeding with the log/log and Arhenius plots you need to determine the concentrations of the ferric, iodide and thiosulfate ions.   NOTE: it is advised that you learn how to use functions and you may want to review section 0.3 on Data Manipulation in Google Sheets.  That is, you can place a function in the blue cells that pulls data from the brown cells and save yourself a lot of time.

    Review Mathematics in Google Sheets Video

    This video goes over making a formula

    Instructions

    You can do simple calculations using formulas. Start all formulas by typing =

    Addition +

    Subtraction -

    Multiplication *

    Division /

    Exponent ^

    Parentheses ()

    So for example if we can use the sheet to calculate the gravitational force between two objects


    Video \(\PageIndex{1}\): 1:40 Video example of how to do basic calculations in sheets ()

     

    clipboard_ed866acc95783293c67936911cabd92ae.png
    Figure \(\PageIndex{1}\): Calculating the gravitational force of two objects. Formula used : =D2*((A2*B2)/C2^2) (Poirot)

     

    • Lets look at how we could write the formula for the dilution equation.  In cell with reference ID of E2 we could write =(Cell Ref1)*(Cell Ref2)/(Cell Ref3) where the Cell Ref# is the ID like A1 of a cell with data used in that experiment.  Once we have loaded the equation with the proper data we hit enter and it calculates the value.  We then use the small black square to scroll down and calculate those values for all the other rows of data.

    Hint \(\PageIndex{1}\)

    This hint shows a shortcut for inserting data

    Hint

     

    clipboard_e4970f42b623e1c457666bd23c11eb64c.png
    Figure \(\PageIndex{4}\): Highlighting a cell and dragging will copy its content while highlighting two cells and dragging creates a series of values based on the difference of the two cells. (Bob Belford; LibreTexts CC0)

         Double clicking the blue square will repeat the formula for every cell that has data in the next column

     

     

    Ferric Ion Page

    clipboard_e93697572963c304d259d5bd31bbeb054.pngFigure \(\PageIndex{8}\): Note the blue text data is taken from the data tab and the black text values are taken from the concentration tab.  You may want to "paste values" (when you paste do a "right click" choose "paste special" and "paste values only"

    In this page of the workbook you will calculate "m", the order of reaction with respect to ferric iron by working up data from three experiments where [iodide] and T are constant.

    \[R=k[Fe^{+3}]^m[I^-]^n\] reduces down to \[R=k'[Fe^{+3}]^m \\ \; \\ \text{and you can determine the value of the exponent in a log-log plot} \\ \; \\ logR=mlog[Fe^{+3}] + logk' \]

    where \(k'=k[I^-]^n\)

    Note how all the data for Iodide is constant, and you never used it in your equations.

     

    Lets look at some of the functions you could write based on your data and the above spreadsheet.  From section 4.2.3 we saw

    \[R=\frac{\Delta [S_2O_3^{-2}]}{\Delta t}\]

    and so you should use functions for calculating R, log[Fe] and log[R].  In fact you could skip the R column, but we want you to do it.

    Hint \(\PageIndex{1}\)

    This hint has a screenshot on pasting values.

    Answer

    ctrl+shift+v does the same action as right-click paste values only

    Paste formula only is also valuable for repeating the formula from one tab to another

    clipboard_e92965707883ca4701518707c32a661fc.pngFigure \(\PageIndex{5}\): Familiarize yourself with options like paste value only. (Copyright; author via source)

     

     

    Iodide Ion Page

    clipboard_ef1cc59a880f43e60ebd246a00f8117c1.pngFigure \(\PageIndex{8}\): Google Sheet students need to fill out

    In this page of the workbook you will calculate "n", the order of reaction with respect to iodide by working up data from experiments where you kept [ferric ion] and Temperature constant. You should also use calculations with your Google Sheets, and properly label all axis on the graph (chart).

    \[R=k[Fe^{+3}]^m[I^-]^n\] reduces down to \[R=k''[I^{-}]^n] \\ \; \\ \text{and you can determine the value of the exponent in a log-log plot} \\ \; \\ logR=nlog[I^{-}] + logk'' \]

    where \(k''=k[Fe^{+3}]^m\)

     

    Arrhenius Graph

    clipboard_e10d8d0418ad38c28c86db665efa145b8.pngFigure \(\PageIndex{9}\): Google Sheet students need to fill

    This is the most complicated graph, you need to report the Arrhenius constant and plot all the appropriate data where the ferric iron and iodide constants were held constant, which was experiment three,  You will also need to use the orders of reaction from the ferric iron and iodide pages.

    Note, you could have calculated the lnk in one equation but we had you solve it in 4  If you look at the Rate Law, where R stands for the reaction rate

    \[R=k[Fe^{+3}]^m[I^-]^n\] can be solved for k

    \[k=\frac{R}{[Fe^{+3}]^m[I^-]^n} \] and the denominator of this equation is column J of the spreadsheet.  It is important that you use the spreadsheet as structured as there is a grading template that will validate your work, and that uses this framework.  But yes, you could have skiped columns I,J and K and gone straight to lnk (Column M), but our goal is to get you to look at the chemistry, and so we broke this into steps that had meaning, and would hopefully be easier to follow.

    It should be noted that the k here is the k of the Arrhenius equation \[k=Ae^-\frac{E_A}{RT}\]  (where R stands for the ideal gas constant) and we are plotting the natural log form of it
    \[lnk = -\frac{E_A}{R}\left ( \frac{1}{T} \right ) + lnA\] and the slope of the line is equal to -\(\frac{E_A}{R}\).

     

    Hint \(\PageIndex{1}\)

    You can copy data from exp 1-3 from the ferric ion page and experiments 4 & 5 from the iodide page (use paste values) 

    Answer
    clipboard_e92965707883ca4701518707c32a661fc.pngFigure \(\PageIndex{5}\): Familiarize yourself with options like paste value only. (Copyright; author via source)

    5.4: Data Analysis is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?