The Length, Width, Price Survey Tool computes the min, max, mean, median 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.
INSTRUCTIONS: Enter rows of three numbers separated by commas:
- (L,W,P) Length and Width in Feet 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 product option. This list is then sorted by Price per Area from least to most expensive.
Example
Data Entered for decking boards price survey of L,W,P where L is length in feet, W is width in inches and P is price per board. The first row is 3,6,2,57 for 3 foot long, six inches wide for $2.57 per board, and so forth.
3,6,2.57
4,6,3.46
6,6,5.64
8,6,6.84
10,6,8.7
12,6,10.53
14,6,13.16
16,6,14.37
18,6,22.69
20,6,25.18
22,6,44.4
24,6,48.41
Example Stats
- (n)Number of Samples: 12
- (Avg) Average Price per Square Feet: 2.28 USD/ft²
- (Min) Minimum Price per Square Feet: 1.71 USD/ft²
- (Max) Maximum Price per Area: 4.04 USD/ft²
- (Med) Median Price per Square Feet: 1.84 USD/ft²
- (MP) Midpoint Price per Square Feet: 2.87 USD/ft²
- (Rng)Range of Prices per Square Feet: 2.33 USD/ft²
- SURVEY: Economy, Low, Mid, High, Premium, n: 1.71,1.74,1.84,2.52,4.04,12
- Economy = $1.71
- Low = $1.74
- Mid = $1.84
- High = $2.52
- Premium = $4.04
- Sample Size (n) = 12
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: