Explore BrainMass

Explore BrainMass

    Least Squares Trend Equation - Regression Analysis

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

    Please help with the following problem.

    The amounts spent in vending machines in the United States, in billions of dollars, for the years 1999 through 2003 are given below. Determine the least squares trend equation.

    Year Code X Vending Machine Sales ($ billions) Y
    1999 1 17.5
    2000 2 19.0
    2001 3 21.0
    2002 4 22.7
    2003 5 24.0

    Solve using regression analysis:

    © BrainMass Inc. brainmass.com June 3, 2020, 10:32 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/least-squares-trend-equation-regression-analysis-236412

    Solution Preview

    The amounts spent in vending machines in the United States, in billions of dollars, for the years 1999 through 2003 are given below. Determine the least squares trend equation.

    Year Code X Vending Machine Sales ($ billions) Y
    1999 1 17.5
    2000 2 ...

    Solution Summary

    The expert determines the least square trend equation for vending machines in the United States. A regression analysis is used. The solution is provided in an Excel spreadsheet.

    $2.19

    ADVERTISEMENT