software

Hi all,

I have a task to do for a uny but unfortunately I have no idea what do
I have to do and where do I jave to start.

Here is the problem:

*Problem 1
The length of a metal rod is measured repeatedly as its temperature
changes. The table shows the resulting data.

T(C) L(cm)
10 64.600
15 64.603
20 64.605
25 64.608
30 64.612
35 64.614

The length of a rod is related to its temperature by the general linear
equation:

L = Lo Lo a T

whe Lo is the lenght of the rod at T = 0C

and a is the coefficient of linear expansion

----

You are required to do the following using Excel.

1.Plot L against T with the trendline equation.
2.Find the value of Lo and a using the SLOPE and INTERCEPT functions.
3.Use the equation found to calculate the rod length at 48C*Any help or advice will be highly appriciated.

Thanks a lot.

D.S.--
infodata
------------------------------------------------------------------------
infodata's Profile: www.excelforum.com/member.php...oamp;userid=34379
View this thread: www.excelforum.com/showthread...hreadid=541584I would suggest to start by checking if the Analysis ToolPack add-in is
installed (Tools -gt; Add-ins), as those functions are available there.
After that, you can place the formulas in your worksheet, and check the help
for the functions; it comes with some examples, that may be useful in your
case. There is also a good step by step help on how to add a trendline to a
graph.

Hope this helps,
Miguel.

quot;infodataquot; wrote:

gt;
gt; Hi all,
gt;
gt; I have a task to do for a uny but unfortunately I have no idea what do
gt; I have to do and where do I jave to start.
gt;
gt; Here is the problem:
gt;
gt; *Problem 1
gt; The length of a metal rod is measured repeatedly as its temperature
gt; changes. The table shows the resulting data.
gt;
gt; T(C) L(cm)
gt; 10 64.600
gt; 15 64.603
gt; 20 64.605
gt; 25 64.608
gt; 30 64.612
gt; 35 64.614
gt;
gt; The length of a rod is related to its temperature by the general linear
gt; equation:
gt;
gt; L = Lo Lo a T
gt;
gt; whe Lo is the lenght of the rod at T = 0C
gt;
gt; and a is the coefficient of linear expansion
gt;
gt; ----
gt;
gt; You are required to do the following using Excel.
gt;
gt; 1.Plot L against T with the trendline equation.
gt; 2.Find the value of Lo and a using the SLOPE and INTERCEPT functions.
gt; 3.Use the equation found to calculate the rod length at 48C*
gt;
gt;
gt; Any help or advice will be highly appriciated.
gt;
gt; Thanks a lot.
gt;
gt; D.S.
gt;
gt;
gt; --
gt; infodata
gt; ------------------------------------------------------------------------
gt; infodata's Profile: www.excelforum.com/member.php...oamp;userid=34379
gt; View this thread: www.excelforum.com/showthread...hreadid=541584
gt;
gt;