CH 104N - Excel Exam

0.0(0)
Studied by 1 person
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/74

encourage image

There's no tags or description

Looks like no tags are added yet.

75 Terms

1
New cards

What is Beer's law?

A = εbc

2
New cards

In Beer's law, what does A represent?

Absorbance (unitless)

3
New cards

In Beer's law, what does ε represent?

Molar absorptivity (M⁻¹ cm⁻¹)

4
New cards

In Beer's law, what does b represent?

Path length (cm)

5
New cards

In Beer's law, what does c represent?

Concentration (M)

6
New cards

What can Beer's law be manipulated to solve for?

Any missing variable

7
New cards

What does the slope of a calibration curve represent?

Molar absorptivity multiplied by path length (εb)

8
New cards

What does the y-intercept of a calibration curve represent?

Error

9
New cards

What does an R² value closer to 1 indicate?

Stronger correlation

10
New cards

What is the general form of a chemical reaction?

aA + bB ⇌ cC + dD

11
New cards

What is the equilibrium constant expression for aA + bB ⇌ cC + dD?

K = [C]^c[D]^d / ([A]^a[B]^b)

12
New cards

In an equilibrium expression, what do lowercase letters represent?

Stoichiometric coefficients

13
New cards

In an equilibrium expression, what do uppercase letters represent?

Reactants or products

14
New cards

What should be excluded from an equilibrium constant expression?

Solids

15
New cards

What does K > 1 indicate?

Products are favored at equilibrium

16
New cards

What does K < 1 indicate?

Reactants are favored at equilibrium

17
New cards

What does K = 1 indicate?

Products and reactants are equally favored

18
New cards

What should you know how to calculate using Ksp?

Ksp as a function of concentration

19
New cards

What is ΔH?

Change in enthalpy

20
New cards

What does a negative ΔH indicate?

Exothermic reaction

21
New cards

What does a positive ΔH indicate?

Endothermic reaction

22
New cards

What is ΔS labeled as in the notes?

Change in entropy

23
New cards

What does a negative ΔS indicate?

Decreasing entropy

24
New cards

What does a positive ΔS indicate?

Increasing entropy

25
New cards

What is ΔG?

Change in Gibbs free energy

26
New cards

What does ΔG > 0 indicate?

Nonspontaneous; reactants favored

27
New cards

What does ΔG < 0 indicate?

Spontaneous; products favored

28
New cards

What does ΔG = 0 indicate?

Equilibrium

29
New cards

What equation relates ln(K) to ΔH and ΔS?

ln(K) = −(ΔH/R)(1/T) + ΔS/R

30
New cards

What is the general slope-intercept equation?

y = mx + b

31
New cards

How do you calculate ΔH from the slope of the ln(K) vs. 1/T graph?

Multiply the slope by −R

32
New cards

How do you calculate ΔS from the y-intercept of the ln(K) vs. 1/T graph?

Multiply the y-intercept by R

33
New cards

What does the y-axis represent on a titration curve?

pH

34
New cards

What does the x-axis represent on a titration curve?

Volume of NaOH added

35
New cards

What is the formula for change in pH?

ΔpH = pH₂ − pH₁

36
New cards

What is the formula for change in volume?

ΔV = V₂ − V₁

37
New cards

What does the y-axis represent on the first-derivative graph?

ΔpH / ΔV

38
New cards

What does the x-axis represent on the first-derivative graph?

Average volume of NaOH added

39
New cards

What is the formula for the second change in pH?

Δ²pH = ΔpH₂ − ΔpH₁

40
New cards

What is the formula for the second change in volume?

Δ²V = ΔV₂ − ΔV₁

41
New cards

What does the y-axis represent on the second-derivative graph?

Δ²pH / Δ²V

42
New cards

What does the x-axis represent on the second-derivative graph?

Average of the average NaOH volumes

43
New cards

How do you calculate molarity?

M = moles / liters

44
New cards

What is the formula for moles when molarity and volume are known?

Moles = molarity × volume in liters

45
New cards

How do you calculate molecular weight from mass and moles?

Molecular weight = mass (g) / moles (mol)

46
New cards

What is the molecular weight unit?

g/mol

47
New cards

How many moles of NaOH are in 0.010 L of 0.1 M NaOH?

0.001 mol NaOH

48
New cards

What is the mole ratio of NaOH to amino acid in the example?

1 mol amino acid per 1 mol NaOH

49
New cards

In the example, how many moles of amino acid react with 0.001 mol NaOH?

0.001 mol amino acid

50
New cards

What is the molecular weight of 0.117 g amino acid containing 0.001 mol?

117 g/mol

51
New cards

What is the equivalence point in an amino acid titration?

The volume of NaOH needed to react with all amino groups

52
New cards

What is the mole relationship at the equivalence point in the example?

Moles of acid = moles of base

53
New cards

What is the midpoint of a titration?

The point where half the relevant amino groups have reacted

54
New cards

What is the relationship between pH and pKa at the midpoint?

pH = pKa

55
New cards

Where is the equivalence point on the titration curve?

Near the middle of the steepest part of the graph

56
New cards

Where is the equivalence point on the first-derivative graph?

At the maximum

57
New cards

Where is the equivalence point on the second-derivative graph?

At the x-intercept

58
New cards

What does the AVERAGE() function calculate?

The average of a set of values

59
New cards

What Excel function calculates the average?

=AVERAGE()

60
New cards

What Excel function calculates standard deviation according to the notes?

=STDEV()

61
New cards

What does the COUNT() function calculate?

The number of cells containing numbers

62
New cards

What Excel function counts numeric entries?

=COUNT()

63
New cards

What do you use to calculate the slope from known y- and x-values?

=SLOPE(known_ys, known_xs)

64
New cards

What do you use to calculate the y-intercept from known y- and x-values?

=INTERCEPT(known_ys, known_xs)

65
New cards

What do you use to calculate R² from known y- and x-values?

=RSQ(known_ys, known_xs)

66
New cards

How do you calculate the average of a range of cells?

=AVERAGE(range)

67
New cards

How do you calculate the slope of a calibration curve in Excel?

=SLOPE(known_ys, known_xs)

68
New cards

How do you calculate the y-intercept of a calibration curve in Excel?

=INTERCEPT(known_ys, known_xs)

69
New cards

How do you calculate R² in Excel?

=RSQ(known_ys, known_xs)

70
New cards

How do you count numeric values in a range in Excel?

=COUNT(range)

71
New cards

How do you create an absolute cell reference?

Use a dollar sign before the column letter and row number, e.g. =$A$1

72
New cards

What does an absolute cell reference do when a formula is copied?

Keeps the referenced row and column fixed

73
New cards

What Excel function calculates the natural logarithm?

=LN(number)

74
New cards

How do you calculate the first derivative from two pH and volume measurements?

=(pH₂-pH₁)/(V₂-V₁)

75
New cards

How do you calculate the second derivative from first-derivative values?

=(First derivative₂-First derivative₁