"Affordable" Diamond Pricing Imagine you have set out to purchase a diamond, and you want all the
information you can possibly get before the purchase. You run an Internet
search on diamonds to learn more about the different cuts, carat ranges, color
values, and so on. After having researched a bit, you've decided on the basic
cut, quality, color, and weight range that you can probably afford.
This diamond pricing spreadsheet e gives three snapshots of a large set of
data on diamond pricing. The 0.30-0.40 Carats tab gives the 2012 data on
diamonds ranging from 0.30 to 0.40 carats.
Part A
Go to the Subset tab, which gives a subset of randomly chosen data from the
first tab. Go to your Math Tools and open the Graph tool. Plot the data of
weight (carat) versus price in this tab using the +Data button (Note that you
can copy two columns of data and use "paste table data"). Export an image of
the plot, and paste it in the space below. Find the equation of the regression
line (using a Best Fit Linear relationship) and the value of the correlation
coefficient (0)

Submarines control how much they float or sink in the ocean by changing the volume of air and water contained in large ballast tanks. when the tanks are completely full of water, the submarine increases its overall mass and sinks down to the bottom. when the tanks are completely full of air, the submarine reduces its overall mass and floats to the surface. depending on the density of the seawater surrounding the submarine, it will pump seawater in or out of the tanks in order to achieve the same overall density as the sea water and float neutrally in the water. the volume of the submarine never changes. when the tanks are completely full of water, a submarine with a volume of 7.8\times10^3\text{ m}^37.8×10 3 m 3 7, point, 8, times, 10, start superscript, 3, end superscript, space, m, start superscript, 3, end superscript has a total mass of 8\times10^6\text{ kg}8×10 6 kg8, times, 10, start superscript, 6, end superscript, space, k, g. the density of the seawater is 10^3\text{ kg/m}^310 3 kg/m 3 10, start superscript, 3, end superscript, space, k, g, slash, m, start superscript, 3, end superscript. to make that submarine float neutrally, and neither float nor sink in the ocean, what volume of water does that submarine need to subtract from its tanks?