Solve Using an Excel Spreadsheet:

You work for a company that builds environmentally controlled inventory storage facilities for electronic parts. All the facilities you have built in the past are listed in the table below. Assuming no inflation, write an equation that predicts the total cost of one of your storage facilities. The objective is to produce a reasonable model that fits the existing data with an R 2 > 0.95. ("Reasonable" in this case excludes anything greater than a 3rd order polynomial.)

Floors | Gross Floor Area (ft2) | Perimeter (ft) | Total Cost 600 200 $2,084,440 500 103 $1,703,173.5 1000 800 $3,659,600 1435 450 $6,158,784 2000 179 $5,341,878.5 600 98 $1,800,574 780 74 $2,295,105 1400 500 $6.347.960 600 196 $1,800,574 3000 219 $8,248,677 600 600 $4,032,540 4000 800 $14,638,400 600 100 $1,666,990 400 234 $1,669,782 2540 700 $9,390,006 600 500 $4.310.840 0304845047000260 st 4 7 0 877067 7449804 0416777197644 16700519565 C4398-05708236900 s055-409404366691 07613823820 6 6 3 3 02136512618 4-1119 ri 03009 069000400 e-0005784091000 00 P2184-975-268-275 00003000000000040 t000-400S-400000050 6511267163646426 F23-41234-2341234