20 50 40 50 I Need Help With My Assignment

20 50 40 50 I Need Help With My Assignment

Question 2

A sample of the ages of 10 employees of a company is shown below.

20 50 40 50 50
30 20 30 50 40

  • Using a method of your choosing, construct a dot plot for the above data. Remember that all charts, tables, and graph need titles that clearly describe what is being shown. In addition, axes need labels.

Question 3

The following data shows the price of PAO, Inc. stock over the last eight months.

  1. Using Excel, develop a scatter diagram and draw a trend line through the points. Remember, all charts, tables, and graphs need titles that clearly show the relationship between the two variables.
  2. What kind of relationship exists between stock price and time (negative, positive, or no relation)?
  3. How does the relationship from #2 relate to slope?

Question 4

For this part of the assignment 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. Explain the concept of ROI. Why is ROI important to people?
  2. For each of the 2 majors create a pie chart using the column ‘School Type’.
  3. For each of the 2 majors create a frequency distribution table and a 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). Make sure that no two ranges overlap.
  4. Make sure that all graphs and charts have labels on each axis. Make sure pie graphs have a key so that we know what each section represents. For the histograms, you could title your charts “Histogram Business Major: Annual % ROI” for Business majors and “Histogram Engineering Major: Annual % ROI” for Engineering Majors.