# Least Squares Trend Equation - Regression Analysis

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 ad1c9bdddfhttps://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.