Creating chart with two variables and related trendline equation

HI

I am trying to create a chart and trendline for a data set to be used
for interpolation/forecasting.

Following is the data set:

X-axis	Y-axis ------------>>>>>
Rel Humid	PO	PO           PO	PO
@0deg     @15deg   @30deg   @30deg
0	1.0000	1.2	1.4	2	
10	1.1000	1.4	1.48	2.2	
20	1.2000	1.6	1.56	2.4	
30	1.3300	1.8	1.64	2.6	
40	1.4600	2	1.72	2.8	
50	1.5900	2.2	1.8	3	
60	1.7200	2.4	1.88	3.2	
70	1.8500	2.6	1.96	3.4	
80	1.9800	2.8	2.04	3.6	
90	2.1100	3	2.12	3.8	
100	2.2400	3.2	2.2	4	

The chart is created with Rel. Humid as X axis and Power Output at
various ambient temperatures (specifically for 0, 15, 30 and 45 degrees
is plotted) on Y axis.

Following are the problems :

1) How to create a 3-D chart with above data set.

2) How to obtain an trendline equation for �Power Output� wherein two
inputs are required viz. Rel. Humid. and Amb. Temp. ie. How to know
Power output at lets say at 32 degrees and rel. humidity of 75%.

3) Is there any way to link the trendline equation to a set of input
data and automate the process. 

Thanking you in advance.
Sudhanshu


---
Message posted from http://www.ExcelForum.com/

0
1/23/2004 2:38:28 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
356 Views

Similar Articles

[PageSpeed] 51

Reply:

Similar Artilces: