Final Project: Statistical Tools and Data Analysis
khkmay_rb
final_paper_appendix_1.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 |
| 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 |
| 11 | $23,654 | 0 | 0 | 0 | 1 | 3 | 2 |
| 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 |
| 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 |
| 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 |
Contingency analysis
| 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 | Count of Department | Column Labels | ||||||||||||
| 2 | $46,184 | 3 | 20 | 4 | 0 | 4 | 1 | Row Labels | 1 | 2 | 3 | 4 | Grand Total | ||||||||
| 3 | $32,782 | 1 | 0 | 7 | 0 | 1 | 0 | 0 | 6 | 3 | 4 | 11 | 24 | ||||||||
| 4 | $54,899 | 5 | 12 | 8 | 1 | 4 | 0 | 1 | 4 | 5 | 3 | 10 | 22 | ||||||||
| 5 | $34,869 | 5 | 7 | 4 | 1 | 4 | 1 | Grand Total | 10 | 8 | 7 | 21 | 46 | ||||||||
| 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 | ||||||||||||||
| 11 | $23,654 | 0 | 0 | 0 | 1 | 3 | 2 | ||||||||||||||
| 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 | ||||||||||||||
| 15 | $68,425 | 2 | 25 | 12 | 0 | 4 | 1 | ||||||||||||||
| 16 | $35,468 | 5 | 9 | 4 | 1 | 2 | 5 | Dept | |||||||||||||
| 17 | $36,578 | 4 | 4 | 8 | 0 | 3 | 8 | Gender | 1 | 2 | 3 | 4 | Grand Total | ||||||||
| 19 | $36,487 | 5 | 6 | 2 | 0 | 4 | 3 | 0 | 6 | 3 | 4 | 11 | 24 | ||||||||
| 20 | $37,548 | 9 | 19 | 4 | 0 | 3 | 6 | 1 | 4 | 5 | 3 | 10 | 22 | ||||||||
| 21 | $31,528 | 11 | 3 | 3 | 0 | 1 | 6 | Grand Total | 10 | 8 | 7 | 21 | 46 | ||||||||
| 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 |
Alhamis, Innocentus: For each cell, calculate first the expected value. For instance, in cell K19 where we have observed value of 6, we calculate the expected value as (24*10)/10 In cell K20 where we have observed value, i.e., 4 we can calculate expected value as (22*10)/10 Find expected values for all cells by following the formula provided. Then Use Chi-square formula provided in the PPTs to get chi-square. You will substract all expected values from observed values, then square the result and divide the result by the expected value. This has to be for every cell. Then sum up all the outcomes. That will be your chi square contingency calculated. Use this to get probability, i.e., p-value or probability of Alternative hypothesis. In excel you will use the formula =CHIDIST. Remeber degrees of freedom You will take number of rows minus 1 times number of columns - 1 (2-1)(4-1) = 3 so we have 3 degrees of freedom. |
|||||||||||||
|
Christopher J. Zappe: Number of years of relevant work experience prior to coming to DataCom. |
Christopher J. Zappe: Number of years employed at DataCom. |
Christopher J. Zappe: Number years of education beyond high school. |
Christopher J. Zappe: 0=Female, 1=Male |
Christopher J. Zappe: 1=Sales, 2=Purchasing, 3=Advertising, 4=Engineering. |
Christopher J. Zappe: Number of employees supervised by this employee. |
Alhamis, Innocentus: we copied results from pivot table here under | 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 |
ANOVA
| 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. | Dept1 Christopher J. Zappe: Current annual salary (in dollars). | Dept2 | Dept3 | Dept4 | |||||||||||||||||||||||||
| 3 | $32,782 | 1 | 0 | 7 | 0 | 1 | 0 | $32,782 | $35,467 | $23,654 | $65,487 | |||||||||||||||||||||||||
| 8 | $32,920 | 3 | 15 | 9 | 1 | 1 | 4 | $32,920 | $35,468 | $36,578 | $46,184 | Anova: Single Factor | ||||||||||||||||||||||||
| 9 | $29,548 | 6 | 5 | 1 | 0 | 1 | 0 | $29,548 | $29,876 | $37,548 | $54,899 | |||||||||||||||||||||||||
| 18 | $39,828 | 6 | 18 | 5 | 1 | 1 | 5 | $39,828 | $43,674 | $53,234 | $34,869 | SUMMARY | ||||||||||||||||||||||||
| 21 | $31,528 | 11 | 3 | 3 | 0 | 1 | 6 | $31,528 | $36,431 | $54,679 | $35,487 | Groups | Count | Sum | Average | Variance | ||||||||||||||||||||
| 26 | $38,985 | 7 | 18 | 9 | 0 | 1 | 5 | $38,985 | $26,578 | $47,536 | $26,548 | Dept1 | 10 | 340005 | 34000.5 | 31479782.9444444 | ||||||||||||||||||||
| 29 | $41,889 | 16 | 22 | 7 | 0 | 1 | 7 | $41,889 | $36,571 | $31,425 | $34,231 | Dept2 | 8 | 300391 | 37548.875 | 82885830.9821429 | ||||||||||||||||||||
| 30 | $38,791 | 4 | 21 | 5 | 0 | 1 | 9 | $38,791 | $56,326 | $39,331 | Dept3 | 7 | 284654 | 40664.8571428571 | 133792262.809524 | |||||||||||||||||||||
| 34 | $28,985 | 1 | 0 | 4 | 1 | 1 | 4 | $28,985 | $36,512 | Dept4 | 21 | 907010 | 43190.9523809524 | 157721269.947619 | ||||||||||||||||||||||
| 45 | $24,749 | 2 | 6 | 0 | 1 | 1 | 1 | $24,749 | $68,425 | |||||||||||||||||||||||||||
| 14 | $35,467 | 6 | 3 | 6 | 1 | 2 | 3 | $36,487 | ||||||||||||||||||||||||||||
| 16 | $35,468 | 5 | 9 | 4 | 1 | 2 | 5 | $34,632 | ANOVA | |||||||||||||||||||||||||||
| 24 | $29,876 | 0 | 2 | 3 | 1 | 2 | 5 | $46,211 | Source of Variation | SS | df | MS | F | P-value | F crit | |||||||||||||||||||||
| 25 | $43,674 | 9 | 6 | 4 | 0 | 2 | 2 | $51,698 | Between Groups | 623553563.771997 | 3 | 207851187.923999 | 1.8108892497 | 0.1598627529 Alhamis, Innocentus: The P-value is larger than 0.05 significance level, thus we have no evidence to reject the null hypothesis | 2.8270487121 | |||||||||||||||||||||
| 39 | $36,431 | 4 | 9 | 4 | 1 | 2 | 2 | $69,246 | Within Groups | 4820697839.18452 | 42 | 114778519.980584 | ||||||||||||||||||||||||
| 40 | $26,578 | 6 | 0 | 2 | 1 | 2 | 2 | $48,695 | ||||||||||||||||||||||||||||
| 42 | $36,571 | 1 | 6 | 4 | 0 | 2 | 2 | $34,987 | Total | 5444251402.95652 | 45 | |||||||||||||||||||||||||
| 43 | $56,326 | 3 | 12 | 8 | 0 | 2 | 6 | $35,631 | ||||||||||||||||||||||||||||
| 11 | $23,654 | 0 | 0 | 0 | 1 | 3 | 2 | $39,743 | ||||||||||||||||||||||||||||
| 17 | $36,578 | 4 | 4 | 8 | 0 | 3 | 8 | $41,255 | ||||||||||||||||||||||||||||
| 20 | $37,548 | 9 | 19 | 4 | 0 | 3 | 6 | $26,452 | ||||||||||||||||||||||||||||
| 27 | $53,234 | 0 | 25 | 6 | 0 | 3 | 3 | |||||||||||||||||||||||||||||
| 36 | $54,679 | 3 | 20 | 6 | 1 | 3 | 4 | |||||||||||||||||||||||||||||
| 41 | $47,536 | 5 | 15 | 6 | 0 | 3 | 4 | |||||||||||||||||||||||||||||
| 44 | $31,425 | 6 | 7 | 5 | 1 | 3 | 6 |
Alhamis, Innocentus: We sorted the data in terms of Department by using custom sort and select sort by Department. Then we copied salary and pest them in department wise so we could find ANOVA, i.e., salary across departments for the evidence to show if salary differs between departments or not. we use data analysis to find ANOVA |
||||||||||||||||||||||||||||
|
Christopher J. Zappe: Number of years of relevant work experience prior to coming to DataCom. |
Christopher J. Zappe: Number of years employed at DataCom. |
Christopher J. Zappe: Number years of education beyond high school. |
Christopher J. Zappe: 0=Female, 1=Male |
Alhamis, Innocentus: The P-value is larger than 0.05 significance level, thus we have no evidence to reject the null hypothesis |
Christopher J. Zappe: 1=Sales, 2=Purchasing, 3=Advertising, 4=Engineering. |
Christopher J. Zappe: Number of employees supervised by this employee. |
Christopher J. Zappe: Current annual salary (in dollars). | 1 | $65,487 | 0 | 27 | 12 | 1 | 4 | 44 | |||||||||||||||||||||
| 2 | $46,184 | 3 | 20 | 4 | 0 | 4 | 1 | |||||||||||||||||||||||||||||
| 4 | $54,899 | 5 | 12 | 8 | 1 | 4 | 0 | |||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||
| 10 | $34,231 | 2 | 6 | 6 | 0 | 4 | 3 | |||||||||||||||||||||||||||||
| 12 | $39,331 | 3 | 9 | 6 | 1 | 4 | 1 | |||||||||||||||||||||||||||||
| 13 | $36,512 | 6 | 6 | 4 | 1 | 4 | 2 | |||||||||||||||||||||||||||||
| 15 | $68,425 | 2 | 25 | 12 | 0 | 4 | 1 | |||||||||||||||||||||||||||||
| 19 | $36,487 | 5 | 6 | 2 | 0 | 4 | 3 | |||||||||||||||||||||||||||||
| 22 | $34,632 | 4 | 5 | 4 | 0 | 4 | 0 | |||||||||||||||||||||||||||||
| 23 | $46,211 | 5 | 14 | 6 | 1 | 4 | 5 | |||||||||||||||||||||||||||||
| 28 | $51,698 | 6 | 18 | 6 | 0 | 4 | 1 | |||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||
| 35 | $35,631 | 4 | 6 | 4 | 0 | 4 | 2 | |||||||||||||||||||||||||||||
| 37 | $39,743 | 6 | 9 | 5 | 1 | 4 | 1 | |||||||||||||||||||||||||||||
| 38 | $41,255 | 4 | 9 | 6 | 0 | 4 | 4 | |||||||||||||||||||||||||||||
| 46 | $26,452 | 3 | 1 | 2 | 1 | 4 | 0 |
Correlation
| 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 | |||||||||
| 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 | Salary | Years Previous Experience | Years Employed | Years Education | Gender | Department | Number Supervised | ||
| 10 | $34,231 | 2 | 6 | 6 | 0 | 4 | 3 | Salary | 1.00 | |||||||
| 11 | $23,654 | 0 | 0 | 0 | 1 | 3 | 2 | Years Previous Experience | 0.03 | 1.00 | ||||||
| 12 | $39,331 | 3 | 9 | 6 | 1 | 4 | 1 | Years Employed | 0.77 | 0.03 | 1.00 | |||||
| 13 | $36,512 | 6 | 6 | 4 | 1 | 4 | 2 | Years Education | 0.78 | 0.08 | 0.61 | 1.00 | ||||
| 14 | $35,467 | 6 | 3 | 6 | 1 | 2 | 3 | Gender | -0.25 Alhamis, Innocentus: As you can see the correlation for gender is negative and probably the t- calculated can be negative as well. You will need to add negative sign for the p-value in the probability function to make the t-value absolute because we cant find probability of negative t. i.e.,TDIST(-K19,44,2) | -0.22 | -0.21 | -0.19 | 1.00 | |||
| 15 | $68,425 | 2 | 25 | 12 | 0 | 4 | 1 | Department | 0.34 | -0.11 | 0.09 | 0.09 | 0.01 | 1.00 | ||
| 16 | $35,468 | 5 | 9 | 4 | 1 | 2 | 5 | Number Supervised | 0.52 | 0.22 | 0.35 | 0.50 | -0.10 | 0.16 | 1.00 | |
| 17 | $36,578 | 4 | 4 | 8 | 0 | 3 | 8 | |||||||||
| 18 | $39,828 | 6 | 18 | 5 | 1 | 1 | 5 | t | 0.1947951959 Alhamis, Innocentus: click on this cell to see the function used which will show in the fx ruler above. In the function, just change the cell and all the values for t and p-value will vary. |
|||||||
| 19 | $36,487 | 5 | 6 | 2 | 0 | 4 | 3 | P-value | 0.8464499621 | |||||||
| 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 |
Regression- Multiple
| 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. | SUMMARY OUTPUT | ||||||||||||||||||||||||||||||||||||||||||
| 1 | $65,487 | 0 | 27 | 12 | 1 | 4 | 44 | |||||||||||||||||||||||||||||||||||||||||||
| 2 | $46,184 | 3 | 20 | 4 | 0 | 4 | 1 | Regression Statistics | ||||||||||||||||||||||||||||||||||||||||||
| 3 | $32,782 | 1 | 0 | 7 | 0 | 1 | 0 | Multiple R | 0.9051553444 | |||||||||||||||||||||||||||||||||||||||||
| 4 | $54,899 | 5 | 12 | 8 | 1 | 4 | 0 | R Square | 0.8193061975 | |||||||||||||||||||||||||||||||||||||||||
| 5 | $34,869 | 5 | 7 | 4 | 1 | 4 | 1 | Adjusted R Square | 0.7915071509 | |||||||||||||||||||||||||||||||||||||||||
| 6 | $35,487 | 2 | 8 | 2 | 1 | 4 | 2 | Standard Error | 5022.3666093428 | |||||||||||||||||||||||||||||||||||||||||
| 7 | $26,548 | 1 | 5 | 0 | 0 | 4 | 2 | Observations | 46 | |||||||||||||||||||||||||||||||||||||||||
| 8 | $32,920 | 3 | 15 | 9 | 1 | 1 | 4 | |||||||||||||||||||||||||||||||||||||||||||
| 9 | $29,548 | 6 | 5 | 1 | 0 | 1 | 0 | ANOVA | ||||||||||||||||||||||||||||||||||||||||||
| 10 | $34,231 | 2 | 6 | 6 | 0 | 4 | 3 | df | SS | MS | F | Significance F | ||||||||||||||||||||||||||||||||||||||
| 11 | $23,654 | 0 | 0 | 0 | 1 | 3 | 2 | Regression | 6 | 4460508914.96951 | 743418152.494919 | 29.4724567672 | 0 | |||||||||||||||||||||||||||||||||||||
| 12 | $39,331 | 3 | 9 | 6 | 1 | 4 | 1 | Residual | 39 | 983742487.987009 | 25224166.3586413 | |||||||||||||||||||||||||||||||||||||||
| 13 | $36,512 | 6 | 6 | 4 | 1 | 4 | 2 | Total | 45 | 5444251402.95652 | ||||||||||||||||||||||||||||||||||||||||
| 14 | $35,467 | 6 | 3 | 6 | 1 | 2 | 3 | |||||||||||||||||||||||||||||||||||||||||||
| 15 | $68,425 | 2 | 25 | 12 | 0 | 4 | 1 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||||||||||||||||||||||||||||||||||
| 16 | $35,468 | 5 | 9 | 4 | 1 | 2 | 5 | Intercept | 19589.4712256373 | 2862.6377136653 | 6.8431541763 | 0.0000000352 Alhamis, Innocentus: We can see that P-values for Gender, years of experience and number supervised are larger than significance level, 0.05 (5%). Thus these variables are not significant, i.e., we don’t have enough evidence to reject the null hypothesis that said, there is no relationship between them and the dependent variable, Salary. Thus we ignore them. |
Christopher J. Zappe: Current annual salary (in dollars). |
Alhamis, Innocentus: Multiple R = 0.9 shows there is a strong positive relationship between dependent variable and independent variable. Also R^2 and adjusted R ^2 show that the model explains about 80% of the dependent variable, only 20% is unexplained. We can say, our model is a good estimator |
Christopher J. Zappe: Number of years of relevant work experience prior to coming to DataCom. |
Christopher J. Zappe: Number of years employed at DataCom. |
Christopher J. Zappe: Number years of education beyond high school. |
Christopher J. Zappe: 0=Female, 1=Male |
Christopher J. Zappe: 1=Sales, 2=Purchasing, 3=Advertising, 4=Engineering. |
Christopher J. Zappe: Number of employees supervised by this employee. | 13799.2399148517 | 25379.7025364229 | 13799.2399148517 | 25379.7025364229 | ||||||||||||||||||||||||||
| 17 | $36,578 | 4 | 4 | 8 | 0 | 3 | 8 | Years Previous Experience | -106.5479020112 | 213.0790415752 | -0.5000393339 | 0.6198572496 | -537.5409446555 | 324.4451406332 | -537.5409446555 | 324.4451406332 | ||||||||||||||||||||||||||||||||||
| 18 | $39,828 | 6 | 18 | 5 | 1 | 1 | 5 | Years Employed | 621.0565789328 Alhamis, Innocentus: This is yearly increment, i.e., if we consider only this variable holding other variables constant estimated Salary = a+ b1 Years Employed Thus Salary = 19589.123 + 621.0565789 Yearsemployed Thus with one year working in the company, average salary will be Salary = 19589.123 + 621.0565789(1) | 125.4148496626 | 4.9520178879 | 0.00001457 | 367.3811012824 | 874.7320565831 | 367.3811012824 | 874.7320565831 | ||||||||||||||||||||||||||||||||||
| 19 | $36,487 | 5 | 6 | 2 | 0 | 4 | 3 | Years Education | 1631.8308340345 | 362.756523923 | 4.4984189847 | 0.0000600767 | 898.0865069114 | 2365.5751611576 | 898.0865069114 | 2365.5751611576 | ||||||||||||||||||||||||||||||||||
| 20 | $37,548 | 9 | 19 | 4 | 0 | 3 | 6 | Gender | -1654.0745949844 | 1558.114638622 | -1.0615872247 | 0.2949530505 | -4805.6589269015 | 1497.5097369326 | -4805.6589269015 | 1497.5097369326 | ||||||||||||||||||||||||||||||||||
| 21 | $31,528 | 11 | 3 | 3 | 0 | 1 | 6 | Department | 2134.2893191233 | 624.7683153271 | 3.4161292543 | 0.0014973357 | 870.5761205844 | 3398.0025176621 | 870.5761205844 | 3398.0025176621 | ||||||||||||||||||||||||||||||||||
| 22 | $34,632 | 4 | 5 | 4 | 0 | 4 | 0 | Number Supervised | 134.014350414 | 88.1398993 | 1.520473151 | 0.136458961 | -44.2654235932 | 312.2941244211 | -44.2654235932 | 312.2941244211 | ||||||||||||||||||||||||||||||||||
| 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 | RESIDUAL OUTPUT |
Alhamis, Innocentus: Alhamis, Innocentus: |
|||||||||||||||||||||||||||||||||||||||||
|
Alhamis, Innocentus: This is yearly increment, i.e., if we consider only this variable holding other variables constant estimated Salary = a+ b1 Years Employed Thus Salary = 19589.123 + 621.0565789 Yearsemployed Thus with one year working in the company, average salary will be Salary = 19589.123 + 621.0565789(1) | 27 | $53,234 | 0 | 25 | 6 | 0 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||
| 28 | $51,698 | 6 | 18 | 6 | 0 | 4 | 1 | Observation | Predicted Salary | Residuals | ||||||||||||||||||||||||||||||||||||||||
| 29 | $41,889 | 16 | 22 | 7 | 0 | 1 | 7 | 1 | 68719.6829649594 | -3232.6829649594 | ||||||||||||||||||||||||||||||||||||||||
| 30 | $38,791 | 4 | 21 | 5 | 0 | 1 | 9 | 2 | 46889.4540613041 | -705.4540613041 | ||||||||||||||||||||||||||||||||||||||||
| 31 | $69,246 | 3 | 22 | 10 | 0 | 4 | 45 | 3 | 33040.0284809907 | -258.0284809907 | ||||||||||||||||||||||||||||||||||||||||
| 32 | $48,695 | 19 | 6 | 8 | 0 | 4 | 40 | 4 | 46447.1400165591 | 8451.8599834409 | ||||||||||||||||||||||||||||||||||||||||
| 33 | $34,987 | 6 | 9 | 2 | 1 | 4 | 3 | 5 | 36948.5481361714 | -2079.5481361714 | ||||||||||||||||||||||||||||||||||||||||
| 34 | $28,985 | 1 | 0 | 4 | 1 | 1 | 4 | 6 | 34759.6011034827 | 727.3988965173 | ||||||||||||||||||||||||||||||||||||||||
| 35 | $35,631 | 4 | 6 | 4 | 0 | 4 | 2 | 7 | 31393.3921956111 | -4845.3921956111 | ||||||||||||||||||||||||||||||||||||||||
| 36 | $54,679 | 3 | 20 | 6 | 1 | 3 | 4 | 8 | 44288.4258357003 | -11368.4258357003 | ||||||||||||||||||||||||||||||||||||||||
| 37 | $39,743 | 6 | 9 | 5 | 1 | 4 | 1 | 9 | 25821.586861392 | 3726.413138608 | ||||||||||||||||||||||||||||||||||||||||
| 38 | $41,255 | 4 | 9 | 6 | 0 | 4 | 4 | 10 | 41832.9002271535 | -7601.9002271535 | ||||||||||||||||||||||||||||||||||||||||
| 39 | $36,431 | 4 | 9 | 4 | 1 | 2 | 2 | 11 | 24606.2932888507 | -952.2932888507 | ||||||||||||||||||||||||||||||||||||||||
| 40 | $26,578 | 6 | 0 | 2 | 1 | 2 | 2 | 12 | 41667.4187661282 | -2336.4187661282 | ||||||||||||||||||||||||||||||||||||||||
| 41 | $47,536 | 5 | 15 | 6 | 0 | 3 | 4 | 13 | 36354.9580056415 | 157.0419943585 | ||||||||||||||||||||||||||||||||||||||||
| 42 | $36,571 | 1 | 6 | 4 | 0 | 2 | 2 | 14 | 33620.8856490795 | 1846.1143509205 | ||||||||||||||||||||||||||||||||||||||||
| 43 | $56,326 | 3 | 12 | 8 | 0 | 2 | 6 | 15 | 63155.9315302548 | 5269.0684697452 | ||||||||||||||||||||||||||||||||||||||||
| 44 | $31,425 | 6 | 7 | 5 | 1 | 3 | 6 | 16 | 34458.1400574463 | 1009.8599425537 | ||||||||||||||||||||||||||||||||||||||||
| 45 | $24,749 | 2 | 6 | 0 | 1 | 1 | 1 | 17 | 42177.1353662812 | -5599.1353662812 | ||||||||||||||||||||||||||||||||||||||||
| 46 | $26,452 | 3 | 1 | 2 | 1 | 4 | 0 | 18 | 39438.6428807412 | 389.3571192588 | ||||||||||||||||||||||||||||||||||||||||
| 19 | 34985.9331849821 | 1501.0668150179 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20 | 44164.892503251 | -6616.892503251 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 21 | 28114.4819640235 | 3413.5180359765 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 22 | 37333.0431248875 | -2701.0431248875 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 23 | 45095.6632584256 | 1115.3367415744 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 24 | 29011.6526809383 | 864.3473190617 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 25 | 33420.8102563459 | 10253.1897436541 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 26 | 47513.4929098524 | -8528.4929098524 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 27 | 51711.781711775 | 1522.218288225 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 28 | 48591.3588654741 | 3106.6411345259 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 29 | 46043.1551402421 | -4154.1551402421 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 30 | 43705.0404182022 | -4914.0404182022 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 31 | 63819.1836415916 | 5426.8163584084 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 32 | 48243.7785263501 | 451.2214736499 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 33 | 35088.4804247848 | -101.4804247848 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 34 | 27026.5187855588 | 1958.4812144412 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 35 | 38222.1284046482 | -2591.1284046483 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 36 | 46766.7948665072 | 7912.2051334928 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 37 | 39715.9442260603 | 27.0557739397 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 38 | 43616.9885103434 | -2361.9885103434 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 39 | 34162.6449082155 | 2268.3550917845 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 40 | 25096.3782257294 | 1481.6217742706 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 41 | 45102.4907628056 | 2433.5092371944 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 42 | 34273.1934724351 | 2297.8065275649 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 43 | 44849.8178798032 | 11476.1821201968 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 44 | 37009.6135011414 | -5584.6135011414 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 45 | 23716.9439697644 | 1032.0560302356 | ||||||||||||||||||||||||||||||||||||||||||||||||
| 46 | 30037.6284481142 | -3585.6284481142 |
Regression Salary and Experienc
| Salary | Years Previous Experience | Years Employed | Years Education | Gender | Department | Number Supervised | |||||||||||
| 65487 | 0 | 27 | 12 | 1 | 4 | 44 | SUMMARY OUTPUT | ||||||||||
| 46184 | 3 | 20 | 4 | 0 | 4 | 1 | |||||||||||
| 32782 | 1 | 0 | 7 | 0 | 1 | 0 | Regression Statistics | ||||||||||
| 54899 | 5 | 12 | 8 | 1 | 4 | 0 | Multiple R | 0.0293538262 | |||||||||
| 34869 | 5 | 7 | 4 | 1 | 4 | 1 | R Square | 0.0008616471 | |||||||||
| 35487 | 2 | 8 | 2 | 1 | 4 | 2 | Adjusted R Square | -0.0218460427 | |||||||||
| 26548 | 1 | 5 | 0 | 0 | 4 | 2 | Standard Error | 11118.7396884834 | |||||||||
| 32920 | 3 | 15 | 9 | 1 | 1 | 4 | Observations | 46 | |||||||||
| 29548 | 6 | 5 | 1 | 0 | 1 | 0 | |||||||||||
| 34231 | 2 | 6 | 6 | 0 | 4 | 3 | ANOVA | ||||||||||
| 23654 | 0 | 0 | 0 | 1 | 3 | 2 | df | SS | MS | F | Significance F | ||||||
| 39331 | 3 | 9 | 6 | 1 | 4 | 1 | Regression | 1 | 4691023.50529194 | 4691023.50529194 | 0.0379451683 | 0.8464499621 | |||||
| 36512 | 6 | 6 | 4 | 1 | 4 | 2 | Residual | 44 | 5439560379.45123 | 123626372.260255 | |||||||
| 35467 | 6 | 3 | 6 | 1 | 2 | 3 | Total | 45 | 5444251402.95652 | ||||||||
| 68425 | 2 | 25 | 12 | 0 | 4 | 1 | |||||||||||
| 35468 | 5 | 9 | 4 | 1 | 2 | 5 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| 36578 | 4 | 4 | 8 | 0 | 3 | 8 | Intercept | 39428.1026854042 | 2624.7201203828 | 15.0218312342 | 6.20530373635922E-19 | 34138.3268627945 | 44717.8785080139 | 34138.3268627945 | 44717.8785080139 | ||
| 39828 | 6 | 18 | 5 | 1 | 1 | 5 | Years Previous Experience | 86.6380965632 | 444.7650578974 | 0.1947951959 | 0.8464499621 | -809.7269793687 | 983.0031724952 | -809.7269793687 | 983.0031724952 | ||
| 36487 | 5 | 6 | 2 | 0 | 4 | 3 | |||||||||||
| 37548 | 9 | 19 | 4 | 0 | 3 | 6 | |||||||||||
| 31528 | 11 | 3 | 3 | 0 | 1 | 6 | |||||||||||
| 34632 | 4 | 5 | 4 | 0 | 4 | 0 | |||||||||||
| 46211 | 5 | 14 | 6 | 1 | 4 | 5 | |||||||||||
| 29876 | 0 | 2 | 3 | 1 | 2 | 5 | |||||||||||
| 43674 | 9 | 6 | 4 | 0 | 2 | 2 | |||||||||||
| 38985 | 7 | 18 | 9 | 0 | 1 | 5 | |||||||||||
| 53234 | 0 | 25 | 6 | 0 | 3 | 3 | |||||||||||
| 51698 | 6 | 18 | 6 | 0 | 4 | 1 | |||||||||||
| 41889 | 16 | 22 | 7 | 0 | 1 | 7 | |||||||||||
| 38791 | 4 | 21 | 5 | 0 | 1 | 9 | |||||||||||
| 69246 | 3 | 22 | 10 | 0 | 4 | 45 | |||||||||||
| 48695 | 19 | 6 | 8 | 0 | 4 | 40 | |||||||||||
| 34987 | 6 | 9 | 2 | 1 | 4 | 3 | |||||||||||
| 28985 | 1 | 0 | 4 | 1 | 1 | 4 | |||||||||||
| 35631 | 4 | 6 | 4 | 0 | 4 | 2 | |||||||||||
| 54679 | 3 | 20 | 6 | 1 | 3 | 4 | |||||||||||
| 39743 | 6 | 9 | 5 | 1 | 4 | 1 | |||||||||||
| 41255 | 4 | 9 | 6 | 0 | 4 | 4 | |||||||||||
| 36431 | 4 | 9 | 4 | 1 | 2 | 2 | |||||||||||
| 26578 | 6 | 0 | 2 | 1 | 2 | 2 | |||||||||||
| 47536 | 5 | 15 | 6 | 0 | 3 | 4 | |||||||||||
| 36571 | 1 | 6 | 4 | 0 | 2 | 2 | |||||||||||
| 56326 | 3 | 12 | 8 | 0 | 2 | 6 | |||||||||||
| 31425 | 6 | 7 | 5 | 1 | 3 | 6 | |||||||||||
| 24749 | 2 | 6 | 0 | 1 | 1 | 1 | |||||||||||
| 26452 | 3 | 1 | 2 | 1 | 4 | 0 |
regression salary and years emp
| Salary | Years Previous Experience | Years Employed | Years Education | Gender | Department | Number Supervised | ||||||||||||
| 65487 | 0 | 27 | 12 | 1 | 4 | 44 | SUMMARY OUTPUT | |||||||||||
| 46184 | 3 | 20 | 4 | 0 | 4 | 1 | ||||||||||||
| 32782 | 1 | 0 | 7 | 0 | 1 | 0 | Regression Statistics | |||||||||||
| 54899 | 5 | 12 | 8 | 1 | 4 | 0 | Multiple R | 0.7651735539 | ||||||||||
| 34869 | 5 | 7 | 4 | 1 | 4 | 1 | R Square | 0.5854905675 | ||||||||||
| 35487 | 2 | 8 | 2 | 1 | 4 | 2 | Adjusted R Square | 0.5760698986 | ||||||||||
| 26548 | 1 | 5 | 0 | 0 | 4 | 2 | Standard Error | 7161.598283961 | ||||||||||
| 32920 | 3 | 15 | 9 | 1 | 1 | 4 | Observations | 46 | ||||||||||
| 29548 | 6 | 5 | 1 | 0 | 1 | 0 | ||||||||||||
| 34231 | 2 | 6 | 6 | 0 | 4 | 3 | ANOVA | |||||||||||
| 23654 | 0 | 0 | 0 | 1 | 3 | 2 | df | SS | MS | F | Significance F | |||||||
| 39331 | 3 | 9 | 6 | 1 | 4 | 1 | Regression | 1 | 3187557843.79985 | 3187557843.79985 | 62.1495747875 | 0.0000000006 | ||||||
| 36512 | 6 | 6 | 4 | 1 | 4 | 2 | Residual | 44 | 2256693559.15667 | 51288489.9808335 | ||||||||
| 35467 | 6 | 3 | 6 | 1 | 2 | 3 | Total | 45 | 5444251402.95652 | |||||||||
| 68425 | 2 | 25 | 12 | 0 | 4 | 1 | ||||||||||||
| 35468 | 5 | 9 | 4 | 1 | 2 | 5 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||
| 36578 | 4 | 4 | 8 | 0 | 3 | 8 | Intercept | 28394.1580619539 | 1793.9512498846 | 15.8277199917 | 8.84666131886618E-20 | 24778.6868828036 | 32009.6292411042 | 24778.6868828036 | 32009.6292411042 | |||
| 39828 | 6 | 18 | 5 | 1 | 1 | 5 | Years Employed | 1107.2183771581 | 140.4475619402 | 7.8835001609 | 5.93E-10 | 824.1649149143 | 1390.271839402 | 824.1649149143 | 1390.271839402 | |||
| 36487 | 5 | 6 | 2 | 0 | 4 | 3 | ||||||||||||
| 37548 | 9 | 19 | 4 | 0 | 3 | 6 | ||||||||||||
| 31528 | 11 | 3 | 3 | 0 | 1 | 6 | ||||||||||||
| 34632 | 4 | 5 | 4 | 0 | 4 | 0 | ||||||||||||
| 46211 | 5 | 14 | 6 | 1 | 4 | 5 | ||||||||||||
| 29876 | 0 | 2 | 3 | 1 | 2 | 5 | ||||||||||||
| 43674 | 9 | 6 | 4 | 0 | 2 | 2 | ||||||||||||
| 38985 | 7 | 18 | 9 | 0 | 1 | 5 | ||||||||||||
| 53234 | 0 | 25 | 6 | 0 | 3 | 3 | ||||||||||||
| 51698 | 6 | 18 | 6 | 0 | 4 | 1 | ||||||||||||
| 41889 | 16 | 22 | 7 | 0 | 1 | 7 | ||||||||||||
| 38791 | 4 | 21 | 5 | 0 | 1 | 9 | ||||||||||||
| 69246 | 3 | 22 | 10 | 0 | 4 | 45 | ||||||||||||
| 48695 | 19 | 6 | 8 | 0 | 4 | 40 | ||||||||||||
| 34987 | 6 | 9 | 2 | 1 | 4 | 3 | ||||||||||||
| 28985 | 1 | 0 | 4 | 1 | 1 | 4 | ||||||||||||
| 35631 | 4 | 6 | 4 | 0 | 4 | 2 | ||||||||||||
| 54679 | 3 | 20 | 6 | 1 | 3 | 4 | ||||||||||||
| 39743 | 6 | 9 | 5 | 1 | 4 | 1 | ||||||||||||
| 41255 | 4 | 9 | 6 | 0 | 4 | 4 | ||||||||||||
| 36431 | 4 | 9 | 4 | 1 | 2 | 2 | ||||||||||||
| 26578 | 6 | 0 | 2 | 1 | 2 | 2 | ||||||||||||
| 47536 | 5 | 15 | 6 | 0 | 3 | 4 | ||||||||||||
| 36571 | 1 | 6 | 4 | 0 | 2 | 2 | ||||||||||||
| 56326 | 3 | 12 | 8 | 0 | 2 | 6 | ||||||||||||
| 31425 | 6 | 7 | 5 | 1 | 3 | 6 | ||||||||||||
| 24749 | 2 | 6 | 0 | 1 | 1 | 1 | ||||||||||||
| 26452 | 3 | 1 | 2 | 1 | 4 | 0 |
Sheet3
_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 | 35487 | ||||||||||||||||||
| Data Sheet Format | 1 | ||||||||||||||||||
| Formula Eval Cell | 1 | ||||||||||||||||||
| Num Stored Vars | 8 | ||||||||||||||||||
| 1 : Info | VG1743C6AA27034F7B | var1 | ST_Employee | TRUE | 0 | 4 | |||||||||||||
| 1 : Ranges | 12 | ||||||||||||||||||
| 1 : MultiRefs | |||||||||||||||||||
| 2 : Info | VG12C5EA24365B9834 | var2 | ST_Salary | TRUE | 0 | 4 | |||||||||||||
| 2 : Ranges | 68425 | ||||||||||||||||||
| 2 : MultiRefs | |||||||||||||||||||
| 3 : Info | VG222F19C927DB081E | var3 | ST_YearsPreviousExperience | TRUE | 0 | 4 | |||||||||||||
| 3 : Ranges | 6 | ||||||||||||||||||
| 3 : MultiRefs | |||||||||||||||||||
| 4 : Info | VG318DF0BF37CD035A | var4 | ST_YearsEmployed | TRUE | 0 | 4 | |||||||||||||
| 4 : Ranges | 3 | ||||||||||||||||||
| 4 : MultiRefs | |||||||||||||||||||
| 5 : Info | VG1D035ED392DEF6C | var5 | ST_YearsEducation | TRUE | 0 | 4 | |||||||||||||
| 5 : Ranges | 3 | ||||||||||||||||||
| 5 : MultiRefs | |||||||||||||||||||
| 6 : Info | VGD6E122BC53379A | var6 | ST_Gender | TRUE | 0 | 4 | |||||||||||||
| 6 : Ranges | 0 | ||||||||||||||||||
| 6 : MultiRefs | |||||||||||||||||||
| 7 : Info | VG6A49E251126D455 | var7 | ST_Department | TRUE | 0 | 4 | |||||||||||||
| 7 : Ranges | 1 | ||||||||||||||||||
| 7 : MultiRefs | |||||||||||||||||||
| 8 : Info | VG2E375F36BF1B1A4 | var8 | ST_NumberSupervised | TRUE | 0 | 4 | |||||||||||||
| 8 : Ranges | 3 | ||||||||||||||||||
| 8 : MultiRefs |
