The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete part aClick the icon to view the closing prices data.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. The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.E Click the icon to view the closing prices data.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.)DateForecast A09/03/ 201009/07/2010Closing Prices09/08/ 201009/ 09/2010Stock09/ 10/2010Exchange D10,415.6810,320.55DateAВD09/ 13/201009/03/ 2010 128.7318.2821.1515.2509/07/ 2010 125.4718.1120.6815.4409/ 14/201009/08/ 2010 127.2417.7320.7615.6810,353.2709/ 15/201009/ 09/ 2010 127.2517.9820.5615.7910,332.9909/10/2010 127.4618.0520.4316.0510,474.0109/ 16/201009/ 13/2010 129.9318.5821.3616.1210,635.4509/17/201009/ 14/2010 127.8118.8621.5716.2510,488.7809/ 15/2010 129.7418.7321.7516.1810,518.8309/ 20/201009/ 16/2010 128.6618.9321.7216.3310.602.8909/21/201009/ 17/2010 129.8218.7621.8416.2610,690.5409/ 20/2010 131.1118.9821.6716.6110,714.1709/21/2010 132.2619.1821.6116.6310,703.66PrintDoneOOOOD ODOODO

Given information: Given data represents the values of stock prices for 12 days.

The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete part a Click the icon to view the closing prices data. a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smooth

The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete part a Click the icon to view the closing prices data. a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smooth

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: Use the Seaport data set below, a = 0.2, and ẞ = 0.4 to calculate the adjusted exponential smoothing…

Q: A researcher studied the relationship between the number of times a certain species of cricket will…

A: Inferential statistic is used to analysis the data by applying some statistical methods. Inferential…

Q: Median household income sharply increased in 2015 by 5.2% but only grew by 1.8% in 2017 to $61,372.…

A: a) Assume the median income in 2016 is x.

Q: make a scatterplot of the data. Make sure to include an appropriate title as well as titles for…

A: This is an example of extrapolation Exponential smoothing is best used for forecasts that are…

Q: It costs $30 a day to rent a dump truck plus $0.95 per mile. A. Is this an example of a linear or…

A: Given that fixed cost to rent a dump truck a day is $30 and per mile the cost to rent the truck is…

Q: The graphs below give the diabetes mortality rate for countries with low per capita income and…

A: Given that,

Q: Jamal launched a website for his custom shoe store. On the first day, 3 visitors registered on the…

Q: Assume the amount of money seventh–grade students spend on food each day at school is exponentially…

A: Given : Assume the amount of money seventh–grade students spend on food each day at school is…

Q: Benny's Arcade has 5 video game machines. The average time between machine failures is 100 hours.…

A: By the Exponential distribution, we haveAverage number of machines fails per hour,isλ=1/100=0.01…

Q: Time Temperature 450 350 3.

A: Given data table is, Time Temperature 0 450 3 350 6 290 9 230 12 190 15 150 18 130…

Q: The bar graph given below shows the percentage of college freshmen in the United States, as of the…

A: From the given bar, the percentage of college freshmen in the year 2010 is 48 approximately.

Q: Produce a graph comparing the total customer base under each of the two scenarios described below.…

A: given,subscription volume = 60 monthstotal market potential = 1,000,000

Q: Explain what would happen if the smoothing constant in an exponential smoothing model was equal to…

Q: Determine a reasonable length of time when the people in the country notice the problem and organize…

A: Right now, the growth factor is 4.5, the population growth rate is 2.17 and the population of Jordan…

Q: Q2 You Beauty is a cosmetics company that uses exponential smoothing with trend to forecast monthly…

Q: #1: A city has been losing population. In the 1990 census it decreased by 15% from the 1980 census…

A: Given that, A city has been losing population. In the 1990 census it decreased by 15% from the 1980…

Q: 1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the…

A: Definition of Correlation coefficient: Correlation coefficient is a measure of degree or extent of…

Q: Use the Dental Clinic data set below, a = 0.4, and ß = 0.2 to calculate the adjusted exponential…

A: Given information: α=0.40, β=0.20 Day Number of Patients Tuesday 35 Wednesday 38 Thursday…

Q: Suppose you ran a quadratic trend forecasting model on some time series data for 18 months. The…

A: quadratic trend forecasting model, which can be represented by the equation:

Q: Which graph shows exponential decay? 3. YA A B to YA D

A: An exponential function is a non linear function of the form y=abx where a≠0,b≠1,b>0 The function…

