LastName_Excel
docx
keyboard_arrow_up
School
Minnesota State University, Moorhead *
*We aren’t endorsed by this school
Course
150L
Subject
Chemistry
Date
Jan 9, 2024
Type
docx
Pages
2
Uploaded by MasterMousePerson897
Using
Microsoft Excel
Name:
Hand-In, Chem 150L, Fall 2022
Partner:
Due Monday, Sept. 12, 11:59 pm
1.
(2 points) Briefly describe your
experimental design
and state your original, testable
hypothesis
of
what would happen in the experiment.
Design: {Type answer here.}
Hypothesis: {Type answer here.}
2.
(2 points) Paste your properly formatted Excel data table below.
Be sure that the statistics rows are
included at the bottom and all values are rounded appropriately.
3.
(4 points) Paste your properly formatted Excel graph below.
The graph should be at least one-third to
one-half of the page in size so that it is easily readable.
4.
(4 points) (a) Is there a trend in your data?
If so, what kind of trend is it?
{Type answer here.}
(b) What does the equation of the line tell you, and what is the physical interpretation of the slope?
What does the R
2
value tell you?
{Type answer here.}
(c) Do your experimental results support or refute your original hypothesis?
Explain by using data
from
both
your table and graph.
{Type answer here.}
See the rubric below for more detailed information about grading.
Unsatisfactory
Borderline
Satisfactory
Excellent
Pts.
Q#1
Hypothesis
No hypothesis.
0 points
Hypothesis is there
but not well stated.
1 point
Reasonable
hypothesis, but no
experiment
description.
1.5 points
Reasonably stated
hypothesis and
experimental design.
2 points
2 pts
Q#2
Data Sheet
No data sheet.
0 points
No statistics.
1 point
-0.5 pt for each
poorly formatted
item.
1.5 points
Meaningful column
labels and widths.
Table is easy to
follow. Statistics
included. Rounding
appropriate.
2 points
2 pts
Q#3
Graph
If the graph is
not an x-y
scatter plot, the
graph earns
zero points.
0 points
Graph is an x-y
scatter plot but does
not meet any of the
criteria noted in the
last column.
1 point
-0.5 pt for each minor
error.
3 points
Graph is large enough
to be easily readable
and is scaled
properly, 1 pt.
Correct axis labels
and graph title, 1 pt.
Best fit line and
equation with R
2
value, 1 pt.
4 points
4 pts
Q#4
Conclusion
No conclusion
or answers to
questions.
0 points
Poorly supported
conclusion and one
or more parts of
question not
answered correctly.
1-2 points
One part of question
not answered
correctly or poorly
supported conclusion.
3 points
Trend described, 1 pt.
Equation, slope, and
R
2
explained, 1 pt.
Conclusion is
supported by data
presented in table
and
graph, 2 pts.
4 points
4pts
Total
12
pts
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Please help
arrow_forward
I am not asking for help in writing this report.
Could you solve the calculation parts for the steps on the last page? like 13, 14, 15, 17, 18, and 19.
This experiment is based on this video: https://www.youtube.com/watch?v=SVvGtcFhdls
arrow_forward
You work in a research organization that is looking for markers of various diseases that can be used as a diagnostic for the disease. It has been reported in the past that high levels of Cu are found in the sweat of people with cystic fibrosis. One of the research projects is focused on looking for high levels of Cu in samples that can be obtained non-invasively such as saliva, sweat, hair, nails, etc.
The lab will analyze large samples for Cu. What instrument would you recommend purchasing to support this work, Atomic absorption spectrophotometer or an inductively coupled plasma atomic spectrophotometer? Explain the basis for your decision.
arrow_forward
2
W
S
Type your answer to the following:
Consider the steps the student took in the following scenario. Then describe anything the student
did wrong and how it would have affected the student results (too high, low, or unchanged) and why.
X
A student forgot to weigh the filter paper prior to filtering the salt from the sand. To make up for this,
the student weighed a different filter paper from the box and used that mass in the calculations.
Edit View Insert Format Tools Table
12pt Paragraph
#
3
80
F3
E
D
$
4
C
888
R
LL
F
BI U
%
5
V
F5
T
G
MacBook Air
6
F6
Y
B
T²
&
7
H
F7
A
U
N
*
00
8
J
1
(
9
M
K
O
F10
L
X
P
arrow_forward
SWAN
B.Leciure28-Introto Sk
Doctors Vs Nurses: Wh
eztomheducation.com
A https://ezto.mheducation.com/hm.tpx
E Connect
Chem 1151- Survey of Chemistry I. Cher
(Dr. Meyers), Spring 2020
CHEMISTRY
Set 7 (Ch. 4)
Question 29 (of 42)
value:
0.00 points
3 attempts left
Check my work
Enter your answer in the provided box.
When potassium cyanide (KCN) reacts with hydrochloric acid, hydrogen cyanide (HCN), a poisonous
gas, is produced. The equation is
кCNag) + HC (аg) > КСаg) + HCN(g)
Calculate the number of g of KCN that will react with 6.93 mol of HCI.
g KCN
pe here to search
arrow_forward
Assuming that an experiment's results are 10.1, 10.4 and 10.6, find the mean, the average deviation from the mean and the
standard deviation. You can use Excel to verify your calculation.
Use the editor to format your answer
arrow_forward
There is one incorrect answer here. Can you help me figure out which one?
arrow_forward
LIMIT TEST (IMPURITIES - BIOLOGICAL)
Instructions: Note the color change of each of the samples by writing blue or pink accordingly. Then give inference whether the sample is contaminated or not contaminated upon observation.
Answer the highlighted numbers.
BLANK
(Sterile distilled water)
Reference Sugar Solution
Sample A
Sample B
REPLICATE 1
BLUE
BLUE
PINK
PINK
REPLICATE 2
BLUE
PINK
BLUE
PINK
REPLICATE 3
BLUE
PINK
PINK
PINK
INFERENCE
NOT CONTAMINATED
CONTAMINATED
1
2
1.
2.
3. Which of the two samples is relatively clean of biological impurities?
4. Given the result in limit test as an analyst, what will be the final conclusion to this? Write whether rejected or accepted for each sample.
(see attached photo)
arrow_forward
phs.blackboard.com/webapps/assessment/take/take.jsp?course_assessment_id%3D 36688_1&course_id%3D_31958 1&content_id%3_1130567_1&-
8r
10
13 140 15
16
20
11
12
17
18
19
20
A Moving to another question will save this response.
Quèstion 6
Select the statement that is not supported by the following equation:
q=0=(mwater)(Cwater)(ATwater)+ (mmetal)(Cmetal)( ATmetal)
The total change in heat is the sum of the changes in heat of water and a metal.
Energy is conserved.
Energy is transferred between water and a metal.
Energy is lost during a calorimetry experiment.
A Moving to another question will save this response.
hp
&
%23
9.
6.
00
进3
arrow_forward
4,6,7,8)
Question 19 of 20 (5 points) Question Attempt: 1 of 1
Time Remaining: 30:47
Hannah
10
= 11
= 12
=13
=14
=15
= 16
17
18
19
20
Predict the reactants of this chemical reaction. That is, fill in the left side of the chemical equation. Be sure the equation you submit is balanced. (You can edit
both sides of the equation to balance it, if you need to.)
do
Note: you are writing the molecular, and not the net ionic equation.
-
CaBr, (aq) + H,O(1)
Submit Assignment
Continue
Accessibility
Privacy Center
2021 McGraw Hill LLC All Rights Reserved. Terms of Use
II
arrow_forward
help me answer this thank you
this is analytical chemistry
arrow_forward
Prelab1
Please help with 1-3
arrow_forward
Please answer questions 3 and 4 and show work please. Thank you
arrow_forward
You are interested to know the Q10 value for mean heart rate (# of beats/10 sec) for a species of crab for the
temperature interval of 25°C - 35°C. To find this value, you collect data for these six temperatures and calculate mean
heart rate (# of beats/10 sec) for each temperature. Here is the data:
10°C
15°C
20°C
25°C
30°C
35°C
Mean Heart Rate (#
23.67
23.89
24.33
27
35.89
37.78
beats/10 sec)
What is the Q1o value for heart rate (# of beats/10 seconds) for the temperature interval of 25°C - 35°C? Round your
answer to two decimal places.
arrow_forward
Course name: College Chemistry
You need to solve this problem based on Problem, Data, Hypothesis Experiment, and
conclusion. Please do not use Chat GPT to solve this problem.
Scientific methods
Instruction: Clearly provide the statement for each step of the scientific method in 1
sentence:
1.
2.
4.
Problem
3. Hypothesis
Experiment
Conclusion
5.
Data
Course code: CHEM 141
SCENARIO 5: Study Habits and Test Performance
A group of students in a class notice that their test scores vary, even though they study
similar amounts. They want to determine if different study habits affect test performance.
The students note down the study hours of each student and their corresponding test
scores. They also survey students about their study methods, such as reading notes,
practicing problems, or group study. The students speculate that students who engage in
active study methods, such as practicing problems, will perform better on tests compared
to those who passively review notes. They begin by…
arrow_forward
Tube 1:
Tube 2:
Tube 3:
Tube 4:
arrow_forward
can you please explain how we get the cumulative volume and what is it? The image below is just for reference. It shows the cumulative volume. But do we obtain it
arrow_forward
Categorize each as a determinate or an indeterminate error and further
classify determinate errors as instrumental, method or personal.
a) An unknown sample being weighed is hygroscopic.
b) One component of a mixture being analyzed quantitatively by GC
reacts with the column packing.
c) A radioactive sample being counted repeatedly without any change in
condition yields a slightly different count at each trial.
d) The tip of the pipet used in the analysis is broken.
e) In measuring the same peak heights of a chromatogram, two
technician each report different heights.
arrow_forward
4.
Now that you know how to take measurements from the video, it's time to determine the trial you will use for your calculations.
Pick your first trial based on your birth month:
Trial 1: January, February, or March
Trial 2: April, May, or June
Trial 3: July, August, or September
Trial 4: October, November, or December
Which is the first trial you will observe?
arrow_forward
&
Spring 2023 CHEM 1411 14 General Chemistry I LAB
Experiment 2 Postlab
57 minutes remaining
Postlab Content
Page 3 of 6
Question 2
An object with a mass of 47.2 kilograms and a volume of 47.6 liters. Find the density with units of g/cm³. Report your answer
with three significant figures.
Add your answer
Questions Filter (5)
5 OF 5 QUESTIONS REMAINING
K First Last >
Continue
Details & In
PER Assessm
2/23/23
X
✓
• You
after
76°F
Time li
60 min
Attem
2 atte
Grading
Sa
arrow_forward
To ensure that you are not confused, I attached what the experiment was about. I highly recommend you read through it before going to the questions.
file:///Users/michaelzheng/Downloads/ExploringEnergy%20(2).pdf
Only answer Post lab questions 2-5
For number five, put the answers in the format stated in the background.
Thank you.
arrow_forward
Please find standard de
arrow_forward
ESF X
empt/quiz_start_frame_auto.d21?ou=9739790&isprv=&qi=11007766&cfql=0&dnb=0&fromQB=0&inProgress=1
ystems
Question 5 (1 point)
Ben starts walking along a path at 3 mi hr¹. Amanda starts jogging along the same path 1 hour later at 5 mi hr. After how much
time jogging does Amanda catch up to Ben?
3.5 hr
2.5 hr
2 hr
16
arrow_forward
20,18,2,4,15,15,10
Using these data, construct a 80% confidence interval for the average net change in a student's score after completing the course. Assume the population is approximately normal.
Construct the 80% confidence interval. Round your answer to one decimal place.
arrow_forward
Answer the questions using one of the words or phrases from the following list. We suggest that you copy and paste answers as it avoids mis-spellings and typos.
Accuracy
Precision
False positive
False negative
Detection limit
Blank
Linear range
Spike
Limit of quantitation Internal standard
Please provide the terms for each definition
If a patient does not have COVID, but a test results says that they do?
How close your experimental result is to the "true" answer?
When you run an unknown and then repeat the analysis after adding a known amount of analyte?
When you run a solution known to have a zero concentration of your analyte?
The lowest concentration of an analyte which can be reported with an accurate concentration?
If a patient does have COVID, but a test results says that they do not?
How close multiple sample replicate results are to each other?
When you run a solution with a known concentration of a compound which is not your analyte?
The lowest concentration of an analyte…
arrow_forward
Question 1 of 20
A barrel of crude oil has a volume of
42 gallons, only approximately 45%
of which is processed into gasoline. If
your car achieves 32 mi/gal, and you
drive 36,000 miles in one year, how
many barrels of crude oil are required
to run your car for a year?
Tap here or pull up for additional resources
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Introductory Chemistry: A Foundation
Chemistry
ISBN:9781285199030
Author:Steven S. Zumdahl, Donald J. DeCoste
Publisher:Cengage Learning
Related Questions
- Please helparrow_forwardI am not asking for help in writing this report. Could you solve the calculation parts for the steps on the last page? like 13, 14, 15, 17, 18, and 19. This experiment is based on this video: https://www.youtube.com/watch?v=SVvGtcFhdlsarrow_forwardYou work in a research organization that is looking for markers of various diseases that can be used as a diagnostic for the disease. It has been reported in the past that high levels of Cu are found in the sweat of people with cystic fibrosis. One of the research projects is focused on looking for high levels of Cu in samples that can be obtained non-invasively such as saliva, sweat, hair, nails, etc. The lab will analyze large samples for Cu. What instrument would you recommend purchasing to support this work, Atomic absorption spectrophotometer or an inductively coupled plasma atomic spectrophotometer? Explain the basis for your decision.arrow_forward
- 2 W S Type your answer to the following: Consider the steps the student took in the following scenario. Then describe anything the student did wrong and how it would have affected the student results (too high, low, or unchanged) and why. X A student forgot to weigh the filter paper prior to filtering the salt from the sand. To make up for this, the student weighed a different filter paper from the box and used that mass in the calculations. Edit View Insert Format Tools Table 12pt Paragraph # 3 80 F3 E D $ 4 C 888 R LL F BI U % 5 V F5 T G MacBook Air 6 F6 Y B T² & 7 H F7 A U N * 00 8 J 1 ( 9 M K O F10 L X Parrow_forwardSWAN B.Leciure28-Introto Sk Doctors Vs Nurses: Wh eztomheducation.com A https://ezto.mheducation.com/hm.tpx E Connect Chem 1151- Survey of Chemistry I. Cher (Dr. Meyers), Spring 2020 CHEMISTRY Set 7 (Ch. 4) Question 29 (of 42) value: 0.00 points 3 attempts left Check my work Enter your answer in the provided box. When potassium cyanide (KCN) reacts with hydrochloric acid, hydrogen cyanide (HCN), a poisonous gas, is produced. The equation is кCNag) + HC (аg) > КСаg) + HCN(g) Calculate the number of g of KCN that will react with 6.93 mol of HCI. g KCN pe here to searcharrow_forwardAssuming that an experiment's results are 10.1, 10.4 and 10.6, find the mean, the average deviation from the mean and the standard deviation. You can use Excel to verify your calculation. Use the editor to format your answerarrow_forward
- There is one incorrect answer here. Can you help me figure out which one?arrow_forwardLIMIT TEST (IMPURITIES - BIOLOGICAL) Instructions: Note the color change of each of the samples by writing blue or pink accordingly. Then give inference whether the sample is contaminated or not contaminated upon observation. Answer the highlighted numbers. BLANK (Sterile distilled water) Reference Sugar Solution Sample A Sample B REPLICATE 1 BLUE BLUE PINK PINK REPLICATE 2 BLUE PINK BLUE PINK REPLICATE 3 BLUE PINK PINK PINK INFERENCE NOT CONTAMINATED CONTAMINATED 1 2 1. 2. 3. Which of the two samples is relatively clean of biological impurities? 4. Given the result in limit test as an analyst, what will be the final conclusion to this? Write whether rejected or accepted for each sample. (see attached photo)arrow_forwardphs.blackboard.com/webapps/assessment/take/take.jsp?course_assessment_id%3D 36688_1&course_id%3D_31958 1&content_id%3_1130567_1&- 8r 10 13 140 15 16 20 11 12 17 18 19 20 A Moving to another question will save this response. Quèstion 6 Select the statement that is not supported by the following equation: q=0=(mwater)(Cwater)(ATwater)+ (mmetal)(Cmetal)( ATmetal) The total change in heat is the sum of the changes in heat of water and a metal. Energy is conserved. Energy is transferred between water and a metal. Energy is lost during a calorimetry experiment. A Moving to another question will save this response. hp & %23 9. 6. 00 进3arrow_forward
- 4,6,7,8) Question 19 of 20 (5 points) Question Attempt: 1 of 1 Time Remaining: 30:47 Hannah 10 = 11 = 12 =13 =14 =15 = 16 17 18 19 20 Predict the reactants of this chemical reaction. That is, fill in the left side of the chemical equation. Be sure the equation you submit is balanced. (You can edit both sides of the equation to balance it, if you need to.) do Note: you are writing the molecular, and not the net ionic equation. - CaBr, (aq) + H,O(1) Submit Assignment Continue Accessibility Privacy Center 2021 McGraw Hill LLC All Rights Reserved. Terms of Use IIarrow_forwardhelp me answer this thank you this is analytical chemistryarrow_forwardPrelab1 Please help with 1-3arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Introductory Chemistry: A FoundationChemistryISBN:9781285199030Author:Steven S. Zumdahl, Donald J. DeCostePublisher:Cengage Learning

Introductory Chemistry: A Foundation
Chemistry
ISBN:9781285199030
Author:Steven S. Zumdahl, Donald J. DeCoste
Publisher:Cengage Learning