Lab Partner: Period: 3 Date Completed: 9/23/2014 Date Submitted: 9/29/2014
Data
TABLE 4
DENSITY OF SALT SOLUTIONS-INDIVIDUAL GROUP’S RESULTS
Concentration (%)
Mass (g)
Volume (mL)
Density (g/mL)
0
9.9522
10.00
0.9952
4
10.1291
10.00
1.013
8
10.5233
10.00
1.052
12
10.7487
10.00
1.075
16
11.0297
10.00
1.103
Unknown #
10.6234
10.00
1.062
Calculations
1. Show all density calculations.
Density : Mass / Volume
9.9522 / 10.00 = 0.9952 g/ml
10.1291 / 10.00 = 1.013 g/ml
10.5233 / 10.00 = 1.052 g/ml
10.7487 / 10.00 = 1.075 g/ml
11.0297 / 10.00 = 1.103 g/ml
10.6234 / 10.00 = 1.062 g/ml
2. Be sure to include the Excel graph you have created from your data. Using the density of the unknown, determine the percentage of the unknown solution by using the trendline formula. Determine if there is a positive linear correlation.
Unknown = 10.13 % NaCl by mass
Correlation coefficient = 0.9902 therefore
TABLE 5
DENSITY OF SALT SOLUTIONS- CLASS AVERAGE
Concentration (%)
Density (g/mL)
0
0.9487
4
0.9497
8
1.017
12
1.047
16
1.078
Unknown
1.048
3. Use Excel to produce a graph showing the relationship between concentration and density of the known salt solutions using class average information in Table 5. Is there a significant linear correlation? How do you know?
There is a relationship between concentration and density of the known salt solutions because when a lineair line is drawn, it fits the points very well. The correlationcoefficient is a number that gives us information about the relationship between variables. The number variates between -1 and +1. How closer the -1 or +1, the better the relationship is between the variables. Because our correlationcoefficient is very close to +1, there can be concluded that how