Need statistics help with "Using ROI Excel" Presentation of Data Business Statistics

User Generated

Funerivn25

Mathematics

Description

Project Week 1

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags