Using Excel create a line graph Figure 1 Use scatter plot pl

Using Excel, create a line graph [Figure 1] (Use scatter plot (please see appendix 2 in your Knisely book), use \"add trendline\" after you have made the graph) that shows the relationship of total volume versus total measured weight of the water sample measured in Procedure 1. In the most of the procedure you weighed and measured the volume of water. Write a paragraph in which you answer these questions. What effect, if any, does temperature have upon these measurements? Are there any markings on your glassware related to this potential problem? Calculate the mean percentage error and standard error from the final columns of Tables 1 through 6 below Using Excel, create a bar graph [Figure 2] with error bars (plusminus standard error) showing the relationship between type of measuring device and the percentage error. Write a paragraph (that means several sentences) discussing the accuracy of these measuring devices and their uses from question #4. Calculate the mean absorbance, and 95% confidence Interval, of these mean, from Table 7 and enter them in the table below

Solution

expecting that the answers are required for questions 2 and 5 the answers are like this :

question 2 :Temperature impact on water : when temperature increases the volume increases and density decreases. so the measuring glassware with gradations on it shows change in volume or increase in the content upon heating.

Question 5: measuring devices accuracy and uses

The measuring glassware in the laboratory as mentioned in the table above are like beaker, 25ml graduated cylinder, 100 ml graduated cyclinder, burette, 10ml glass pipette, P1000 0r 1000 ul or 1ml pipette are all lab accessories in measuring the liquid content in the labs. They are generally useful in the following ways

beaker : is meant to mix things or stirring, or heating liquids in a lab. The accuracy of measurement is not accurate and very much prone to errors.

25 ml graduated cylinder : is meant to measure liquids up to the 25 ml. The gradationa help to determine the volume required and the lower or upper miniscus decides the rarer or denser liquid is in the measuring. the accuracy of measurement is only until 25 ml

100 ml graduated cylinder is meant to measure liquids up to 100 ml with gradations help to measure the required quantity up to 100 ml. accuracy is until 100 ml.

burette : is meant for titrations and used to titrate a required amount of liquids very slowly so that the end point is measured accurately. the gradations helps to measure the volumes and determine the endpoint so the accuracy needs to be very high.

10 ml glass pipette : is meant to add a liquid up to 10 ml to another liquid for volumetric titrations or acid base experiments or chemical reactions and needs to b very accurate.

1 ml automatic pipette : the accuracy is very high and ease of adding 1 ml or below for exact biochemical experiments.