Chemistry Excel Assignment, create a scatter plot
  1. Fill in the table below by completing the following calculations (Moles NaOH, Moles HNO3, Molarity HNO3, Avg M and St. dev M) in Excel:
0.025 L HNO3

 

 Vol NaOH (mL)

(0.09876 M)

 Moles NaOH Moles HNO3 Molarity HNO3
Trial 1 23.51
Trial 2 22.95
Trial 3 22.82
Trial 4 23.23
Average M
St. dev M

 

 

 

  1. Copy the data in the table below in excel and create a scatter plot of absorbance versus concentration. Make sure the plot has the following features:
  • y axis showing absorbance, x axis showing concentration in ppm
  • plot created a separate sheet in the workbook
  • proper title
  • labeled axes
  • sensible scales on the axes
  • no gridline
  • a colorless background to the plot
  • solid green squares as data markers
  • a line of best fit (trendline) which passes through the origin
  • set y intercept to zero
  • the equation of the line and R2 value to the four decimal places
Concentration (parts per million, ppm) Absorbance
20 0.736
15 0.556
10 0.702
5 0.206
2 0.084
0 0

 

  1. Based off your R2 value, make a statement about the quality of data. In other words, how well does your data fit a linear relationship?