Reference the data in the ROI Excel spreadheet. Attached below

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

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
  1. For each of the 2 majors create a pie chart using the column ‘School Type’. Comment on your results.
  2. 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.
  • Question 1 hint/help. Find out how many schools are public and how many are private in each major and do a pie chart (2 charts total). Use the charting function to make a pie chart in Excel. Make sure not to include the total in your pie chart—just the numbers for private and public for each major.Question 2 hint/help. For each major do a frequency distribution (2 charts total)—that is find out how many schools are in each bucket. The buckets will look something like 6%≤x<6.5%, 6.5%≤x<7%, etc. all the way to 10.5%≤x<11%, where x is Annual ROI. Then use these as the text labels for the x axis of your graph—Excel can do this automatically–the y axis will be the number of schools in each Annual ROI bucket.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.