The Price per Square Feet Survey Tool computes the min, max, mean, median dollars per square feet for a sample of tiles based their area and prices, where the area is in square feet and prices are in dollars.
INSTRUCTIONS: Enter rows of three numbers separated by commas:
Price per Square Feet Survey Stats: The tool returns the following for the set of values entered.
If RC is set to SORT, the Price per Area is computed and appended to each tile option. This list is then sorted by Price per Area from least to most expensive.
Data Entered for square feet price survey of A,P where A is the area in square feet and P is the price per area. The first row is for a 54 square feet of linoleum at $22.22. The second row is for 1 square foot at $1.24, and so forth.
54,22.22
1,1.34
1,0.89
1,0.99
1,0.78
1,1.11
1,0.59
1,1.11
1,1.34
1,0.89
1,0.99
1,1.19
1,1.34
1,2.97
1,1.47
1,1.29
1,1.79
1,2.49
STATS Results:
SORT Results:
[A, P, PSF]
[54.0, 22.22, 0.41]
[1.0, 0.59, 0.59]
[1.0, 0.78, 0.78]
[1.0, 0.89, 0.89]
[1.0, 0.89, 0.89]
[1.0, 0.99, 0.99]
[1.0, 0.99, 0.99]
[1.0, 1.11, 1.11]
[1.0, 1.11, 1.11]
[1.0, 1.19, 1.19]
[1.0, 1.29, 1.29]
[1.0, 1.34, 1.34]
[1.0, 1.34, 1.34]
[1.0, 1.34, 1.34]
[1.0, 1.47, 1.47]
[1.0, 1.79, 1.79]
[1.0, 2.49, 2.49]
[1.0, 2.97, 2.97]