Question

Comparing apples to apples is important when working with numeric data. Sometimes information is presented in different units or formats. Use a spreadsheet (MSExcel) to compare the following questions. • Who earns more? An annual salary of $50,000 or an hourly wage of $30/hour • Which is a better value? A 32 oz bottle at $2.25 or a gallon bottle at $11.00 • Which is a longer drive? 10km or 7 miles

Answer 1

The calculated values are shown below. First of all $50000 a year salary translates to $24.03 per hour salary. Compared to this, the hourly wage of $30 is higher.

1 gallon is 128 oz. using this we can see that 1 gallon cost at $11 is higher than 32 oz for 2.25.

The conversion ratio is 1 mile = 1.6 KM. Using this, 10 KM is 6.25 miles. Thus 7 miles drive is longer.

X fxAnnual salary A1 B A C D E G H K M N O Hourly wage 1 Annual salary 30 50000 of weeks 4 52 Hours per week 6 40 Hourly salary 7 8 24.03846154 9 10 11 32 oz price 2.25 12 1 oz price 128 oz price 0.0703125 13 14 1 Gallon price 15 11 16 17 18 KM 10 19 Mile 6.25 20 21 .. Sheet1218 Sheet1219 Sheet1220 Sensitivity Report 79 Sheet1221 Sheet1223 READY 130%