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.
- 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.
- What kind of relationship exists between stock price and time (negative, positive, or no relation)?
- 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’.
- Explain the concept of ROI. Why is ROI important to people?
- For each of the 2 majors create a pie chart using the column ‘School Type’.
- 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.
- 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.