Use an independent t-test to analyze data from a fictitious study. This study compares the ability of native English speakers and native Spanish speakers to state the font color of words that are color names. Although some of the participants are nonnative English speakers, all participants are considered fluent in English at the time of the study. The tricky aspect of this task is that the words will be printed in colors that are incongruent to the color names. The independent variable is the native language, and the dependent variable is the time it takes to state the color of font for all the words. It is hypothesized the native English speakers will take longer to state the colors compared with the nonnative speakers.
The data from the hypothetical study is given below. The explanations for the variable names used in the table are participant number (PID), time for native English speaker to read color words (NECW), age of participants in years (Age), and time for Spanish speaker to read color words (SSCW).
PID
NECW
Age
PID
SSCW
Age
P1
39
27
P11
32
52
P2
44
32
P12
27
27
P3
59
29
P13
29
33
P4
38
34
P14
34
40
P5
58
40
P15
40
31
P6
62
38
P16
38
28
P7
41
35
P17
35
22
P8
59
51
P18
28
23
P9
58
50
P19
36
25
P10
76
29
P20
38
38
You need to take the data from the twenty fictitious participants provided and enter the data into Microsoft Excel. Click here for instructions to install the Data Analysis ToolPak. Obtain the descriptive statistics (be sure to reformat so these are clearly readable). Next, analyze the data with an independent t-test (be sure to reformat the output so it is clearly readable). Was the hypothesis supported?