The Basics of Multivariate Regressions in Excel
This technical note provides a comprehensive guide to conducting multivariate linear regressions using Excel. It covers essential concepts such as setting up the regression model, selecting variables, and interpreting the results. Key outputs from Excel’s regression tool, including coefficients, standard errors, t-stats, p-values, and R-squared, are explained in detail. Additionally, the document highlights the limitations of Excel for advanced statistical analysis. The technical note uses example data from the case “Flying Around Real Estate Development: Persuading with Data Visualizations” (UVA-BC-0285); the case itself is optional for those who wish to read more.
Collection: Darden University of Virginia (USA)
Ref: DARDEN-BC-0311-E
Format: PDF
Number of pages: 4
Publication Date: Aug 26, 2024
Language: English
Description
This technical note provides a comprehensive guide to conducting multivariate linear regressions using Excel. It covers essential concepts such as setting up the regression model, selecting variables, and interpreting the results. Key outputs from Excel’s regression tool, including coefficients, standard errors, t-stats, p-values, and R-squared, are explained in detail. Additionally, the document highlights the limitations of Excel for advanced statistical analysis. The technical note uses example data from the case “Flying Around Real Estate Development: Persuading with Data Visualizations” (UVA-BC-0285); the case itself is optional for those who wish to read more.
Read more
Leave your rating
"The Basics of Multivariate Regressions in Excel"
Register for free with IESE Publishing and enjoy all the advantages
What type of account do you want to create?
Choose account type
Professors
Academic Institutions
Companies
Individuals