HW2.1.xlsx

Sheet1

Bob's Dice Shop
Quarterly Sales
Q1 Q2 Q3 Q4 Total per Category
d4 $257.35 $234.98 $102.66 $186.99 $781.98
d6 112.22 145.47 132.74 221.33 611.76
d8 87.65 108.00 299.35 167.54 662.54
d10 99.53 45.44 88.23 285.22 518.42
d12 67.99 54.73 45.77 88.00 256.49
d20 305.22 442.77 567.99 789.29 2,105.27
Total for Quarter $929.96 $1,031.39 $1,236.74 $1,738.37
Quarter one total sales equal quarter four sales.
Quarter three total sales are at least as much as quarter two total sales.
Quarter two and quarter three total sales are greater than $1000
We sold more than $100 of either d6 or d12 in quarter one.
We sold more than $100 of either d6 or d20 in quarter one, but not both.
Quarter one d4 sales are greater than quarter one d20 sales.
We did not sell the same amount of d4 in quarters one and two.
Quarter three total sales are the same or less than quarter two.
Quarter one total sales are less than quarter four total sales.
Quarter two total sales are greater than quarter one, and less than quarter 3.