Needs to Done on Time!!!
1
Running head: Project Week 1
Week 1 Project
Yvonne Lang
Grantham University
Week 1 Project
1. For each of the 2 majors create a pie chart using the column ‘School Type’. Comment on your results.
We can see here that 80% of the Business majors in this study attended a private school.
We can see here that the type of school attended for engineering is almost half private and half public.
2. For each of the 2 majors create a frequency distribution and histogram using the column ‘Annual % ROI’. Group with starting at 6% (0.06), ending at 11% (0.11), and go by 0.5% (0.005).
Business Major |
|
Annual % ROI |
Frequency |
6 to 6.5% |
0 |
6.5 to 7% |
2 |
7 to 7.5% |
9 |
7.5 to 8% |
3 |
8 to 8.5% |
2 |
8.5 to 9% |
0 |
9 to 9.5% |
1 |
9.5 to 10% |
1 |
10 to 10.5% |
2 |
10.5 to 11% |
0 |
11 to 11.5% |
0 |
11.5 to 12% |
0 |
Engineering Major |
|
Annual % ROI |
Frequency |
6 to 6.5% |
0 |
6.5 to 7% |
0 |
7 to 7.5% |
0 |
7.5 to 8% |
7 |
8 to 8.5% |
3 |
8.5 to 9% |
1 |
9 to 9.5% |
0 |
9.5 to 10% |
2 |
10 to 10.5% |
2 |
10.5 to 11% |
2 |
11 to 11.5% |
1 |
11.5 to 12% |
2 |
From these charts, we can conclude that most college educations will yield at least a 6.5% and up to an 11.7% Annual ROI if you major in Business or Engineering.
0 1 2 3 4 5 6 7 8
6 to 6.5%
6.5 to 7%
7 to 7.5%
7.5 to 8%
8 to 8.5%
8.5 to 9%
9 to 9.5%
9.5 to 10%
10 to 10.5%
10.5 to 11%
11 to 11.5%
11.5 to 12%
Fr eq ue nc y
Annual % ROI
Histogram Engineering Major: Annual % ROI
0
1
2
3
4
5
6
7
8
6 to
6.5%
6.5 to
7%
7 to
7.5%
7.5 to
8%
8 to
8.5%
8.5 to
9%
9 to
9.5%
9.5 to
10%
10 to
10.5%
10.5
to
11%
11 to
11.5%
11.5
to
12%
F
r
e
q
u
e
n
c
y
Annual % ROI
Histogram Engineering Major: Annual % ROI
Private 80%
Public 20%
Business Major School Type
Private Public
Private
80%
Public
20%
Business Major School Type
PrivatePublic
Private 55%
Public 45%
Engineering Major School Type
Private Public
Private
55%
Public
45%
Engineering Major School Type
PrivatePublic
0 1 2 3 4 5 6 7 8 9 10
6 to 6.5%
6.5 to 7%
7 to 7.5%
7.5 to 8%
8 to 8.5%
8.5 to 9%
9 to 9.5%
9.5 to 10%
10 to 10.5%
10.5 to 11%
11 to 11.5%
11.5 to 12%
Fr eq ue nc y
Annual % ROI
Histogram Business Major: Annual % ROI
0
1
2
3
4
5
6
7
8
9
10
6 to
6.5%
6.5 to
7%
7 to
7.5%
7.5 to
8%
8 to
8.5%
8.5 to
9%
9 to
9.5%
9.5 to
10%
10 to
10.5%
10.5
to
11%
11 to
11.5%
11.5
to
12%
F
r
e
q
u
e
n
c
y
Annual % ROI
Histogram Business Major: Annual % ROI