{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

homework09.1

# homework09.1 - Homework 09.1 Pairs Assignment Problem 1...

This preview shows pages 1–3. Sign up to view the full content.

Homework 09.1 Pairs Assignment Problem 1: Temperature Conversion Create a spreadsheet that will perform temperature conversions (Celsius, Fahrenheit, Kelvin, and Rankine) for Fahrenheit temperatures from –200 to 200 in increments of 20. The mathematical expressions that relate these scales are: TempC = (5/9)(TempF - 32) TempR = TempF + 460 TempF = (9/5)(TempC) + 32 TempK = Temp C + 273 Temperature Conversion Chart Fahrenheit Celsius Rankine Kelvin -200 -128.9 260 144.1 200 93.3 660 366.6 Problem 2: Planets The time it takes for a planet to revolve around the sun depends on the mass of the sun and the distance the planet is from the sun. The weight of a person on the surface of another planet will be different than the weight on earth, and depends on the planet mass and diameter. Create a spreadsheet that has the following form: Planet Distance from the sun Diameter Mass Period My Weight (km × E06) (mi × E06) (km) (mi) (kg x 1E24) (earth days) (lb) Mercury 57.9 4880 0.3289 Venus 108.2 12104 4.849 Earth 149.61 12756 5.98 Mars 227.9 6787 0.6458 Jupiter 778.3 142800 1901 Saturn 1427 120000 569.3 Uranus 2869.6 51800 87.31 Neptune 4496.6 49500 102.9 Pluto 5900 6000 0.598 My Weight On earth (lb) 200 Formulas and Conversions: 1 km = 0.62137 mile M sun = 1.99E30 kg G = 6.67E-11 N·m 2 /kg 2 T earth days = (1.996E-10)*(Dist sun ) 3/2 with Dist sun in kilometers Weight on planet = Weight earth *(Mass planet /Mass Earth )*(Dia earth /Dia planet ) 2 Mass earth = 5.98E24 kg D earth = 12756 km Weight on planet (lb) = 2.721E-17*( Mass planet /(Dia planet ) 2 )* Weight earth with Mass planet in kg, Dia planet in km and Weight earth in lb. Remember Weight earth is a constant…use absolute address (i.e., \$B\$15) Problem 3: Grade Spreadsheet Prepare a grade spreadsheet similar to the one in excel_intro.xls by doing the following:

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
1. Open an Excel spread sheet. 2. To import the data file: a. Pull down the File tab in the upper left-hand corner. b. Chose Open File . A pop-up menu will appear. c. On the lower left corner of the pop-up menu click on file type and select all files .
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 4

homework09.1 - Homework 09.1 Pairs Assignment Problem 1...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online