University of Nevada General Chemistry Problems Report Please use excel to complete the attached excel assignment. All of the needed details are in the exc

University of Nevada General Chemistry Problems Report Please use excel to complete the attached excel assignment. All of the needed details are in the excel assignment attachment. I also included an attachment that explains how to make a graph on excel. This assignment is for Chemistry 122. Thank you in advance. How to create a graph
on Excel
Chem 122 lab
What is Excel?
• A computer program used to create spreadsheets electronically.
• Uses the same shortcuts and functions like other Microsoft programs.
• Used to easily organize data, create charts and graphs, edit information, and
perform calculations.
• FREE Excel and other Microsoft Office products available for UNLV
students at: https://oit.unlv.edu/software/microsoft-office-365
Overview of Excel
• By default, Excel will open a blank workbook
that contains worksheets/spreadsheets.
• It is possible to have more than one spreadsheet in a
workbook.
• Each box in a column and a row is called a
“cell”.
• Ie. Column A, Row 1 (shown by arrow) is referred to
as “cell A1”.
• In chemistry, Excel is used to create graphs, in
order to see the trends in the data.
Text Recognition
• Excel is capable of recognizing text
consisting of numbers, letters, and
characters.
• Text alignment will reveal how Excel
perceives the data being input on
each cell.
• Left alignment is recognized as words.
• Right alignment means that Excel sees
the data as a set of numbers and can,
therefore, be used to perform
mathematical functions.
Creating a graph
A step-by-step procedure
• Properly label row 1.
• To resize the column width, select the column(s) and align the mouse at the end of the
column. If aligned properly, the mouse will change into
. Double click.
• To select multiple columns, press the CTRL button on the keyboard and left-click the mouse
button to choose the proper columns.
• Fill the column with the data.
• If the data is a series of numbers:
• Type the first number on cell A2.
• Type the equal sign on cell A3.
• Click on or type in the first cell’s
number (“A2”) in the series.
• Type in “+1” and press “enter”.
• Autofill
• Select cell A3.
• Place the cursor at the bottom right
corner of cell A3.
• When the cursor turns into
,
left click on the mouse and drag
down to autofill the rest of the
column.
• When performing a math function,
such as setting up an equation that
automatically calculates the natural
log of energy drinks consumed:
• Type in the equal sign.
• Type the math function (ie. “ln” for
•
•
•
•
natural log).
Type in an open parenthesis “(”.
Select the proper cell from the data
(in this case, type or select cell
“B2”).
Close the parenthesis “)”.
Press “ENTER”.
• Drag the cursor to the
bottom right corner of cell
C2 and when the cursor
turns into , double click to
autofill the rest of the
column.
• Select column A
and C by clicking
on the top of the
columns. Press
and hold the
CTRL button in
order to select
more than 1
column at a time.
• While columns A and C are highlighted:
• Click the “INSERT” tab.
• Find the “Chart” and select “Scatter with Smooth Lines and Markers”.
• Click on “Chart Elements” (plus sign on the right of the graph) and select
“Axis Titles”. Label your x-axis, y-axis, as well as the title of your graph.
• Right click on any of your data points on the graph and select “Add
Trendline”. (You should see a dotted line appear on your graph.)
• Choose the “Linear” trendline.
• Right click on the trendline on the graph again and choose outline, to change
the color of the trendline.
• Scroll down to the bottom of “trendline options” and check the boxes for
“Display Equation on chart” and “Display R-squared value on chart.”
Integrated Rate Laws on a Plot
Rate Laws
• Using the R2 value on a plot can help determine if a reaction is zero, first or
second order.
Plot for straight line
Zero Order
First Order
Second Order
[A] vs. t
ln [A] vs. t
1/[A] vs t
Assignment
• See your TA for the worksheet.
• Due at the beginning of lab next week. No exceptions.
CHE122L: General Chemistry II
Excel Graphing Activity
Microsoft Excel: Create a Basic Spreadsheet
To complete this assignment, you will need the Microsoft Excel program installed on
your tablet or computer. Alternatively, you may utilize any of the computer labs on
campus. More information about the UNLV computer labs and locations can be found at
http://oit.unlv.edu/labs-classrooms/computer-labs. Make sure you show all your work
and include all the graphs in each problem in your lab report in order to receive full
credit.
Please read through the following questions and provide the information requested:
1. A general chemistry student tracks her hours of sleep during the course of a
particularly rough semester and finds the following data:
Time (months)
Average amount of nightly sleep (hours)
1
9.43
2
7.38
3
6.29
4
4.65
•
•
•
•
•
•
•
•
Enter the data into cells in an Excel spreadsheet
Graph the above data using a scatterplot
o The month values should appear on the x axis and the hours of sleep
values should appear on the y axis.
Label your axes
o Include the provided variables and units
Title your graph with the following: “Sleep Study”
Create a linear trendline on the graph
Display the equation and R2 value on the chart
Determine if the correlation is strong based upon the calculated R2 value.
o Any value above 0.90 is considered a strong correlation. The slope of
the line indicates a positive or negative correlation.
Print this graph along with the excel data on one page of paper to turn in.
Answer the following questions:
1a) What is the calculated R2 value from the chart?
1b) Based upon this value, how would you describe the relationship between the length
of the semester and the amount of sleep the student is getting on average? Is there a
strong correlation between them? Is this a positive or negative correlation?
1c) If the semester continued another month (Time = 5), what would the expected amount
of sleep be? (Hint: use the equation provided by the chart software to calculate the
amount of sleep). Does your final answer make sense based upon the trend you see in the
data over time?
CHE122L: General Chemistry II
Excel Graphing Activity
2. A student is titrating a sample in 1.00 mL aliquots over 1.00 minute intervals for a total
of ten readings. The titrated sample is placed in a spectrophotometer at each interval and
an absorbance reading is taken. The data is as follows:
Time (minutes)
1.0
2.0
3.0
4.0
5.0
6.0
7.0
8.0
9.0
10.0
•
•
•
•
•
•
•
•
•
Absorbance
0.98
0.86
0.77
0.65
0.55
0.46
0.35
0.22
0.19
0.17
Enter the data above into cells in an Excel spreadsheet
In the column to the right of Absorbance, calculate the log of Absorbance
o You should have three columns total
o Label your new column “log(Abs)”
Graph the time versus log(Abs)
o The time values should appear on the x axis and log(Abs) values should
appear on the y axis.
Label your axes
o Log (Abs) does not have units, so none should be listed
Title your graph with the following: “Kinetics of Titration”
Create a linear trendline on the graph
Display the equation and R2 value on the chart
Determine if the correlation is strong based upon the calculated R2 value.
o Any value above 0.90 is considered a strong correlation. The slope of
the line indicates a positive or negative correlation.
Print this graph along with the excel data on one page of paper to turn in.
Answer the following questions:
2a) What is the calculated R2 value from the chart?
2b) Based upon this value, is there a strong correlation between time and the
log(Absorbance) values? Is this a positive or negative correlation?
CHE122L: General Chemistry II
Excel Graphing Activity
3. A student obtains the following data while preforming an experiment:
Concentration (mol/L)
Signal (counts)
1.00
0.009
2.00
0.021
5.00
0.046
10.00
0.095
20.00
0.213
•
Graph the data above:
o Hint: Use the directions and structure from problem 1 to guide you
through this exercise.
Answer the following questions:
3a) What is the nature of the relationship between concentration and signal?
3b) What is the concentration of a solution with a signal of 0.065?
4. Dimethyl ether, CH3OCH3, decomposes at high temperatures as shown in the
following equation:
CH3OCH3(g) ® CH4(g) + H2(g) + CO(g)
The following data were obtained when the partial pressure of CH3OCH3 was studied as
this compound decomposed at 500°C. Use these data to determine the order of this
reaction. You must show ALL work to get full points (all graphs).
PCH3OCH3
(mm Hg)
Time (s)
312
278
251
227
157
0
390
777
1195
3155

Purchase answer to see full
attachment