Posted by **jeng** on Wednesday, October 28, 2009 at 12:54pm.

Consider the following method of estimating

Fahrenheit temperatures given Celsius temperatures

(which was stated earlier in this section):

To estimate the Fahrenheit temperature for a given Celsius

temperature, double the Celsius temperature and add 30.

Create a spreadsheet comparing the estimates with the

actual Fahrenheit temperatures for Celsius temperatures

from 0 to 40°. (The estimate can be expressed as follows:F = 2C + 30

.) For what temperatures is the estimate

most accurate? least accurate? Are there any Celsius temperatures

for which the estimate is exactly correct?

- math -
**Reiny**, Wednesday, October 28, 2009 at 1:25pm
In Excel, I would create 3 columns

Put 0 into A1

in B1 type: A1*2 + 30

in C1 type : A1*(9/5) + 32

in A2 type : =A1 + 1

select A2 to A101, "fill down"

"fill down" the values for columns B and C from 1 to 101

as a check: my values for 20 are 70 and 68

and at 10º F I get 50 in both columns

## Answer this Question

## Related Questions

- Algebra - The formula for converting Celsius temperatures to Fahrenheit ...
- INTRO PROGRAMMING - Celsius to Fahrenheit Table Design a program that displays ...
- Algebra - Celsius temperature readings can be converted to Fahrenheit readings ...
- Algebra - The folrmula F=9/5c+32 can be used to make temperature conversions ...
- Algebra - Celsius temperature readings can be converted to Fahrenheit readings ...
- C Programming - Write a program that prompts the user to enter a temperature, ...
- algebra - write 9.03 x 10^-2 in standard notation. That is 9.02 hundreths, or 0....
- Fund of programming 1 - Complete the following C++ program. The program should ...
- Algebra - In order to covert temperature from Celsius to Fahrenheit,one can use ...
- math - the formula C=5/9(F-32) is used to convert Fahrenheit temperature,F, to ...

More Related Questions