Question: Problem Statement A retail company is testing a new platform to promote and sell products to business customers. As part of the experiment to examine
Problem Statement
A retail company is testing a new platform to promote and sell products to business customers.
As part of the experiment to examine the effect of the new platform on sales, the following data was collected:
- 180 established business customers (or accounts) were randomly selected, and their average weekly order for the last 6 months was calculated.
- 90 randomly selected customers out of the 180 were routed to use the new platform. After six months, their average weekly order was calculated once again.
- Additional 90 new customers were routed to the new platform, and their average weekly orders were calculated after six months.
The experiment process generated three disjoint groups of customers:
| Group Name | Description | #customers |
| A | Assigned to new platform: The weekly order was calculated before and after the new platform | 90 |
| b | Did not experience the new platform: The weekly order was calculated twice by six months | 90 |
| C | Assigned to new platform: The weekly order was calculated only once after 6 months on the new platform | 90 |
Please note that the groups do not necessary correlate with different populations. The populations will be defined by the research question in each study.
Timeline of experiment:
May 1, 2021 (first measure, A & B) November 1, 2021 (second measure, A, B & C)
For each business customer, additional information was collected such as business "age" (numeric), "premium" (yes/no, whether the customer subscribes to the premium delivery), "industry" (primary, secondary, tertiary or quaternary), and "location" in the US (pacific/ eastern). In addition, the variable "measure" indicates whether the calculation corresponds to the first or second measurement. For the C group, there is only one "measure" that equates to the second measurement on the other groups.
Please use R commands or Rstudio to answer the following questions.
For each of the following research question:
- State the null and alternative hypotheses.
- Determine the appropriate hypothesis test and justify your selection.
- Run the hypothesis test and provide the R code with results.
- State the statistical conclusion
- Communicate the statistical conclusion within the context of the problem in plain English.
Use 0.02 significance level for all statistical tests.
- Is the average weekly order on the new platform greater than $5,900?
Hypotheses:
H0: _____________________________________________________
H1: _____________________________________________________
Statistical test and justification: _____________________________________________
Statistical test code and results: _____________________________________________
Statistical conclusion: _____________________________________________________
Conclusion within context: _________________________________________________
- Based on the data from May 1, 2021, is the proportion of customers that subscribe to the premium delivery while on the old platform less than 12%?
Hypotheses:
H0: _____________________________________________________
H1: _____________________________________________________
Statistical test and justification: _____________________________________________
Statistical test code and results: _____________________________________________
Statistical conclusion: _____________________________________________________
Conclusion within context: _________________________________________________
- Based on the data from November 1, 2021, when using the new platform, is there a difference in the average weekly order of customers located in the pacific versus eastern region?
Hypotheses:
H0: _____________________________________________________
H1: _____________________________________________________
Statistical test and justification: _____________________________________________
Statistical test code and results: _____________________________________________
Statistical conclusion: _____________________________________________________
Conclusion within context: _____________________________________________________
- Based on the data from November 1, 2021, is the average weekly order of customers that experience the new platform greater than those who did not?
Hypotheses:
H0: _____________________________________________________
H1: _____________________________________________________
Statistical test and justification: _____________________________________________
Statistical test code and results: _____________________________________________
Statistical conclusion: _____________________________________________________
Conclusion within context: _________________________________________________
- Based on the data from November 1, 2021, is the proportion of customers that subscribe to the premium delivery different between the old platform and new platform?
Hypotheses:
H0: _____________________________________________________
H1: _____________________________________________________
Statistical test and justification: _____________________________________________
Statistical test code and results: _____________________________________________
Statistical conclusion: _____________________________________________________
Conclusion within context: _________________________________________________
- Based on the data from group A, is the average weekly order after the new platform greater than on the old platform?
Hypotheses:
H0: _____________________________________________________
H1: _____________________________________________________
Statistical test and justification: _____________________________________________
Statistical test code and results: _____________________________________________
Statistical conclusion: _____________________________________________________
Conclusion within context: _________________________________________________
| customer | platform | type | measure | premium | age | industry | location | orders |
| 1 | old | A | first | no | 6 | primary | pacific | 5,345.94 |
| 2 | old | A | first | yes | 12 | quaternary | eastern | 4,821.59 |
| 3 | old | A | first | no | 8 | tertiary | pacific | 6,272.81 |
| 4 | old | A | first | yes | 11 | tertiary | pacific | 6,768.93 |
| 5 | old | A | first | no | 11 | quaternary | eastern | 4,010.05 |
| 6 | old | A | first | no | 13 | secondary | eastern | 5,087.74 |
| 7 | old | A | first | no | 14 | quaternary | eastern | 5,705.77 |
| 8 | old | A | first | no | 3 | tertiary | pacific | 5,657.64 |
| 9 | old | A | first | no | 8 | tertiary | eastern | 4,382.20 |
| 10 | old | A | first | no | 5 | quaternary | eastern | 6,368.85 |
| 11 | old | A | first | no | 14 | quaternary | eastern | 4,725.28 |
| 12 | old | A | first | no | 9 | tertiary | pacific | 3,416.43 |
| 13 | old | A | first | no | 11 | quaternary | pacific | 3,335.83 |
| 14 | old | A | first | yes | 15 | secondary | eastern | 6,124.94 |
| 15 | old | A | first | no | 4 | quaternary | pacific | 4,250.16 |
| 16 | old | A | first | no | 8 | quaternary | eastern | 5,370.10 |
| 17 | old | A | first | no | 15 | quaternary | pacific | 4,467.32 |
| 18 | old | A | first | no | 12 | secondary | pacific | 6,716.01 |
| 19 | old | A | first | no | 14 | quaternary | eastern | 5,087.34 |
| 20 | old | A | first | no | 4 | secondary | pacific | 5,619.67 |
| 21 | old | A | first | no | 13 | secondary | eastern | 4,473.68 |
| 22 | old | A | first | yes | 15 | primary | pacific | 4,917.27 |
| 23 | old | A | first | no | 14 | primary | pacific | 5,639.48 |
| 24 | old | A | first | no | 8 | primary | pacific | 5,488.54 |
| 25 | old | A | first | no | 7 | tertiary | eastern | 6,652.73 |
| 26 | old | A | first | no | 15 | primary | pacific | 3,862.92 |
| 27 | old | A | first | no | 11 | quaternary | eastern | 7,286.47 |
| 28 | old | A | first | no | 6 | secondary | pacific | 4,368.58 |
| 29 | old | A | first | no | 14 | quaternary | eastern | 4,402.19 |
| 30 | old | A | first | no | 13 | secondary | pacific | 3,430.43 |
| 31 | old | A | first | no | 14 | primary | eastern | 3,878.04 |
| 32 | old | A | first | no | 4 | tertiary | pacific | 5,491.90 |
| 33 | old | A | first | no | 7 | primary | eastern | 4,967.99 |
| 34 | old | A | first | no | 2 | secondary | eastern | 3,256.04 |
| 35 | old | A | first | no | 12 | primary | pacific | 4,097.27 |
| 36 | old | A | first | no | 9 | primary | pacific | 4,127.17 |
| 37 | old | A | first | no | 2 | primary | pacific | 4,954.12 |
| 38 | old | A | first | no | 3 | tertiary | eastern | 4,466.12 |
| 39 | old | A | first | no | 9 | primary | pacific | 5,190.92 |
| 40 | old | A | first | no | 15 | quaternary | eastern | 5,553.20 |
| 41 | old | A | first | no | 6 | quaternary | pacific | 4,343.98 |
| 42 | old | A | first | no | 6 | quaternary | eastern | 4,698.53 |
| 43 | old | A | first | no | 4 | tertiary | eastern | 5,548.55 |
| 44 | old | A | first | yes | 5 | tertiary | eastern | 4,986.00 |
| 45 | old | A | first | no | 13 | quaternary | pacific | 5,821.59 |
| 46 | old | A | first | yes | 6 | primary | eastern | 4,961.36 |
| 47 | old | A | first | no | 15 | quaternary | eastern | 4,349.92 |
| 48 | old | A | first | no | 7 | primary | pacific | 4,870.13 |
| 49 | old | A | first | yes | 1 | primary | pacific | 3,610.50 |
| 50 | old | A | first | no | 10 | primary | eastern | 6,505.54 |
| 51 | old | A | first | no | 4 | primary | pacific | 4,429.25 |
| 52 | old | A | first | no | 8 | secondary | eastern | 5,279.37 |
| 53 | old | A | first | no | 13 | primary | pacific | 4,118.87 |
| 54 | old | A | first | no | 3 | tertiary | pacific | 5,262.03 |
| 55 | old | A | first | no | 11 | tertiary | pacific | 3,240.20 |
| 56 | old | A | first | no | 14 | quaternary | eastern | 5,956.34 |
| 57 | old | A | first | no | 6 | quaternary | pacific | 3,378.98 |
| 58 | old | A | first | yes | 3 | quaternary | pacific | 5,143.52 |
| 59 | old | A | first | no | 15 | primary | pacific | 4,404.95 |
| 60 | old | A | first | no | 11 | quaternary | pacific | 4,632.18 |
| 61 | old | A | first | yes | 7 | secondary | pacific | 5,108.40 |
| 62 | old | A | first | no | 2 | tertiary | pacific | 4,822.31 |
| 63 | old | A | first | no | 2 | primary | pacific | 5,461.63 |
| 64 | old | A | first | no | 15 | primary | eastern | 6,338.69 |
| 65 | old | A | first | no | 14 | quaternary | eastern | 5,828.02 |
| 66 | old | A | first | no | 7 | tertiary | eastern | 5,170.22 |
| 67 | old | A | first | no | 7 | secondary | pacific | 5,128.87 |
| 68 | old | A | first | no | 8 | primary | pacific | 5,660.01 |
| 69 | old | A | first | no | 9 | tertiary | pacific | 5,088.12 |
| 70 | old | A | first | no | 11 | tertiary | pacific | 6,547.26 |
| 71 | old | A | first | no | 2 | tertiary | eastern | 4,457.15 |
| 72 | old | A | first | no | 5 | secondary | pacific | 5,506.53 |
| 73 | old | A | first | no | 12 | quaternary | eastern | 5,245.95 |
| 74 | old | A | first | no | 11 | tertiary | eastern | 4,934.91 |
| 75 | old | A | first | no | 9 | secondary | eastern | 5,469.29 |
| 76 | old | A | first | yes | 10 | quaternary | eastern | 3,147.16 |
| 77 | old | A | first | no | 6 | quaternary | pacific | 3,750.13 |
| 78 | old | A | first | no | 8 | quaternary | eastern | 4,870.92 |
| 79 | old | A | first | yes | 2 | primary | pacific | 5,583.17 |
| 80 | old | A | first | no | 2 | primary | pacific | 3,093.04 |
| 81 | old | A | first | no | 1 | quaternary | pacific | 3,509.50 |
| 82 | old | A | first | no | 5 | quaternary | eastern | 3,213.61 |
| 83 | old | A | first | no | 11 | primary | pacific | 3,322.44 |
| 84 | old | A | first | no | 12 | secondary | pacific | 4,060.25 |
| 85 | old | A | first | no | 11 | primary | pacific | 5,385.67 |
| 86 | old | A | first | no | 3 | primary | eastern | 3,876.44 |
| 87 | old | A | first | no | 1 | secondary | eastern | 5,415.51 |
| 88 | old | A | first | no | 13 | secondary | pacific | 5,267.21 |
| 89 | old | A | first | yes | 5 | primary | pacific | 3,101.79 |
| 90 | old | A | first | no | 12 | secondary | eastern | 4,179.71 |
| 91 | old | B | first | no | 6 | secondary | pacific | 4,520.79 |
| 92 | old | B | first | no | 2 | secondary | eastern | 4,770.85 |
| 93 | old | B | first | no | 2 | primary | pacific | 2,467.08 |
| 94 | old | B | first | no | 12 | tertiary | pacific | 4,972.87 |
| 95 | old | B | first | no | 13 | quaternary | eastern | 6,131.91 |
| 96 | old | B | first | no | 4 | secondary | pacific | 4,698.63 |
| 97 | old | B | first | no | 2 | secondary | eastern | 3,602.78 |
| 98 | old | B | first | no | 13 | primary | pacific | 4,842.24 |
| 99 | old | B | first | no | 5 | quaternary | eastern | 4,215.81 |
| 100 | old | B | first | no | 15 | tertiary | pacific | 3,753.24 |
| 101 | old | B | first | no | 9 | quaternary | eastern | 3,913.80 |
| 102 | old | B | first | no | 13 | tertiary | eastern | 5,715.65 |
| 103 | old | B | first | no | 9 | tertiary | pacific | 4,772.57 |
| 104 | old | B | first | no | 12 | secondary | pacific | 4,177.22 |
| 105 | old | B | first | no | 15 | quaternary | eastern | 5,038.07 |
| 106 | old | B | first | no | 13 | tertiary | eastern | 5,087.71 |
| 107 | old | B | first | no | 14 | tertiary | eastern | 5,881.58 |
| 108 | old | B | first | no | 6 | primary | eastern | 4,628.69 |
| 109 | old | B | first | no | 4 | quaternary | pacific | 6,473.97 |
| 110 | old | B | first | yes | 9 | tertiary | eastern | 4,333.58 |
| 111 | old | B | first | no | 5 | primary | pacific | 5,788.10 |
| 112 | old | B | first | no | 14 | tertiary | eastern | 5,480.61 |
| 113 | old | B | first | no | 13 | primary | eastern | 6,492.47 |
| 114 | old | B | first | no | 6 | secondary | eastern | 6,193.64 |
| 115 | old | B | first | no | 6 | primary | eastern | 3,843.54 |
| 116 | old | B | first | no | 15 | quaternary | pacific | 3,205.53 |
| 117 | old | B | first | no | 12 | quaternary | pacific | 3,702.77 |
| 118 | old | B | first | no | 12 | tertiary | eastern | 4,081.63 |
| 119 | old | B | first | no | 4 | secondary | pacific | 4,364.70 |
| 120 | old | B | first | no | 1 | primary | pacific | 5,155.42 |
| 121 | old | B | first | no | 5 | quaternary | pacific | 4,380.59 |
| 122 | old | B | first | no | 1 | tertiary | pacific | 4,208.36 |
| 123 | old | B | first | no | 14 | secondary | pacific | 6,003.20 |
| 124 | old | B | first | no | 9 | tertiary | pacific | 4,382.99 |
| 125 | old | B | first | no | 3 | tertiary | eastern | 5,494.31 |
| 126 | old | B | first | no | 13 | primary | eastern | 4,173.38 |
| 127 | old | B | first | yes | 5 | primary | eastern | 5,351.15 |
| 128 | old | B | first | no | 7 | secondary | eastern | 6,325.30 |
| 129 | old | B | first | no | 3 | quaternary | eastern | 4,385.76 |
| 130 | old | B | first | no | 2 | tertiary | pacific | 5,415.03 |
| 131 | old | B | first | no | 4 | primary | pacific | 4,456.34 |
| 132 | old | B | first | no | 11 | secondary | eastern | 2,888.05 |
| 133 | old | B | first | yes | 2 | quaternary | pacific | 3,161.18 |
| 134 | old | B | first | no | 2 | secondary | eastern | 4,921.87 |
| 135 | old | B | first | no | 6 | tertiary | pacific | 2,966.67 |
| 136 | old | B | first | no | 12 | secondary | pacific | 4,855.21 |
| 137 | old | B | first | no | 10 | secondary | eastern | 4,461.04 |
| 138 | old | B | first | no | 1 | secondary | eastern | 5,178.90 |
| 139 | old | B | first | no | 14 | secondary | eastern | 4,866.18 |
| 140 | old | B | first | no | 5 | secondary | pacific | 5,616.82 |
| 141 | old | B | first | no | 6 | secondary | pacific | 6,314.81 |
| 142 | old | B | first | no | 14 | quaternary | eastern | 5,285.03 |
| 143 | old | B | first | yes | 14 | primary | eastern | 3,694.93 |
| 144 | old | B | first | no | 9 | secondary | eastern | 3,584.79 |
| 145 | old | B | first | no | 3 | tertiary | eastern | 6,503.94 |
| 146 | old | B | first | no | 14 | tertiary | pacific | 3,774.61 |
| 147 | old | B | first | no | 5 | quaternary | pacific | 3,266.29 |
| 148 | old | B | first | no | 11 | tertiary | pacific | 5,214.74 |
| 149 | old | B | first | no | 7 | tertiary | pacific | 5,829.07 |
| 150 | old | B | first | no | 6 | tertiary | eastern | 4,073.93 |
| 151 | old | B | first | no | 7 | primary | eastern | 5,560.08 |
| 152 | old | B | first | no | 3 | tertiary | eastern | 3,907.95 |
| 153 | old | B | first | no | 14 | secondary | eastern | 5,623.80 |
| 154 | old | B | first | no | 7 | primary | pacific | 3,146.47 |
| 155 | old | B | first | yes | 13 | secondary | pacific | 4,943.32 |
| 156 | old | B | first | no | 9 | tertiary | pacific | 4,949.19 |
| 157 | old | B | first | no | 7 | primary | eastern | 5,236.12 |
| 158 | old | B | first | no | 12 | quaternary | pacific | 4,982.97 |
| 159 | old | B | first | no | 11 | secondary | eastern | 4,262.67 |
| 160 | old | B | first | no | 3 | quaternary | pacific | 5,770.76 |
| 161 | old | B | first | no | 10 | quaternary | pacific | 5,805.95 |
| 162 | old | B | first | no | 14 | primary | pacific | 5,180.11 |
| 163 | old | B | first | no | 3 | secondary | eastern | 4,555.58 |
| 164 | old | B | first | no | 13 | quaternary | eastern | 3,261.50 |
| 165 | old | B | first | no | 13 | primary | pacific | 5,379.01 |
| 166 | old | B | first | yes | 2 | tertiary | eastern | 5,089.02 |
| 167 | old | B | first | no | 3 | secondary | pacific | 4,810.57 |
| 168 | old | B | first | no | 9 | tertiary | eastern | 4,419.53 |
| 169 | old | B | first | no | 5 | tertiary | pacific | 3,838.77 |
| 170 | old | B | first | no | 15 | primary | pacific | 5,209.24 |
| 171 | old | B | first | no | 2 | primary | eastern | 4,961.59 |
| 172 | old | B | first | no | 4 | quaternary | eastern | 4,568.08 |
| 173 | old | B | first | no | 5 | tertiary | eastern | 6,155.71 |
| 174 | old | B | first | no | 10 | tertiary | pacific | 5,591.36 |
| 175 | old | B | first | no | 1 | quaternary | eastern | 4,899.97 |
| 176 | old | B | first | no | 9 | quaternary | eastern | 5,498.04 |
| 177 | old | B | first | no | 7 | tertiary | eastern | 3,642.79 |
| 178 | old | B | first | no | 8 | quaternary | eastern | 5,039.32 |
| 179 | old | B | first | no | 10 | quaternary | eastern | 4,356.95 |
| 180 | old | B | first | no | 9 | primary | eastern | 4,487.58 |
| 1 | new | A | second | no | 6 | primary | pacific | 6,297.62 |
| 2 | new | A | second | no | 12 | quaternary | eastern | 5,399.73 |
| 3 | new | A | second | no | 8 | tertiary | pacific | 6,384.61 |
| 4 | new | A | second | no | 11 | tertiary | pacific | 7,415.82 |
| 5 | new | A | second | yes | 11 | quaternary | eastern | 5,519.70 |
| 6 | new | A | second | no | 13 | secondary | eastern | 6,451.30 |
| 7 | new | A | second | no | 14 | quaternary | eastern | 6,780.57 |
| 8 | new | A | second | yes | 3 | tertiary | pacific | 6,785.24 |
| 9 | new | A | second | no | 8 | tertiary | eastern | 5,417.81 |
| 10 | new | A | second | no | 5 | quaternary | eastern | 6,688.68 |
| 11 | new | A | second | no | 14 | quaternary | eastern | 5,854.33 |
| 12 | new | A | second | yes | 9 | tertiary | pacific | 5,380.64 |
| 13 | new | A | second | no | 11 | quaternary | pacific | 4,424.91 |
| 14 | new | A | second | no | 15 | secondary | eastern | 7,456.81 |
| 15 | new | A | second | no | 4 | quaternary | pacific | 4,938.23 |
| 16 | new | A | second | yes | 8 | quaternary | eastern | 6,072.20 |
| 17 | new | A | second | no | 15 | quaternary | pacific | 5,790.45 |
| 18 | new | A | second | no | 12 | secondary | pacific | 7,522.87 |
| 19 | new | A | second | yes | 14 | quaternary | eastern | 6,769.40 |
| 20 | new | A | second | no | 4 | secondary | pacific | 6,370.37 |
| 21 | new | A | second | no | 13 | secondary | eastern | 5,065.24 |
| 22 | new | A | second | no | 15 | primary | pacific | 5,787.66 |
| 23 | new | A | second | yes | 14 | primary | pacific | 6,688.39 |
| 24 | new | A | second | no | 8 | primary | pacific | 7,186.94 |
| 25 | new | A | second | no | 7 | tertiary | eastern | 7,650.95 |
| 26 | new | A | second | no | 15 | primary | pacific | 4,632.26 |
| 27 | new | A | second | no | 11 | quaternary | eastern | 8,215.96 |
| 28 | new | A | second | no | 6 | secondary | pacific | 5,597.44 |
| 29 | new | A | second | yes | 14 | quaternary | eastern | 6,278.80 |
| 30 | new | A | second | yes | 13 | secondary | pacific | 3,715.45 |
| 31 | new | A | second | no | 14 | primary | eastern | 4,505.95 |
| 32 | new | A | second | yes | 4 | tertiary | pacific | 6,156.16 |
| 33 | new | A | second | no | 7 | primary | eastern | 6,128.24 |
| 34 | new | A | second | no | 2 | secondary | eastern | 4,421.98 |
| 35 | new | A | second | no | 12 | primary | pacific | 5,239.75 |
| 36 | new | A | second | yes | 9 | primary | pacific | 4,172.97 |
| 37 | new | A | second | no | 2 | primary | pacific | 6,504.89 |
| 38 | new | A | second | no | 3 | tertiary | eastern | 4,855.34 |
| 39 | new | A | second | no | 9 | primary | pacific | 5,791.08 |
| 40 | new | A | second | no | 15 | quaternary | eastern | 6,206.51 |
| 41 | new | A | second | yes | 6 | quaternary | pacific | 4,877.23 |
| 42 | new | A | second | no | 6 | quaternary | eastern | 6,587.62 |
| 43 | new | A | second | no | 4 | tertiary | eastern | 5,799.91 |
| 44 | new | A | second | no | 5 | tertiary | eastern | 5,485.78 |
| 45 | new | A | second | no | 13 | quaternary | pacific | 6,626.61 |
| 46 | new | A | second | yes | 6 | primary | eastern | 6,332.80 |
| 47 | new | A | second | yes | 15 | quaternary | eastern | 5,626.87 |
| 48 | new | A | second | yes | 7 | primary | pacific | 5,648.08 |
| 49 | new | A | second | no | 1 | primary | pacific | 4,374.09 |
| 50 | new | A | second | no | 10 | primary | eastern | 7,494.58 |
| 51 | new | A | second | yes | 4 | primary | pacific | 5,189.70 |
| 52 | new | A | second | yes | 8 | secondary | eastern | 6,803.02 |
| 53 | new | A | second | no | 13 | primary | pacific | 6,253.95 |
| 54 | new | A | second | yes | 3 | tertiary | pacific | 5,655.42 |
| 55 | new | A | second | no | 11 | tertiary | pacific | 3,664.28 |
| 56 | new | A | second | yes | 14 | quaternary | eastern | 7,096.78 |
| 57 | new | A | second | yes | 6 | quaternary | pacific | 3,597.15 |
| 58 | new | A | second | no | 3 | quaternary | pacific | 5,721.06 |
| 59 | new | A | second | yes | 15 | primary | pacific | 5,449.50 |
| 60 | new | A | second | no | 11 | quaternary | pacific | 5,624.81 |
| 61 | new | A | second | no | 7 | secondary | pacific | 7,333.44 |
| 62 | new | A | second | no | 2 | tertiary | pacific | 5,656.56 |
| 63 | new | A | second | no | 2 | primary | pacific | 6,733.10 |
| 64 | new | A | second | no | 15 | primary | eastern | 7,189.47 |
| 65 | new | A | second | no | 14 | quaternary | eastern | 6,778.75 |
| 66 | new | A | second | no | 7 | tertiary | eastern | 5,684.42 |
| 67 | new | A | second | no | 7 | secondary | pacific | 6,335.40 |
| 68 | new | A | second | no | 8 | primary | pacific | 6,627.82 |
| 69 | new | A | second | no | 9 | tertiary | pacific | 5,028.66 |
| 70 | new | A | second | yes | 11 | tertiary | pacific | 7,418.26 |
| 71 | new | A | second | no | 2 | tertiary | eastern | 5,738.66 |
| 72 | new | A | second | no | 5 | secondary | pacific | 6,921.05 |
| 73 | new | A | second | no | 12 | quaternary | eastern | 5,989.41 |
| 74 | new | A | second | no | 11 | tertiary | eastern | 5,951.55 |
| 75 | new | A | second | no | 9 | secondary | eastern | 5,929.48 |
| 76 | new | A | second | no | 10 | quaternary | eastern | 5,283.94 |
| 77 | new | A | second | no | 6 | quaternary | pacific | 3,894.63 |
| 78 | new | A | second | no | 8 | quaternary | eastern | 6,540.70 |
| 79 | new | A | second | no | 2 | primary | pacific | 7,604.78 |
| 80 | new | A | second | no | 2 | primary | pacific | 4,218.49 |
| 81 | new | A | second | no | 1 | quaternary | pacific | 3,684.05 |
| 82 | new | A | second | no | 5 | quaternary | eastern | 3,644.84 |
| 83 | new | A | second | yes | 11 | primary | pacific | 3,221.80 |
| 84 | new | A | second | yes | 12 | secondary | pacific | 5,761.21 |
| 85 | new | A | second | yes | 11 | primary | pacific | 5,396.61 |
| 86 | new | A | second | no | 3 | primary | eastern | 5,443.07 |
| 87 | new | A | second | yes | 1 | secondary | eastern | 6,220.43 |
| 88 | new | A | second | no | 13 | secondary | pacific | 6,523.90 |
| 89 | new | A | second | no | 5 | primary | pacific | 4,333.41 |
| 90 | new | A | second | yes | 12 | secondary | eastern | 4,855.94 |
| 91 | old | B | second | no | 6 | secondary | pacific | 4,591.02 |
| 92 | old | B | second | no | 2 | secondary | eastern | 4,880.14 |
| 93 | old | B | second | no | 2 | primary | pacific | 2,582.37 |
| 94 | old | B | second | no | 12 | tertiary | pacific | 5,018.64 |
| 95 | old | B | second | no | 13 | quaternary | eastern | 6,176.79 |
| 96 | old | B | second | no | 4 | secondary | pacific | 4,828.78 |
| 97 | old | B | second | no | 2 | secondary | eastern | 3,640.76 |
| 98 | old | B | second | no | 13 | primary | pacific | 4,866.09 |
| 99 | old | B | second | no | 5 | quaternary | eastern | 4,270.06 |
| 100 | old | B | second | no | 15 | tertiary | pacific | 3,878.56 |
| 101 | old | B | second | no | 9 | quaternary | eastern | 4,060.20 |
| 102 | old | B | second | no | 13 | tertiary | eastern | 5,778.53 |
| 103 | old | B | second | no | 9 | tertiary | pacific | 4,885.75 |
| 104 | old | B | second | no | 12 | secondary | pacific | 4,267.56 |
| 105 | old | B | second | no | 15 | quaternary | eastern | 5,023.26 |
| 106 | old | B | second | no | 13 | tertiary | eastern | 5,149.85 |
| 107 | old | B | second | no | 14 | tertiary | eastern | 5,945.95 |
| 108 | old | B | second | no | 6 | primary | eastern | 4,740.47 |
| 109 | old | B | second | no | 4 | quaternary | pacific | 6,559.77 |
| 110 | old | B | second | no | 9 | tertiary | eastern | 4,484.32 |
| 111 | old | B | second | yes | 5 | primary | pacific | 5,798.96 |
| 112 | old | B | second | no | 14 | tertiary | eastern | 5,625.71 |
| 113 | old | B | second | no | 13 | primary | eastern | 6,573.24 |
| 114 | old | B | second | yes | 6 | secondary | eastern | 6,337.32 |
| 115 | old | B | second | no | 6 | primary | eastern | 3,926.91 |
| 116 | old | B | second | no | 15 | quaternary | pacific | 3,355.21 |
| 117 | old | B | second | no | 12 | quaternary | pacific | 3,787.05 |
| 118 | old | B | second | no | 12 | tertiary | eastern | 4,039.34 |
| 119 | old | B | second | no | 4 | secondary | pacific | 4,470.92 |
| 120 | old | B | second | no | 1 | primary | pacific | 5,251.61 |
| 121 | old | B | second | no | 5 | quaternary | pacific | 4,493.57 |
| 122 | old | B | second | no | 1 | tertiary | pacific | 4,307.15 |
| 123 | old | B | second | no | 14 | secondary | pacific | 6,100.21 |
| 124 | old | B | second | no | 9 | tertiary | pacific | 4,427.54 |
| 125 | old | B | second | no | 3 | tertiary | eastern | 5,615.15 |
| 126 | old | B | second | no | 13 | primary | eastern | 4,360.72 |
| 127 | old | B | second | yes | 5 | primary | eastern | 5,385.73 |
| 128 | old | B | second | no | 7 | secondary | eastern | 6,359.27 |
| 129 | old | B | second | no | 3 | quaternary | eastern | 4,509.80 |
| 130 | old | B | second | no | 2 | tertiary | pacific | 5,529.96 |
| 131 | old | B | second | no | 4 | primary | pacific | 4,553.55 |
| 132 | old | B | second | no | 11 | secondary | eastern | 2,969.38 |
| 133 | old | B | second | no | 2 | quaternary | pacific | 3,187.27 |
| 134 | old | B | second | no | 2 | secondary | eastern | 4,948.15 |
| 135 | old | B | second | no | 6 | tertiary | pacific | 3,059.76 |
| 136 | old | B | second | no | 12 | secondary | pacific | 4,959.90 |
| 137 | old | B | second | no | 10 | secondary | eastern | 4,570.83 |
| 138 | old | B | second | no | 1 | secondary | eastern | 5,210.30 |
| 139 | old | B | second | no | 14 | secondary | eastern | 4,824.83 |
| 140 | old | B | second | no | 5 | secondary | pacific | 5,751.46 |
| 141 | old | B | second | no | 6 | secondary | pacific | 6,400.84 |
| 142 | old | B | second | no | 14 | quaternary | eastern | 5,419.87 |
| 143 | old | B | second | no | 14 | primary | eastern | 3,776.29 |
| 144 | old | B | second | yes | 9 | secondary | eastern | 3,610.94 |
| 145 | old | B | second | no | 3 | tertiary | eastern | 6,585.28 |
| 146 | old | B | second | no | 14 | tertiary | pacific | 3,804.92 |
| 147 | old | B | second | no | 5 | quaternary | pacific | 3,383.95 |
| 148 | old | B | second | no | 11 | tertiary | pacific | 5,391.11 |
| 149 | old | B | second | no | 7 | tertiary | pacific | 5,920.98 |
| 150 | old | B | second | no | 6 | tertiary | eastern | 4,263.46 |
| 151 | old | B | second | no | 7 | primary | eastern | 5,707.66 |
| 152 | old | B | second | no | 3 | tertiary | eastern | 4,026.70 |
| 153 | old | B | second | yes | 14 | secondary | eastern | 5,691.36 |
| 154 | old | B | second | no | 7 | primary | pacific | 3,293.27 |
| 155 | old | B | second | no | 13 | secondary | pacific | 5,032.91 |
| 156 | old | B | second | yes | 9 | tertiary | pacific | 5,061.51 |
| 157 | old | B | second | no | 7 | primary | eastern | 5,329.82 |
| 158 | old | B | second | no | 12 | quaternary | pacific | 5,043.39 |
| 159 | old | B | second | no | 11 | secondary | eastern | 4,457.05 |
| 160 | old | B | second | yes | 3 | quaternary | pacific | 5,923.70 |
| 161 | old | B | second | no | 10 | quaternary | pacific | 5,981.91 |
| 162 | old | B | second | no | 14 | primary | pacific | 5,299.60 |
| 163 | old | B | second | yes | 3 | secondary | eastern | 4,675.24 |
| 164 | old | B | second | no | 13 | quaternary | eastern | 3,368.00 |
| 165 | old | B | second | no | 13 | primary | pacific | 5,507.70 |
| 166 | old | B | second | no | 2 | tertiary | eastern | 5,265.02 |
| 167 | old | B | second | no | 3 | secondary | pacific | 4,862.85 |
| 168 | old | B | second | yes | 9 | tertiary | eastern | 4,548.99 |
| 169 | old | B | second | no | 5 | tertiary | pacific | 3,914.92 |
| 170 | old | B | second | no | 15 | primary | pacific | 5,282.94 |
| 171 | old | B | second | no | 2 | primary | eastern | 5,074.05 |
| 172 | old | B | second | no | 4 | quaternary | eastern | 4,678.62 |
| 173 | old | B | second | no | 5 | tertiary | eastern | 6,241.14 |
| 174 | old | B | second | no | 10 | tertiary | pacific | 5,616.99 |
| 175 | old | B | second | no | 1 | quaternary | eastern | 4,940.94 |
| 176 | old | B | second | no | 9 | quaternary | eastern | 5,534.58 |
| 177 | old | B | second | no | 7 | tertiary | eastern | 3,683.65 |
| 178 | old | B | second | no | 8 | quaternary | eastern | 5,150.48 |
| 179 | old | B | second | no | 10 | quaternary | eastern | 4,492.97 |
| 180 | old | B | second | no | 9 | primary | eastern | 4,467.31 |
| 181 | new | C | second | no | 3 | tertiary | pacific | 6,200.55 |
| 182 | new | C | second | yes | 9 | secondary | pacific | 7,211.76 |
| 183 | new | C | second | no | 10 | quaternary | eastern | 6,189.26 |
| 184 | new | C | second | no | 8 | quaternary | eastern | 5,183.99 |
| 185 | new | C | second | yes | 10 | quaternary | eastern | 5,236.51 |
| 186 | new | C | second | yes | 6 | secondary | eastern | 5,115.49 |
| 187 | new | C | second | no | 9 | primary | pacific | 5,962.19 |
| 188 | new | C | second | no | 10 | secondary | eastern | 6,145.75 |
| 189 | new | C | second | yes | 4 | secondary | eastern | 8,254.34 |
| 190 | new | C | second | yes | 7 | quaternary | eastern | 5,136.72 |
| 191 | new | C | second | yes | 5 | secondary | pacific | 3,941.78 |
| 192 | new | C | second | yes | 8 | primary | eastern | 6,020.03 |
| 193 | new | C | second | no | 5 | quaternary | pacific | 5,763.30 |
| 194 | new | C | second | yes | 6 | primary | pacific | 4,864.28 |
| 195 | new | C | second | no | 15 | tertiary | pacific | 3,983.81 |
| 196 | new | C | second | no | 5 | tertiary | pacific | 4,005.69 |
| 197 | new | C | second | yes | 12 | primary | eastern | 5,766.63 |
| 198 | new | C | second | no | 6 | secondary | eastern | 6,627.82 |
| 199 | new | C | second | no | 5 | tertiary | eastern | 4,557.22 |
| 200 | new | C | second | no | 7 | primary | pacific | 5,714.47 |
| 201 | new | C | second | no | 12 | primary | pacific | 5,395.89 |
| 202 | new | C | second | yes | 12 | tertiary | pacific | 7,361.50 |
| 203 | new | C | second | no | 1 | secondary | pacific | 5,996.13 |
| 204 | new | C | second | no | 5 | secondary | pacific | 5,491.88 |
| 205 | new | C | second | yes | 5 | tertiary | eastern | 6,186.69 |
| 206 | new | C | second | no | 7 | secondary | pacific | 8,207.55 |
| 207 | new | C | second | no | 6 | primary | pacific | 5,521.46 |
| 208 | new | C | second | yes | 5 | secondary | pacific | 4,077.62 |
| 209 | new | C | second | no | 2 | secondary | eastern | 8,103.44 |
| 210 | new | C | second | yes | 1 | primary | eastern | 5,622.19 |
| 211 | new | C | second | no | 8 | secondary | eastern | 7,072.14 |
| 212 | new | C | second | no | 2 | tertiary | eastern | 7,107.52 |
| 213 | new | C | second | yes | 5 | primary | eastern | 5,426.31 |
| 214 | new | C | second | no | 12 | secondary | eastern | 4,702.45 |
| 215 | new | C | second | yes | 12 | tertiary | pacific | 7,711.43 |
| 216 | new | C | second | yes | 2 | quaternary | pacific | 6,110.20 |
| 217 | new | C | second | no | 11 | tertiary | pacific | 4,434.93 |
| 218 | new | C | second | no | 6 | tertiary | eastern | 7,286.67 |
| 219 | new | C | second | no | 1 | quaternary | eastern | 5,320.34 |
| 220 | new | C | second | yes | 4 | tertiary | eastern | 8,153.19 |
| 221 | new | C | second | yes | 3 | tertiary | pacific | 5,769.10 |
| 222 | new | C | second | no | 8 | tertiary | pacific | 5,073.50 |
| 223 | new | C | second | no | 1 | secondary | eastern | 6,290.61 |
| 224 | new | C | second | no | 2 | tertiary | eastern | 6,007.03 |
| 225 | new | C | second | yes | 4 | quaternary | eastern | 7,311.64 |
| 226 | new | C | second | yes | 11 | tertiary | pacific | 5,129.21 |
| 227 | new | C | second | no | 15 | secondary | eastern | 5,453.77 |
| 228 | new | C | second | yes | 5 | tertiary | eastern | 4,329.50 |
| 229 | new | C | second | no | 13 | tertiary | pacific | 6,349.87 |
| 230 | new | C | second | yes | 1 | secondary | pacific | 6,173.69 |
| 231 | new | C | second | yes | 11 | secondary | eastern | 7,644.26 |
| 232 | new | C | second | no | 9 | quaternary | eastern | 6,655.82 |
| 233 | new | C |
