Political Affiliation	State	Case Rate per 100,000	GDP Per Capita in 2020 ($)
Swing States	Arizona	11,702	50,187
	Florida	9,815	50,424
	Georgia	10,172	57,819
	Michigan	8,589	51,766
	Nevada	10,055	54,998
	North Carolina	8,974	55,292
	Pennsylvania	8,537	61,031
	Wisconsin	11,150	58,066
Solid Red States	Arkansas	11,033	42,591
	Indiana	10,447	55,165
	Kansas	10,480	59,475
	Kentucky	9,753	46,909
	Nebraska	11,156	66,480
	Oklahoma	11,242	46,871
	Tennessee	12,141	52,925
	Wyoming	9,884	62,236
Solid Blue States	California	9,134	78,538
	Colorado	8,428	67,169
	Connecticut	9,200	78,971
	Delaware	10,261	76,522
	Maryland	7,194	69,805
	Massachusetts	9,234	84,722
	New Jersey	10,892	69,695
	Virginia	7,536	64,229

1. Select the most appropriate test statistic to examine whether the means of GDP per capita in 2020 between three groups of states (swing states, solid red states, and solid blue states) are significantly different.

1. You are required to insert a new sheet in Excel to place the data on GDP per capita in 2020 grouped by political affiliation (swing states, solid red states, and solid blue states). Also, please keep your original statistical results in this new sheet. (Tips: Complete this question in Excel)

2. Please follow the famous eight steps to test whether the means of GDP per capita in 2020 between three groups of states (swing states, solid red states, and solid blue states) are significantly different. (Tips: Complete this question in Word)