Question 1

I need help to understand this question(in Excel), as 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.So I may solve this sample to do my work thanks.

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

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

1. How confident are you in this forecast? Explain your answer by citing the relevant metrics with details of how this was the answerand I need to know this while I need to provide the regression output tablestoo

Year

Rental and Leasing

($ millions)

20045,860

20056,632

20066,543

20075,952

20085,732

20095,423

20104,589