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!

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:

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