Compute the equation of a trend line

Assignment Help Business Management
Reference no: EM131376465

Consider the sales pattern shown in the data set below: 

Sales

Year

Time Index

121

2004

0

130

2005

1

145

2006

2

160

2007

3

155

2008

4

179

2009

5

215

2010

6

208

2011

7

235

2012

8

262

2013

9

?

2014

10

?

2015

11

Using the regression feature of Excel, compute the equation of a trend line to forecast sales in 2014 and 2015. Note, you can use 'Year' as the explanatory variable or the 'Time Index' as the explanatory variable, but not both in the same equation. In your opinion, is this a good equation for forecasting future sales? Why or why not?

Reference no: EM131376465

Questions Cloud

Charge lower rates of interest : As a result, credit unions may be able to charge lower rates of interest to borrowers and pay a higher rate to depositors than these other institutions. What do you think of this argument?
Determine the value of the maximum contact pressure : A 15-mm-diameter, 20-mm-long steel roller is subjected to a load of 150 N per axial millimeter, as it runs on the inside of a steel ring of inside diameter 75 mm. Determine the value of the maximum contact pressure and the width of the contact zon..
Firm chooses the quantity of output that generates largest : To maximize? profit, the firm chooses the quantity of output that generates the largest:
Explain in terms a layperson could understand : Explain in terms a layperson could understand, the neurobiology of drug tolerance, dependence and withdrawal
Compute the equation of a trend line : Using the regression feature of Excel, compute the equation of a trend line to forecast sales in 2014 and 2015. Note, you can use 'Year' as the explanatory variable or the 'Time Index' as the explanatory variable, but not both in the same equation..
Why might the president of the small firm : Suppose General Motors is trying to hire a small firm to manufacture the door handles for Buick sedans.  The task requires an investment in expensive capital equipment that cannot be used for any other purpose. Why might the president of the small fi..
Compare and contrast historical and contemporary police : Explain the various causes of crime using criminal justice theories, practices and compare and contrast historical and contemporary police functions, issues and
Different about the fundamental value : What is different about the fundamental value in the indefinite horizon case as compared with the finite horizon case studied in class?
How deep below the surface is the maximum shear stress : Two mating steel spur gears are 20 mm wide, and the tooth profiles have radii of curvature at the line of contact of 10 and 15 mm. A force of 250 N is transmitted between them.

Reviews

Write a Review

Business Management Questions & Answers

  Contrast the leadership model of hershey and blanchard

Compare and contrast the leadership model of Hershey and Blanchard with the Tannenbaum and Schmidt model. How are they similar and how are they different?

  Project manager point of view

After watching the video, from a project manager point of view, discuss the importance of knowing the scope of the project, the scenario of the project, in this case an expedition on extreme weather conditions.

  Global expansion through franchising for market

global expansion through franchising for market penetrationthe ceo is looking for another country in which to enter

  Major theories of organizational behaviorshow ways the

major theories of organizational behaviorshow ways the major theories of organizational behavior ob can help or have

  What strategies did it use

What strategies did it use?How did it implement them, and what were the results?

  Case study for global pharmaceutical companyas vice

case study for global pharmaceutical companyas vice president of chemical development and processing of global

  Diagram or flowchart detailing the service delivery process

Create and defend a diagram or flowchart detailing the service delivery process. The chart should clearly identify each contact point (e.g., frontline employee, supervisor, delivery, etc.) before, during, and after the purchase. Your defense of th..

  Global questions

Global Questions - how would you say such an approach affects the viability of knowledge management, especially when entering an emerging market that requires substantial infrastructure renovation or creation?

  An organization and ultimately cost them great revenue

When an organization is using net present value to evaluate the priority of their projects it is clear there looking to see which project will bring about the most profit. How can measuring projects only on profitability hurt an organization a..

  Specific recommendations concerning the following

Create a proposal for where the revenue would be derived if the U.S. were to adopt a zero income tax model. In your response, provide specific recommendations concerning the following:

  Implementing a training presentation for management

Create and implement a training presentation for management training track of a firm that is a growing business consulting company. I have to design new worker orientation presentations inclusive of our matrix structure.

  What does polc mean in management

What does POLC mean in management and how did it come about?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd