Bridges_Chapter_3-3_Planets_Finished
xlsx
keyboard_arrow_up
School
Germanna Community College *
*We aren’t endorsed by this school
Course
MTH 154
Subject
Astronomy
Date
Apr 3, 2024
Type
xlsx
Pages
9
Uploaded by ConstablePheasant4237
Planets
Project De
In this proble
Use a cell re
Steps to P
Step
1
2
3
4
5
6
7
8
9
10
s
escription: em, you will calculate the orbital radii in different units for all the planets. You will also provide the results as a bar chart.
eference 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 recei
Perform:
Instructions
Start Excel. Download and open the workbook named:
Chapter_3-3_Planets_Start
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 Numbe
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. For
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:
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
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.
Save your file and submit for grading.
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 Recom
Style 5 on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with Orbital Radius (millions km)
.
0
4
6
6
6
6
2
2
4
0
36
Points Possible
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Planets
Use a cell reference or a single formula where appropriate in order to receive full credit. Do km
miles
1
0.621371
a.)
b.)
c.)
Planet
miles
millions of miles
Ea
Mercury
57.9
35,977,381 35.98
0.39
Venus
108.2
67,232,342 67.23
0.72
Earth
149.6
92,957,102 92.96
1
Mars
227.9
141,610,451 141.61
1.52
Asteroids
686.1
426,322,643 426.32
4.59
Jupiter
778.3
483,613,049 483.61
5.2
Saturn
1429.4
888,187,707 888.19
9.55
Uranus
2875.0
1,786,441,625 1786.44
19.22
Neptune
4504.5
2,798,965,670 2798.97
30.11
Pluto
5915.8
3,675,906,562 3675.91
39.54
Part d:
Yes
Part e:
Yes
Orbital Radius (millions of km)
not copy and paste values or type values, as you will not receive full credit for your answers.
c.)
c.)
arth Set to One
0.39
0.39
0.72
0.72
1
1
1.52
1.52
4.59
4.59
5.2
5.2
9.55
9.55
19.22
19.22
30.11
30.11
39.54
39.54
f.)
Given a planetary scale of orbital radii in millions of kilome
a.) Convert these distances to miles.
b.) Convert these distances to millions of miles. Format to 2
c.) Scale each of the three rows of data (millions of kilomet
millions of miles) with Earth set to 1. Format to 2 decimal p
d.) If you are going to create a planetary scale with Earth se
matter what units (e.g. km or miles) are used for the origin
e.) Are the scales you just created in part c
with Earth set t
f.) Make a well-labeled bar chart comparing the orbital rad
for the title: Orbital Radius (millions km).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
eters:
2 decimal places.
ters, miles, and places.
et to 1, does it nal scale?
to 1 unit-less?
dii. Use the following
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help