Question: Using Excel, make a spreadsheet that organizes your observations and calculations on the decolorization of phenolphthalein. Pls show the graphs too 4. Using Excel, make

Using Excel, make a spreadsheet that organizes your observations and calculations on the decolorization of phenolphthalein. Pls show the graphs too

Using Excel, make a spreadsheet that organizes your observations and calculations onthe decolorization of phenolphthalein. Pls show the graphs too 4. Using Excel,

4. Using Excel, make a spreadsheet that organizes your observations and calculations on the decolorization of phenolphthalein. The columns of your spreadsheet should be: (column 1) Time (s) (column 2) Fast reaction absorbance (column 3) Fast reaction concentration of phenolphthalein (column 4) Time (s) (column 5) Slow reaction absorbance (column 6) Slow reaction concentration of phenolphthalein In order to convert your average absorbance values to [P2-), you will need to use Beer's law. Use 2.1x103 L/mol.cm for the molar absorptivity of phenolphthalein, , at 550 nm and use 1.00 cm for the cuvet pathlength, b: An = b[P2.] so [P2-]= Aa/be Time (s) Fast abs Fast Concentration (P2-] Time (s) 1.4 0.79624971 22 0.7753106 42 0.75462898 62 0.73480606 82 0.71547707 102 0.69623669 122 0.67817211 142 0.66042542 162 0.64326247 182 0.6265076 202 0.6099395 222 0.59410214 242 0.57904363 262 0.56406736 282 0.549891 302 0.53592682 322 0.52228212 342 0.50957243 362 0.4962337 382 0.48375328 402 0.47199686 422 0.46032429 442 0.44929067 462 0.43823918 482 0.42805274 502 0.41725755 522 0.40757736 542 0.39778352 562 0.38871209 582 0.37972371 Slow Abs Slow concentration[P2-] 1.4 0.79588055 62 0.76647779 122 0.73859535 182 0.71184966 242 0.68632495 302 0.66140446 362 0.6379848 422 0.61550349 482 0.59411439 542 0.57383001 602 0.55455848 662 0.53609514 722 0.51883329 782 0.50143325 842 0.48570946 902 0.47034069 962 0.45594717 1022 0.44183453 1082 0.42868217 1142 0.41615006

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Chemical Engineering Questions!