2-Fillabale_Excel-Report
pdf
keyboard_arrow_up
School
Stockton University *
*We aren’t endorsed by this school
Course
1105
Subject
Chemistry
Date
Dec 6, 2023
Type
Pages
5
Uploaded by MegaMorningJellyfish34
CHEM 2115
Chem I Lab
LAB REPORT
Experiment
#2
Data Analysis on Excel
N
ame
Damelis
Section#
Station
Date
Data Section:
Attach the following three pages to this Lab Report:
1.
Your Solution B plot shows both your data and class data, with trendlines and equations
2.
A plot showing the class data for both Solution A and Solution B, with trendlines and equations for each.
3.
A table of calculated and fit densities from your spreadsheet showing your density values for both Solution A and
Solution B determined using different methods: calculated average from your data, graphical method with your data,
and graphical method with class data.
Results Section:
Interpret your data and discuss the results by answering the following questions.
1.
Do any of the data points for Solutions A or B disagree significantly with the rest of the class data?
If so, note that here and circle these points on the plot.
Density (g/mL)
Solution A
Solution B
Calculated
0.922 g/mL
.886 g/mL
My best fit
0.921 g/mL
0.886 g/mL
Class Data
0.951 g/mL
0.877 g/mL
2.
Compare your density for Solution A determined by the averaging and graphical method.
How well do they agree?
They do not agree. The Class data density is significantly higher than the calculated density for
Solution A. My data stand curve line for solution A is more precise than the calculated density
for Solution A.
3.
Compare your density for Solution B determined by the averaging and graphical method.
How well do they agree?
Class data density is significantly higher than the calculated density. But the calculated density is
accurate to my data density.
4.
Compare your densities for Solution A with the class value.
How well do they agree?
According to Solution A, my data is more significant than the class data. I know so because my
data R
2
is closer to 1 than the class data R
2.
5.
Compare your densities for Solution B with the class value.
How well do they agree?
According to Solution B, class data seems to be more significant than my data. I know so because
class data R
2
is closer to 1 than my data.
6.
Compare the class densities for Solutions A and B.
Are they the same?
Based on this result, are
Solutions A and B the same?
Explain why.
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
No, Solutions A and B are not the same. Solution B has a higher mass than Solution B. The only
similarity in both solutions is the amount of concentration measured.
“What if”
questions will be included in many of the CHEM I Lab exercises.
They are designed to help you think
about the experiments by asking you to figure out
what
would have happened to the result of an the experiment
if
certain things had occurred.
Scientists use this sort of reasoning to understand the relationship between the ideal
case (what was supposed to have happened) and the real experiment (what might have happened in the lab.)
To
answer these questions, look at each hypothetical circumstance and try to see, step by step, how it would have
changed the results in the experiment that you did.
For example, suppose that one drop of solution A accidentally fell out of the pipet after it was filled but before it
was put into the 50 mL beaker.
Would the density calculated for that point be too high, too low, or unchanged?
The answer is that the volume actually transferred was smaller than what was recorded.
The density is calculated
by dividing the measured mass by the recorded volume.
The measured mass did not include the missing drop, but
the drop was included in the recorded volume. The result is that the calculated density was too small either
because the measured mass was too small for the recorded volume or because the recorded volume was too big
for the measured mass.
Q1.
If there were some dirt on your 50 mL beaker that was not removed before you began the
experiment, it is important to understand how it would affect your mass measurements and your density
result.
Would the masses be high, low or unchanged by the dirt? Would the density be high, low or
unchanged by the dirt?
Explain your answer.
The mass would be higher so the density would be higher. Density equals mass over volume so if the
mass is higher than the volume, the density would be high compared to the volume being higher than the
mass. In this case, you could subtract the empty beaker from the dirt and measure the mass of the
solution.
Q2.
If there were some dirt on the beaker and it fell off between the 10 mL and the 15 mL measurement,
this might also affect your mass measurements and your density result.
Would the masses be high, low
or unchanged by the dirt? Would the density be high, low or unchanged by the dirt?
Explain your
answer.
The mass will be low so the density will be low. Density equals mass over volume so if the mass
is lower than the volume, the density would be low. With more volume than mass, the density would be
low.
Related Questions
Instructions You are required to produce a short lab report using the information given in the accompanying document, ‘Lab report assessment_student data’. This document introduces an experiment, and also provides a set of experimental data for this experiment. You are required to use this data to perform steps 8 and 9 of the procedure. This includes calculations of a particular value, and then comparison to the true value. Consider any experimental errors when comparing calculated values and true values. Your report should be between 300 and 500 words (including all table contents and titles of tables and graphs). Your lab report should consist of three sections only: • Experimental • Results and Discussion • Conclusion You do NOT need to include an introduction section. Your experimental section should be written in appropriate lab report format, (passive voice, 3 rd person, in paragraphs). Your results and discussion section should contain the data presented in table format, and…
arrow_forward
This question has multiple parts. Work all the parts to get the most points.
Use the References to access important values if needed for this question.
18
16
14
12
10
8
6
4.
Choose the correct relationship for the plot shown above.
O a direct proportion
O an inverse proportion
O linear with a positive slope and nonzero y-intercept
O linear with a negative slope and nonzero y-intercept
Submit
Cengage Learning | Cengage Technical Support
MacBook Air
DII
E5
F6
EZ
FA
F9
F10
F
2$
&
*
)
4
5
6
7
8
* 00
arrow_forward
Pls help ASAP.
arrow_forward
In order to calibrate a pipet, you obtain the following data:
# of drops
mL
Trial 1
30
0.72
Trial 2
30
0.77
Trial 3
30
0.82
What volume in mL does your pipet deliver per drop?
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
Question 35
arrow_forward
Multiple Choice
Each of the numbered items or incomplete statements is followed by answers or by completions of the statement.
Select the one lettered answer or completion that is best in each case. Write your answer before each number.
27.Quality control department maintain and store records that represent the history of batch from start to finish
a. Quality Coordinating office
b. Analytical Laboratory
d. Material Inspection Section
e. Biological Testing Laboratory
C.
Specification & Analyrtical Development section
28. Which of the following cannot be assay by direct titration with standard base?
Citric acid in calamansi juice
a. Magnesium hydroxide in Milk of Magnesia C.
Acetic acid in vinegar
b.
d.
Diluted phosphoric acid
29. This is used for quantitative preparation of a standard solution:
a.
Pipet
C.
Volumetric flask
b. Graduated cylinder
d.
Buret
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
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
Routine Chemical Tests for Urine - Word
Table Tools
Decy Joy Garriel
Table Design
O Tell me what you want to do
2 Share
File
Home
Insert
Draw
Design
Layout
References
Mailings
Review
View
Help
Layout
X Cut
P Find
Calibri (Body)
12
A A
Aa v
AaBbCcD AaBbCcDc AaBbCcDc AaBbC AaBbCcC AaBbC AaBbCcD
EE Copy
ab. Replace
Paste
BIU v abe X, x
A v aly - A -
I Normal
No Spacing I No Spac. Heading 1
Heading 2 Heading 3 Heading 4
A Select
Format Painter
Clipboard
Font
Paragraph
Styles
Editing
COLLEGE OF HEALTH SCIENCES
RESULTS AND OBSERVA TIONS:
PARTI: BENEDICTS TEST FOR REDUCING SUGARS
田
TUBE
PATIENT
COLOR
RESULT and
NO.
Before: Blue-green
OBSERVATION
WHITE PRECIPITATE:
1
Normal Patient 1
After: Greenish brown
2
Normal Patient 2
Before: Blue
LIGHT GREEN
After: Green
PRECIPITA TE:
3
WHILTE AND YELLOW
Pathologic Patient 1
Before: Blue
PRECIPITATE:
After: Green
BRICK RED
Before: Blue-green
After: Brick Red
Pathologic Patient 2
PRECIPITATE:
Generalization:
Page 5 of 8
947 words
English (Philippines)
K…
arrow_forward
Prelab1
Please help with 1-3
arrow_forward
Did the control experiment verify or refute the results from Exercise 1? Use the results from Exercise 1 and 2 to validate your answer. (Experiment 1 is exercise 1)
arrow_forward
Use the calibration curve or linear regression equation to determine the concentration of
FD&C blue dye No. 1 in Kool-aid.
Food Coloring is 0.026 M in FD&C blue dye No. 1
7.5 x 10 -5 M is 29 mL -> 1000 mL
arrow_forward
The first pic are my results the 2nd one is the question
arrow_forward
Answer the flow diagram to show the sequence of steps in a typical quantitative analysis
arrow_forward
I need help on questions 2-8?
arrow_forward
Help I really have no idea if I calculated it right
arrow_forward
How do I complete table 4 with the date given in table 3?
arrow_forward
STANDARD SAMPLE PREPARATIONS FOR ABSORBANCE & CONCENTRATION DATA
Concentration of stock nickel sulfate hexahydrate solution = .400 Molarity
Sample
Volume
Absorbance
Concentration (In Molarity)
a
5 mL
.179
10 mL
.329
15 mL
.588
20 mL
.760
25 mL
.939
Reference Blank = 0
Please show how to find Molarity, please show
steps. Thank you and stay safe.
arrow_forward
Please I need answers to 6,7,8 and 9
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Instructions You are required to produce a short lab report using the information given in the accompanying document, ‘Lab report assessment_student data’. This document introduces an experiment, and also provides a set of experimental data for this experiment. You are required to use this data to perform steps 8 and 9 of the procedure. This includes calculations of a particular value, and then comparison to the true value. Consider any experimental errors when comparing calculated values and true values. Your report should be between 300 and 500 words (including all table contents and titles of tables and graphs). Your lab report should consist of three sections only: • Experimental • Results and Discussion • Conclusion You do NOT need to include an introduction section. Your experimental section should be written in appropriate lab report format, (passive voice, 3 rd person, in paragraphs). Your results and discussion section should contain the data presented in table format, and…arrow_forwardThis question has multiple parts. Work all the parts to get the most points. Use the References to access important values if needed for this question. 18 16 14 12 10 8 6 4. Choose the correct relationship for the plot shown above. O a direct proportion O an inverse proportion O linear with a positive slope and nonzero y-intercept O linear with a negative slope and nonzero y-intercept Submit Cengage Learning | Cengage Technical Support MacBook Air DII E5 F6 EZ FA F9 F10 F 2$ & * ) 4 5 6 7 8 * 00arrow_forwardPls help ASAP.arrow_forward
- In order to calibrate a pipet, you obtain the following data: # of drops mL Trial 1 30 0.72 Trial 2 30 0.77 Trial 3 30 0.82 What volume in mL does your pipet deliver per drop?arrow_forward20,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_forwardQuestion 35arrow_forward
- Multiple Choice Each of the numbered items or incomplete statements is followed by answers or by completions of the statement. Select the one lettered answer or completion that is best in each case. Write your answer before each number. 27.Quality control department maintain and store records that represent the history of batch from start to finish a. Quality Coordinating office b. Analytical Laboratory d. Material Inspection Section e. Biological Testing Laboratory C. Specification & Analyrtical Development section 28. Which of the following cannot be assay by direct titration with standard base? Citric acid in calamansi juice a. Magnesium hydroxide in Milk of Magnesia C. Acetic acid in vinegar b. d. Diluted phosphoric acid 29. This is used for quantitative preparation of a standard solution: a. Pipet C. Volumetric flask b. Graduated cylinder d. Buretarrow_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_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_forward
- Routine Chemical Tests for Urine - Word Table Tools Decy Joy Garriel Table Design O Tell me what you want to do 2 Share File Home Insert Draw Design Layout References Mailings Review View Help Layout X Cut P Find Calibri (Body) 12 A A Aa v AaBbCcD AaBbCcDc AaBbCcDc AaBbC AaBbCcC AaBbC AaBbCcD EE Copy ab. Replace Paste BIU v abe X, x A v aly - A - I Normal No Spacing I No Spac. Heading 1 Heading 2 Heading 3 Heading 4 A Select Format Painter Clipboard Font Paragraph Styles Editing COLLEGE OF HEALTH SCIENCES RESULTS AND OBSERVA TIONS: PARTI: BENEDICTS TEST FOR REDUCING SUGARS 田 TUBE PATIENT COLOR RESULT and NO. Before: Blue-green OBSERVATION WHITE PRECIPITATE: 1 Normal Patient 1 After: Greenish brown 2 Normal Patient 2 Before: Blue LIGHT GREEN After: Green PRECIPITA TE: 3 WHILTE AND YELLOW Pathologic Patient 1 Before: Blue PRECIPITATE: After: Green BRICK RED Before: Blue-green After: Brick Red Pathologic Patient 2 PRECIPITATE: Generalization: Page 5 of 8 947 words English (Philippines) K…arrow_forwardPrelab1 Please help with 1-3arrow_forwardDid the control experiment verify or refute the results from Exercise 1? Use the results from Exercise 1 and 2 to validate your answer. (Experiment 1 is exercise 1)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you