Overview
Instructions: First, review how to use the Data Analysis add-in to perform the ANOVA analysis discussed in your chapter notes about the impact of two factors (neighborhood and paint color) on home prices:
- ANOVA for House Pain and Neighborhood FactorsDownload ANOVA for House Pain and Neighborhood Factors
- Video: ANOVA in the Data Analysis Add-InLinks to an external site. (note that this video shows how to do both a single factor ANOVA and a two factor ANOVA in the add-in. In your assignment below, you will do only a two factor ANOVA. Also note that the number of replications in this real estate example video is different than in your data to be collected.)
Then, as discussed in detail in the assignment instructions below, perform an experiment to investigate the impact of two different factors on paper airplane flight distance, and report your findings in a manner exactly like the example shown in the assignment instructions. Your report must be at least 6-7 pages in length, plus a cover page. This content includes the software output, photos, tables, etc. as shown in the example in the instructions. Textual discussion should be single spaced as shown in the example.
Another short video is provided demonstrating how to create a plot for purposes of showing the amount of interaction between your 2 factors on flight distance:
- Week 4 Analysis of Variance Assignment Instructions Download Week 4 Analysis of Variance Assignment Instructions(note that in the example analysis provided in these instructions, the breakdown of the SS variation shown in Figure 7 matches the breakdown of the SS in the two factor ANOVA output shown in Figure 6. Likewise, your SS breakdown in your Figure 7 MUST matchup with your SS from your ANOVA output shown in your Figure 6, based on your data collected.)
- Video: Week 4 Airplane ANOVA Plot
Submit your 1) Excel spreadsheet of your paper airplane ANOVA analysis, and 2) a Word document for your report, formatted like the example shown in the instructions.
| Analysis of Variance Applications | ||
|---|---|---|
| Criteria | Ratings | Points |
Two factor with replication ANOVA analysis done correctly in Excel as outlined in the instructions. | / 4 pts | |
The findings of the ANOVA analysis of the impact of the 2 chosen factors on flight distance are neatly presented, thoroughly discussed and correctly interpreted in a manner similar to the example provided in the instructions. Report is 6-7 pages in length plus a cover page and includes an executive summary, factors considered, flight test data, analysis, and conclusion as outlined in the instructions provided. | / 6 pts | |
| Total points: 0 |