Evaluate equation of a trend line to forecast sales

Assignment Help Microeconomics
Reference no: EM131369582

Economics Assignment- Discussion

• 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: EM131369582

Questions Cloud

What specific supply chain processes and specific metrics : What specific supply chain processes and specific metrics might you look carefully at if you were in charge of improving and or redesigning your company's supply chain to decrease cost?
Represent important understandings of identity and worldview : Flags have significant symbolic meaning in a culture and represent important understandings of identity and worldview. Explain how flags represent cultural patterns and characteristics. Explain their influence on your personal connection to a cult..
What is the utilization rate of the booth workers : How many booth workers are required for the average potential customer to spend no more than 5 minutes waiting and being served? How many potential customers are waiting to be served, on average? What is the utilization rate of the booth workers?
Multi-service aviation business and including fuel : Earhart Aviation operates a multi-service aviation business, including fuel, aircraft maintenance, charter flights, aircraft rentals, and flight instruction. Not only should the user interface be thoroughly tested, there must be sufficient user docum..
Evaluate equation of a trend line to forecast sales : Using the regression feature of Excel, compute 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.
Forensics investigation trainee at two way communications : In this course, you have assumed the role of a forensics investigation trainee at Two Way Communications. You have received positive feedback from the CEO regarding your last report, and you are asked to train with the Internal Security department..
What is the probability that its top executive made : If a firm is randomly chosen from the list of 10 firms studied, what is the probability that its top executive made over $1 million per year?
Independent of the actual number of passengers on the plane : Northwest Airlines runs daily flights from Detroit to Amsterdam. They face a fixed cost of $70,000 for each flight independent of the actual number of passengers on the plane. There are 310 seats available on a plane. One way tickets generate revenue..
Pricing structure of the provider : 1. Do they offer PaaS, SaaS, or both? 2. How is the pricing structure of the provider designed? example price per gb storage price per vm, price per gb data transfer? 2. How easy does it appear to be to set up an account and start using their serv..

Reviews

Write a Review

Microeconomics Questions & Answers

  Effects of massive treasury bill sale by fed in open market

Draw a supply-demand diagram of the Federal funds market which illustrates the effects of a massive Treasury bill sale by the Fed in the open market.

  Identify a strategic alliance

Identify a strategic alliance chosen company has formed and discuss how three to four of the issues from the following list have been addressed by the alliance - Adding value to products

  A contractor estimates maintenance costs for a new backhoe

A contractor estimates maintenance costs for a new backhoe to be $275 for the first month with a monthly increase of 0.5%.

  Calculate the price elasticity of supply for copper

Suppose the current price of copper is $3 per pound and the quantity supplied is 200 pounds per day. If the price of copper falls to $2.50 per pound, the quantity supplied drops to 180 pounds per day. Use the midpoint formula to calculate the price e..

  Keep the economy running in lieu

Speculate what emergency measures might be enacted to keep the economy running in lieu of having an organized banking system.Identify and justify any incidents from history that tell us what we might expect if an electromagnetic pulse actually caused..

  Interest rate-compounded monthly

The average age of engineering students at graduation is a little over 23 years. This means that the working career of most engineers is almost exactly 500 months. How much would an engineer need to save each month to become a millionaire by the end ..

  What should be the unit price to quote

An executive from a large merchandising firm has called your vice president for production to get a price quote for an additional 100 units of given product. The vice president has asked you to prepare a cost estimate,

  Does a monopolistic competitor produce more output

Does a monopolistic competitor produce more or less output as compared to an efficient level of production Explain. What are the benefits and drawbacks of this Should the government intervene to alter this

  What is the estimated percent change in world price of oil

The elasticity of demand for oil is about 0.5, and the elasticity of supply is about 0.3. If the Arctic National Wildlife Refuge (ANWR) were drilled and the world supply of oil increased by 3 percent, what is the estimated percent change in the world..

  Explain facet of your life that relates to economic concepts

You will be expected to use an economic concept and/or theory discussed in class or written in the textbook to explain a facet of your life that relates to Economic concepts we are studying.

  Discusses how and why a pollster got their guess wrong

Today's opinion pollsters are coming under greater pressure because their predictions have a tendency to be wrong. For this assignment, post a link to a news story or blog that discusses how and why a pollster got their guess wrong.

  Describe whether or not you can refute the claim base only

a firm has the choice of the following investmentsinvestment a costs 5000 today pays a total of 4000 next year and 1700

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