This was a statistical analysis of home prices in Ames Iowa performed using Microsoft Excel formulas, pivot tables, and graphs. Below are the links to the spreadsheet where I performed the work as well as a PowerPoint presentation.
Conclusion: It was shown through statistical analysis that there is strong evidence that the presence of an attached garage on single-family, one-story and two-story homes corresponded to a 51% or 26% increase in sales price compared to those homes which had detached garages.