# Stats

posted by .

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

• Stats -

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

 First Name School Subject Your Answer

## Similar Questions

1. ### 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 …
2. ### 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 short-run production function. see tarha question dated july 2,2007 for all of the …
3. ### Com 125

The purpose of this assignment is for students to create résumés for hardcopy and online distribution as well as a job-application letter to accompany one of the résumés. Students will also determine the differences between these …
4. ### 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 …
5. ### 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 …
6. ### 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: …
7. ### 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 …
8. ### 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 …
9. ### Applied Statistics

Assignment Guidelines Perform a two-tailed 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 …
10. ### 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. …

More Similar Questions