‘ school type ’, ‘ cost ’, ’ 30 B u s i n e s s F i n a n c e

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

- Explain the concept of ROI. Why is ROI important to people?
- For each of the 2 majors create a pie chart using the column ‘School Type’.
- For each of the 2 majors create a frequency distribution table and a 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). Make sure that no two ranges overlap.
- Make sure that all graphs and charts have labels on each axis. Make sure pie graphs have a key so that we know what each section represents. For the histograms, you could title your charts “Histogram Business Major: Annual % ROI” for Business majors and “Histogram Engineering Major: Annual % ROI” for Engineering Majors.
- The final project for this course has you giving advice to someone who does not know which is the better ROI – business or engineering. Each week, we will examine the data in this same spreadsheet from a different angle. Look at the graphs that you have constructed. In an area that is highlighted in yellow, interpret these graphs. What is the data telling you about ROI and each major? What conclusions can you draw from these charts. Be as specific as possible. Your final project for this course puts each week’s “main ideas” together to form one massive project. Your specificity now will save you time during Week 8.

For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. Download it here.

Using the ROI data set:

- For each of the 2 majors calculate the mean, median, minimum, maximum, range, and standard deviation for the columns ‘Cost’ and ’30-Year ROI’.
- By hand or with Excel, for each of the 2 majors calculate the probability that a college picked from the column for ‘School Type’ is ‘Private’.
- By hand or with Excel, for each of the 2 majors find the probability that a college with the ‘School Type’ ‘Private’ has a ’30-Year ROI’ between $1,500,000 and $1,800,000.
- Add a box at the bottom of the assignment that is highlighted. This is the main idea box. Write a paragraph of main ideas found in this exercise. Remember that your final project is about ROI. Compare the means, medians, etc. along with interpreting the calculations you did on probability.

## Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount