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

The Basics of Multivariate Regressions in Excel

Options of use
Number of copies
- +
As low as €8.53

Are you interested in this product?

Add it to your favourites so that your institution can purchase it.
You'll be able to order once your profile has been validated.
Add to wishlist

Leave your rating

"The Basics of Multivariate Regressions in Excel"