project week 2

/in /by

Project Week 2

Project 2 Instructor Comments:

Students tend to make this assignment a real pain to grade by scattering the answers all over the page—or not removing other statistics, if the answers are gotten by using Excel Descriptive Statistics. Help by only including the required answers, numbering the problems, and doing each answer in order.

1. Make a column for the 6 variables; then do two columns for Business Major—one for Cost and one for 30 Year ROI; next to that put 2 columns for Engineering Major.

2. There are two answers needed here—one for business and one for engineering. Pull out the private numbers for each major and then divide each by the total observed in each major—answers should be a percent. Put business first and engineering second.

3. Again, two answers are required. Just look at the private data for each major. Add up the schools with 30 Year ROI between $1.5 M and $1.8 M; then divide that number by the total private schools in each category—answers should be a percent. Put business first and engineering second.

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:

  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.
Grading Criteria Assignments Maximum Points
Meets or exceeds established assignment criteria 40
Demonstrates an understanding of lesson concepts 20
Clearly presents well-reasoned ideas and concepts 30
Uses proper mechanics, punctuation, sentence structure, and spelling 10
Total 100
 
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.