Number 3 (499)
tandr102Quiz3StatisticsData.xlsx
DataCom_Data
Salaries and Potentially Related Data for Selected DataCom Employees | ||||||||||
Salary Christopher J. Zappe: Current annual salary (in dollars). | Years_Previous_Experience Christopher J. Zappe: Number of years of relevant work experience prior to coming to DataCom. | Years_Employed Christopher J. Zappe: Number of years employed at DataCom. | Years_Education Christopher J. Zappe: Number years of education beyond high school. | Gender Christopher J. Zappe: 0=Female, 1=Male | Number_Supervised Christopher J. Zappe: Number of employees supervised by this employee. | Department_1 | Department_2 | Department_3 | Department_4 | Department Christopher J. Zappe: 1=Sales, 2=Purchasing, 3=Advertising, 4=Engineering. |
$65,487 | 0 | 27 | 12 | 1 | 44 | 0 | 0 | 0 | 1 | 4 |
$46,184 | 3 | 20 | 4 | 0 | 1 | 0 | 0 | 0 | 1 | 4 |
$32,782 | 1 | 0 | 7 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |
$54,899 | 5 | 12 | 8 | 1 | 0 | 0 | 0 | 0 | 1 | 4 |
$34,869 | 5 | 7 | 4 | 1 | 1 | 0 | 0 | 0 | 1 | 4 |
$35,487 | 2 | 8 | 2 | 1 | 2 | 0 | 0 | 0 | 1 | 4 |
$26,548 | 1 | 5 | 0 | 0 | 2 | 0 | 0 | 0 | 1 | 4 |
$32,920 | 3 | 15 | 9 | 1 | 4 | 1 | 0 | 0 | 0 | 1 |
$29,548 | 6 | 5 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |
$34,231 | 2 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 1 | 4 |
$23,654 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 0 | 3 |
$39,331 | 3 | 9 | 6 | 1 | 1 | 0 | 0 | 0 | 1 | 4 |
$36,512 | 6 | 6 | 4 | 1 | 2 | 0 | 0 | 0 | 1 | 4 |
$35,467 | 6 | 3 | 6 | 1 | 3 | 0 | 1 | 0 | 0 | 2 |
$68,425 | 2 | 25 | 12 | 0 | 1 | 0 | 0 | 0 | 1 | 4 |
$35,468 | 5 | 9 | 4 | 1 | 5 | 0 | 1 | 0 | 0 | 2 |
$36,578 | 4 | 4 | 8 | 0 | 8 | 0 | 0 | 1 | 0 | 3 |
$39,828 | 6 | 18 | 5 | 1 | 5 | 1 | 0 | 0 | 0 | 1 |
$36,487 | 5 | 6 | 2 | 0 | 3 | 0 | 0 | 0 | 1 | 4 |
$37,548 | 9 | 19 | 4 | 0 | 6 | 0 | 0 | 1 | 0 | 3 |
$31,528 | 11 | 3 | 3 | 0 | 6 | 1 | 0 | 0 | 0 | 1 |
$34,632 | 4 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 4 |
$46,211 | 5 | 14 | 6 | 1 | 5 | 0 | 0 | 0 | 1 | 4 |
$29,876 | 0 | 2 | 3 | 1 | 5 | 0 | 1 | 0 | 0 | 2 |
$43,674 | 9 | 6 | 4 | 0 | 2 | 0 | 1 | 0 | 0 | 2 |
$38,985 | 7 | 18 | 9 | 0 | 5 | 1 | 0 | 0 | 0 | 1 |
$53,234 | 0 | 25 | 6 | 0 | 3 | 0 | 0 | 1 | 0 | 3 |
$51,698 | 6 | 18 | 6 | 0 | 1 | 0 | 0 | 0 | 1 | 4 |
$41,889 | 16 | 22 | 7 | 0 | 7 | 1 | 0 | 0 | 0 | 1 |
$38,791 | 4 | 21 | 5 | 0 | 9 | 1 | 0 | 0 | 0 | 1 |
$69,246 | 3 | 22 | 10 | 0 | 45 | 0 | 0 | 0 | 1 | 4 |
$48,695 | 19 | 6 | 8 | 0 | 40 | 0 | 0 | 0 | 1 | 4 |
$34,987 | 6 | 9 | 2 | 1 | 3 | 0 | 0 | 0 | 1 | 4 |
$28,985 | 1 | 0 | 4 | 1 | 4 | 1 | 0 | 0 | 0 | 1 |
$35,631 | 4 | 6 | 4 | 0 | 2 | 0 | 0 | 0 | 1 | 4 |
$54,679 | 3 | 20 | 6 | 1 | 4 | 0 | 0 | 1 | 0 | 3 |
$39,743 | 6 | 9 | 5 | 1 | 1 | 0 | 0 | 0 | 1 | 4 |
$41,255 | 4 | 9 | 6 | 0 | 4 | 0 | 0 | 0 | 1 | 4 |
$36,431 | 4 | 9 | 4 | 1 | 2 | 0 | 1 | 0 | 0 | 2 |
$26,578 | 6 | 0 | 2 | 1 | 2 | 0 | 1 | 0 | 0 | 2 |
$47,536 | 5 | 15 | 6 | 0 | 4 | 0 | 0 | 1 | 0 | 3 |
$36,571 | 1 | 6 | 4 | 0 | 2 | 0 | 1 | 0 | 0 | 2 |
$56,326 | 3 | 12 | 8 | 0 | 6 | 0 | 1 | 0 | 0 | 2 |
$31,425 | 6 | 7 | 5 | 1 | 6 | 0 | 0 | 1 | 0 | 3 |
$24,749 | 2 | 6 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 |
$26,452 | 3 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 4 |
CustomerData
Customer base data for sporting goods stores | |||||
Sales Len Kelly: Len Kelly: one-month sales in dollars | Age Len Kelly: Len Kelly: Median age of customer base in years | Growth Len Kelly: Len Kelly: annual percentage growth rate of customer base over the past 10 years | Income Len Kelly: Len Kelly: median family income of customer base in dollars | HS Len Kelly: Len Kelly: percentage of customer base with high school diploma | College Len Kelly: Len Kelly: percentage of customer base with college degree |
1695712.62 | 33.1574 | 0.8299 | 26748.51 | 73.5949 | 17.835 |
3403862.053 | 32.6667 | 0.6619 | 53063.79 | 88.4557 | 31.9439 |
2710352.905 | 35.6553 | 0.9688 | 36090.14 | 73.5362 | 18.6198 |
529215.459 | 33.0728 | 0.0821 | 32058.07 | 79.178 | 20.6284 |
663686.654 | 35.7585 | 0.4646 | 47843.42 | 84.1838 | 35.2032 |
2546324.335 | 33.8132 | 2.1796 | 50180.97 | 93.4996 | 41.7057 |
2787046.202 | 30.9797 | 1.8048 | 30710.08 | 78.0234 | 28.025 |
612696.054 | 30.7843 | -0.0569 | 29141.7 | 70.2949 | 15.0882 |
891822.033 | 32.3164 | -0.1577 | 25980.15 | 70.6674 | 10.9829 |
1124967.965 | 32.5312 | 0.3664 | 18730.88 | 63.7395 | 13.2458 |
909500.976 | 31.44 | 2.2256 | 31109.23 | 76.9059 | 19.55 |
2631166.881 | 33.1613 | 1.5158 | 35614.12 | 82.9452 | 20.8135 |
882972.654 | 31.8736 | 0.1413 | 23038.43 | 65.2127 | 16.9796 |
1078573.124 | 33.4072 | -1.04 | 34531.72 | 73.4944 | 32.992 |
844320.194 | 34.047 | 1.6836 | 30350.36 | 80.2201 | 22.3185 |
1849119.029 | 28.8879 | 2.3596 | 38964.94 | 87.5973 | 24.567 |
3860007.316 | 36.1056 | 0.784 | 49392.77 | 85.3041 | 30.879 |
826573.88 | 32.8083 | 0.1164 | 25595.69 | 65.5884 | 17.4545 |
604682.868 | 33.0538 | 1.1498 | 29622.61 | 80.6176 | 18.6356 |
1903611.6 | 33.4996 | 0.0606 | 31586.1 | 80.379 | 38.3249 |
2356808.391 | 32.6809 | 1.6338 | 39674.56 | 79.8526 | 23.778 |
2788571.957 | 28.5166 | 1.1256 | 28878.98 | 81.2371 | 16.93 |
634878.286 | 32.8945 | 1.4884 | 24287.08 | 70.2244 | 19.1429 |
2371627.369 | 30.5024 | 4.7937 | 46711.24 | 87.1046 | 30.8843 |
2627837.961 | 30.2922 | 1.8922 | 33449.81 | 80.2057 | 26.557 |
1868116.33 | 31.2911 | 1.8667 | 31694.45 | 75.2914 | 28.36 |
2236796.862 | 33.0498 | 1.7896 | 25459.22 | 77.6162 | 19.249 |
1318876.234 | 32.9348 | 0.2707 | 47047.34 | 85.1753 | 35.4994 |
1868097.836 | 31.8381 | 3.0129 | 26433.24 | 74.1792 | 18.6375 |
1695218.566 | 31.0794 | 23.463 | 33396.66 | 81.6991 | 41.113 |
2700194.415 | 32.1807 | 0.7041 | 26179.36 | 73.414 | 17.8566 |
1156049.774 | 31.6944 | -0.1569 | 33454.64 | 73.7161 | 26.5426 |
643858.444 | 34.0263 | 0.7084 | 42271.5 | 78.6493 | 29.8734 |
2188687.363 | 34.7315 | 0.1353 | 46514.75 | 80.9503 | 24.5374 |
830351.94 | 30.5613 | 0.3848 | 27030.81 | 66.8057 | 14.139 |
1226905.572 | 33.5183 | 0.7417 | 42910.08 | 77.8905 | 20.834 |
566903.589 | 32.3952 | 0.6693 | 40561.4 | 79.3622 | 19.0309 |
826518.398 | 29.9108 | 0.1111 | 22325.96 | 58.361 | 10.6729 |