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

  Socially responsible efforts

Identify an organization with which you are familiar. What are some factors in this organization that might affect the strategies they take in developing their socially responsible efforts?

  Pygmalion effect - leadership and management

Show the Pygmalion Effect -What is the Pygmalion Effect as it relates to leadership and management?

  Ways doing business have as well had dramatic impact

Some breakthrough products as well as services have literally changed the world. The automobile, the telephone, the Internet and countless other inventions have historically shifted the ways people live and work. However shifts in ways doing busin..

  Consider potential topics for you to explore for research

Consider potential topics for you to explore for the Researched Proposal and share the ideas with your peers. One of the most effective strategies for narrowing and refining topic ideas is through peer collaboration and review.

  Identify and define four of the seven key elements

Identify and define four of the seven key elements in the communication process. Give a specific example of a possible breakdown in a communication flow

  Identify the mission or business of the organization

Discuss the ethical, moral and legal implications of your policy and the choices you made in preparing the policy. Be sure to include and identify each type (ethical, moral and legal).

  Motivation with a negative attitudepositive attitude is one

motivation with a negative attitudepositive attitude is one of the keys for his productive career. there are many times

  Movement along and shift of the demand curve

What is the difference between a movement along and shift of the demand curve? Show the affect on the equilibrium price and quantity that result from:(1) an increase in demand,(2) an increase in supply, and(3) an increase in both supply and demand..

  Accept that arthur rabe is suing anna soto for breaching

Accept that Arthur Rabe is suing Anna Soto for breaching a contract in that Soto promised to sell Rabe a Van Gogh painting for $3 Million.

  Evolving relationship between business and society

Write a research paper that analyzes the evolving relationship between business and society.  Choose at least three of the topics from the course learning objectives (listed below), and clearly identify how the topics directly impact relationships ..

  Database analysts or managers or the functions

What effort is required to maintain the data by database analysts or managers or the functions performed by the database analysts (DBA) in your corporation.

  Explanation of scientific management and its techniquemany

explanation of scientific management and its techniquemany companies have thought of the principle of frederick taylors

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