Determine experimental values for pi by plotting diameter and circumference data sets.

Five data sets will be provided. The diameters of various cylinders were measured using a Vernier caliper. The corresponding circumference of each cylinder was measured using the method described in the next paragraph.

A thin strip of paper was carefully wrapped around the cylinder, and the strip of paper was marked with a pencil at the point where the strip overlapped. The thin strip was unwound, laid flat, and the distance from the edge of the strip to the pencil mark was carefully measured to determine the circumference.

For the data that is provided, both the diameters and circumferences were measured in millimeters.

Using a ruler to measure the diameter and the paper strip method described above to measure the circumference, collect data using two different objects with dissimilar diameters. To measure the diameter as accurately as possible, the object selected should have crisp edges. An example of a good object to measure would be a roll of masking tape. Also note that an object with a larger diameter will result in a more accurate measurement for the diameter and circumference.

Using the five $($diameter$,$ circumference$)$ data pairs provided and the two data sets obtained by measuring two different objects, use Excel to create two different scatter plots and determine an experimental value for pi to three $(3)$ decimal places from the fit equation of each scatter plot. If the fit equation is not displaying at least three decimal places, the decimal places of the fit equation may need to be adjusted accordingly. The data pair $(0,0)$ should also be used in addition to the seven data pairs described above. In addition to appropriate axis labels and titles, the fit and fit equation should be displayed on the plot.

Plot #$1$ should be a plot of Diameter vs Circumference. $[$Diameter on the $y-$axis$]$

Plot #$2$ should be a plot of Circumference vs Diameter.

In addition to the scatter plots, include a data table with the diameter$/$circumference pairs that were used to create the scatter plots. The cells in the data table that correspond to the objects that were measured by the student should be highlighted in orange.

Finally, type the experimental value of pi determined from each plot to three decimal places in

Finally, type the experimental value of pi determined from each plot to three decimal places in a cell. Highlight the experimental value of pi determined from plot #$1$ with a border and yellow background. Highlight the experimental value of pi determined from plot #$2$ with a border and green background.

If the plot, table, and highlighted experimental values for pi are all constricted to fit within Rows $1-44$ and Columns A$-$I, everything should fit on one page.

Save the Excel Spreadsheet.

Upload to the Excel Spreadsheet to the 'Determine pi $-$ Upload' Assignment that is worth $90$ points.

Do not email the file directly to the TA$.$