Question 1Assume you have noted the following prices for paperback books and the number of pages that each book contains. Develop a least-squares estimated regression line. Go to Excel. Create a scatt

4


Running head: Project Week 1

93/100 Review Comments

Week 1 Project

Yvonne Lang

Grantham University

Week 1 Project

  1. For each of the 2 majors create a pie chart using the column ‘School Type’.  Comment on your results.

    08‎/‎02‎/‎2018‎ ‎03‎:‎08‎ ‎PM

    Remember that the data is connected to ROI. ROI should be in the title, and it should be in the graph interpretation also

Question 1Assume you have noted the following prices for paperback books and the number of pages that each book contains. Develop a least-squares estimated regression line. Go to Excel. Create a scatt 1

We can see here that 80% of the Business majors in this study attended a private school.

Question 1Assume you have noted the following prices for paperback books and the number of pages that each book contains. Develop a least-squares estimated regression line. Go to Excel. Create a scatt 2

We can see here that the type of school attended for engineering is almost half private and half public.

  1. 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).

Business Major

Annual % ROI

Frequency

6 to 6.5%

6.5 to 7%

7 to 7.5%

7.5 to 8%

8 to 8.5%

8.5 to 9%

9 to 9.5%

9.5 to 10%

10 to 10.5%

10.5 to 11%

11 to 11.5%

11.5 to 12%

Question 1Assume you have noted the following prices for paperback books and the number of pages that each book contains. Develop a least-squares estimated regression line. Go to Excel. Create a scatt 3

Engineering Major

Annual % ROI

Frequency

6 to 6.5%

6.5 to 7%

7 to 7.5%

7.5 to 8%

8 to 8.5%

8.5 to 9%

9 to 9.5%

9.5 to 10%

10 to 10.5%

10.5 to 11%

11 to 11.5%

11.5 to 12%













Question 1Assume you have noted the following prices for paperback books and the number of pages that each book contains. Develop a least-squares estimated regression line. Go to Excel. Create a scatt 4

From these charts, we can conclude that most college educations will yield at least a 6.5% and up to an 11.7% Annual ROI if you major in Business or Engineering.