MBA6320_HW1_Edwards
.xlsx
keyboard_arrow_up
School
Ohio University, Main Campus *
*We aren’t endorsed by this school
Course
6320
Subject
Chemistry
Date
Feb 20, 2024
Type
xlsx
Pages
28
Uploaded by ProfSummer15147
Copyright © Dr. Young and
Question
1. The correct hot key combination to select cells in a column in Excel is
2. The correct hot key to select the correct absolute/relative settings is
3. The correct absolute/relative setting to make both the column and row absolute is
4. The correct absolute/relative setting to make only the column absolute is
5. The correct absolute/relative setting to make only the row absolute is
6. The correct absolute/relative setting to make both the column and row relative is
7. The correct hot key combination to copy a formula down is
8. If you are asked to compute the mean, what Excel function should you use
9. To find the largest value in a column, which function should you use
10. Numbers obtained as a result of measurements are
Copyright © Dr. Young and
d Professor Goodnite. All rights reserved.
Answer
Ctrl Shift Down Arrow
F4
$A$1
$A1
A$1
A1
Ctrl D
AVERAGE
MAX
Continuous numbers
d Professor Goodnite. All rights reserved.
Periodic Table I
I
1
H
1.008
Hydrogen
II
II
3
4
Li
Be
6.941
9.012
Lithium
Beryllium
III
11
12
Na
Mg
22.990
24.305
Sodium
Magnesium
III
IV
V
VI
VII
VIII
IX
IV
19
20
21
22
23
24
25
26
27
K
Ca
Sc
Ti
V
Cr
Mn
Fe
Co
39.098
40.078
44.956
47.880
50.942
51.996
54.938
55.847
58.933
Potassium
Calcium
Scandium
Titanium
Vanadium
Chromium
Manganese
Iron
Cobalt
V
37
38
39
40
41
42
43
44
45
Rb
Sr
Y
Zr
Nb
Mo
Tc
Ru
Rh
85.468
87.620
88.906
91.224
92.906
95.940
(98)
101.070
102.906
Rubidium
Strontium
Yttrium
Zirconium
Niobium
Molybdenum
Technetium
Ruthenium
Rhodium
VI
55
56
Rare Earth (below)
72
73
74
75
76
77
Cs
Ba
Hf
Ta
W
Re
Os
Ir
132.905
137.327
180.948
180.948
183.850
186.207
190.230
192.220
Cesium
Barium
Hafnium
Tantalum
Tungsten
Rhenium
Osmium
Iridium
VII
87
88
104
105
106
107
108
109
Fr
Ra
Rf
Db
Sg
Bh
Hs
Mt
(223)
226.025
(261)
(262)
(263)
(262)
(265)
(266)
Francium
Radium
Rutherfordium Dubnium
Seaborgium
Bohrium
Hassium
Meitnerium
Legend
Non-Metal
Alkali Metals
57
58
59
60
61
62
Alkaline Earth Metals
La
Ce
Pr
Nd
Pm
Sm
Transition Metals
138.906
140.115
140.908
144.240
(145)
150.360
Other Metals
Lanthanum
Cerium
Praseodymium Neodymium Promethium
Samarium
Metalloids
89
90
91
92
93
94
Halogen
Ac
Th
Pa
U
Np
Pu
Noble Gases
227.028
232.038
231.036
238.029
237.048
(244)
Rare Earth
Actinium
Thorium
Protactinium
Uranium
Neptunium
Plutonium
of Elements
XVIII
2
He
4.003
XIII
XIV
XV
XVI
XVII
Helium
5
6
7
8
9
10
B
C
N
O
F
Ne
10.811
12.011
14.007
15.999
18.998
20.180
Boron
Carbon
Nitrogen
Oxygen
Flourine
Neon
13
14
15
16
17
18
Al
Si
P
S
Cl
Ar
26.982
28.086
30.974
32.066
35.453
39.948
X
XI
XII
Aluminum
Silicon
Phosphorous
Sulfur
Chlorine
Argon
28
29
30
31
32
33
34
35
36
Ni
Cu
Zn
Ga
Ge
As
Se
Br
Kr
58.690
63.546
65.390
69.723
72.610
74.922
78.960
79.904
83.800
Nickel
Copper
Zinc
Gallium
Germanium
Arsenic
Selenium
Bromine
Krypton
46
47
48
49
50
51
52
53
54
Pd
Ag
Cd
In
Sn
Sb
Te
I
Xe
106.420
107.868
112.411
114.818
118.710
121.750
127.600
126.904
131.290
Palladium
Silver
Cadmium
Indium
Tin
Antimony
Tellurium
Iodine
Xenon
78
79
80
81
82
83
84
85
86
Pt
Au
Hg
Tl
Pb
Bi
Po
At
Rn
195.080
196.967
200.590
204.383
207.200
208.980
(209)
(210)
(222)
Platinum
Gold
Mercury
Thallium
Lead
Bismuth
Polonium
Astatine
Radon
110
111
112
Uum
Uuu
Uub
(269)
(272)
(272)
Ununnillum Unununium Ununbium
63
64
65
66
67
68
69
70
71
Eu
Gd
Tb
Dy
Ho
Er
Tm
Yb
Lu
151.965
157.250
158.925
162.500
164.930
167.260
168.934
173.040
174.967
Europium
Gadolinium
Terbium
Dysprosium
Holmium
Erbium
Thulium
Ytterbium
Lutetium
95
96
97
98
99
100
101
102
103
Am
Cm
Bk
Cf
Es
Fm
Md
No
Lr
(243)
(247)
(247)
(251)
(252)
(257)
(258)
(259)
(260)
Americium
Curium
Berkelium Californium Einsteinium
Fermium
Mendelevium Nobelium Lawrencium
Given Data
Invoice Number
State Distributor
Product Line
Sales Amount
1259847
Indiana
Gamma
$6,874.04
1259848
Illinois
Eta
$10,781.26
1259849
Indiana
Eta
$2,580.52
1259850
Ohio
Delta
$7,959.09
1259851
Ohio
Eta
$7,157.01
1259852
Illinois
Gamma
$4,241.67
1259853
Ohio
Gamma
$2,243.36
1259854
Ohio
Alpha
$3,648.19
1259855
Indiana
Beta
$2,306.51
1259856
Indiana
Delta
$9,448.73
1259857
Indiana
Alpha
$2,003.26
1259858
Ohio
Beta
$1,128.13
1259859
Ohio
Eta
$3,096.91
1259860
Indiana
Gamma
$4,137.43
1259861
Ohio
Eta
$2,003.26
1259862
Illinois
Eta
$947.54
1259863
Ohio
Alpha
$1,136.03
1259864
Illinois
Gamma
$4,831.09
1259865
Illinois
Eta
$5,475.40
1259866
Indiana
Delta
$9,681.83
1259867
Illinois
Delta
$2,144.27
1259868
Illinois
Alpha
$2,098.17
1259869
Illinois
Delta
$10,259.91
1259870
Indiana
Eta
$4,562.70
1259871
Indiana
Eta
$7,824.38
1259872
Indiana
Beta
$8,614.83
1259873
Ohio
Eta
$3,268.17
1259874
Indiana
Alpha
$5,744.69
1259875
Ohio
Gamma
$9,656.35
1259876
Ohio
Eta
$10,464.07
1259877
Illinois
Eta
$3,111.48
1259878
Illinois
Beta
$5,956.48
1259879
Indiana
Gamma
$7,071.80
1259880
Indiana
Gamma
$5,363.54
1259881
Illinois
Eta
$10,079.01
1259882
Ohio
Delta
$6,371.49
1259883
Illinois
Alpha
$3,384.21
1259884
Illinois
Beta
$5,118.80
1259885
Indiana
Eta
$2,886.32
1259886
Ohio
Delta
$10,920.75
1259887
Illinois
Alpha
$5,674.74
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 Questions
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Which of the following is true about pH probe?
a. A pH probe consists of a metallic indicator.
b. A pH probe will always have an SCE reference electrode.
c. A pH probe is specific for measuring proton concentrations.
d. A pH probe is an ion selective electrode that consists of a concentration cell.
arrow_forward
Instead of using an electrode to collect ions, why electron multiplier is needed as the detector for MS?
arrow_forward
#4
arrow_forward
Calcium in a 100.0 mL sample of fuit juice was analyzed by an electrochemical
method that gave a detector current of 2.40 mA. A standard addition of 10.00 mL of
80.0mg/mL calcium ion increased the current to 4.56 mA. Find the concentration of
calcium in the fruit juice.
arrow_forward
Táke off any gridlines and add a title and axes labels.
Add the trendline and the relevant equation.
b)
If a sample was analyzed and the current was measured to be 5.18 mA, what is the
concentration of analyte in the sample?
5.18= 3.403x + 1.9232
3.2368=3.4403 x
0.947: x
Pentane (C5H12) is a liquid with density of 0.929 g/mL at 25 °C. Find the true mass of pentane
when the mass in air is 14.82 g. Assume air density is 0.0012 g/mL.
arrow_forward
If a pH electrode is experiencing the sodium (alkaline) error...
A. the apparent pH will be lower than the true pH.
B. the apparent pH will be higher than the true pH
C. there will be no effect on the pH, but the glass membrane will dry out because of the sodium.
●
arrow_forward
21.
(What exactly is meant by potentiometric methods? What are they even?)
arrow_forward
Analytical Chemistry II
Why is carbon used as an electrode in arc and spark sources? Explain briefly
arrow_forward
complete: reference electrode is N O T ___
i . i n c o n s t a n t p o t e n t I a l
ii. r e s p o n d I n g t o a na l y t e c o n c e n t r at I o n
iii. g i v i n g s t a bl e r e s p o n s e
arrow_forward
calculate the [FESCN2+] using volumes of stock solutions. Presume that all of the
SCN- ions react. Next, record the light absorbance values of each standard
solution.
Volume
Volume
Volume
[FESCN2+]
Absorbance
Standard
Fe(NO3)3
SCN-
H2O
sample
(mL)
(mL)
(mL)
1
2.50
2.00
20.50
0.1811
2
2.50
1.50
21.00
0.3219
2.50
1.00
21.50
0.4981
4
2.50
0.50
22.00
0.6328
Stock [Fe(NO3)3] = 0.200 M, Stock [SCN-] = 0.0020 M.
%3D
arrow_forward
The basic setups for electrochemical measurement include all of the following, EXCEPT:
Group of answer choices
A. Measure the potential while controlling the current.
B. Measure the current while controlling the potential.
C. Measure the potential at zero current.
D. Measure the potential and current simultaneously.
arrow_forward
please help with the question
arrow_forward
Calculate the molarity of prepared solution?
arrow_forward
Ascorbic acid (vitamin C) in a 50.0-mL sample of orange juice was analyzed by an electrochemical method that gave a detector current of 1.78 mA. A standard addition of 0.400 mL of 0.279 M ascorbic acid increased the current to 3.35 mA. Find the concentration of ascorbic acid in the orange juice.
arrow_forward
Match each commercial application of electrochemistry with the appropriate description.
a. electroplating
b. secondary cell
c. cathodic protection
d. electrorefining
e. fuel cell
f. Hall-Heroult process
g. dry alkaline battery
____
1. measures taken to prevent corrosion
____
2. a battery where the reactants are continuously replenished
____
3. a primary cell
____
4. the application of a thin coating of a metal that resists corrosion
____
5. the use of molten cryolite to produce aluminum
____
6. a rechargeable battery
____
7. the process used to obtain high-grade, pure metals from impure materials
arrow_forward
Which statement is NOT correct?
pH meter should always be standardized before using to make sure that your readings are accurate and repeatable.
The electrode tips should never touch the bottom or sides of a beaker.
When finished using the pH meter, rinse the electrode and place it in the pH 7 buffer solution on standby.
One buffer solution is enough to standardize a pH meter before using.
arrow_forward
One electrochemical technique involves first depositing an analyte on the surface of an electrode, then using an applied current to remove the analyte via a reduction or oxidation reaction. What is this method called?
A. Cyclic voltammetry
B. Polarography
C. Amperometry
D. Hydrodynamic voltammetry
E. Stripping voltammetry
arrow_forward
11. Undercharging has high adverse impact on
a. AGM Battery
c. Gel battery
12. A relative measure of cell electrical current
a. Columbic efficiency
c. Life time
b. Lead Carbon battery
d. Air-Metal Battery
b. C-Rate
d. Power density
arrow_forward
If we had potassium vapor lamps, what color would they be?
arrow_forward
22.a. Which of the following statements describes the change of specific gravity during battery charging?A. The specific gravity increases faster than the state of charge.B. The specific gravity lags behind the state of charge.C. The change in specific gravity with time is directly proportional to the amount of charge.D. A hydrometer reading shows the true state of charge when taken shortly after charging has begun.22.b. The purpose of the vent on the top of a lead-acid cell is toA. permit the gas to escape during charging.B. add water to the cells.C. trap the hydrogen gas generated during charging.D. remove the sediment developed during charging.
arrow_forward
Uses of Substances based on their Chemical Bonds
Objective:
To discover the uses of some substances based on their chemical bonds.
I.
I.
Materials:
Flashlight bulb
3V -battery
Connecting wires (exposed ends)
Metal strips of aluminum, copper, iron
Distilled water
NaCI
Small Beaker
II.
Procedure:
1. To show the conductivity of table salt, NaCl, prepare a simple circuit consisting of a flashlight bulb, 3V-
battery, and connecting wires with insulator ends removed. Prepare 200 cc of distilled water in a small
beaker and immersed the ends of the connecting wire in the water as shown below. Observe the bulb if it
would light. Mix 5 g of NaCl in the distilled water and observe the bulb. Did it light?
electrodes
wire
saltwater
battery
light bulb
2. Add 5 g more, mix and observe the bulb again.
3. Repeat procedure 2.
4. To illustrate the electrical conductivity of different metals, prepare strips of aluminum, copper and iron. Use
the circuit in procedure 1. Connect the bare ends of the wire to…
arrow_forward
1. Identify the components of a pH electrode and explain their functions. Explain throughly.
arrow_forward
DOL
The Chemistry of Rusting-An Introduction to
Unit 4: Chemical T
Flaking Away - Check Your Understanding
For each question, answer on your own in the first row of the table. During partner
time, share your responses and revise your answers as needed, recording them in the
second row. Be prepared to share during the whole-class discussion. Record
final
your
answer to each question in the last row of the table.
1. Write a short paragraph that connects the following words: oxidation, reduction,
anode, cathode, and electrons.
My first answer, thinking on my own:
My revised answer after discussing it with my partner:
My final answer after the whole-class discussion:
НА
arrow_forward
The standard hydrogen electrode (SHE) is used as a reference electrode. True or false?
arrow_forward
A Ni half-cell was coupled to a Ti half-cell to
form a cell at equilibrium conditions:
a. Plot and identify ZA and ZC zones, current
and electron flow.
b. Potential difference between half cells.
c. What is the energy generated by the system.
Data: Standard potential Vs ENH: Ti= 1200 mV
and Sn= -136 mV. The density of Ti = 4.51 g/cm3
and Ni = 8.9 g/cm3. Consider unit areas 1 cm2
arrow_forward
1. IOn selective electrode utilizing pCO2 is used fro the measurement of the electrolyte
a. Phoisphate
b. bicarbonate
c. Magnesium
d. chloride
e. sodium
2. The confirmatory method for the measurement of Calcium and Magnesium
A. Turbidimetry
b. FES
c. none
d. colorimtery
e. AAS
3. the electrolyte is found as component of phospholipids, nucleic acids, creative phosphate and ATP
a. magnesium
b. calcium
c. phosphate
d. bicarbonate
e. chloride
arrow_forward
How does hydronium ion concentation relate to electrode potential in potentiometry?
a. As temperature increases, the pH also increases.
b. Each pH unit represents a 59.1 mV change in potential.
c. The increase in pH is linear relationship to the electrode potential.
d. Decreased H+ concentration is directly proportional to electrode potential.
e. none of these
arrow_forward
Which form if EDTA is used in any analytical experiment? Why?
arrow_forward
Explain the function of each electrode in the polarography cell
arrow_forward
pls helpp
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Instrumental Analysis
Chemistry
ISBN:9781305577213
Author:Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:Cengage Learning
Related Questions
- help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardWhich of the following is true about pH probe? a. A pH probe consists of a metallic indicator. b. A pH probe will always have an SCE reference electrode. c. A pH probe is specific for measuring proton concentrations. d. A pH probe is an ion selective electrode that consists of a concentration cell.arrow_forwardInstead of using an electrode to collect ions, why electron multiplier is needed as the detector for MS?arrow_forward
- #4arrow_forwardCalcium in a 100.0 mL sample of fuit juice was analyzed by an electrochemical method that gave a detector current of 2.40 mA. A standard addition of 10.00 mL of 80.0mg/mL calcium ion increased the current to 4.56 mA. Find the concentration of calcium in the fruit juice.arrow_forwardTáke off any gridlines and add a title and axes labels. Add the trendline and the relevant equation. b) If a sample was analyzed and the current was measured to be 5.18 mA, what is the concentration of analyte in the sample? 5.18= 3.403x + 1.9232 3.2368=3.4403 x 0.947: x Pentane (C5H12) is a liquid with density of 0.929 g/mL at 25 °C. Find the true mass of pentane when the mass in air is 14.82 g. Assume air density is 0.0012 g/mL.arrow_forward
- If a pH electrode is experiencing the sodium (alkaline) error... A. the apparent pH will be lower than the true pH. B. the apparent pH will be higher than the true pH C. there will be no effect on the pH, but the glass membrane will dry out because of the sodium. ●arrow_forward21. (What exactly is meant by potentiometric methods? What are they even?)arrow_forwardAnalytical Chemistry II Why is carbon used as an electrode in arc and spark sources? Explain brieflyarrow_forward
- complete: reference electrode is N O T ___ i . i n c o n s t a n t p o t e n t I a l ii. r e s p o n d I n g t o a na l y t e c o n c e n t r at I o n iii. g i v i n g s t a bl e r e s p o n s earrow_forwardcalculate the [FESCN2+] using volumes of stock solutions. Presume that all of the SCN- ions react. Next, record the light absorbance values of each standard solution. Volume Volume Volume [FESCN2+] Absorbance Standard Fe(NO3)3 SCN- H2O sample (mL) (mL) (mL) 1 2.50 2.00 20.50 0.1811 2 2.50 1.50 21.00 0.3219 2.50 1.00 21.50 0.4981 4 2.50 0.50 22.00 0.6328 Stock [Fe(NO3)3] = 0.200 M, Stock [SCN-] = 0.0020 M. %3Darrow_forwardThe basic setups for electrochemical measurement include all of the following, EXCEPT: Group of answer choices A. Measure the potential while controlling the current. B. Measure the current while controlling the potential. C. Measure the potential at zero current. D. Measure the potential and current simultaneously.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Instrumental AnalysisChemistryISBN:9781305577213Author:Douglas A. Skoog, F. James Holler, Stanley R. CrouchPublisher:Cengage Learning
Principles of Instrumental Analysis
Chemistry
ISBN:9781305577213
Author:Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:Cengage Learning