Explore BrainMass

Regression to relate variables

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

A bank has offices in six different markets. It is feasible to say the annual sales of offices are related to the population of the communities they are in. The dependent variable, y, is annual sales. The independent variable, x is market population. The data are as follows:

Data on Annual Sale and Market Population for Six Offices

Office y=Annual Sales (000s omitted) x=Market Population (000s omitted)
Ionia 500 20
Belding 325 8
Hastings 350 10
Lowell 400 16
Sunfield 250 5
Woodland 125 4

More data attached.

© BrainMass Inc. brainmass.com September 20, 2018, 11:01 am ad1c9bdddf - https://brainmass.com/business/sales-revenue/regression-to-relate-variables-109623


Solution Preview

Looking at the scatterplot, you can see the different plotted variables are close to the regression line. Only a couple are farther away, but not enough to skew the data. This would indicate the relationship is close. If you then look at the Pearson R (on the Excel chart) you see it is .93. This number too indicates a positive relationship, and a very strong one at that.

Suppose you have a number line with -1 at one end and ...

Solution Summary

A discussion and example explained for use of regression, scatterplot, and number line in relating variables.