Posted by **David** on Monday, August 20, 2012 at 11:47am.

This assignment requires you to use Excel. In question 1, you will use the charting features. In

questions 2 and 3, use the regression tool from the analysis toolpack.

There is no template for this assignment. Make sure you explain your answers and provide the

regression output tables for questions 1 and 2.

Question 1

Shown below are rental and leasing revenue

figures for office machinery and equipment in the United

States over a seven-year period according to the U.S. Census Bureau. Use these data to run a linear

regression and then

forecast the rental and leasing revenue for the year 2012.

Year Rental and Leasing ($ millions)

2004 5,860

2005 6,632

2006 7,125

2007 6,000

2008 4,380

2009 3,326

2010 2,642

## Answer This Question

## Related Questions

- managerial economics - my cubic equation is O=C+aL+bL^2+cL3 how can i get the ...
- Com 125 - The purpose of this assignment is for students to create résumés for ...
- Written Communication - Review the job titles and descriptions in the newspaper ...
- COM 215 - Your manager at work has advised you that you and two of your ...
- Biology - What is a molecular clock? A)a tool scientists use to date fossils B)a...
- Data Analysis - You are a District sales manager and you are overloaded with ...
- URGENT! Last calculus question! - Hey! So, I was wondering if someone could ...
- Applied Statistics - Assignment Guidelines Perform a two-tailed hypothesis test ...
- Ms. sue - It has been a long time. need help on this: You have an assignment to ...
- Grammar - Read the following scenario: Your manager at work has advised you that...

More Related Questions