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 F = 1.8°C + 32 allows you to find the Fahrenheit (F) ...
More Related Questions