Hello, I am using the Excel data Analysis package and getting some weird answers. Can you tell me what below should go in the x range and what in the Y? Do I need to add a value to the table or is the data below everything I need?

Shown below are rental and leasing revenue figures for office machinery and equipment in the United States over a 7-year period according to the U.S. Census Bureau. Use this data and the regression tool in the data analysis tool pack to run a linear regression.

Based on the formula you get from the regression output, answer the following questions:

a)What is the forecast for the rental and leasing revenue for the year2011?

b)How confident are you in this forecast? Explain your answer by citing the relevant metrics. Do not just put down a number without explanation.

Year

Rental and Leasing

($ millions)

2004 5,860

2005 6,632

2006 6,543

2007 5,952

2008 5,732

2009 5,423

2010 4,589