Data Analysis Lab Report

The purpose of this experiment was to discover the suitable ways of organizing experimental data in the form of tables and graphs by proficiently using Microsoft Excel. After being provided with a set of experimental data, a graph is then created. The graph contains useful information such as the slope, which could give the density value. The calculation of significant figures was one of the key objectives in this lab as well. Significant figures are essential to interpreting data because they allow for increased precision and accuracy. Also, using Excel, the density calculations could be performed quickly and accurately. In this experiment, the density of water was found by collecting the masses known, which was volumes of water. To determine what the unknown density is, the mass should be divided by the volume.

The densities of water were obtained, by regulating the masses of samples of known volumes. In table 1 it includes the densities of 25.00 mL samples of water

In order to solve for density, first the mass must be known (which is in grams) and then find the volume (mL or cm3). Once the mass and volume are found, you divide the mass by the volume. The average for mass (g) is 24.89 and
SD is the unit to which different types of copies that change from the sample mean. SD informs us how the data is distributed when in regards to the mean. The less the standard deviation, the less uncertainty there is. This allows one to build more certainty relating to their experiment. A disadvantage, when it comes to including many points, is when fitting a curve, the points are not located near the averages. This can result in a lot of confusion with the linear equation. On the other hand, an advantage when it comes to including several points, when attempting to fit a portion of a non-linear curve to a line, is being able to develop a linear equation that demonstrates the data on the