1. Make a report on the detailed description of the data used in this analysis –
ID: 2654736 • Letter: 1
Question
1. Make a report on the detailed description of the data used in this analysis – specifically explain what the data in each column represents.
2. A detailed explanation of any information learned about:
a. School Type for each major;
b. The Cost for each major;
c. The 30 Year ROI for each major;
d. The Annual % ROI for each major.
Explanations should be supported with the results.
Engineering major:
School Type
Cost
30 Year ROI
Annual ROI
Private
$221,700.00
$2,412,000.00
8.70%
Private
$213,000.00
$2,064,000.00
8.30%
Private
$230,100.00
$1,949,000.00
7.90%
Private
$222,600.00
$1,947,000.00
8.00%
Private
$225,800.00
$1,938,000.00
8.00%
Public
$87,660.00
$1,937,000.00
11.20%
Private
$224,900.00
$1,915,000.00
7.90%
Private
$221,600.00
$1,878,000.00
7.90%
Public
$125,100.00
$1,854,000.00
9.80%
Private
$215,700.00
$1,794,000.00
7.90%
Public
$92,530.00
$1,761,000.00
10.60%
Private
$217,800.00
$1,752,000.00
7.70%
Public
$89,700.00
$1,727,000.00
10.70%
Private
$229,600.00
$1,716,000.00
7.50%
Public
$101,500.00
$1,703,000.00
10.20%
Public
$115,500.00
$1,694,000.00
9.70%
Public
$104,500.00
$1,690,000.00
10.10%
Public
$69,980.00
$1,685,000.00
11.50%
Private
$219,400.00
$1,676,000.00
7.60%
Public
$64,930.00
$1,668,000.00
11.70%
Business Major:
School Type
Cost
30 Year ROI
Annual ROI
Private
$222,700.00
$1,786,000.00
7.70%
Private
$176,400.00
$1,758,000.00
8.40%
Private
$212,200.00
$1,714,000.00
7.80%
Public
$125,100.00
$1,535,000.00
9.10%
Private
$212,700.00
$1,529,000.00
7.40%
Public
$92,910.00
$1,501,000.00
10.10%
Private
$214,900.00
$1,485,000.00
7.30%
Private
$217,800.00
$1,483,000.00
7.20%
Private
$225,600.00
$1,444,000.00
7.00%
Private
$217,300.00
$1,442,000.00
7.10%
Private
$226,500.00
$1,441,000.00
7.00%
Private
$215,500.00
$1,438,000.00
7.20%
Private
$223,500.00
$1,428,000.00
7.00%
Private
$226,600.00
$1,414,000.00
7.00%
Private
$189,300.00
$1,397,000.00
7.50%
Public
$89,700.00
$1,382,000.00
9.90%
Public
$87,030.00
$1,376,000.00
10.00%
Private
$218,200.00
$1,343,000.00
6.90%
Private
$229,900.00
$1,339,000.00
6.70%
Private
$148,800.00
$1,321,000.00
8.10%
Best College ROI by Major 2013: Payscale.com
School Type
Cost
30 Year ROI
Annual ROI
Private
$221,700.00
$2,412,000.00
8.70%
Private
$213,000.00
$2,064,000.00
8.30%
Private
$230,100.00
$1,949,000.00
7.90%
Private
$222,600.00
$1,947,000.00
8.00%
Private
$225,800.00
$1,938,000.00
8.00%
Public
$87,660.00
$1,937,000.00
11.20%
Private
$224,900.00
$1,915,000.00
7.90%
Private
$221,600.00
$1,878,000.00
7.90%
Public
$125,100.00
$1,854,000.00
9.80%
Private
$215,700.00
$1,794,000.00
7.90%
Public
$92,530.00
$1,761,000.00
10.60%
Private
$217,800.00
$1,752,000.00
7.70%
Public
$89,700.00
$1,727,000.00
10.70%
Private
$229,600.00
$1,716,000.00
7.50%
Public
$101,500.00
$1,703,000.00
10.20%
Public
$115,500.00
$1,694,000.00
9.70%
Public
$104,500.00
$1,690,000.00
10.10%
Public
$69,980.00
$1,685,000.00
11.50%
Private
$219,400.00
$1,676,000.00
7.60%
Public
$64,930.00
$1,668,000.00
11.70%
Explanation / Answer
1. The data in the school type column express the type of school whether public or private. It basically signifies the percent stake hold by each stakeholder and the private control or public control over the organziation. The cost colum represent the total cost incurred by the students to complete an engioreening major or business major in the school. 30 year ROI signifies the total return a student is expected to earn on its investement (Cost paid to school) in the period of 30 years by the job, service or any other means using the skills developed in the major.Annual ROI is the annual return on investement earned by the students on an avergae after completing their major from the school.
2. School type: the cost incurred in public school is less than the private school and hence their ROI is higher than private schools.
Cost- Cost of public school is low.Cost of engineering major is lower than business major.
30 year ROI - ROI of 30 year is higher for the private schools as compared to public schools.The 30 year business major ROI is lower than the Engineering ROI.
Annual ROI - ROI of public school is higher being the low cost of investement.
Thus, a student should prefer a public schoo rather than a private school and engineering major is preferred over business major.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.