In: Economics
Region | Sales | Labor Costs | Materials Costs |
1 | $2,055,279.00 | $38,313.00 | $17,989.00 |
2 | $2,238,758.00 | $63,294.00 | $21,659.00 |
3 | $1,143,833.00 | $40,570.00 | $25,403.00 |
4 | $1,901,107.00 | $54,704.00 | $24,436.00 |
5 | $2,194,766.00 | $52,411.00 | $17,782.00 |
6 | $1,329,758.00 | $37,071.00 | $24,827.00 |
7 | $1,510,285.00 | $42,391.00 | $18,448.00 |
8 | $2,086,502.00 | $50,228.00 | $20,053.00 |
9 | $2,328,835.00 | $42,438.00 | $23,983.00 |
10 | $1,950,095.00 | $40,898.00 | $15,993.00 |
Please include excel formulas if possible.
For the dataset above answer the following:
a. What are average sales when labor costs exceed $50,000?
b. What are minimum sales when materials costs are less than $20,000?
c. What region had the highest labor costs?
d. What region has the lowest sales?
e. What was the greatest differences in sales across any two regions?