Embedded Files
MEASUREMENT TECHNIQUES AND DENSITY
MEASUREMENT TECHNIQUES AND DENSITY
Using Excel Spreadsheets in the Laboratory
Using Excel Spreadsheets in the Laboratory
Learning Objectives
Learning Objectives
The objective of this experiment is to . . . .
(CLO) Analyze evidence to decide if generalizations or conclusions based on the obtained data are warranted
(CLO4). Interpret and utilize mathematical formulas while solving problems
(CHM 111 MLO1) Apply units of mass, temperature, time, length, and derived units, such as volume and density using dimensional analysis to solve problems with single or multiple steps or conversions.
Calculate the relationship between mass and radius, volume, surface area and density of a metal sphere given the mass and diameter of the sphere.
Create graphs between two variables and determine the lines of best fit and correlation coefficient for the graph
Calculate the statistical values for a set of data
Explain how a spreadsheet can be used to perform calculations and graphing
Experiment 21 purpose is to develop skills using Excel and Google spreadsheets to perform calculations and create a proper xy scatter plot with a best fit trendline.
Complete the following assignments
Submit your Excel or Google sheet containing the data, results, calculations created in the spreadsheet and graphs.
a title page for the laboratory notebook
a laboratory report is discussed on the last page of the Exp 21 document. The report should present the data, results, calculations and graphs with proper formatting and caption.
Discussion
Discussion
Often scientists use graphs to display their quantitative observations. This helps them to see patterns and relationships that exist in the data. Graphing involves the display of two sets of data that are related to each other such as the distance moved in a car and the time it took to move that distance. The relationship can often be determined using a graphing model. . If the time is placed on the horizontal x-axis and the distance moved on the vertical y-axis, the values can be linked by a straight line. As the time increases, the distance moved also increases. Since these two increase by the same value (as time doubles, the distance doubles), we say these are directly proportional and the straight line represents this proportionality. The equation of the line, y = mx + b, and specifically the slope of the line, m, represents this proportionality.
Procedure and Report
Procedure and Report
Using the data (mass and diameter) of a ball bearing given in the assignment, calculate the radius, surface area, volume and density. Briefly, determine the average and other statistical analysis of density. Create graphs of mass (y axis) against radius, surface area and volume on the x-axis. From the graph of mass and volume, determine the volume of the three additional mass given and determine the radius, surface area and density of the three additional masses. Use Excel or Google sheets to calculate the values above. In the report, show how each of the values was calculated using the appropriate mathematical equation.
For a more detailed list of tasks, calculations and requirement see the list in the Experiment 21 document above.
There are 7 known mass and diameter ball bearing. Six known values are given and one must be measured either using the actual ball as shown in the image below or the images of the measurements.
There are 6 ball bearing that either do not have the mass or do not have the diameter given. Two ball bearing's diameter are measured in the images below. The unknown's mass or diameter will be determined from the calibration curve of the ball bearings with known mass and volume.
7th known ball bearing's mass
7th known ball bearing's diameter
Unknown small ball bearing's Diameter with unknown mass
Unknown medium ball bearing's diameter with unknown mass
Entering an Equation into Excel
Entering an Equation into Excel
Explains how to input an equation into Excel 2010 using an engineering example. Made by faculty at the University of Colorado Boulder Department of Chemical and Biological Engineering
Making Scatter Plots/Trendlines in Excel
Making Scatter Plots/Trendlines in Excel
The title says it all! Check out my Channel at www.burkeyacademy.com for more videos on Statistics and Economics.
How to Find the Equation and Slope of a Trendline Using Google Sheets
How to Find the Equation and Slope of a Trendline Using Google Sheets
The Complete Guide to Everything
In this video I will show you how to plot an XY scatter graph in Google sheets and then how to add a trendline (linear) and finally how to display the equation of the line and the R^2 value on the chart. From this you can find the intercept and the gradient (slope) of your line.
Excel 2013 - Manually adding multiple data sets to scatter plot
Excel 2013 - Manually adding multiple data sets to scatter plot
This will show you how to manually add multiple data sets to a scatter plot. The model uses position-time data and adds some linear trendlines. This is especially relevant for those taking my Physics course.
Plotting Two Data Sets in One Graph with Google Sheets
Plotting Two Data Sets in One Graph with Google Sheets
Final Report
Final Report
Complete the data and result tables, graphs, and calculations.
Exp 21 report and spreadsheet submission.mp4this video is a lecture on what I would expect you to put into the Experiment 21 report but can also be used as a general understanding of each laboratory report.
Page updated
Report abuse