The Summary table in the top portion displays mean incomes for our six groups. Males have a higher average income, and that effect is consistent (plus or minus random error) across majors. For example, gender’s main effect on average income does not change from one major to another. The main effects are the portion of the relationship between an independent variable and the dependent variable that does not change based on the values of the other variables in the model. Because the interaction effect is not significant, we can focus on only the main effects. On the other hand, the interaction effect is not significant because its p-value (0.151) is greater than our significance level. Note that these p-values are so low that Excel uses scientific notation to represent them. Because the p-values for both Gender and Major are less than our significance level, these factors are statistically significant. Interpreting Excel’s Two-Way ANOVA Resultsįirst, look in the P-value column in the ANOVA Source of Variation table at the bottom of the output. Change this value only when you have a specific reason for doing so.įor this example, the popup should look like this: Excel uses a default Alpha value of 0.05, which is usually a good value.
This represents the number of observations per group. Under Input, select the ranges for all columns of data.From the Data Analysis popup, choose Anova: Two-Factor With Replication.Two-way ANOVA determines whether the observed differences between means provide strong enough evidence to conclude that the population means are different. It uses a specified number of data points (two is the default), averages them, and then uses this value as a point in the trendline.The dollar amount indicates the average income for each group. Moving Average: To smooth out the fluctuations in your data and show a trend more clearly, use this type of trendline.Logarithmic: This type is best used when the data increases or decreases quickly, and then levels out.The line is more curved than a linear trendline. Exponential: This trendline visualizes an increase or decrease in values at an increasingly higher rate.Linear: A straight line used to show a steady rate of increase or decrease in values.There are different trendlines available, so it’s a good idea to choose the one that works best with the pattern of your data.Ĭlick the arrow next to the “Trendline” option to use other trendlines, including Exponential or Moving Average. This adds the default Linear trendline to the chart. Select the chart, click the “Chart Elements” button, and then click the “Trendline” checkbox.
0 kommentar(er)
