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.
Search
Search articles, videos, podcasts, and faculty experts.
Research from UVA Darden's Peter Debaere and an interdisciplinary team of researchers shows that closing Colorado's "free river" loophole—which allows unlimited water withdrawals during abundant periods—could save millions of cubic meters of water a year, offering a simple, effective step towards addressing the crisis in the Colorado River Basin.
The U.S. economy is showing steady growth, while inflation continues to retreat from elevated levels that had Americans paying more. Today, signs point more strongly than in recent months to a Federal Reserve rate cut, or series of cuts. Rodney Sullivan, executive director for the Mayo Center of Asset Management at Darden, shared more context on the economic outlook.
Writing for The Conversation, Darden professor Ray Charles “Chuck” Howard joins colleague Marcel Lukas of the University of St. Andrews in Scotland to explore how optimism in financial planning might shore up your budget.
In this case, a shipping broker must decide where to relocate his tanker to find new cargo. The ship is currently based in the United Kingdom, and he can either send it to the Baltic or the Mediterranean seas. Due to the short time frames involved in tramp shipping, the broker does not know what cargo the ship will retrieve at its next destination, which creates considerable uncertainty about the ship’s future trajectory. The broker must consider factors such as the length of time to reach each destination, each route’s time charter equivalent (TCE) rates, and the tanker’s daily operating costs. At the conclusion of the case, the broker must select the destination that has the highest probability of yielding the most profitable outcome. This case contains an accompanying spreadsheet with historic shipping logs for Aframax tankers that students can use to estimate the probability of the different destinations.
The University of Virginia Partnership for Leaders in Education, a prominent national education leadership development provider, today announced its new cohort of school and district leadership teams.
Authored by Darden professor Laura Morgan Roberts
The University of Virginia i.Lab Incubator recently held a startup showcase, in the Dome Room of the historic Rotunda, that highlighted the program’s growing impact across UVA and the Commonwealth.
Discover how The Challenge Initiative expands family planning access in urban Africa and Asia, empowering 4.5M users across 13 countries through local government partnerships.
Meet Kai Lu (MBA ’05), the founder and CEO of Munchbird, an all-natural dog treat company making waves in the pet care industry. Her journey from the University of Virginia Darden School of Business to become an entrepreneur is a testament to her dedication, inspiration, and love for her furry companions and the Darden community.
The case describes a coffee shop considering how it can take advantage of a fictional Yelp promotion that allows businesses to select the top three customer reviews they wish to highlight on their Yelp pages. As the coffee shop owner considers various strategies like which reviews were voted the most useful and which reviews were most recent, she recognizes that her analysis is affected by the same cold start problem that Yelp faces when determining if a brand-new review should be shown at the top of a review list. The owner regards this challenge as an opportunity to use a pretrained language model on historical Yelp reviews that others found useful in hopes of uncovering the top three reviews to highlight her shop. This case allows students to consider how data science and machine learning can be used to analyze natural language, specifically in the form of text. The material provides an opportunity to use Python starter code from three Jupyter notebooks to process text data (Yelp reviews) formatted as JSON files, create document embeddings using the text, and then leverage the document embeddings as features in a model that predicts an outcome. Students should be familiar with concepts such as regression techniques, out-of-sample testing, and building models with categorical variables. Jupyter notebooks are provided as instructor supplements to this case and will require a Jupyter environment to use them.