ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
INSTRUCTIONS CREATED BY
3
4
THIS COPY IS READ ONLY!!! Save your own copy before using this sheet. To do this, click File > Make a Copy. Make sure that the "Copy Comments" box is checked, so you can see my notes throughout the sheet. Nia Johnson, CBS '23
Twitter: @_johnsonator
LinkedIn: https://www.linkedin.com/in/niajohnson101/
5
6
7
TABLE OF CONTENTS
8
9
1) Raw Data - where the unfiltered survey responses live
10
2) Descriptive Statistics - means, medians, standard deviations from the data set
11
3) Salary Calulator - use to estimate your hourly pay
12
4) Regression Output - output from the final regression output
13
5) Unpaid Internship Responses - dataset with only entries from unpaid interns
14
6) Unpaid Internship Breakdown - charts and graphs from the unpaid intern data set
15
7) Pay Distribution (Actual) - histogram of the hourly rate paid to interns
16
8) Pay Distribution (Offered) - histogram of the pay initial offered to the interns
17
9) Negotiation Responses - dataset with only entries from interns who attempted to negotiate their pay
18
10) Gender Breakdown (Negotiation) - pie chart detailing the gender idenities of interns who attempted to negotiate their pay
19
11) Gender Breakdown (Successful Negotiation) - pie chart detailing the gender idenities of interns who successfully negotiated their pay
20
12) Degree Program - pie chart detailing the degree program of respondents upon starting the internship
21
13) Year in School - pie chart detailing the year in school of respondents upon starting the internship
22
14) Fund Location - pie chart detailing the fund location of respondents upon starting the internship
23
15) In-Semester vs. Summer - pie chart detailing whether the internship took place over the summer or during school year
24
16) Fund Size - pie chart detailing the size of the funds employing the interns
25
17) VC Experience - pie chart detailing the years of VC experience the interns have upon starting their internship
26
18) Work Experience - pie chart detailing the years of general work experience the interns have upon starting their internship
27
19) Gender - pie chart detailing the gender idenities of the respondents
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