,Fundamentals of Analytical Chemistry: 9th ed. Chapter 3
Chapter 3
3-1. (a) SQRT returns the square root of a number or result of a calculation.
(b) AVERAGE returns the arithmetic mean of a series of numbers.
(c) PI returns the value of pi accurate to 15 digits
(d) FACT returns the factorial of a number, equal to 1 × 2 × 3 × … × number.
(e) EXP returns e raised to the value of a given number.
(f) LOG returns the logarithm of a number to a base specified by the user.
3-2. Count(value 1, value2,…) returns the number of cells that contain numbers and numbers
within the list of arguments. As it appears in Figure 3-10, the COUNT function should
return a value of 8 for the number of data values in each column of the spreadsheet.
3-3. One method is to add comments for the appropriate cells. The comment group is found
under the Review tab. An example for finding the mean (average) of four numbers is
shown below.
Another method is to add a text box to the worksheet by clicking on Text Box in the
Insert tab. An arrow could be added pointing to the appropriate cell by clicking on
Shapes in the Illustrations group under the Insert tab.
,Fundamentals of Analytical Chemistry: 9th ed. Chapter 3
3-4. Replacing these values gives the worksheet below. Obviously, Column C has a
nonsensical result with the replacement.
3-5. The result is:
3-6. The answer is contained in the problem.
2
, Fundamentals of Analytical Chemistry: 9th ed. Chapter 4
Chapter 4
4-1. (a) The millimole is an amount of a chemical species, such as an atom, an ion, a
molecule or an electron. There are
particles mole particles
6.02 ×1023 × 10−3 =
6.02 ×1020
mole millimole millimole
(b) The molar mass is the mass in grams of one mole of a chemical species.
(c) The millimolar mass is the mass in grams of one millimole of a chemical species.
(d) Parts per million, cppm, is a term expressing the concentration of dilute solutions.
Thus,
cppm = mass of solute × 10 6 ppm
mass of solution
The units of mass in the numerator and the denominator must be the same.
4-2. The molar species concentration is number of moles of that species contained in one liter
of solution. The molar analytical concentration is the total number of moles of a solute in
1 liter of the solution, regardless of the solute’s chemical state.
3
1000 mL 1 cm3 1 m
4-3. The liter: 1 L= × × = 10−3 m3
1L 1 mL 100 cm
1 mol 1L 1 mol
Molar concentration: 1 M = × = −3 3
1L 10−3 m3 10 m
1 MHz
4-4. (a) 3.2 ×108 Hz × =
320 MHz
106 Hz
−7 109 ng
(b) 4.56 ×10 g × =
456 ng
1g
Chapter 3
3-1. (a) SQRT returns the square root of a number or result of a calculation.
(b) AVERAGE returns the arithmetic mean of a series of numbers.
(c) PI returns the value of pi accurate to 15 digits
(d) FACT returns the factorial of a number, equal to 1 × 2 × 3 × … × number.
(e) EXP returns e raised to the value of a given number.
(f) LOG returns the logarithm of a number to a base specified by the user.
3-2. Count(value 1, value2,…) returns the number of cells that contain numbers and numbers
within the list of arguments. As it appears in Figure 3-10, the COUNT function should
return a value of 8 for the number of data values in each column of the spreadsheet.
3-3. One method is to add comments for the appropriate cells. The comment group is found
under the Review tab. An example for finding the mean (average) of four numbers is
shown below.
Another method is to add a text box to the worksheet by clicking on Text Box in the
Insert tab. An arrow could be added pointing to the appropriate cell by clicking on
Shapes in the Illustrations group under the Insert tab.
,Fundamentals of Analytical Chemistry: 9th ed. Chapter 3
3-4. Replacing these values gives the worksheet below. Obviously, Column C has a
nonsensical result with the replacement.
3-5. The result is:
3-6. The answer is contained in the problem.
2
, Fundamentals of Analytical Chemistry: 9th ed. Chapter 4
Chapter 4
4-1. (a) The millimole is an amount of a chemical species, such as an atom, an ion, a
molecule or an electron. There are
particles mole particles
6.02 ×1023 × 10−3 =
6.02 ×1020
mole millimole millimole
(b) The molar mass is the mass in grams of one mole of a chemical species.
(c) The millimolar mass is the mass in grams of one millimole of a chemical species.
(d) Parts per million, cppm, is a term expressing the concentration of dilute solutions.
Thus,
cppm = mass of solute × 10 6 ppm
mass of solution
The units of mass in the numerator and the denominator must be the same.
4-2. The molar species concentration is number of moles of that species contained in one liter
of solution. The molar analytical concentration is the total number of moles of a solute in
1 liter of the solution, regardless of the solute’s chemical state.
3
1000 mL 1 cm3 1 m
4-3. The liter: 1 L= × × = 10−3 m3
1L 1 mL 100 cm
1 mol 1L 1 mol
Molar concentration: 1 M = × = −3 3
1L 10−3 m3 10 m
1 MHz
4-4. (a) 3.2 ×108 Hz × =
320 MHz
106 Hz
−7 109 ng
(b) 4.56 ×10 g × =
456 ng
1g
