Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. A smelter produces five different lead ingots of the following volumes and weights. Enter these data into a blank Excel spreadsheet. Each data

image text in transcribedimage text in transcribed

1. A smelter produces five different lead ingots of the following volumes and weights. Enter these data into a blank Excel spreadsheet. Each data piece should be in a separate cell, just like the table below. Give each of your columns a title (again, like the table). Mass, Ounces Volume, Cubic Inches 5.471 0.8689 11.598 1.622 18.114 2.768 3.580 4.102 24.137 26.843 2. Convert the masses in ounces into masses in grams in a separate column with its own title. Assume there are 0.03527 ounces in a gram (0.03527 oz/g). NOTE: try working this calculation out on paper first to determine how to cancel the units correctly and therefore whether to multiply or divide. 3. Convert each number in cubic inches (in) into milliliters (mL) in a separate column (again, with a title). Assume there are 16.39 milliliters in a cubic inch (16.39 mL/in). 4. Highlight all the cells you have numbers in and their labels (column headings) and paste into a Word document. 5. If you divide the ingot masses you calculated in grams by their volumes in mL, you'll have each ingot's density in grams per milliliter (g/mL). Do this for all the data rows and label the new column. 6. Use Excel's AVERAGE function to average the densities you calculated in g/mL. Do this in a cell below the cells where you calculated the individual densities. 7. Use Excel's standard deviation function, STDEV.S, to calculate the standard deviation of the densities you just averaged. You can put this number right below your average.

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

Modeling the Dynamics of Life Calculus and Probability for Life Scientists

Authors: Frederick R. Adler

3rd edition

840064187, 978-1285225975, 128522597X, 978-0840064189

More Books

Students also viewed these Mathematics questions