Forecast model for stock a

Assignment Help Macroeconomics
Reference no: EM132813503

The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.

Date A B C D Stock Exchange

09/03/2010 128.41 18.44 21.01 15.46 10,348.41
09/07/2010 126.43 18.21 20.65 15.32 10,387.99
09/08/2010 125.74 18.03 20.65 15.65 10,458.24
09/09/2010 126.48 17.83 20.65 15.98 10,432.73
09/10/2010 127.09 17.89 20.72 15.83 10,478.29
09/13/2010 130.19 18.71 21.43 16.25 10,623.48
09/14/2010 130.09 18.88 21.57 16.05 10,444.89
09/15/2010 128.74 18.64 21.71 16.18 10,567.38
09/16/2010 129.25 18.93 22.13 16.26 10,609.54
09/17/2010 130.57 18.99 21.95 16.23 10,599.16
09/20/2010 132.72 18.78 21.72 16.68 10,783.53
09/21/2010 131.99 19.25 21.47 16.43 10,784.47

a. Use? Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3. Complete the exponential smoothing forecast model for stock A. ?(Type integers or decimals rounded to two decimal places as? needed.)

Reference no: EM132813503

Questions Cloud

Benefits and potential problems associated with conflict : Using a practical example, what are the benefits and potential problems associated with conflict?
Improve the service of the organization : 1. As a customer, which part of the organizational service cycle do you usually experience frustration?
Estimate average customer wait before receiving response : Customers send e-mails to a help desk of an online retailer. On average, 3 e-mails are sent every 2 minutes and the interarrival times follow exponential
Implementation of an omnichannel strategy : In an implementation of an omnichannel strategy, sometimes there is some resistance from the different parts of the organization.
Forecast model for stock a : The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.
What is the capacity requirement for the next year : A firm produces two products, Prod A and Prod B, using the same type of machines. The firm would like to determine capacity requirements for the next year. Proc
What is the value of the centerline : Over 30-day period, an average of 19 requests per day are received. What is the value of the centerline?
Differences in managing risk in an agile project : Identify and describe 4 differences in managing risk in an agile project compared to managing risk in a traditionally managed project.
How many options are available to amazon sellers : Research how many options are available to Amazon sellers with regards to delivering goods to customers?

Reviews

Write a Review

Macroeconomics Questions & Answers

  Two forms of dishonesty

Are lying and deception same? If not, explain why and how the two forms of dishonesty are different? Please provide a minumum of 75 - 150 words. Nothing copied and pasted from online or plagerized.

  Spose demand and supply are given by qd 60 - p and qs

suppose demand and supply are given by qd 60 - p and qs p - 20.a. what are the equilibrium quantity and price in

  Calculate how the hurricane affects income of each worker

Now suppose the price of apples is back at $2, but a hurricane destroys half the orchards. Calculate how the hurricane affects the income of each worker and of each remaining orchard owner. What happens to the income of Ectenia as a whole

  What people need is a quality of mind that will help them

what people need... is a quality of mind that will help them to use information and to develop reason in order to

  Explanations of the term cloud computing

You will find many different explanations of the term "cloud computing" on the Internet. Do an Internet search and read a few descriptions of cloud computing, such as those found on popular sites like PCMag.com,

  What will the new equilibrium price be in the market

Assume Madagascar is hit by a hurricane (actually occurred in 2000), What will the new equilibrium price be in the market? Label that point b

  Homeland security question

In the National Security Strategy of 2010, which set the tone of the Obama Administration's tenure, there are a number of elements discussed as influencing/impacting national security

  Worker production function for the united states

What would happen to the per worker production function for the United States economy if the US decided to double in support of universities research?

  Tea consumption and raise government revenue

Suppose the government imposes a tax of $1 to reduce tea consumption and raise government revenue. What will the newequilibrium quantity be? What price will the buyer pay? What amountper kilogram will the seller receive? How much is the inefficien..

  Determine what choice the other prisoner will make

The classic prisoner's dilemma involves two suspects, A and B, who are arrested by the police. Because the police have insufficient evidence for conviction on a key charge, they place the prisoners in isolation and offer each.

  Discuss privatization in terms of the production

An ongoing policy issue is the privatization of hydro in the province of Ontario . Discuss privatization in terms of the production, transmission and retailing sectors . Specifically which sectors should be deregulated and why?

  What is the net societal benefit

In response to pressure from environmentalists the government now tightens the maximum damage standard to 4 units. How much fertilizer will farmers use now? What will their profit be? What is the net societal benefit? What is the value of ??

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