Week 1 project
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.
9 years ago 5
Answer(2)
Purchase the answer to view it
NOT RATED
- order_53538_129156.xlsx
Purchase the answer to view it
NOT RATED
- week_1_assignment.docx
Bids(1)
other Questions(10)
- Assignment
- Political Science Assignment
- Ratio Analysis
- can you deliver in 8 hours?
- math
- Managing Change at Multiple Levels
- Watch Video Lecture Segment: 11 Problem Solving with Repetition. There are 3 problems solved. Test Scores, Gas Mileage, and Factorials. Type along with the video, pausing where necessary. Get each of these programs to work. Walk through the code in the d
- Business slp1
- Interview
- FOR KIM WOODS Only