# Week 1 Project Assignment

For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadsheet. 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â€™.

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.

# Week 2 Project Assignment

For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadsheet. 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.

# Week 3 Project Assignment

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

Using the ROI data set:

If we select 7 colleges from a major and then record whether they are of â€˜School Typeâ€™ â€˜Privateâ€™ or not, is this experiment a binomial one? Why or why not?

For each of the 2 majors determine if the â€˜Annual % ROIâ€™ appears to be normally distributed. Consider the shape of the histogram and the measures of central tendency (mean and median) to justify your results. Report on each of these with charts and calculations to justify your answers.