The Tile Price Survey Tool computes the min, max, mean, median dollars per square feet for a sample of tiles based their lengths, widths and prices, where the lengths and widths are in inches and prices are in dollars.
INSTRUCTIONS: Enter rows of three numbers separated by commas:
- TD(L,W,P) Length and Width in inches and price in dollars
- (Example. 3,4,5.25)
- (RC) Report Choice of STATS for SORT.
Tile Survey Stats: The tool returns the following for the set of values entered.
- (n) Number of Samples
- (Avg) Average Price per Area in USD/ft²
- (Min) Minimum Price per Area in USD/ft²
- (Max) Maximum Price per Area in USD/ft²
- (MP) Midpoint Price per Area in USD/ft²
- (Rng) Range of Prices per Area in USD/ft²
- (SURVEY):
- Price Points: Economy, Low, Mid, High, Premium
- Sample Size: n
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.
Example
Data Entered for ceramic tile price survey of L,W,P where L is length in inches, W is width in inches and P is price per tile. The first row is for a 12”x12" tile at $4.44 per tile. The second row is for a 4”x12" tile at $1.24 per tile and so forth.12,12,4.44
4,12,1.24
11,13,3.55
12,24,1.77
6,24,1.24
12,12,8.89
12,13,8
10,14,8.85
11.5,14,8.23
12,12,5.78
9,12,4.44
3,6,0.13
4.25,4.25,0.13
3,6,0.26
6,6,0.35
STATS Results:
- (n)Number of Samples: 15
- (avg)Average Price per Square Feet: 4.26 USD/ft²
- (mn)Minimum Price per Square Feet: 0.88 USD/ft²
- (mx)Maximum Price per Square Feet: 9.1 USD/ft²
- (Med) Median Price per Square Feet: 3.65 USD/ft²
- (mp)Midpoint Price per Square Feet: 4.99 USD/ft²
- (rng)Range of Prices per Square Feet: 8.22 USD/ft²
SORT Results: L,W,P,A,PSF
[24.0, 12.0, 1.77, 2, 0.89]
[6.0, 3.0, 0.13, 0.13, 1.04]
[4.25, 4.25, 0.13, 0.13, 1.04]
[24.0, 6.0, 1.24, 1, 1.24]
[6.0, 6.0, 0.35, 0.25, 1.4]
[6.0, 3.0, 0.26, 0.13, 2.08]
[13.0, 11.0, 3.55, 0.99, 3.57]
[12.0, 4.0, 1.24, 0.33, 3.72]
[12.0, 12.0, 4.44, 1, 4.44]
[12.0, 12.0, 5.78, 1, 5.78]
[12.0, 9.0, 4.44, 0.75, 5.92]
[14.0, 11.5, 8.23, 1.12, 7.36]
[13.0, 12.0, 8.0, 1.08, 7.38]
[12.0, 12.0, 8.89, 1, 8.89]
[14.0, 10.0, 8.85, 0.97, 9.1]
Price Survey Calculators
- Board Price Survey Tool: (Inch, Feet, Price) Computes the sample size, min, max, mean, median, midpoint and range of dollars per square feet for a sample of boards based their lengths, widths and prices, where the board widths are in inches, lengths in feet and prices are in dollars. It also has a sort function for the input data. This is useful for flooring boards, siding, and some roofing products.
- Length Width Price Survey Tool: (Feet, Feet, Price) Computes the sample size, min, max, mean, median, midpoint and range of dollars per square feet for a sample of products based their lengths, widths and prices, where the length and widths are in feet and prices are in dollars. It also has a sort function for the input data. This is useful for flooring boards, siding, and some roofing products.
- Square Feet Pricing Survey Tool: (Square Feet, Price) Computes the sample size, min, max, mean, median, midpoint and range of 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. This is useful in many flooring applications such a carpet.
- Tile Price Survey Tool: (Inch, Inch, Price) Computes the sample size, min, max, mean, median, midpoint and range of dollars per square feet for a sample of tiles based their lengths, widths and prices, where the lengths and widths are in inches and prices are in dollars. This is useful for ceramic tile, carpet tile, ceiling tile, pavers.
These statistical survey tools help populate the following dataset: