In this data set – the ROI data set - for 2 different majors (Business and Engin

Question

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

Thus first proportional percentages are found out

Now using this pie chart is prepared

Percentage School Type Cost 30 Year ROI Annual ROI Cost 30 yr ROI Private $221,700.00 $2,412,000.00 8.70% $6.73 $6.56 Private $213,000.00 $2,064,000.00 8.30% $6.47 $5.61 Private $230,100.00 $1,949,000.00 7.90% $6.99 $5.30 Private $222,600.00 $1,947,000.00 8.00% $6.76 $5.30 Private $225,800.00 $1,938,000.00 8.00% $6.86 $5.27 Public $87,660.00 $1,937,000.00 11.20% $2.66 $5.27 Private $224,900.00 $1,915,000.00 7.90% $6.83 $5.21 Private $221,600.00 $1,878,000.00 7.90% $6.73 $5.11 Public $125,100.00 $1,854,000.00 9.80% $3.80 $5.04 Private $215,700.00 $1,794,000.00 7.90% $6.55 $4.88 Public $92,530.00 $1,761,000.00 10.60% $2.81 $4.79 Private $217,800.00 $1,752,000.00 7.70% $6.61 $4.77 Public $89,700.00 $1,727,000.00 10.70% $2.72 $4.70 Private $229,600.00 $1,716,000.00 7.50% $6.97 $4.67 Public $101,500.00 $1,703,000.00 10.20% $3.08 $4.63 Public $115,500.00 $1,694,000.00 9.70% $3.51 $4.61 Public $104,500.00 $1,690,000.00 10.10% $3.17 $4.60 Public $69,980.00 $1,685,000.00 11.50% $2.12 $4.58 Private $219,400.00 $1,676,000.00 7.60% $6.66 $4.56 Public $64,930.00 $1,668,000.00 11.70% $1.97 $4.54    $3,293,600.00 $36,760,000.00 $100.00 $100.00

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.