create an excel and follow the instructions attached. please someone has experience only chapter_3_e

  

create an excel and follow the instructions attached. please someone has experience only
chapter_3_excel.xlsx

chapter_4_excel.xlsx

Don't use plagiarized sources. Get Your Custom Essay on
create an excel and follow the instructions attached. please someone has experience only chapter_3_e
Just from $13/Page
Order Essay

Unformatted Attachment Preview

Chapter 3 Excel Assignment
Tab Name
Conversion
Density
Planets
Marathons
Possible Points Points Earned
114
24
36
48
Grade 0%
Conversions
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste v
Convert units for length, mass, volume, and speed using the given ratio tables.
In particular, use mixed and absolute cell references so that your formulas are
able to be filled across each row. Format all answers to 2 decimal places.
in
Ratio Tables
yd
cm
3
1
ft
36
lb
g
2,000
gal
1
cc
3.785
ft/s
0.447
91.44
0.9144
kg
oz
ton
907,185
907.185
32,000
l
m/s
m
in^3
3785.41
mph
1.467
ft^3
231
0.1337
kph
1
1
1.609
credit. Do not copy and paste values or type values, as you will not receive full credit for your answers.
INPUTS
inches
feet
yards
centimeters
meters
pounds
grams
kilograms
ounces
tons
inches
centimeters
meters
grams
OUTPUTS
kilograms
ounces
tons
liters
OUTPUTS
cubic cm
cubic in.
cubic ft
12
3
1
100
1
INPUTS
pounds
10,000
10,000
10,000
16,000
1
INPUTS
gallons
liters
cubic cm
cubic in.
cubic ft
gallons
1
1
231
231
1
INPUTS
m/s
ft/s
mph
kph
feet
OUTPUTS
yards
m/s
1
1
1
1
ft/s
OUTPUTS
mph
kph
d.)
d.)
d.)
d.)
s.
a.)
a.)
a.)
a.)
a.)
a.) Convert inches, feet, yards, centimeters, and meters to each of these units.
Format to 2 decimal places.
b.)
b.)
b.)
b.)
b.)
b.) Convert pounds, grams, kilograms, ounces, and tons to each of these units.
Format to 2 decimal places.
c.)
c.)
c.)
c.)
c.)
c.) Convert gallons, liters, cubic centimeters, cubic inches, and cubic feet to each
of these units. Format to 2 decimal places.
d.) Convert meters per second, feet per second, miles per hour, and kilometers
per hour to each of these units. Format to 2 decimal places.
Density
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste v
lb
kg
2.2
Material
Helium
Aerographite
Metallic microlattice
Aerogel
Air
Tungsten hexafluoride
Liquid hydrogen
Styrofoam
Cork
Lithium
Wood
Potassium
Sodium
Ice
Water (fresh)
Water (salt)
Plastics
Tetrachloroethene
Magnesium
Beryllium
Glycerol
Silicon
Aluminium
Diiodomethane
Diamond
Titanium
Selenium
Vanadium
Antimony
Zinc
Chromium
Tin
Manganese
Iron
Niobium
Cadmium
cubic in.
1
1,000,000
a.)
lb/in.^3
Density (kg/m^3)
0.179
0.2
0.9
1
1.2
12.4
70
75
240
535
700
860
970
916.7
1,000
1,030
1,175
1,622
1,740
1,850
1,261
2,330
2,700
3,325
3,500
4,540
4,800
6,100
6,690
7,000
7,200
7,310
7,325
7,870
8,570
8,650
b.)
Gold Scale
Cobalt
Nickel
Copper
Bismuth
Molybdenum
Silver
Lead
Thorium
Rhodium
Mercury
Tantalum
Uranium
Tungsten
Gold
Plutonium
Platinum
Iridium
Osmium
8,900
8,900
8,940
9,750
10,220
10,500
11,340
11,700
12,410
13,546
16,600
18,800
19,300
19,320
19,840
21,450
22,420
22,570
credit. Do not copy and paste values or type values, as you will not receive full credit for your answers.
cubic m
This spreadsheet lists the densities of various materials in kilograms per
cubic meter.
16.387
c.)
Water Scale
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.
d.) Create a well-labeled column chart showing the densities of all the materials.
Use Density (kg/m^3) for the title.
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?
e.) Does scale matter?
d.)
wers.
lograms per
he densities using
and adjust all other
o 1 and adjust all
s of all the materials.
how the relative size
Planets
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste v
km
miles
1
0.621371
a.)
Planet
Mercury
Venus
Earth
Mars
Asteroids
Jupiter
Saturn
Uranus
Neptune
Pluto
b.)
Orbital
Radius
(millions of
miles
km)
57.9
108.2
149.6
227.9
686.1
778.3
1429.4
2875.0
4504.5
5915.8
millions of miles
Part d:
Part e:
c.)
Earth Set to One
credit. Do not copy and paste values or type values, as you will not receive full credit for your answers.
Given a planetary scale of orbital radii in millions of kilometers:
c.)
c.)
a.) Convert these distances to miles.
Earth Set to One
b.) Convert these distances to millions of miles. Format to 2 decimal places.
c.) Scale each of the three rows of data (millions of kilometers, miles, and
millions of miles) with Earth set to 1. Format to 2 decimal places.
d.) If you are going to create a planetary scale with Earth set to 1, does it matt
what units (e.g. km or miles) are used for the original scale?
e.) Are the scales you just created in part c with Earth set to 1 unit
f.) Make a well-labeled bar chart comparing the orbital radii. Use the followin
for the title: Orbital Radius (millions km).
f.)
nswers.
s of kilometers:
Format to 2 decimal places.
of kilometers, miles, and
2 decimal places.
ith Earth set to 1, does it matter
ginal scale?
Earth set to 1 unit-less?
orbital radii. Use the following
Marathons
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste v
Marathon Distance:
miles
plus yards
26
Time
2:55:18
2:52:45
2:46:53
2:46:05
2:42:31
2:40:34
2:38:16
2:36:07
2:38:01
2:32:36
2:29:02
2:30:58
2:26:14
2:27:49
2:26:44
2:26:42
2:25:39
2:20:42
2:18:40
2:18:35
2:17:39
2:18:05
2:15:17
2:15:16
2:15:16
2:14:28
2:14:43
2:13:55
2:12:12
2:12:00
2:09:36
2:08:34
26.21875 miles
385
Given the selected maratho
42.195 km
Name
Nationality
Johnny Hayes
United States
Robert Fowler
United States
James Clark
United States
Albert Raines
United States
Henry Barrett
United Kingdom
Thure Johansson
Sweden
Harry Green
United Kingdom
Alexis Ahlgren
Sweden
Umberto Blasi
Italy
Hannes Kolehmainen Finland
Albert Michelsen
United States
Harry Payne
United Kingdom
Son Kitei
Japan[52]
Fusashige Suzuki
Japan
Yasuo Ikenaka
Japan
Son Kitei
Japan[52]
Suh Yun-bok
Korea
Jim Peters
United Kingdom
Jim Peters
United Kingdom
Jim Peters
United Kingdom
Jim Peters
United Kingdom
Paavo Kotila
Finland
Sergei Popov
Soviet Union
Abebe Bikila
Ethiopia
Toru Terasawa
Japan
Leonard Edelen
United States
Brian Kilby
United Kingdom
Basil Heatley
United Kingdom
Abebe Bikila
Ethiopia
Morio Shigematsu
Japan
Derek Clayton
Australia
Derek Clayton
Australia
a.)
Date
24-Jul-08
1-Jan-09
12-Feb-09
8-May-09
26-May-09
31-Aug-09
12-May-13
31-May-13
29-Nov-14
22-Aug-20
12-Oct-25
5-Jul-29
21-Mar-35
31-Mar-35
3-Apr-35
3-Nov-35
19-Apr-47
14-Jun-52
13-Jun-53
4-Oct-53
26-Jun-54
12-Aug-56
24-Aug-58
10-Sep-60
17-Feb-63
15-Jun-63
6-Jul-63
13-Jun-64
21-Oct-64
12-Jun-65
3-Dec-67
30-May-69
2:09:29
2:09:12
2:09:06
2:09:01
2:08:18
2:08:05
2:07:12
2:06:50
2:06:05
2:05:42
2:05:38
2:04:55
2:04:26
2:03:59
2:03:38
2:03:23
Ron Hill
Ian Thompson
Shigeru So
Gerard Nijboer
Robert De Castella
Steve Jones
Carlos Lopes
Belayneh Dinsamo
Ronaldo da Costa
Khalid Khannouchi
Khalid Khannouchi
Paul Tergat
Haile Gebrselassie
Haile Gebrselassie
Patrick Makau
Wilson Kipsang
United Kingdom
United Kingdom
Japan
Netherlands
Australia
United Kingdom
Portugal
Ethiopia
Brazil
Morocco
United States
Kenya
Ethiopia
Ethiopia
Kenya
Kenya
23-Jul-70
31-Jan-74
5-Feb-78
26-Apr-80
6-Dec-81
21-Oct-84
20-Apr-85
17-Apr-88
20-Sep-98
24-Oct-99
14-Apr-02
28-Sep-03
30-Sep-07
28-Sep-08
25-Sep-11
29-Sep-13
eive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers.
Given the selected marathon data for men and women record times (http://en.wikipedia.org/wiki/Marathon_wor
a.) Compute the record time for men AND women in minutes; and then compute the rates formatted to two decim
b.) as minutes per mile
c.) as miles per minute
d.) as miles per hour.
Event/Place
London, United Kingdom
Yonkers,[nb 5] United States
New York City, United States
New York City, United States
Polytechnic Marathon,London, United Kingdom
Stockholm, Sweden
Polytechnic Marathon
Polytechnic Marathon
Legnano, Italy
Antwerp, Belgium
Port Chester, United States
London
Tokyo, Japan
Tokyo, Japan
Tokyo, Japan
Tokyo, Japan
Boston Marathon
Polytechnic Marathon
Polytechnic Marathon
Turku Marathon
Polytechnic Marathon
Pieksämäki, Finland
Stockholm, Sweden
Rome, Italy
Beppu-Ōita Marathon
Polytechnic Marathon
Port Talbot, Wales
Polytechnic Marathon
Tokyo, Japan
Polytechnic Marathon
Fukuoka Marathon
Antwerp, Belgium
Hours
2.92
2.88
2.78
2.77
2.71
2.68
2.64
2.60
2.63
2.54
2.48
2.52
2.44
2.46
2.45
2.45
2.43
2.35
2.31
2.31
2.29
2.30
2.25
2.25
2.25
2.24
2.25
2.23
2.20
2.20
2.16
2.14
a.)
b.)
Minutes Minutes/Mile
Edinburgh, Scotland
Christchurch, New Zealand
Beppu-Ōita Marathon
Amsterdam Marathon
Fukuoka Marathon
Chicago Marathon
Rotterdam Marathon
Rotterdam Marathon
Berlin Marathon
Chicago Marathon
London Marathon
Berlin Marathon
Berlin Marathon
Berlin Marathon
Berlin Marathon
Berlin Marathon
2.16
2.15
2.15
2.15
2.14
2.13
2.12
2.11
2.10
2.10
2.09
2.08
2.07
2.07
2.06
2.06
credit for your answers.
en.wikipedia.org/wiki/Marathon_world_record_progression):
pute the rates formatted to two decimal places:
c.)
d.)
Miles/Minute Miles/Hour
Time
5:40:00
3:40:22
3:37:07
3:27:45
3:19:33
3:15:23
3:07:27
3:02:53
3:01:42
2:55:22
2:49:40
2:46:36
2:46:24
2:43:54
2:42:24
2:40:16
2:38:19
2:35:15
2:34:48
2:32:30
2:27:33
2:31:23
2:30:57
2:25:41
2:30:27
2:29:57
2:29:02
2:26:12
2:25:29
2:22:43
2:24:26
2:21:06
Name
Nationality
Marie-Louise Ledru France
Violet Piercy
United Kingdom
Merry Lepper
United States
Dale Greig
United Kingdom
Mildred Sampson
New Zealand
Maureen Wilton
Canada
Anni Pede-Erdkamp West Germany
Caroline Walker
United States
Elizabeth Bonner
United States
Elizabeth Bonner
United States
Cheryl Bridges
United States
Michiko Gorman
United States
Chantal Langlacé
France
Jacqueline Hansen
United States
Liane Winter
West Germany
Christa Vahlensieck West Germany
Jacqueline Hansen
United States
Chantal Langlacé
France
Christa Vahlensieck West Germany
Grete Waitz
Norway
Grete Waitz
Norway
Joan Benoit
United States
Patti Catalano
United States
Grete Waitz
Norway
Joyce Smith
United Kingdom
Joyce Smith
United Kingdom
Charlotte Teske
West Germany
Joan Benoit
United States
Grete Waitz
Norway
Joan Benoit
United States
Ingrid Kristiansen
Norway
Ingrid Kristiansen
Norway
2:20:47
2:20:43
2:19:46
2:18:47
2:17:18
2:15:25
Tegla Loroupe
Tegla Loroupe
Naoko Takahashi
Catherine Ndereba
Paula Radcliffe
Paula Radcliffe
Kenya
Kenya
Japan
Kenya
United Kingdom
United Kingdom
Date
29-Sep-18
3-Oct-26
16-Dec-63
23-May-64
21-Jul-64
6-May-67
16-Sep-67
28-Feb-70
9-May-71
19-Sep-71
5-Dec-71
2-Dec-73
27-Oct-74
1-Dec-74
21-Apr-75
3-May-75
12-Oct-75
1-May-77
10-Sep-77
22-Oct-78
21-Oct-79
3-Feb-80
6-Sep-80
26-Oct-80
16-Nov-80
29-Mar-81
16-Jan-82
12-Sep-82
17-Apr-83
18-Apr-83
13-May-84
21-Apr-85
Event/Place
Tour de Paris Marathon
London [nb 7]
Culver City, United States
Ryde
Auckland, New Zealand
Toronto, Canada
Waldniel, West Germany
Seaside, OR
Philadelphia, United States
New York City Marathon
Culver City, United States
Culver City, United States
Neuf-Brisach, France
Culver City, United States
Boston Marathon
Dülmen
Eugene, United States
Oiartzun, Spain
Berlin Marathon
New York City Marathon
New York City Marathon
Auckland, New Zealand
Montreal, Canada
New York City Marathon
Tokyo, Japan
London Marathon
Miami, United States
Eugene, United States
London Marathon
Boston Marathon
London Marathon
London Marathon
Hours
5.67
3.67
3.62
3.46
3.33
3.26
3.12
3.05
3.03
2.92
2.83
2.78
2.77
2.73
2.71
2.67
2.64
2.59
2.58
2.54
2.46
2.52
2.52
2.43
2.51
2.50
2.48
2.44
2.42
2.38
2.41
2.35
a.)
b.)
Minutes Minutes/Mile
c.)
Miles/Minute
19-Apr-98
26-Sep-99
30-Sep-01
7-Oct-01
13-Oct-02
13-Apr-03
Rotterdam Marathon
Berlin Marathon
Berlin Marathon
Chicago Marathon
Chicago Marathon
London Marathon
2.35
2.35
2.33
2.31
2.29
2.26
d.)
Miles/Hour
Conversions
Project Description:
In this problem, you will convert one unit to another using the given ratio tables.
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
receive full credit for your answers.
Steps to Perform:
Step
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Total Points
Conversions
Project Description:
In this problem, you will convert one unit to another using the given ratio tables.
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.
Steps to Perform:
Instructions
In cell K6, convert inches in cell J6 to inches. Fill cell K6 across columns L-O. Format cells K6:O6 as Number with 2 decimal
places.
In cell K7, convert feet in cell J7 to inches. Fill cell K7 across columns L-O. Format cells K7:O7 as Number with 2 decimal
places.
In cell K8, convert yards in cell J8 to inches. Fill cell K8 across columns L-O. Format cells K8:O8 as Number with 2 decimal
places.
In cell K9, convert centimeters in cell J9 to inches. Fill cell K9 across columns L-O. Format cells K9:O9 as Number with 2
decimal
places.
In cell K10,
convert meters in cell J10 to inches. Fill cell K10 across columns L-O. Format cells K10:O10 as Number with 2
decimal
places.
In cell K14, convert pounds in cell J14 to pounds. Fill cell K14 across columns L-O. Format cells K14:O14 as Number with 2
decimal
places.
In
cell K15,
convert grams in cell J15 to pounds. Fill cell K15 across columns L-O. Format cells K15:O15 as Number with 2
decimal
places.
In cell K16, convert kilograms in cell J16 to pounds. Fill cell K16 across columns L-O. Format cells K16:O16 as Number with 2
decimal
places.
In cell K17,
convert ounces in cell J17 to pounds. Fill cell K17 across columns L-O. Format cells K17:O17 as Number with 2
decimal
places.
In cell K18,
convert tons in cell J18 to pounds. Fill cell K18 across columns L-O. Format cells K18:O18 as Number with 2
decimal
places.
In cell K22,
convert gallons in cell J22 to gallons. Fill cell K22 across columns L-O. Format cells K22:O22 as Number with 2
decimal
places.
In cell K23, convert liters in cell J23 to gallons. Fill cell K23 across columns L-O. Format cells K23:O23 as Number with 2
decimal
places.
In cell K24,
convert cubic centimeters in cell J24 to gallons. Fill cell K24 across columns L-O. Format cells K24:O24 as
Number
with
2 decimal
places.
In cell K25, convert
cubic
inches in cell J25 to gallons. Fill cell K25 across columns L-O. Format cells K25:O25 as Number with
2 decimal
In
cell K26,places.
convert cubic feet in cell J26 to gallons. Fill cell K26 across columns L-O. Format cells K26:O26 as Number with 2
decimal
places.
In cell K30, convert meters per second in cell J30 to meters per second. Fill cell K30 across columns L-N. Format cells
K30:N30
asconvert
Numberfeet
withper
2 decimal
In cell K31,
second places.
in cell J31 to meters per second. Fill cell K31 across columns L-N. Format cells K31:N31
as cell
Number
2 decimal
places.
In
K32, with
convert
miles per
second in cell J32 to meters per second. Fill cell K32 across columns L-N. Format cells K32:N32
as
Number
2 decimal
places.
In cell
K33, with
convert
kilometers
per second in cell J33 to meters per second. Fill cell K33 across columns L-N. Format cells
K33:N33 as Number with 2 decimal places.
Total Points
alues, as you will not
Points
Possible
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
114
Density
Project Description:
In this problem, you will convert the densities to pounds per cubic inch for different materials. You will also provide the results as a column ch
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
receive full credit for your answers.
Steps to Perform:
Step
1
2
3
4
5
Total Points
Density
Project Description:
In this problem, you will convert the densities to pounds per cubic inch for different materials. You will also provide the results as a column chart.
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.
Steps to Perform:
Instructions
In cell D9, convert the densities in cell B9 to pounds per cubic inch. Fill cell D9 down the column to cell D62. Format cells
D9:D62 as Scientific to any number of decimal places.
In cell E9, calculate a new scale for helium by setting the density of gold to 100. Fill cell E9 down the column to cell E62.
Format cells E9:E62 as Number with 3 decimal places.
In cell F9, calculate a new scale for helium by setting the density of fresh water to 1. Fill cell F9 down the column to cell F62.
Format cells F9:F62 as Number with 5 decimal places.
In cells H32:O48, insert a Clustered Column Chart to show the densities of all the materials. Select range B8:C62. On the
Insert tab, click Recommended Charts, and then click Clustered Column. Apply Style 6 on the Design tab. Add a chart title and
choose the Above Chart option. Replace Chart Title with Density (kg/m^3).
In cell J29, determine whether the scale you use matters when you make a column chart.
Total Points
s a column chart.
alues, as you will not
Points
Possible
6
6
6
4
2
24
Planets
Project Description:
In this problem, you will calculate the orbital radii in different units for all the planets. You will also provide the results as a bar chart.
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
receive full credit for your answers.
Steps to Perform:
Step
2
3
4
5
6
7
8
9
Total Points
Planets
Project Description:
In this problem, you will calculate the orbital radii in different units for all the planets. You will also provide the results as a bar chart.
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.
Steps to Perform:
Instructions
In cell D12, convert the orbital radius of Mercury to miles. Fill cell D12 down the column to cell D21.
In cell E12, convert the orbital radius of Mercury to million of miles. Fill cell E12 down the column to cell E21. Format cells
E12:E21 as Number with 2 decimal places.
In cell F12, calculate the ratio of Mercury’s orbital radius in millions of kilometers to that of Earth. Fill cell F12 down the column
to cell F21. Format cells F12:F21 as Number with 2 decimal places.
In cell G12, calculate the ratio of Mercury’s orbital radius in miles to that of Earth. Fill cell G12 down the column to cell G21.
Format cells G12:G21 as Number with 2 decimal places.
In cell H12, calculate the ratio of Mercury’s orbital radius in millions of miles to that of Earth. Fill cell H12 down the column to
cell H21. Format cells H12:H21 as Number with 2 decimal places.
In cell E24, determine if it matters what units to use for the original scale when you create a planetary scale with Earth set to 1.
In cell E26, determine if the scales with Earth set to 1 unit are unit-less.
In cells J28:P42, insert a Clustered Bar Chart to show the orbital radii of all the planets. Select range B12:C21. On the Insert
tab, click Recommended Charts, and then click Clustered Bar. Apply Style 5 on the Design tab. Add a chart title and choose
the Above Chart option. Replace Chart Title with Orbital Radius (millions km).
Total Points
hart.
alues, as you will not
Points
Possible
4
6
6
6
6
2
2
4
36
Marathons
Project Description:
In this problem, you will investigate men and women record times in different units.
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not …
Purchase answer to see full
attachment

  
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more