Report - Using Excel To Graph Data Using Excel to Graph Data To complete this experiment, you need to request a data set

[answerhappygod]

Report Using Excel To Graph Data Using Excel To Graph Data To Complete This Experiment You Need To Request A Data Set 1 (57.29 KiB) Viewed 65 times

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 (Tt) 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 pi is a universal physical constant. The diameter and circumference of several circles were measured by several chemistry students, each using a different ruler. Data Set: Circumference (y) Diameter (x) 1.36 cm 4.06 cm 3.82 cm 4.69 in 1.58 in 12.5 cm 2.05 in 6.41 in 7.27 cm 8.56 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. non

Report Table EX.1: Converted Data Set Table view List view Diameter and circumference measurements converted to centimeters Diameter (x, cm) Circumference (y, cm) 1.36 cm 4.06 cm Measurement 1 3.82 cm Measurement 2 11.9 cm 4.01 cm 12,5 cm Measurement 3 Measurement 4 5.21 cm 16.3 cm 7.27 cm 21.7 cm Measurement 5 (1 pts) Question 1 Inspect the data and calculate the value of pi using two pairs of the data: (0.5pts) Value of pi using the first pair of the data: 2.99 Saved (0.5pts) Value of pi using the second pair of the data: 3.12

(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 4.95 cm. Circumference (cm) (1 pts) c. Estimate the diameter, in centimeters, of a circle with a circumference of 5.00 in. Diameter (cm) (4pts) d. Attach a picture of the fully labelled, hand-drawn plot here. Browse your files to upload or Drag and Drop Max attachments: 1 Max Size: 20.00MB each (5pts) Question 3

(5pts) Question 3 Prepare a plot using graphing software, (5pts) a. Include a title, axis labels (with units), the equation of the best-fit line and the R2 value on the graph. b. Rewrite the equation of the best-fit line substituting 'Diameter" for x and "Circumference" for y directly on the graph. c. Attach a picture of the fully labeled computer generated graph or your Excel file containing the graph here. Browse your files to upload or Drag and Drop Max attachments: 1 Max Size: 20.00MB each (1 pts) Question 4 What is the value of pi based on the equation for the best-fit line? (1pts) Calculated value of pi:

(1 pts) Question 5 Determine the percent error using Equation EX. 1 and an actual value of 3.142 for pi. Actual – Experimental %error = 100 Equation EX.1 Actual (1pts) Percent error (%) (3pts) Question 6 Using your computer-generated graph: (1pts) a. Visually estimate the circumference, in centimeters, of a circle when the diameter is 4.95 cm. Circumference (cm) (1pts) b. Calculate the circumference, in centimeters, for d = 4.95 cm using the equation of the best-fit line. Use the graph to ensure that this value is reasonable. Circumference (cm) (1 pts) C. Compare the calculated circumference to the two visually interpolated values (Steps 2b and 6a). Briefly discuss any discrepancies. Saved Normal • BIU E = fa # FIT IT 7

(3pts) Question 7 Using your computer-generated graph: (1pts) a. Visually estimate the diameter, inches centimeters, of a circle with a circumference of 5.00 Diameter (cm) (1pts) b. Calculate the diameter, in centimeters, for c = 5.00 in using the equation of the line. Use the graph to ensure that this value is reasonable. Diameter (cm) (1pts) c. Compare the calculated diameter to the two visually interpolated values (Steps 2c and 7a). Briefly discuss any discrepancies. Saved Normal BIU = = fx e 根田 1|||山田 T