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.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.