Multiple variable issue

F

FadaSininho

I need to correlate data of temperature and concentration of solutions
of acetic acid in order to find its density. Density is a function of
both these variables.

I have a table that presents the density of acetic acid solutions
versus concentration and temperature. The problem is that the density
is given for variations of 1% in concentration and of 5ºC to 10ºC (9ºF
to 18ºF) in temperature, so often I have to get the density for a
solution at a certain concentration and temperature, but that
temperature is not specified in the table.

The table shows the temperatures on its first (upper) line and the
concentrations on its first (left) column. The density is found by
choosing a temperature and a concentration and then reading the density
value on the point on the table where the temperature column and
concentration line intersect. The table is in the doc file attached.

I intend to type the whole table in Excel. Does anyone know if there’s
a smart way of correlating the variables, by using Excel tools?

Many thanks :)


+-------------------------------------------------------------------+
|Filename: Density Table.doc |
|Download: http://www.excelforum.com/attachment.php?postid=5219 |
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

try to build a model for thermodynamics 2
Word wrap issues within merged cells 5
Multiple selections from forms 5
Finding intersection of row and column (both variable) in table 8
carry over data to other sheet - help needed 3
Looking for more elegant code 4
mutiple regression help 1
Defining a variable length area for output. 2

Top