Final Project: Statistical Tools and Data Analysis
khkmay_rb
final_paper__case_scenario_salary_data.xlsxOriginal Data
| Employee | 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 | Department Christopher J. Zappe: 1=Sales, 2=Purchasing, 3=Advertising, 4=Engineering. | Number Supervised Christopher J. Zappe: Number of employees supervised by this employee. |
||||
| 1 | $65,487 | 0 | 27 | 12 | 1 | 4 | 44 | ||||
| 2 | $46,184 | 3 | 20 | 4 | 0 | 4 | 1 | ||||
| 3 | $32,782 | 1 | 0 | 7 | 0 | 1 | 0 | ||||
| 4 | $54,899 | 5 | 12 | 8 | 1 | 4 | 0 | 0.0293538262 | weak | ||
| 5 | $34,869 | 5 | 7 | 4 | 1 | 4 | 1 | ||||
| 6 | $35,487 | 2 | 8 | 2 | 1 | 4 | 2 | ||||
| 7 | $26,548 | 1 | 5 | 0 | 0 | 4 | 2 | ||||
| 8 | $32,920 | 3 | 15 | 9 | 1 | 1 | 4 | ||||
| 9 | $29,548 | 6 | 5 | 1 | 0 | 1 | 0 | ||||
| 10 | $34,231 | 2 | 6 | 6 | 0 | 4 | 3 | 0.1947951959 | |||
| 11 | $23,654 | 0 | 0 | 0 | 1 | 3 | 2 | p-value | 0.84643 | ||
| 12 | $39,331 | 3 | 9 | 6 | 1 | 4 | 1 | ||||
| 13 | $36,512 | 6 | 6 | 4 | 1 | 4 | 2 | ||||
| 14 | $35,467 | 6 | 3 | 6 | 1 | 2 | 3 | 0.7651735539 | |||
| 15 | $68,425 | 2 | 25 | 12 | 0 | 4 | 1 | ||||
| 16 | $35,468 | 5 | 9 | 4 | 1 | 2 | 5 | ||||
| 17 | $36,578 | 4 | 4 | 8 | 0 | 3 | 8 | ||||
| 18 | $39,828 | 6 | 18 | 5 | 1 | 1 | 5 | ||||
| 19 | $36,487 | 5 | 6 | 2 | 0 | 4 | 3 | There is no cor. Btw sal. | |||
| 20 | $37,548 | 9 | 19 | 4 | 0 | 3 | 6 | ||||
| 21 | $31,528 | 11 | 3 | 3 | 0 | 1 | 6 | ||||
| 22 | $34,632 | 4 | 5 | 4 | 0 | 4 | 0 | ||||
| 23 | $46,211 | 5 | 14 | 6 | 1 | 4 | 5 | ||||
| 24 | $29,876 | 0 | 2 | 3 | 1 | 2 | 5 | ||||
| 25 | $43,674 | 9 | 6 | 4 | 0 | 2 | 2 | ||||
| 26 | $38,985 | 7 | 18 | 9 | 0 | 1 | 5 | ||||
| 27 | $53,234 | 0 | 25 | 6 | 0 | 3 | 3 | ||||
| 28 | $51,698 | 6 | 18 | 6 | 0 | 4 | 1 | ||||
| 29 | $41,889 | 16 | 22 | 7 | 0 | 1 | 7 | ||||
| 30 | $38,791 | 4 | 21 | 5 | 0 | 1 | 9 | ||||
| 31 | $69,246 | 3 | 22 | 10 | 0 | 4 | 45 | ||||
| 32 | $48,695 | 19 | 6 | 8 | 0 | 4 | 40 | ||||
| 33 | $34,987 | 6 | 9 | 2 | 1 | 4 | 3 | ||||
| 34 | $28,985 | 1 | 0 | 4 | 1 | 1 | 4 | ||||
| 35 | $35,631 | 4 | 6 | 4 | 0 | 4 | 2 | ||||
| 36 | $54,679 | 3 | 20 | 6 | 1 | 3 | 4 | ||||
| 37 | $39,743 | 6 | 9 | 5 | 1 | 4 | 1 | ||||
| 38 | $41,255 | 4 | 9 | 6 | 0 | 4 | 4 | ||||
| 39 | $36,431 | 4 | 9 | 4 | 1 | 2 | 2 | ||||
| 40 | $26,578 | 6 | 0 | 2 | 1 | 2 | 2 | ||||
| 41 | $47,536 | 5 | 15 | 6 | 0 | 3 | 4 | ||||
| 42 | $36,571 | 1 | 6 | 4 | 0 | 2 | 2 | ||||
| 43 | $56,326 | 3 | 12 | 8 | 0 | 2 | 6 | ||||
| 44 | $31,425 | 6 | 7 | 5 | 1 | 3 | 6 | ||||
| 45 | $24,749 | 2 | 6 | 0 | 1 | 1 | 1 | ||||
| 46 | $26,452 | 3 | 1 | 2 | 1 | 4 | 0 |
_STDS_DG3573D64C
| Name | Data Set #1 | StatTools Version that generated sheet, Major | 5 | StatTools Version that generated sheet, Minor | 5 | StatTools Version that generated sheet, Revision | 0 | Min. StatTools Version to Read Sheet, Major (note ST versions before 1.1.1 don't perform forward compatibility check) | 1 | Min. StatTools Version to Read Sheet, Minor | 0 | Min. StatTools Version to Read Sheet, Revision | 0 | Min. StatTools version to not put up warning about extra info, Major | 1 | Min. StatTools version to not put up warning about extra info, Minor | 0 | Min. StatTools version to not put up warning about extra info, Revision | 0 |
| GUID | DG3573D64C | ||||||||||||||||||
| Format Range | FALSE | ||||||||||||||||||
| Variable Layout | Columns | ||||||||||||||||||
| Variable Names In Cells | TRUE | ||||||||||||||||||
| Variable Names In 2nd Cells | TRUE | ||||||||||||||||||
| Data Set Ranges | ERROR:#REF! | ||||||||||||||||||
| Data Sheet Format | 1 | ||||||||||||||||||
| Formula Eval Cell | 1 | ||||||||||||||||||
| Num Stored Vars | 8 | ||||||||||||||||||
| 1 : Info | VG1743C6AA27034F7B | var1 | ST_Employee | TRUE | 0 | 4 | |||||||||||||
| 1 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 1 : MultiRefs | |||||||||||||||||||
| 2 : Info | VG12C5EA24365B9834 | var2 | ST_Salary | TRUE | 0 | 4 | |||||||||||||
| 2 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 2 : MultiRefs | |||||||||||||||||||
| 3 : Info | VG222F19C927DB081E | var3 | ST_YearsPreviousExperience | TRUE | 0 | 4 | |||||||||||||
| 3 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 3 : MultiRefs | |||||||||||||||||||
| 4 : Info | VG318DF0BF37CD035A | var4 | ST_YearsEmployed | TRUE | 0 | 4 | |||||||||||||
| 4 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 4 : MultiRefs | |||||||||||||||||||
| 5 : Info | VG1D035ED392DEF6C | var5 | ST_YearsEducation | TRUE | 0 | 4 | |||||||||||||
| 5 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 5 : MultiRefs | |||||||||||||||||||
| 6 : Info | VGD6E122BC53379A | var6 | ST_Gender | TRUE | 0 | 4 | |||||||||||||
| 6 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 6 : MultiRefs | |||||||||||||||||||
| 7 : Info | VG6A49E251126D455 | var7 | ST_Department | TRUE | 0 | 4 | |||||||||||||
| 7 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 7 : MultiRefs | |||||||||||||||||||
| 8 : Info | VG2E375F36BF1B1A4 | var8 | ST_NumberSupervised | TRUE | 0 | 4 | |||||||||||||
| 8 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 8 : MultiRefs |
