Explore BrainMass

Statistics - Bi-variate Regression Analysis in Excel

Not what you're looking for? Search our solutions OR ask your own Custom question.

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

I have a two question problem with three sub questions that I need help with for my Statistics class. It is supposed to deal with Bi-variate analysis. If someone can help me out with this, it would be much appreciated.

1. Perform a regression analysis Show the scatter plot of data with the regression line superimposed.
2. Discuss the import of the following statistics:
a. Correlation coefficient
b. Coefficient of determination
c. Slope and intercept of the regression equation
Price No. of TV's
310.8 8
227.1 4
227.1 4
243.7 6
294.5 6
345.3 8
312.1 6
236.8 4
240 4
252.3 4
270.8 6
327.2 6
186.7 5
254.3 4
294.3 7
312.1 7
293.7 6
247.7 5
155.4 4
266.6 4
246 6
188.3 5
188.3 5
207.5 5
175.6 4
216 4
263.1 4
192.6 6
209.7 5
236.4 5
269.2 5
269.9 5
273.2 5
188.3 6
188.3 6
326.3 6
209.3 5
289.8 6
209.3 6
147.4 6

https://brainmass.com/statistics/regression-analysis/statistics-bi-variate-regression-analysis-excel-214096

SOLUTION This solution is FREE courtesy of BrainMass!

The solution file is attached.

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