In: Statistics and Probability
A sociologist researching the link between race and inequality believes that younger people and/or people with more education generally have more tolerant views. To test this hypothesis, the sociologist gathers a random sample of 10 Caucasians ranging in age from teenager to elderly and asks them for their beliefs about African-Americans on a 10-point scale (1 representing acceptance of negative beliefs, 10 representing acceptance of positive beliefs), and number of completed years in school (including college if applicable). Check to see if his idea about the relationship between age and racial stereotyping and education is correct by conducting the correct comparative analysis and interpreting the results in context with APA notation in your response and an APA style table depicting the results.
Age |
Beliefs about African-Americans |
Years in School |
16 |
9 |
10 |
18 |
10 |
12 |
20 |
7 |
15 |
29 |
8 |
12 |
34 |
6 |
13 |
46 |
3 |
11 |
51 |
5 |
16 |
65 |
4 |
12 |
69 |
5 |
11 |
82 |
3 |
9 |
To test claim that younger people and/or people with more education generally have more tolerant views, the regression analysis is used to draw a relationship between explanatory variable Beliefs about African-Americans and response variable Years in school and Age.Then, the hypothesis test is performed to test the relationship between tolerant views and Years in school and Age.
The regression analysis is performed in excel by following these 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: 'Beliefs about African-Americans' column, Input X Range: 'Years in School and Age' column then OK. The screenshot is shown below,
The result is obtained. The screenshot is shown below,
From the result summary, the regression equation is,
The hypothesis is tested by calculating the t-statistic value and corresponding p-value as shown below,
For Beliefs about African-Americans vs Years in School
Null Hypothesis:
Alternate Hypothesis:
From the regression analysis output summary,
Since the P-value is greater than 0.05 at 5% significance level. The null hypothesis is not rejected.
For Beliefs about African-Americans vs Age
Null Hypothesis:
Alternate Hypothesis:
From the regression analysis output summary,
Since the P-value is less than 0.05 at 5% significance level. The null hypothesis is rejected.
Hence we can conclude that Age has statistically significant relation with Beliefs about African-Americans.