Using Microsoft Excel Create Table of Values & Standard Curve Digitally Ques

Student Number:

a b c d e f g h i

Note: Change any “0” value in your student number to a “7”.

If b ≥ 7, x = 9 If d ≥ 7, y = 5

If b ≥ 4, x = 8 If d ≥ 4, y = 4

If b ≥ 1, x = 7 x If d ≥ 1, y = 3 y

Dilutions

  1. How much of a x.e % (w/v) stock solution is required to create 20.0 mL of a y.i % (w/v)

solution? [3 marks]

  1. What is the final concentration of a solution if x.e mL solvent is added to y.d mL of a b.c M

solution? [4 marks]

  1. How much solvent must be added to b.c mL of a 34.6 % (v/v) stock solution to create at c.d %

(v/v) solution? [4 marks]

Serial Dilutions

  1. What is the initial concentration of a solution that has a final concentration of 0.dg % (w/v) that has been serially diluted 1/b, then 1/c, then finally 1/d? (3 SD) [5 marks]
  1. You have an aliquot of cells with a concentration of f.hi x 10 cells/mL.

x

Prepare a serial dilution to create e.f mL with a concentration of c.de x 10y cells/mL.

Include your plan to accurately create this serial dilution. Include all the volumes of solute,

solvent, and total solution. [10 marks]

Standard Curve

You collect the following data from a Spectrophotometer. [2 marks]

Concentration (mg/mL)% TransmittanceAbsorbance
0.0100
0.62593.7
1.2587.6
2.576.6
5.057.8
10.033.7
20.011.2
Unknowncd.e

𝐴𝐴 = 2 − log (%𝑇𝑇)

  1. Using graph paper, create a handwritten Standard Curve. [10 marks]

Ensure it is properly labeled and professional in appearance.

Using the % Transmittance data for the Unknown to determine the concentration.

  1. Using Microsoft Excel, create a table of values and a Standard Curve digitally. [10 marks]

Using the equation from the Line of Best Fit, determine the concentration of the Unknown.

Submit a professional looking Table and Standard Curve.

  1. Calculate the Percent Error for the Unknown, using the digital data as Accepted Value. (2 SD)

[2 marks]

Order a unique copy of this paper
(550 words)

Approximate price: $22