Report - Using Excel To Graph Data Using Excel to Graph Data To complete this experiment, you need to request a data set to work with Generate data set (5pts) Graphing Data Set Pi (n) is the ratio of the circumference of a circle to its diameter. The value of this ratio is a constant regardless of the size of the circle, thus piis a universal physical constant . The diameter and circumference of several circles were measured by several chemistry students, each using a different ruler. Data Set: Diameter (X) Circumference (9) 1.36 cm 4.07 cm 3.80 cm 4.68 in 1.55 in 12.5 cm 2.04 in 6.41 in 7.30 cm 8.58 in First, examine the data and note the variety of units. In order to work with this data, it must all be converted to the same unit. Convert the data so that all the values are reported in the SI unit of centimeters, then re-enter all the data, in centimeters, in the table below. Be sure to report the measurements with the correct number of significant figures. Report Table Ex.1: Converted Data Set Diameter and circumference measurements converted to centimeters Diameter (cm) Circumference (y,cm) Measurement 1 1.36 4.07 Measurement 2 3.80 11.89 3.94 12.5 Measurement 3 5.21 16.28 Measurement 4 7.30 21.79 Measurement 5 (1 pts) Question 1 Inspect the data and calculate the value of pl using two pairs of the data (0.5pts) Value of pi using the first pair of the data 2.99 (0.5pts) Value of pl using the second pair of the data 3.13 Saved (6pts) Question 2 Prepare a hand-drawn plot of the two variables using the grid sheet in the lab manual or other graph paper, a. Include a title, axis labels (with units), and a trendline. (1pts) b. Estimate the circumference, in centimeters of a circle with a diameter of 3.47 cm Circumference (cm) 10.90 Saved (1 pts) c. Estimate the diameter, in centimeters, of a circle with a circumference of 5.69 in Diameter (cm) 4.60 Saved (4pts) d. Attach a picture of the fully labelled, hand-drawn plot here You've reached the maximum allowed files imagetopdf.pdf (3pts) Question 6 a Using your computer-generated graph (1pts) a Visually estimate the circumference in centimeters of a circle when the diameter is 3.47 cm Circumference (cm) (1pts) b. Calculate the circumference, in centimeters, for d = 3.47 cm using the equation of the best-fit line. Use the graph to ensure that this value is reasonable. Circumference (cm) (Ipts) c. Compare the calculated circumference to the two visually interpolated values (Steps 2b and 6). Briefly discuss any discrepancies Normal BILIU X1 EEE