Question: In this data set the ROI data set - for 2 different majors (Business and Engineering), you are given a sample of the 20

In this data set – the ROI data set - for 2 different majors (Business and Engineering), you are given a sample of the 20 best colleges according to ROI (ROI = Return on Investment) and their ‘School Type’, ‘Cost’, ’30-Year ROI’, and ‘Annual % ROI’.

For each of the 2 majors create a pie chart using the column ‘School Type’. Comment on your results.

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).

For the histograms title your charts “Histogram Business Major: Annual % ROI” for Business majors and “Histogram Engineering Major: Annual % ROI” for Engineering Majors. Be sure to Comment on your results.

School TypeCost30 Year ROIAnnual ROI
Private$221,700.00$2,412,000.008.70%
Private$213,000.00$2,064,000.008.30%
Private$230,100.00$1,949,000.007.90%
Private$222,600.00$1,947,000.008.00%
Private$225,800.00$1,938,000.008.00%
Public$87,660.00$1,937,000.0011.20%
Private$224,900.00$1,915,000.007.90%
Private$221,600.00$1,878,000.007.90%
Public$125,100.00$1,854,000.009.80%
Private$215,700.00$1,794,000.007.90%
Public$92,530.00$1,761,000.0010.60%
Private$217,800.00$1,752,000.007.70%
Public$89,700.00$1,727,000.0010.70%
Private$229,600.00$1,716,000.007.50%
Public$101,500.00$1,703,000.0010.20%
Public$115,500.00$1,694,000.009.70%
Public$104,500.00$1,690,000.0010.10%
Public$69,980.00$1,685,000.0011.50%
Private$219,400.00$1,676,000.007.60%
Public$64,930.00$1,668,000.0011.70%

Step by Step Solution

3.38 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The pie chart for Private and Public School type are The frequency distribution ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

635d8d61a13bc_176685.pdf

180 KBs PDF File

Word file Icon

635d8d61a13bc_176685.docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!