job market model.xlsx
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Job Market Model
3
dropout rate per year:0.2
4
new applicants per year:500
5
jobs per year:100
6
7
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11
8
class yearjobs givenremaining candidates from classjobs givenremaining candidates from classjobs givenremaining candidates from classjobs givenremaining candidates from classjobs givenremaining candidates from classjobs givenremaining candidates from classjobs givenremaining candidates from classjobs givenremaining candidates from classjobs givenremaining candidates from classjobs givenremaining candidates from classjobs givenremaining candidates from class
9
100100100100100100100100100100100
10
x (start)100320392252116313120890667450338229222117
11
x+1500613513325520188131409105679460345234226
12
x+2500463632826819199131499112685564349337
13
x+3500393692627517206121559117688567351
14
x+4500353722427917210121589120691569
15
x+5500323752228216213121619122692
16
x+6500303762128416215111638123
17
x+750028377212851521611164
18
x+8500273782028615217
19
x+95002737920287
20
x+1050026379
21
100100100100100100100100100100100
22
23
total applicants:500820107612811445157616811764183218851928
24
total jobs:100100100100100100100100100100100
25
average individual placement rate:20%12%9%8%7%6%6%6%5%5%5%
26
percentage of jobs to first two years on market:100%100%79%67%60%55%52%50%48%47%46%
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1