The data set is used to predict how level of education (% of population over 25 with BA degree and higher) affects wealth (median household income) in CA counties. Please answer the following questions.

Q1: Please use the data set to create a regression equation or a regression line that can predict how level of education affects wealth in CA countie. NOTES: You are required to: 1) clearly state what is the dependent variable (Y) (4 pts) and what is the independent variable (X) (); 2) correctly calculate the associated slope and intercept (8 pts); 3) finally write out the exact regression equation (4 pts).

Q2: Please predict the related median household income when there is 70% of population over 25 with BA degree and higher.

DATA BELOW

% of population over 25 with BA degree and higher	Median Household Income ($)
42.1	100,929
20.5	71,348
25.0	59,961
21.1	69,588
39.4	108,689
32.1	90,996
19.5	63,284
27.5	53,746
13.4	58,528
15.2	66,834
12.5	63,647
16.2	49,757
29.9	82,439
13.5	60,980
54.8	136,032
22.5	55,057
13.0	59,460
23.1	74,320
31.9	92,291
32.8	72,723
37.3	101,991
35.7	96,623
20.8	72,793
28.2	73,413
18.8	70,608
35.1	86,490
52.9	119,795
18.1	70,046
32.1	75,332
45.0	129,290
31.4	83,773
47.3	125,946
37.5	89,007
19.1	59,949
24.0	46,764
24.3	80,797
32.6	82,006
16.4	65,643
18.5	67,646
14.1	55,480
13.3	58,295
19.8	59,266
31.6	98,200
38.3	76,752
14.2	54,213