Question 1

I need help. Hi there. Will you help me tutor by allowing me to see how to know how to show the data 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 we get from the regression output, will you help me learn how to answer the following questions:

1. What is the forecast for the rental and leasing revenue for the year2011?

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

This is the data to use below: Each year corresponds with the data show below in millions. Its a chart but I am not sure how to add the chart or a picture so you can see the data chart. But it is in a 2 column chart with the 7 rows, does that make sense?

Rental Years

2004

2005

2006

2007

2008

2009

2010

Leasingin ($ millions)

5860

6632

6543

5952

5732

5423

4589