4.4: Data Analysis
- Page ID
- 374936
\( \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
Cover page tab
The first page is always the cover page.
Figure \(\PageIndex{4}\): Cover page for lab report. (Copyright; Belford CC0)
Spectra tab
The second tab will contain your spectra. Open the CSV (comma separated variable) text file of the spectrum that you saved to a flash drive on the labquest, and then copy and past the raw data into columns A & B of the second tab (keep the titles, so start on the second row). Use "smooth line chart"
Importing Spectra csv
- On your google sheet open the spectra tab and click on cell 1A
- Click File>import
- Click upload and select the file you want to upload
- Click the drop down for import location
- Select Append to current sheet
- Then click import data
Making Spectra Chart
- Highlight columns A and B by clicking and dragging on column labels (where it says A and B) or click A then shift+click B. This should highlight the entire column
- (there is a lot of data and trying to scroll through the entire sheet will take a long time)
- Click Insert>Chart
- Open chart editor by clicking the three dots in the top right corner of the chart
- Check that your chart type is a smooth line chart
- Check your data range (google should ignore the Veneir information and skip to where your data starts)
- Make sure your chart has a Title, Axes labels for x and y axis, and units.
Dilution tab
In this tab you will calculate the concentration (Molarity) of the solution after each dilution. Use the drop down to label each column as the initial or final Molarity or volume.
Figure \(\PageIndex{6}\): Data sheet for calculating solution concentrations. (Copyright; Belford CC0)Beer's Law tab
Transfer the data from your data sheet to the orange cells and enter your values from the dilutions tab in the blue cells. Do not rearrange these cells as they are connected to your instructor's workbook. If needed you can download a new template, but then must resubmit its URL through the google form and alert you instructor (as there will be two spreadsheets with your name).
If needed you can also make another tab and name it "scratch" to do other work, However only answers in the boxes on the template pages will be graded.
Make a Beer's Law Plot using a scatter plot with line of best fit and appropriate equation. Use the equation to find the extinction coefficient, ϵ. 4.2.2 (Note the width of the cuvette is 1cm)
Figure \(\PageIndex{7}\):Beer's Law worksheet. (Copyright; Poirot CC0)
Kinetics Tab
Import your decay plot data using the same steps as importing the spectra. Delete any rows where the absorbance is above 1 or below 0.05. (Delete rows not the individual cells otherwise your pdf will have several blank pages)
Make your plots for Zeroth, First, and Second Order (Summary of Rate Laws). Determine the order of reaction and report it on the coverpage
Use formulas to do algebraic calculations (Tips and short cuts)