1510, LAB 1, Saunders, Cade, FALL, 2023

This area is for TA only. Lab 1, How To Make And Repo Cell Colors Point of row Student Point All calculations must be NAME: Cade S Part 1. Density of Meta Table 1. Density of metal by dimension measurement using ruler. Heigth (mm) Diameter (mm) Mass (g) 4 4 10.2 12.1 3.484 4 4 15.4 12.0 5.220 4 4 20.5 11.8 6.721 4 4 25.3 12.4 8.743 4 4 10.0 12.4 3.560 4 4 15.3 12.2 5.278 4 4 20.3 12.4 6.817 4 4 25.0 12.2 8.753 2 2 2 2 2 2 4 4 95% CI (single) 4 4 95% CI (single) 1 1 4 4 99.5% CI (single) 4 4 99.5% CI (Mean) Part 2. Density of Liquids and Liqu Table 4. Volume and mass of water. INPUT RAW DATA/ANSWERS TO QUESTIONS INPUT CALCULATED VALUES, NO ROUNDING NECESSARY INPUT CALCULATED VALUES, CORRECTLY ROUNDED OFF PLACE GRAPH IN THIS AREA By checking the box with an X on the left si report. Failure to sign this declaration will c

Volume (mL) Mass (g) Density (g/mL) 0.00 0.0000 Not Applicable 0.5 0.5 1.00 1.0370 1.037 0.5 0.5 2.00 2.0880 1.044 0.5 0.5 3.00 3.1290 1.043 0.5 0.5 4.00 4.1680 1.042 0.5 0.5 5.00 5.2060 1.0412 0.5 0.5 6.00 6.2430 1.0405 0.5 0.5 7.00 7.2790 1.039857143 0.5 0.5 8.00 8.3140 1.03925 0.5 0.5 9.00 9.3560 1.039555556 0.5 0.5 10.00 10.3950 1.0395 2 2 Average of Density 1.041 2 2 STD Dev 0.002 2 2 Value of t for 95% CI 2.262 4 4 Density 1.041 Save your work before proceeding 5 5 (graph pts) Table 5. Linest output without setting y intercept (b) to 0. 3 3 m 1.039127273 0.005727273 b 0.000489035 0.00289317 0.999998007 0.005129042 2 2 Value of t for 95% CI 2.262 4 4 m 1.039 0.001 4 4 b 0.006 0.007 Part 3. Impleme ± ts m s m s b R 2 ± ts m ± ts b When you use the cell in red color you will need to tell the Excel spreadsh front of the row and another dollar sign in front of the column. For exam you add "$" so it is $C$22.

ort Scientific Measurements: Density performed only by excel's formula Saunders Email: al by Dimension Measurement Radius (cm) Height (cm) 0.605 1.020 1.173051561 2.970031 0.600 1.540 1.7419248 2.996685 0.590 2.050 2.24214691 2.997573 0.620 2.530 3.055695544 2.861214 0.620 1.000 1.2077848 2.947545 0.610 1.530 1.788781446 2.950612 0.620 2.030 2.451803144 2.780403 0.610 2.500 2.9228455 2.994684 Average of Density 2.94 STD Dev 0.08 Value of t for 95% CI 2.365 2.9 ± ts 0.2 2.94 0.06 Value of t for 99.5% CI 4.029 2.9 ± ts 0.3 2.9 0.1 uid Solutions using a 1.00 mL Autopipette Save this file as 1510, Lab #, Last name, first name.xlsx, then go to blackboard and submit: Data Analysis --> Lab #: xxxx --> Browse for Local File --> Submit --> Ok Rounding Rule: Round STD to 1 significant figure and round the mean to the same number of decimal places. It may be necessary to use the scientific notation if STD>1. How to: Highlight cell -> Right click -> Format Cell -> Number -> Scientific -> Change decimal places. cs587222@ohio.edu ide, I certify that I have not falsified data and that I have not plagiarized any part of this lab cost you 10% points. Volume (cm 3 ) Density (g/cm 3 ) ± ts m ± ts m

0.001 enting Given Formulas Make a plot of mass versus volume without setting intercept b = 0 below. Think about which one is the dependent and independent variable. Right click on the white box, then select data. Once you have the data be sure to label the x and y axis (include units), trendline, linear equation, R2. heet to keep using the same value in all the rows. You can do this by adding a dollar sign in mple: If you want excel to calculate values using the number in cell C22, after clicking on C22, 0.00 2.00 4.00 6.00 8.00 10.00 12.00 0.0000 2.0000 4.0000 6.0000 8.0000 10.0000 12.0000 Chart Title