# math

posted by .

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 -

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

## Similar Questions

1. ### Algebra

Celsius temperature readings can be converted to Fahrenheit readings using formula F=9/5c+32 What is the fahrenheit temp. that corresponds to each of the following Celsius temperatures -10, 0, 15, 1000?
2. ### algebra

write 9.03 x 10^-2 in standard notation. That is 9.02 hundreths, or 0.0902 Celsius temperatur readings can be converted to fahrenheit eadings using the formula F= 9/5 C + 32. What is the Fahrenheit temperature that corresponds to each …
3. ### Algebra

Celsius temperature readings can be converted to Fahrenheit readings using the formula F = 9/5c + 32, what is the Fahrenheit temperature that correspond to each of the following celsius temperatures: -10,0,15,100
4. ### Algebra

The folrmula F=9/5c+32 can be used to make temperature conversions with the Celsius ans Fahrenheit temperature scales. F-Fahrenheit temperature C=Celsius temperature Convert 100 degress Fahrenheit to the Celsius temperature scale. …
5. ### C Programming

Write a program that prompts the user to enter a temperature, followed by a letter representing Celsius (C) or Fahrenheit (F). Then prompt the user for the conversion type and print the results to the screen with one decimal point. …
6. ### Algebra

The formula for converting Celsius temperatures to Fahrenheit temperatures is F= 9/5C + 32 where F is the temperature in degrees Fahrenheit and C is the temperature in degrees Celsius. Which formula could be used to convert Fahrenheit …
7. ### Fund of programming 1

Complete the following C++ program. The program should compute and output the Celsius value corresponding to the given Fahrenheit value. //************************************************ // Celsius program // This program outputs …
8. ### Algebra

In order to covert temperature from Celsius to Fahrenheit,one can use the following equation f= 1.8c+32,where C is the temperature in Celsius and F is the temprature in Fahrenheit.what is the temperature in Fahrenheit when C is 15 …
9. ### INTRO PROGRAMMING

Celsius to Fahrenheit Table Design a program that displays a table of the Celsius temperatures 0 through 20 and their Fahrenheit equivalents. The formula for converting a temperature from Celsius to Fahrenheit is F = 95 C + 3 2 where …
10. ### math

The formula F = 1.8°C + 32 allows you to find the Fahrenheit (F) temperature for a given Celsius (C) temperature. Solve the equation for C to produce a formula for finding the Celsius temperature for a given Fahrenheit temperature. …

More Similar Questions