Your human resources director has recently provided you with data on your Norcross and Dallas plants. Evaluate the data for Norcross only, Dallas only, and Norcross and Dallas combined.
| Store | Hours | Sales |
| 1 | 120 | $23,300 |
| 2 | 135 | $25,600 |
| 3 | 96 | $19,200 |
| 4 | 102 | $10,211 |
| 5 | 240 | $19,330 |
| 6 | 190 | $35,789 |
| 7 | 108 | $12,540 |
| 8 | 234 | $43,150 |
| 9 | 140 | $27,886 |
| 10 | 300 | $54,156 |
| 11 | 254 | $34,080 |
| 12 | 180 | $25,900 |
| 13 | 270 | $36,400 |
| 14 | 175 | $25,760 |
| 15 | 256 | $31,500 |
Using Excel
data -> data analysis -> descriptive statistics


We see that at Hourse increase, Sales increases too
There is positive correlation between Hours and Sales
Your human resources director has recently provided you with data on your Norcross and Dallas plants....
Jake's Auto Services' regional manager notices that the sale of two types of tires have been sluggish for the last few business cycles. Atlas tires and Continental tires brands are lagging compared to rivals such as Michelin that sell at a similar price point. Directions 1. Use the following Excel workbook that prepares you to analyze number-of-units-sold and total-sales for the two tire brands (Atlas tires and Continental tires). Data are reported by two retail outlets within the region as...