Explore BrainMass

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

    © BrainMass Inc. brainmass.com December 24, 2021, 7:44 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/statistics-bi-variate-regression-analysis-excel-214096

    Attachments

    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!

    © BrainMass Inc. brainmass.com December 24, 2021, 7:44 pm ad1c9bdddf>
    https://brainmass.com/statistics/regression-analysis/statistics-bi-variate-regression-analysis-excel-214096

    Attachments

    ADVERTISEMENT