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 deadlinesOrder Paper Now
- 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.
- 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.