Multivariate Regression in Excel Say, for example, that you decide to collect data on average temperatures and average rainfall in a particular location for an entire year, collecting data every day.