Project Week 1

Project 1 Instructor Comments:

Submit your answers by uploading the spreadsheet with answers completed.

1. Find out how many schools are public and how many are private in each major and do a pie chart (2 charts total). Use the charting function to make a pie chart in Excel. Make sure not to include the total in your pie chart—just the numbers for private and public for each major.

2. For each major do a frequency distribution (2 charts total)—that is find out how many schools are in each bucket. The buckets will look something like 6%≤x<6.5%, 6.5%≤x<7%, etc. all the way to 10.5%≤x<11%, where x is Annual ROI. Then use these as the text labels for the x axis of your graph—Excel can do this automatically–the y axis will be the number of schools in each Annual ROI bucket.

For these project 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. For each of the 2 majors create a pie chart using the column ‘School Type’. Comment on your results.
  2. 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.

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
#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational