- Mass Of 4 Drops Of Orange Dye Solution Stock Orange Solution Density H O Volume Of Initial Solution Concentration Initia 1 (67.15 KiB) Viewed 50 times
- Mass Of 4 Drops Of Orange Dye Solution Stock Orange Solution Density H O Volume Of Initial Solution Concentration Initia 2 (65.08 KiB) Viewed 50 times
- Mass Of 4 Drops Of Orange Dye Solution Stock Orange Solution Density H O Volume Of Initial Solution Concentration Initia 3 (65.08 KiB) Viewed 50 times
CH FLE HOME 10 11 13 BIV-D 2-A M/10/2016 21 3M of suf Orange dye sation orang un Deity Vel of who Contrato 11 14 Solution 1525 124 230 100 17 nilang 3 Orange 2nd R Sen Chery Proj Orange O ww Slope Exponat 00-00 RISTA 607M P 82500 4MM 2+² 0.011 Drangedy (M) Abortance Calc(M) 4.34 LIL- 300-0 LAD 4.323 COM 0.000 6.782 www Good 12 20-00 30% on 24070 AOCAAT 45 aoungangy 322 LA LA 2.4 Calibration curve for Orange Dye at 483 m 33 0:01.00 IMG IMO Dye Concentra y-28946x 0.0112 GE WEN ADEUS sate AIEM HOOL Figure B-1. Completed standard curve spreadsheet and graph after step 18. Boxed cells contain calculations or a reference to another cell. In cells A5 to A9, D5 to D11, A14 to A18, and B14 to D14, type the labels as displayed in Figure B-1. Adjust the column width as necessary. Labels in column A can run into column B. In cell A7 you will need to format the subscript 2 in H₂O. 4. In cells C5 to C8 enter the numerical data shown. Format so trailing significant zeros are displayed. 5. In your lab notebook or on a sheet of scratch paper (ask your instructor which), write an equation using the information in cells C5, C6, C7, and C8 to determine the concentration of the orange dilution. Be careful of units and conversion factors so the final unit is molarity. 6. Using the equation from the previous step, input a formula into cell C9 which will calculate the molarity of the initial solution. Be sure to use cell addresses containing the data (e.g. C5, C6, C7, and C8) in the equation. You will need to format the number so that it will display in scientific notation. If you do not get the value shown in Fig B-1, check your calculation. 7. Create the data block needed to construct the graph. This will consist of concentration - absorbance data pairs. Since you used the first solution as one of your samples, in cell BIS place a reference to the just calculated initial solution concentration: =C9. 8. For the 2nd solution, you diluted the 1". Calculate the concentration of the 2nd solution in cell B16 using the cell address of the 1" solution concentration and the appropriate numerical volumes. (Hint: do this calculation on scratch paper first so you know how to input the formula) ea