# The following table shows the annual number of PhD graduates in a country in various fields. NaturalSciencesEngineeringSocialSciencesEducation1990701070301995130401104020003301302801202005490370460210201059055083052020126905901,000900(a)With x = the number of social science doctorates and y = the number of education doctorates, use technology to obtain the regression equation. (Round coefficients to three significant digits.)y(x) =   (b)Use technology to obtain the coefficient of correlation r. (Round your answer to three decimal places.)r =

Question
1 views
The following table shows the annual number of PhD graduates in a country in various fields.
Natural
Sciences
Engineering Social
Sciences
Education
1990 70 10 70 30
1995 130 40 110 40
2000 330 130 280 120
2005 490 370 460 210
2010 590 550 830 520
2012 690 590 1,000 900
(a)
With x = the number of social science doctorates and y = the number of education doctorates, use technology to obtain the regression equation. (Round coefficients to three significant digits.)
y(x) =

(b)
Use technology to obtain the coefficient of correlation r. (Round your answer to three decimal places.)
r =
check_circle

Step 1

(a)

Step-by-step procedure to obtain the regression equation using Excel:

• In Excel sheet, enter X in one column and enter Y in one column.
• In Data, select Data Analysis and choose Regression.
• In Input Variable y Range, select Education.
• In Input Variable x Range, select Social Sciences.
• Click Labels.
• Click Ok.

Output obtained using Excel is given below:

Step 2

From the output, the regre...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in