Question

1. Using the unemployment data provided, investigate the association between the male unemployment rate in 2007 and 2010 for a sample of 52 countries. (If you use EXCEL please show me how you solved this please - it would be great help to see the steps) Thank you!

Find a regression model predicting the 2010 rate from the 2007 rate for the sample of 52 countries . State in simple language what the model says.

2010 Index = ___________ + _____________________ x 2007 Index (Round to two decimal places as needed.)

State in simple language what the model says. Select the correct choice below and fill in the answer box to complete your choice.

(Round to two decimal places as needed.)

0 A. For each 1% increase in the 2007 rate, the 2010 rate increased by ____________

0 B. The 2010 rate increased by______________________ per year.

0 C. The 2007 rate increased by _______________per year.

0 D. For each 1% increase in the 2010 rate, the 2007 rate increased by ___________________

Determine the test statistic. t = ____________ (Round to two decimal places as needed.)

Determine the P-value. P-value = _____________ (Round to three decimal places as needed.)

Make a conclusion.

Since the P-value is (1) ________________ the significance level, a, (2)_____________________ the null hypothesis.

The association (3) ______________significant

(1)      0 less than                       

          0 greater than

      (2)      0 do not reject

                0 reject

    (3)     0 is

   0 is not

Country	Male 2007	Male 2010
1	24 .1	21.5
2	11.9	10.1
3	9.6	11.4
4	20 .7	17.5
5	25.2	22.7
6	14.7	13.3
7	16.8	15.7
8	13.6	11.6
9	12.5	10.2
10	30.6	29.2
11	8.5	13.4
12	21.1	19.5
13	8.6	8.9
14	14.1	11.3
15	21.4	16.2
16	27.7	15.2
17	22.9	3.7
18	24.5	26.8
19	13.9	26.4
20	18.4	17.8
21	8.9	5.4
22	15.9	19.4
23	8.2	9.2
24	20.3	8.4
25	20.3	17.8
26	11.1	10.6
27	12.8	11.1
28	16.9	12.9
29	21.8	16.7
30	21.9	19.6
31	6.6	5.6
32	8.3	9.3
33	12.9	12.8
34	22.2	17.2
35	19.3	21.8
36	18.4	15.6
37	38.9	35.5
38	13.2	13.3
39	21.3	24.6
40	21.2	18.4
41	22.8	21.5
42	33.2	29 .2
43	12.2	10.3
44	18.7	16.9
45	21.9	19.9
46	16.7	15.2
47	8.5	7.2
48	4.8	4 .3
49	65.4	63.5
50	20.6	19.1
51	12.2	12.3
52	12.6	11.2

Answer 1

The regression equation is defined as,

The regression analysis is done in excel by following steps

Step 1: Write the data values in excel. The screenshot is shown below,

Step 2: DATA > Data Analysis > Regression > OK. The screenshot is shown below,

Step 3: Select Input Y Range: 'Male 2010 ' column, Input X Range: 'Male 2007' column then OK. The screenshot is shown below,

The result is obtained. The screenshot is shown below,

The regression equation is,

Correct Answer: A.  For each 1% increase in the 2007 rate, the 2010 rate increased by 0.88%

Explanation: Since independent variable is male 2007, hence for 1% increase in independent variable( 2007 rate), the dependent variable (2010 rate) will increase by the value of estimated slope coefficient (0.88%) of independent variable.

Correct Answer: t-statistic = 14.33

Explanation: From the result summary, the t statistic for the estimate coefficient value of independent variable is 14.3318

Correct Answer: P-value = 0.000

Explanation: From the result summary, the P-value for the t statistic above is 0.000

Correct Answer: Since the P-value is less than the significance level, a, reject the null hypothesis.The association is significant.

Explanation: The null and alternative hypothesis for the test are defined as,,

From the result summary, the P-value for the slope coefficient is less than significance level = 0.01 at 1% significance level. The null hypothesis is rejected hence the independent variable is statistically significant.