# Project part 1

For
these project assignments throughout the course you will need to
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. The
Week 8 project is completed in part every week. If you do each
week’s project, your Week 8 project will go a lot better than if you
do not. Open the spreadsheet. Explain what ROI is.
2. From
the spreadsheet, define what each column is telling you. Go beyond
giving the name of the column. For example, what is a 30-year
ROI?
3. For
each of the 2 majors create a pie chart using the column ‘School
Type’. Make sure that the title clearly explains what you
are looking at.
4. 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). Make
sure that there are NO overlapping bars. For example, if one
5. In
a highlighted box, interpret your results. Do the samples
represent public and private schools equally? What does this
mean in terms of the population of schools? Is there a certain
histogram bar that is higher than all the others? What does
this mean in terms of ROI? These are not the only questions
you can use to interpret the results, but they are a push in the
right direction. Keep going. What else do you see?

# Project part 2

For
these project assignments throughout the course you will need to
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. Define each
of the terms in #1, and explain how each can be used to provide
3. 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’.
4. 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.
5. This is 