Creating a Function (Data Model) Based off Series of Data and Constants

[flash_659]

I've been given a university assignment where I am trying to predict corrosion rate based off moisture content for a buried pipe. The teacher wants a function based off corrosion rate (cr) (of which I have 130 values) and those 130 values corresponding moisture content (mc). These will also be a function of two constants; e and d10.

An example of the equation would be:

corrosion rate = x1 + x2 * mc + x3 * e + x4 *d10

Placing the known values into the equation gives:

corrosion rate = x1 + x2 * mc + x3 * 1.05 + x4 * 0.015

He has suggested using the Data Analysis ToolPak, which I have installed, but I have no idea were to begin.

I have linked the 130 values of corrosion rate and moisture content here: TinyUpload.com - best file hosting solution, with no limits, totaly free

If anyone could get me on the correct path I would really appreciate it.

Thanks in advance.

 

[oldbrewer]

look up regression on wikipedia

then see what toolpak tools can help you

hint if the equation was of the form Y= mX + c you can find slope m and constant C