### Create an Account

Home / Questions / Name Partner's Name Table 2. Calculated Data - Mean, standar Fill in the table with the va...

# Name Partner's Name Table 2. Calculated Data - Mean, standar Fill in the table with the values calculated using Excel. - Mean, standard deviation, and percent errors for volumes C D exel Beaker Volume

Name Partner's Name Table 2. Calculated Data - Mean, standar Fill in the table with the values calculated using Excel. - Mean, standard deviation, and percent errors for volumes C D exel Beaker Volumetric Buret Pipet flack Calculated Value Actual volume Mean Standard Deviation Percent Error Graduated cylinder am 24.334 13.057 m 0.174 m 22.009. 24.334 24.0m 24.858 1 24.780L 23.7842 0.079 my 0.406m 3.953 mf Show correct significant figures and units for all data that require units for full credit. Attach your Excel spreadsheet used to find volume means and standard deviations. A sample spreadsheet with fictitious data is shown in Figure 1 of the Data Analysis section. Show below sample calculations using beaker data. Calculate the actual volume" for your first trial using beaker data in Table 1, and then calculate the "percent error" for the volume using the mean of all eight measurements for beaker data in Table 2. 1. Calculation of actual volume of your first 25 mL sample using the beaker. 2. Calculation of percent error in measuring 25 mL using a 100 ml or 150 mL beaker. Rev 8-23-17
Group Beaker 17.384 17.355 22.688 22.000 23.343 23.356 25.577 24.370 Graduated cylinder 24.217 24.222 24.496 24.558 24.448 24.421 24.261 24.047 vol. Flask 24.728 24.809 24.854 24.782 24.933 24.947 24.889 24.920 Buret 24.700 24.617 25.681 24.873 24.471 24.482 24.478 24.940 Pipet 24.126 14.248 27.194 24.920 24.872 24.845 25.097 24.966 Mean Std Dev 22.009 3.057 24.334 0.174 24.858 0.079 24.780 0.406 23.784 3.953
Table 1. Group Data - Actual or Measured Volumes of 25 mL samples of water Trial Graduate Trial #2 Your data Trial #1 Group A Trial #2 Beaker Vol. Flask Buret Pipet Trial #1 Your data 17.384 24.217 24.728 m2 24.700mL 24. 126m| 17.559 m2 24.222mL 24.809 mL 24.017mL 24.248 ml 22.680 / 24.496mL 24.854 25.681 m 27.194m! Group A 122.000m 24.558m 24.782mL/ 24.873m1124.92004 23.343 m2 24.4484 34.933m2 24.471 ml | 24.872mL Group B 23-3564 24.42/m2 24.947m2 24.4820424.845 m4 Trial #1 | 25.577mL 24.261 m2 24.889 m2 24.478mL 25.097ml Group C Trail #2 Group C 24.370mL 24.047 1 24.920mL 24.94ool 24.966ml Show correct significant figures and units for all data to receive full credit. Trail #1 Group B Trial #2

Jun 17 2021 View more View Less