Question: Copy and paste the water & oil data ( Activity 3 . 3 ) into Excel ( use the excel template provided ) Water data

Copy and paste the water & oil data (Activity 3.3)into Excel (use the excel template provided)
Water data
Water Volume (ml) Mass (g)
10.7
32.9
73.0
1010.0
25120.5
100191.5
150240.7
170260.8
220303.1
Oil data
Oil Volume (ml) Oil Mass (g)
11.0
54.9
109.2
2522.4
10086.8
150132.88
1) Create two scatter plots right inside the Excel sheet that contains your data
2) Add the best-fit line (or trendline) and displace the equation on each chart
3) The equation in the y=mx+b format gives you the density, which equals to m.
Click the chart, then copy & paste it in the space below (1 pt)
Water:
Oil:
Graph grading rubric
Informative title (0.5 pt)
Proper axis label (2 pts)
o Each axis should be labeled with the variable name and unit if the variable measurement has unit
o Independent variable plotted on the x-axis; dependent variable plotted on the y-axis
Presence of the best-fit line & equation (0.5 pt)
Use the equations to determine the density (record your answers to two decimal places; include unit)(0.6 pt)
Water density =
Oil density =
Use the specific density data from above to answer the question: Why does the oil float on the surface of the water? (0.4 pt)Water data
Oil data
Create two scatter plots right inside the Excel sheet that contains your data
Add the best-fit line (or trendline) and displace the equation on each chart
The equation in the y=mx+b format gives you the density, which equals to m.
ick the chart, then copy & paste it in the space below (1 pt)
Water:
 Copy and paste the water & oil data (Activity 3.3)into Excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!