The following Excel output for = 0.01 summarizes a portion of the results for a
ID: 3437503 • Letter: T
Question
The following Excel output for = 0.01 summarizes a portion of the results for a randomized block experiment without interaction where factor A (column) represents three income categories (low, medium, high), factor B (rows) consists of three different kinds of political parties (Democrat, Republican, Independent), and the variable measured was the amount (in $) contributed to the political party during the 2008 presidential election.
Find the missing values in the ANOVA table. (Round your answers except "df" to 2 decimal places.)
ANOVA Source of variation SS df MS F p-value F crit Rows 43,061.29 3 MSB = FFactor B = 0.0010 12.0600 Columns 15,374.15 3 MSA = FFactor A = 0.0150 12.0600 Error 2,537.79 5 MSE = Total 60,973.23 11Explanation / Answer
On the MS column:
MSB = SS(row)/df(row) = 14353.76
MSA = SS(columns) / df(columns) = 5124.72
MSE = SS(error)/df(error) = 507.56
*****************
On the F column,
F(B) = MSB / MSE = 28.28
F(A) = MSA / MSE = 10.10