English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

The Equations i Figured out for the conversion of Fahrenheit (F) to degrees Celsius (C ) Vise Versa.
F = 9/5C + 32
C = 5/9(F – 32)

I know how to make the graph by hand (so dont waste your time explaining it to me because i already know!) but i know there is a way to do it on the internet or on Excel. I would really like to figure it out soon because frankly i think it would look neater on a printed out graph then one that i drew...

2006-09-19 15:57:34 · 2 answers · asked by Gotty 2 in Science & Mathematics Mathematics

2 answers

You will have to make a column of the centigrade scale form 0 to 100°. Then you can use the formula in the row beside it to get the fairenheit scale. (Example: If your 0° C is in cell A5, then in cell b5, write the formula "=1.8*A5 + 32" (without the quotes).
Copy this cell in this column to the next 100 cell in the same column. So you will have Column A with celcius scale and Column B with a Fairenheit scale.
Then mark all the cells, hit the graph button, pick probably X-Y graph, Follow through the steps and tell it to put the graph on a new page. You can change the colors, scales, etc. Give it a Title and label the X and Y axis.
As far as I know, Excel does not graph based on a single equation; Excel has to see actual data points so it will know the range, scale, etc. that you want to look at.
There are programs around like Math-Cad that can graph equations, but you did asked about M$-Excel.

2006-09-19 16:24:48 · answer #1 · answered by captn_carrot 5 · 0 0

just type the foumula into excell and hit "graphs" and it will automatically do that for you.

2006-09-19 16:05:14 · answer #2 · answered by Anonymous · 0 0

fedest.com, questions and answers