School Type I Need Help With My Work

School Type I Need Help With My Work

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

  1. Explain the concept of ROI. Why is ROI important to people?
  2. For each of the 2 majors create a pie chart using the column ‘School Type’.
  3. 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.
  4. 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.
  5. 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 assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. Download it here.

Using the ROI data set:

  1. For each of the 2 majors calculate the mean, median, minimum, maximum, range, and standard deviation for the columns ‘Cost’ and ’30-Year ROI’.
  2. 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’.
  3. 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.
  4. 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.

For these 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 –

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.

Order your essay today and save 7% with the discount code ESSAYHELP7