Use Excel and the information in the table above create a scatter plot of

Use excel and the information in the table above

This preview shows page 6 - 7 out of 7 pages.

Use Excel and the information in the table above create a scatter plot of absorbance ( y -axis) vs. concentration ( x -axis). From your graph determine the equation of the best fit line and the R 2 value. This information should be displayed on your graph. To complete this task use the feature Format trendline . PART B Brand of Aspirin tablet ____________ Mass of acetylsalicylic acid per tablet (from label on bottle) ____________ Absorbance (ave.) of solution ____________ Concentration of acetylsalicylic acid solution in 50.00 mL sample ____________ Concentration of acetylsalicylic acid in the 2.00-mL aliquot ____________ Concentration of acetylsalicylic acid in the 250-mL flask ____________ Moles of acetylsalicylic acid in the tablet ____________ Mass of acetylsalicylic acid in the tablet ____________
Image of page 6