Question

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%

School Type

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 Majo 2013: Payscale.com

1. Make a column for the 6 variables; then do two columns for Business Major—one for Cost and one for 30 Year ROI; next to that put 2 columns for Engineering Major.

2. There are two answers needed here—one for business and one for engineering. Pull out the private numbers for each major and then divide each by the total observed in each major—answers should be a percent. Put business first and engineering second.

3. Again, two answers are required. Just look at the private data for each major. Add up the schools with 30 Year ROI between $1.5 M and $1.8 M; then divide that number by the total private schools in each category—answers should be a percent. Put business first and engineering second.

For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. Download it here.

Using the ROI data set:

For each of the 2 majors calculate the mean, median, minimum, maximum, range, and standard deviation for the columns ‘Cost’ and ’30-Year ROI’.

By hand or with Excel, for each of the 2 majors calculate the probability that a college picked from the column for ‘School Type’ is ‘Private’.

By hand or with Excel, for each of the 2 majors find the probability that a college with the ‘School Type’ ‘Private’ has a ’30-Year ROI’ between $1,500,000 and $1,800,000.

Answer 1

a) The pie chart for Private and Public School type are

b) The frequency distribution and histogram using the column ‘Annual % ROI’ is

Anual ROI	Cost	30 Year ROI
6-6.5%	0.00	0.00
6.5-7%	0.00	0.00
7-7.5%	2,29,600.00	17,16,000.00
7.5-8%	1777900.00	14849000.00
8-8.5%	213000.00	2064000.00
8.5-9%	221700.00	2412000.00
9-9.5%	0	0
9.5-10%	240600.00	3548000.00
10-10.5%	206000.00	3393000.00
10.5-11%	182230.00	3488000.00
11-11.5%	157640.00	3622000.00
11.5-12%	64930.00	1668000.00 c)