Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

IBM Db2 11 1 Certification Guide Explore Techniques To Master Database Programming And Administration Tasks In IBM Db2

Authors: Mohankumar Saraswatipura ,Robert Collins

1st Edition

1788626915, 978-1788626910

More Books

Students also viewed these Databases questions

Question

write an arraylist called game dice containss 10 0 dice

Answered: 1 week ago