Open a new Excel spreadsheet and use it to complete the following two tasks. Your instructor will notify you of their preference regarding how you submit the assignment.
Use the data shown here to complete the following tasks in Excel:
Create a table with this data.
Using the formula feature in Excel, have Excel calculate the following:
Average
Standard Deviation (STDEV.S in Excel)
Percent Relative Standard Deviation (%RSD)
Divide each data value by ten.
Divide each data value by the average, and then multiply the result by 100.
Use the "Increase Decimal" or "Decrease Decimal" buttons on Excel to adjust for the proper number of significant figures.
Data
2.53
3.61
2.89
2.56
2.13
3.45
Use the data shown here to complete the following tasks in Excel:
Create a table with this data.
Create a BAR GRAPH (known as Column Chart in Excel) of nitrate concentration at each sample spot.
Create a SCATTER PLOT of absorbance (y-axis) as a function of nitrate concentration (x-axis). Include a linear trendline with equation and R squared value.
As you are creating your graphs, remember: