Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Density Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type

image text in transcribedimage text in transcribed Density Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers. lb kg 2.2 This spreadsheet lists the densities of various materials in kilograms per cubic meter. Material Helium Aerographite cubic in. cubic m 1,000,000 16.387 Density (kg/m^3) a.) lb/in.^3 b.) c.) Gold Scale Water Scale 0.179 6.453 x 10^-6 0.2 7.21x10^-6 Metallic microlattice Aerogel Air Tungsten hexafluoride Liquid hydrogen Styrofoam 0.9 3.244x10^-5 1 3.605x10^-5 1.2 4.336x10^-5 12.4 4.4702x10^-4 70 2.5235x10^-3 75 2.70375x10^-3 240 0.652x10^-3 a.) Convert the densities to pounds per cubic inch. Format the densities using scientific notation. b.) Create a new scale by setting the density of gold to 100 and adjust all other densities proportionally. Format to 3 decimal places. c.) Create a new scale by setting the density of fresh water to 1 and adjust all other densities proportionally. Format to 5 decimal places. 0.031 d.) Create a well-labeled column chart showing the densities of all the materials. Use Density (kg/m^3) for the title. Cork Lithium 535 0.019286 Wood 700 0.025235 Potassium Sodium 860 970 0.034968 Ice 916.7 0.03304 Water (fresh) 1,000 1000.0005 Water (salt) 1,030 1030.0005 Plastics Tetrachloroethene Magnesium 1,175 1175.0005 1,622 1622.0005 1,740 1740.0005 Beryllium Glycerol e.) If you want to make a column chart of the densities to show the relative size of the different densities, does it matter which scale you use? Silicon Aluminium Diiodomethane Diamond Titanium 1,850 1850.0005 1,261 1261.0005 2,330 2330.0005 2,700 2700.0005 3,325 3325.0005 3,500 3500.0005 4,540 4540.0005 e.) Does scale matter? d. Selenium 4,800 4800.0005 Vanadium 6,100 6100.0005 Antimony 6,690 6690.0005 Zinc 7,000 7000.0005 Chromium 7,200 7200.0005 Tin 7,310 7310.0005 Manganese 7,325 7325.0005 Iron 7,870 7870.0005 Niobium 8,570 8570.0005 Cadmium 8,650 8650.0005| Cobalt Nickel 8,900 8900.0005 8,900 8900.0005 8,940 8940.0005 Copper Bismuth 9,750 9750.0005 Molybdenum 10,220 10220 Silver 10,500 10500 Lead 11,340 11340 Thorium 11,700 11700 Rhodium 12,410 12410 Mercury 13,546 13546 Tantalum 16,600 16600 Uranium 18,800 18800 Tungsten 19,300 19300 Gold 19,320 19320 Plutonium 19,840 19840 Platinum 21,450 21450 Iridium 22,420 22420 Osmium 22,570 22570

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

Step: 3

blur-text-image

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

Cost Management Measuring Monitoring And Motivating Performance

Authors: Leslie G. Eldenburg, Susan Wolcott, Liang Hsuan Chen, Gail Cook

2nd Canadian Edition

1118168879, 9781118168875

More Books

Students also viewed these Accounting questions

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago