Purchase Solution

Analysis of a factorial ANOVA in EXCEL

Not what you're looking for?

Ask Custom Question

Using the attached EXCEL file, complete a factorial ANOVA. You may need to reclassify the DV as numeric. You may want to make sure that your output includes cell means (to help interpret any interactions).

Attachments
Purchase this Solution
Solution Summary

In this solution, EXCEL was used to conduct an analysis of variance on data from a two factor factorial experiment. The output from the EXCEL sheet shows and ANOVA table for evaluating the significance of both main effects and the interaction effect. Interaction plots are also included along with a discussion of how to interpret the plots in terms of significant main effects and interactions.

Solution Preview

Attached is an Excel Worksheet to this response. The sheet shows all ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Analysis of Variance with Interaction

    . ** Please see the attachment for the complete solution ** NB: The analysis is done using the Excel Data Analysis Tool. The manual computation of the ANOVA Table is a tedious task.

  • Factorial ANOVA

    To prepare for this Application: Review Chapter 13 of the Field text for a description of the factorial analysis of variance and an example of conducting a factorial ANOVA using PASW.

  • Proper usage of the one-way, repeated measures, and factorial ANOVA

    In the above scenario, we shall use a two-factor ANOVA to test the null hypotheses. The proper usage of the one-way, repeated measures and factorial ANOVA.

  • Determine the Mean as Director of Sales

    Think about how tedious it is to conduct a t-test with 1 variable. Now imagine doing that multiple times. It is inefficient and a waste of time. There are several types of factorial ANOVA, and in this case we would consider: Factorial ANOVA.

  • ANOVA and MANOVA

    ANOVA is a statistical method that stands for analysis of variance. ANOVA was developed by Ronald Fisher in 1918 and is the extension of the t and the z test. Before the use of ANOVA, the t-test and z-test were commonly used.

  • ANOVA types and repeated measures analysis

    106445 ANOVA types and repeated measures analysis 1. Give an example of a repeated measures analysis of variance (ANOVA)--no examples of therapy or temperature. 2.

  • Two way ANOVA

    E - Discuss the results of A through D. Use the Anova file attached in excel.---------------------------------------------- Please see the answers Step by step method for computing test statistic for two way ANOVA is given in the answer.

  • Statistics: ANOVA Tables

    526425 Statistics: ANOVA Tables Complete each of the following ANOVA summary tables. In addition, answer the following questions for each of the ANOVA summary tables: a. What is the factorial notation? b. How many conditions were in the study? c.

  • ANOVA: Educating Elementary Aged Children in Math

    Create a table that presents descriptive statistics for the sample. 2. Factorial ANOVA. Perform a factorial ANOVA using the 'Activity 6.sav' data set. a. Is there a main effect of gender? If so, explain the effect.

View More Related Solutions