Number 3 (499)

profiletandr102
Quiz3StatisticsData.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