Embedded Files
You will be performing statistical analyses, graphical analyses, and displaying your final data in graph form for every module you complete this semester. That will require the extensive use of a spreadsheet program. The Chemistry Department recommends that you use Excel. You can download Excel for free as part of the Microsoft Office package with your maine.edu account using the following link:
You will be performing statistical analyses, graphical analyses, and displaying your final data in graph form for every module you complete this semester. That will require the extensive use of a spreadsheet program. The Chemistry Department recommends that you use Excel. You can download Excel for free as part of the Microsoft Office package with your maine.edu account using the following link:
Excel Tutorial
Excel Tutorial
This Excel Tutorial will walk you through the basics of how to use Excel. If you have little to no experience with Excel, it is HIGHLY recommended that you work through the entire tutorial, as we will be using these skills throughout the semester. You will need to download this file to your computer.
This Excel Tutorial will walk you through the basics of how to use Excel. If you have little to no experience with Excel, it is HIGHLY recommended that you work through the entire tutorial, as we will be using these skills throughout the semester. You will need to download this file to your computer.
Excel Tutorial - Rev S23.xlsxGraded Excel Activity
Graded Excel Activity
This activity will be submitted for a grade. Your instructor will notify you of their preference as to how the assignment is to be submitted.
This activity will be submitted for a grade. Your instructor will notify you of their preference as to how the assignment is to be submitted.
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.
Task 1 - Data Table and Calculations
Task 1 - Data Table and Calculations
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
12.24
12.06
12.16
11.98
12.39
12.20
12.01
Task 2 - Bar Graph and Scatter Plot
Task 2 - Bar Graph and Scatter Plot
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:
Page updated
Report abuse