Q: B3 Calculate (predict) t = 11 for each trend method. Create a Linear prediction for Federal…

A: 1. The linear regression for the given data is as follows: Now, the Federal debt-GDP for t=11 is…

Q: he value of a $3000 computer decreases about 30% each year. 3. Write a function for the computer's…

Question

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

Click the icon to view the closing prices data.

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.

The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.
E Click the icon to view the closing prices data.
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.)
Date
Forecast A
09/03/ 2010
09/07/2010
Closing Prices
09/08/ 2010
09/ 09/2010
Stock
09/ 10/2010
Exchange D
10,415.68
10,320.55
Date
A
В
D
09/ 13/2010
09/03/ 2010 128.73
18.28
21.15
15.25
09/07/ 2010 125.47
18.11
20.68
15.44
09/ 14/2010
09/08/ 2010 127.24
17.73
20.76
15.68
10,353.27
09/ 15/2010
09/ 09/ 2010 127.25
17.98
20.56
15.79
10,332.99
09/10/2010 127.46
18.05
20.43
16.05
10,474.01
09/ 16/2010
09/ 13/2010 129.93
18.58
21.36
16.12
10,635.45
09/17/2010
09/ 14/2010 127.81
18.86
21.57
16.25
10,488.78
09/ 15/2010 129.74
18.73
21.75
16.18
10,518.83
09/ 20/2010
09/ 16/2010 128.66
18.93
21.72
16.33
10.602.89
09/21/2010
09/ 17/2010 129.82
18.76
21.84
16.26
10,690.54
09/ 20/2010 131.11
18.98
21.67
16.61
10,714.17
09/21/2010 132.26
19.18
21.61
16.63
10,703.66
Print
Done
OOOOD ODOODO

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Please please solve all parts of the question. Thank you so much.
Find a graph or bar chart that represents a real situation where you could use a linear or exponential equation to model the data. Identify the type of function that is being modeled and why you believe it to be this type. Estimate the equation for the function.
Describe the patterns in quantity sold and own and rival prices during this time period using basic descriptive statistics. Graphs are welcome as well. Take the logs of the variables, and estimate the demand function. Interpret the R-square. Interpret the coefficients for logP and logPsub Interpret the p-values associated with each independent variable Are consumers price sensitive? Why or why not? (be as precise as you can – you have estimates!). Does this price sensitivity make sense given the good we are examining? How sensitive are our consumers to changes in the rival good’s price? Explain in detail. Suppose we decide to charge a per ounce price of $2, while at the same time our rival charges a price of $2.15. All else equal, what would you expect sales to be? How confident are you in your forecast? Suppose we are charging a price of $2 and our current marginal cost is $1.50 Are we maximizing profits at this price? If not, should we raise or lower price? Why?
Can you guys help me on this? Thank you!
the table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.
The common ratio for the home prices in an Austin neighborhood is 1.08 every year for the past five years. Describe the pattern. Choose all that apply. Increasing Decreasing Linear Exponential
Eloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's been tracking her page count at the end of each business day to see if she's on track. Use Excel to fit a trendline to Eloise's data to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next Friday? Assume she works only on weekdays. Day Pages Monday 425 Tuesday 431 Wednesday 449 Thursday 464 Friday 471 A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line? The slope is The intercept is B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday? Yes
Please do it fast.
please answer in text form and in proper format answer with must explanation , calculation for each part and steps clearly
A trendline is given to depict enrollment at a local college where x is the year and y represents enrollment. Y=178.09x-353194 Use the rrendline ro estimate the enrollment for 2009. Round to the nearest whole number.
. Fill in the "Years since 1970" column for the data to the right. Make a scatter plot in Excel of the data using Years since 1970 and Total Waste in Millions of Tons (Title your graph and label your axes appropriately). How would you best describe the trend? Add an exponential regression model to the data. Write the equation below. Is it a good fit? Explain how you know. Based on the exponential model, what is the growth rate per year? Explain the meaning of the growth rate in the context of the data. Using the exponential model, make a prediction of how much plastic will be in landfills (and the ocean gyres) by Year Years since 1970 Total Waste in Millions of Tons 1970 0 249 1980 10 798 1985 15 1200 1990 20 1740 1995 25 2440 2000 30 3390 2005 35 4600 2010 40 6060 2015 45 7820 Do you think recycling alone will solve this problem (See Q11 and Q12)? What are some of the challenges in recycling plastic that might hinder the world from recycling all plastic…