Explore BrainMass

Finding regression line by using Excel

What is realtionship between the amt spent per wk on food and the size of the family? Do larger families spend more on food? A sample of 10 families in the chicago are revealed the following figures for family size and the amount spent on food per week.
Chart attached


Solution Summary

The solution contains detailed explanation of finding simple linear regression line by using Excel.