Saturday
April 19, 2014

Homework Help: Stats

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

First Name:
School Subject:
Answer:

Related Questions

managerial economics - my cubic equation is O=C+aL+bL^2+cL3 how can i get the ...
math using excel - how do i use excel to plot a graph then find x from the slope...
psychology - Any situation that involves learning a)requires some relatively ...
economic - I HAVE AN ASSIGNMENT WHERE I HAVE TO PLOT POINTS ON A GRAPH IN EXCEL...
Applied Statistics - Assignment Guidelines Perform a two-tailed hypothesis test ...
MS Office Suite - I am familiar with Excel 2007. I just got the news that I will...
Data Analysis - You are a District sales manager and you are overloaded with ...
ecxel unit - Ms.Sue can you help me by explaining and telling the answeres. i ...
Excel - The use of excel Excel is a very necessary tool for all businesses in ...
Grammar - The patient had been on oral contraceptives until 2006; she stopped ...

Search
Members