Stats
posted by David .
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 sevenyear 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

Stats 
MathGuru
Regression equation is in this format:
predicted y = a + bx
...where a = intercept and b = slope.
Determine the equation, then substitute 2012 for x to find predicted y (forecasting the rental and leasing revenue).
Respond to this Question
Similar Questions

Written Communication
Review the job titles and descriptions in the newspaper and database. • Select one job from each source. • Create a résumé you would use for hardcopy distribution and one you would use for online distribution. You may use the … 
managerial economics
my cubic equation is O=C+aL+bL^2+cL3 how can i get the excel to help me to do this equation.I need to do a regression analysis to estimate the firm's shortrun production function. see tarha question dated july 2,2007 for all of the … 
Com 125
The purpose of this assignment is for students to create résumés for hardcopy and online distribution as well as a jobapplication letter to accompany one of the résumés. Students will also determine the differences between these … 
COM 215
Your manager at work has advised you that you and two of your coworkers will be visiting a branch of your company in another country. Select a country that you would like to learn more about. Then, conduct an Internet or library search … 
Grammar
Read the following scenario: Your manager at work has advised you that you and two of your coworkers will be visiting a branch of your company in another country. Select a country that you would like to learn more about. Then, conduct … 
URGENT! Last calculus question!
Hey! So, I was wondering if someone could answer this. I am mad studying for my exam and I still have a few questions left that I just don't have time to answer, and the assignment is due tomorrow. Thanks and here is the question: … 
Data Analysis
You are a District sales manager and you are overloaded with data that you need to compile into useable data and you are looking to use Excel to help you do this. Using the concept from this week, how will you determine where to start … 
Ms. sue
It has been a long time. need help on this: You have an assignment to write a research paper about the hiring practices at XYZ Mart, a large retail chain. Use the Internet to find five Web sites that you think will be appropriate to … 
Applied Statistics
Assignment Guidelines Perform a twotailed hypothesis test using the steps outlined in the assignment description. In a Word document, create a report that includest the following: Null and alternate statements. Pasted Microsoft Excel … 
English
I am trying to write a paper but I am having a difficult time understanding the way you use first person in APA style. The instructions are: Use APA format For this assignment you may use first person and use the questions as subheadings. …