Project Week 1
For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. Download it here.
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. Comment on your results.