I have a small data set (see attachment valve.txt or valve.csv), in which
there are a few facors: Type, ValveBody,Manufacturer
and a few numeric sizes: FlangeSize, Port.Size, Pressure and Cost.
I would like to find a statistics model that shows how Cost is related to
these factors and numeric sizes.
It seems to me that it is hard to find the relationship between Cost and a
few factors using regression models.
Could you please direct me on how to approach it? Thanks,
-james
Date Type ValveBody Manufacturer FlangeSize Port.Size
Pressure FaceType Cost
8/30/2005 Pipeline Protection System Ball Bettis 4 4
600 RF 11206.3
8/30/2005 Pipeline Protection System Ball Bettis 2 2
1500 RF 10480.89
1/20/2006 Pipeline Protection System Ball Bettis 4 4
600 RF 10335.56
1/20/2006 Pipeline Protection System Ball Bettis 2 2
600 RF 7988.56
11/16/2005 Pipeline Protection System Ball Bettis 2 2
900 RTJ 4406.06
12/22/2005 On/Off Valve Ball El-o-Matic 2 2 1500
RTJ 5325
12/9/2005 Pipeline Protection System Ball El-o-Matic 2
2 1500 RTJ 6416.81
11/17/2005 On/Off Valve Ball El-o-Matic 4 3 600
RF 6222
2/15/2006 Pipeline Protection System Ball Cameron 6 NA
600 RF 14465
12/13/2005 Pipeline Protection System Ball Cameron 6 NA
600 RF 14900
10/25/2005 Control Valve Globe Fisher 2 NA 600 RF
3675.5
11/16/2005 Control Valve unsure Fisher 2 NA 600 RF
5316.48
12/9/2005 Control Valve unsure Fisher 2 NA 600 RF
4935.87
11/29/2005 On/Off Valve Ball Cameron 6 NA 600 RF
14900
11/21/2005 On/Off Valve Ball Bettis 2 2 300 RF
4762
11/21/2005 Pipeline Protection System Ball Bettis 2 2
300 RF 6391.85
11/23/2005 Control Valve Globe Fisher 2 NA 150 RF
3713.46
12/22/2005 Control Valve unsure Fisher 2 NA 600 RF
5077.78
6/21/2007 Control Valve Globe Fisher 2 NA 300
3950
1/13/2006 On/Off Valve Ball Bettis 2 2 600 RF
4352.91
1/13/2006 On/Off Valve Ball Bettis 2 2 600 RF
5905
1/13/2006 On/Off Valve Ball Bettis 4 4 600 RF
6073.07
1/13/2006 On/Off Valve Ball Bettis 4 4 600 RF
8571
2/1/2007 On/Off Valve Ball Bettis 6 6 600 RF
13816.34
2/1/2007 On/Off Valve Ball Bettis 8 8 600 RF
18335.5
2/1/2007 On/Off Valve Ball Bettis 10 10 600 RF
25080.34
12/1/2006 On/Off Valve Ball Bettis 2 2 600 RF
3670.44
12/1/2006 On/Off Valve Ball Bettis 4 4 600 RF
4805.67
11/21/2005 On/Off Valve Ball El-o-Matic 4 NA 600
RF 6222
11/18/2005 Control Valve unsure Fisher 2 NA 600 RF
5316.48
11/18/2005 Pipeline Protection System Ball El-o-Matic 2
NA 900 RTJ 6005.7
11/25/2005 Pipeline Protection System Ball Bettis 2 NA
300 RF 6391.85
11/25/2005 Pipeline Protection System Ball Bettis 2 NA
300 RF 6391.85
10/12/2005 Pipeline Protection System Ball El-o-Matic 2
NA 900 RTJ 7669
10/5/2005 Control Valve Globe Fisher 2 NA 600 RF
3675.2
8/23/2005 On/Off Valve Ball Bettis 4 4 600 RF
8033
8/23/2005 On/Off Valve Ball Bettis 2 2 600 RF
5323
8/23/2005 On/Off Valve Ball Bettis 2 2 1500 RF
7347
9/15/2005 Control Valve Globe Fisher 2 NA 1500 RTJ
4161.8
4/21/2005 Pipeline Protection System Ball Bettis 4 4
600 RF 9754
3/21/2005 Pipeline Protection System Ball Bettis 2 2
1500 RF 9902
3/22/2005 Pipeline Protection System Ball Bettis 2 2
900 RF 8827
3/7/2005 Pipeline Protection System Ball Bettis 6 6
600 RF 15446
7/7/2004 Control Valve Globe Fisher 1 NA NA
530
6/9/2004 Control Valve unsure Fisher 8 NA 600 RF
19321.43
7/8/2004 Control Valve Globe Fisher 2 NA 600 RF
1833.33
6/11/2004 On/Off Valve Ball Bettis 4 4 600 RF
5651
7/14/2004 On/Off Valve Ball Bettis 6 NA 600 RF
6959
3/3/2005 Pipeline Protection System Ball Bettis 2 2
600 RF 7602
1/9/2006 On/Off Valve Ball Bettis 4 4 600 RF
8571
1/9/2006 Pipeline Protection System Ball Bettis 4 4
600 RF 10363.56
1/9/2006 On/Off Valve Ball Bettis 2 2 600 RF
5905
1/9/2006 Pipeline Protection System Ball Bettis 2 2
600 RF 7697.56
11/15/2005 On/Off Valve Ball Bettis 6 4 600 RF
7335
11/15/2005 On/Off Valve Ball Bettis 4 34 600 RF
6748
11/15/2005 On/Off Valve Ball 6 NA 600 RF
6120
11/15/2005 On/Off Valve Ball 4 NA 600 RF
4000
12/9/2005 Control Valve unsure Fisher 2 NA NA
1884.87
11/18/2005 On/Off Valve Globe Fisher 1 NA NA
530
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
