This data is for a company who wants to minimize their expenses. The expenses is described out of the production costs . (Production, salary, capital and material prices). I need to create a regression model, which explains the expenses as good as possible by using R.
Expenses Production Salary Capital Material prices
30.8803877 5643.56430 10183.508 61.04610 27.85258
8.6860685 1627.16270 7913.191 79.22792 31.68327
29.8040801 4187.41870 7997.240 74.12741 47.43044
2.2369237 198.01980 7047.205 64.95149 38.00380
12.7842783 2632.26320 8470.687 70.30203 30.97410
3.0430043 869.08690 8373.797 68.23382 21.06911
46.8034799 11227.12260 8886.279 83.89439 23.62836
119.3855374 33823.38200 7264.246 70.81508 22.15031
58.1212115 17876.78750 6289.039 73.40234 20.62116
1.3423342 183.01830 5063.996 74.43744 35.51355
16.1720170 2863.28630 7510.121 81.55815 30.24042
5.5976597 938.09380 7704.030 77.20472 25.40254
282.2761248 48244.82400 9674.347 70.77708 36.51365
31.9915988 10150.01490 6438.564 73.14731 18.53615
90.3808372 21958.19560 7955.265 83.34633 22.91379
277.3242296 72254.22470 7420.662 56.30663 25.09391
21.5608559 3886.38860 9539.634 63.57536 30.89249
737.4825409 115511.55000 8439.644 76.62766 38.85388
125.3481336 24003.40010 8048.155 74.37944 33.09651
28.7889786 9660.96600 6687.399 79.54995 20.26503
67.8629856 15221.52200 6986.789 74.03240 25.66457
17.2912290 2763.27630 8059.716 80.66807 45.66817
183.2498231 27120.71180 9915.351 78.48785 41.76198
3.1507150 378.03780 7896.220 60.28303 42.47255
18.8981896 2020.20200 10807.281 79.57796 46.90469
17.4819480 4148.41480 7537.644 74.03240 24.58616
10.3146314 1886.18860 6834.613 67.68677 25.60256
31.2192216 9057.90570 10600.920 31.72817 21.58216
79.0784070 12707.27060 9283.438 70.86009 37.25142
42.2556251 7320.73200 5880.098 92.07221 39.21432
13.2692268 2445.24450 8765.626 76.14761 28.36764
22.2645262 5601.56010 7582.448 68.86489 26.61766
7.6243624 1340.13400 6439.064 79.22792 38.15211
0.6159616 50.00500 9205.160 90.47905 32.07321
31.6399637 4617.46170 6489.039 70.81308 41.99320
24.7258723 5331.53310 7862.196 43.42234 28.48085
469.2321185 66496.64900 9138.944 78.98790 41.01410
32.5872584 7930.79300 7119.722 49.00190 22.84028
31.2953292 7484.74840 8064.536 67.68677 23.52905
42.4159412 8650.86500 7147.385 72.97430 27.87209
29.4899487 5292.52920 8177.148 76.14761 22.83968
68.4868480 12543.25420 8143.654 80.39304 35.79178
30.1708168 9602.96020 7054.885 59.98300 20.20302
19.9027901 5785.57850 7970.347 71.91719 22.24702
55.1819176 10856.08550 8062.766 71.49715 31.76328
66.1098103 11838.18370 8710.301 75.38654 31.33523
78.7106703 17133.71320 8161.616 78.90689 25.54035
35.1126109 5699.56990 7989.279 80.37804 42.63936
0.4887489 14.00140 5439.434 86.11861 34.15341
147.0036989 25149.51470 9901.750 75.73257 33.47755
169.2523235 38346.83430 9118.072 65.99860 31.59286
6.6227622 1500.15000 7589.459 82.84828 21.39724
27.2470244 4568.45680 9620.722 76.14761 35.66807
106.2835273 28374.83720 7503.680 66.58666 24.44544
25.6119609 6604.66040 7715.111 90.87909 21.27113
22.4443442 5648.56480 8955.015 78.44784 25.91859
12.3255324 2816.28160 13045.304 58.86589 30.59306
2.2589259 295.02950 8219.222 71.94719 39.20392
27.0859083 7896.78960 7120.672 74.52045 20.11201
1.3644364 154.01540 8291.819 87.47375 35.78358
9.7852784 1627.16270 8356.586 76.14761 31.34053
50.2143209 13031.30300 6735.673 55.92559 26.16662
40.5321528 6891.68910 6770.227 74.12741 35.96870
2.5595559 243.02430 7001.510 81.75817 33.43934
35.5338530 6770.67700 7799.040 67.57676 29.82798
0.7606761 65.00650 8972.787 41.24712 28.54185
30.1910188 5317.53170 9587.589 78.01580 41.84418
16.1780176 2487.24870 8089.259 66.62866 32.62186
24.3999398 3490.34900 8478.078 75.42754 38.00380
113.2668255 22524.25220 9501.730 76.73967 25.03140
38.8510847 10058.00570 6036.554 81.58616 25.82658
111.8974886 23219.32170 6874.417 83.88839 33.39774
5.9286928 723.07230 6433.183 62.09221 43.88839
240.5377514 29615.96130 9313.861 81.75817 41.89139
47.3911386 9530.95300 7625.332 83.88839 31.58566
22.8458844 3789.37890 6430.183 76.30763 34.26243
134.2417228 19446.94450 9830.303 67.58676 38.80658
0.3158316 16.30163 7728.543 38.10981 33.46335
10.9675966 2506.25060 7413.101 57.24572 27.42344
2.0534053 374.03740 7885.728 82.49325 26.30403
168.3945378 34215.42120 5684.398 80.39304 40.53265
9.4683467 2233.22330 6717.852 59.96300 22.69557
45.1872183 12937.29360 8320.892 65.76658 22.03520
57.7324727 10005.00040 6473.507 76.30763 28.09871
3.7608760 377.03770 7432.983 74.12741 33.43934
11.1102109 1961.19610 6965.506 82.49325 28.26623
30.2097207 5286.52860 7084.808 73.33233 38.34223
24.2927290 5316.53160 9760.806 74.03240 27.84078
2.0360036 617.06170 9548.675 81.75817 18.49185
30.4737471 8060.80600 7000.700 37.06171 30.77308
282.9683940 53765.37600 9620.862 73.46735 34.64346
79.6286621 16509.65080 9405.910 78.05180 42.21282
30.2270224 6904.69040 11146.335 31.72817 25.18252
1.7706770 153.01530 10964.996 57.61776 46.16462
0.6363636 67.00670 6697.170 58.26383 25.40254
88.1079099 26523.65210 6890.949 68.65086 20.51885
13.6283627 2437.24370 7846.845 65.57156 30.67427
6.6220621 856.08560 8034.523 67.68677 39.58516
90.7258717 17281.72800 9192.389 72.97430 36.88529
7.5499549 2969.29690 8184.158 80.66507 9.00090
48.1173112 11115.11140 8414.701 69.98200 22.55586
33.8847881 7382.73820 7513.471 72.36924 25.90269
33.9766973 5708.57080 10025.202 78.10981 42.17022
0.1304130 4.00040 6010.301 92.65927 33.20232
22.5634561 3571.35710 7298.440 78.26283 41.59926
72.0427035 12725.27240 8038.644 74.03240 37.52115
21.5475545 3981.39810 8186.869 75.08951 35.20842
8.6380637 1090.10900 8508.771 39.13091 33.90339
113.6023591 22279.22770 5571.607 82.67627 36.04060
55.3679362 13074.30730 7025.062 76.32763 26.28363
19.7111709 2682.26820 9485.798 81.75817 50.45665
41.9057902 12955.29540 6461.286 62.33623 21.75718
9.6438643 2689.26890 6365.036 78.44784 23.49125
107.9883978 18456.84550 6690.899 76.30763 32.96870
14.0445043 2001.20010 8612.391 74.03240 30.64766
97.3956386 13847.38460 7787.149 88.54885 44.16152
40.8980894 9553.95530 7287.899 61.34113 26.84968
9.4068406 1412.14120 7961.696 40.69607 41.53415
77.8926885 13703.37020 7114.501 70.85708 34.96510
80.3673359 16312.63110 7283.338 81.55815 40.97330
4.5054505 467.04670 8411.181 76.30763 26.85269
111.9354924 31911.19080 6972.237 75.22552 23.09391
3.7258725 643.06430 7332.863 64.51245 21.16402
52.7686763 9145.91450 10374.537 81.75817 35.81188
6.8299829 946.69466 10643.224 43.60436 51.46815
5.8493849 1025.10250 7094.029 68.23382 22.28153
3.9825982 391.03910 5826.623 78.29583 44.63746
So far, the best fit i've made is:
lm(Expenses~production+I(Capital^3)+Salary+Material)