The Closing Stock Prices data below provides data for four stocks and the Dow Jones Industrial...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Closing Stock Prices data below provides data for four stocks and the Dow Jones Industrial Average over a one-month period. 1. Construct a visual of your choice to display all four stocks prices and the DJIA for each day over the period from 9/3/2010 to 10/1/2010. Be sure each stock/index is clearly identifiable. 2. Develop a spreadsheet model for forecasting each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3. 3. Compare your results to the output from Excel's Data Analysis tool. 4. Compute MAD, MSE, and MAPE. 5. Does a smoothing constant of 0.1 or 0.5 yield better results? Closing Stock Prices Date DJ 2 alpha 0.3 IBM INTC 9/3/2010 $127.58 9/7/2010 $125.95 CSCO GE $18.43 $21.04 $15.39 $18.12 $20.58 $15.44 Industrials Index Expodential smoothing 10447.93 IBM INTC CSCO GE DJ Industrials Index 10340.69 $127.58 $18.43 $21.04 $15.39 $10,447.93 9/8/2010 $126.08 $17.90 $20.64 $15.70 10387.01 $127.09 $18.34 $20.90 $15.41 $10,415.76 9/9/2010 $126.36 $18.00 $20.61 $15.91 10415.24 $126.79 $18.21 $20.82 $15.49 $10,407.13 9/10/2010 $127.99 $17.97 $20.62 $15.98 10462.77 $126.66 $18.14 $20.76 $15.62 $10,409.57 9/13/2010 $129.61 $18.56 $21.26 $16.25 10544.13 $127.06 $18.09 $20.72 $15.73 $10,425.53 9/14/2010 $128.85 $18.74 $21.45 $16.16 10526.49 $127.82 $18.23 $20.88 $15.88 $10,461.11 9/15/2010 $129.43 $18.72 $21.59 $16.34 10572.73 $128.13 $18.38 $21.05 $15.97 $10,480.72 9/16/2010 9/17/2010 $129.67 $18.97 $21.93 $16.23 10594.83 $128.52 $18.48 $21.21 $16.08 $10,508.32 $130.19 $18.81 $21.86 $16.29 10607.85 $128.87 $18.63 $21.43 $16.12 $10,534.28 9/20/2010 $131.79 $18.93 $21.75 $16.55 10753.62 $129.26 $18.68 $21.56 $16.17 $10,556.35 9/21/2010 $131.98 $19.14 $21.64 $16.52 10761.03 $130.02 $18.76 $21.62 $16.29 $10,615.53 9/22/2010 $132.57 $19.01 $21.67 $16.50 10739.31 $130.61 $18.87 $21.62 $16.36 $10,659.18 9/23/2010 $131.67 $18.98 $21.53 $16.14 10662.42 $131.20 $18.91 $21.64 $16.40 $10,683.22 9/24/2010 $134.11 $19.42 $22.09 $16.66 10860.26 $131.34 $18.93 $21.61 $16.32 $10,676.98 9/27/2010 $134.65 $19.24 $22.11 $16.43 10812.04 $132.17 $19.08 $21.75 $16.42 $10,731.96 9/28/2010 $134.89 $19.51 $21.86 $16.44 10858.14 $132.91 $19.13 $21.86 $16.43 $10,755.99 9/29/2010 $135.48 $19.24 $21.87 $16.36 10835.28 $133.51 $19.24 $21.86 $16.43 $10,786.63 9/30/2010 $134.14 $19.20 $21.90 $16.25 10788.05 $134.10 $19.24 $21.86 $16.41 $10,801.23 10/1/2010 $135.64 $19.32 $21.91 $16.36 10829.68 $134.11 $19.23 $21.87 $16.36 $10,797.27 The Closing Stock Prices data below provides data for four stocks and the Dow Jones Industrial Average over a one-month period. 1. Construct a visual of your choice to display all four stocks prices and the DJIA for each day over the period from 9/3/2010 to 10/1/2010. Be sure each stock/index is clearly identifiable. 2. Develop a spreadsheet model for forecasting each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3. 3. Compare your results to the output from Excel's Data Analysis tool. 4. Compute MAD, MSE, and MAPE. 5. Does a smoothing constant of 0.1 or 0.5 yield better results? Closing Stock Prices Date DJ 2 alpha 0.3 IBM INTC 9/3/2010 $127.58 9/7/2010 $125.95 CSCO GE $18.43 $21.04 $15.39 $18.12 $20.58 $15.44 Industrials Index Expodential smoothing 10447.93 IBM INTC CSCO GE DJ Industrials Index 10340.69 $127.58 $18.43 $21.04 $15.39 $10,447.93 9/8/2010 $126.08 $17.90 $20.64 $15.70 10387.01 $127.09 $18.34 $20.90 $15.41 $10,415.76 9/9/2010 $126.36 $18.00 $20.61 $15.91 10415.24 $126.79 $18.21 $20.82 $15.49 $10,407.13 9/10/2010 $127.99 $17.97 $20.62 $15.98 10462.77 $126.66 $18.14 $20.76 $15.62 $10,409.57 9/13/2010 $129.61 $18.56 $21.26 $16.25 10544.13 $127.06 $18.09 $20.72 $15.73 $10,425.53 9/14/2010 $128.85 $18.74 $21.45 $16.16 10526.49 $127.82 $18.23 $20.88 $15.88 $10,461.11 9/15/2010 $129.43 $18.72 $21.59 $16.34 10572.73 $128.13 $18.38 $21.05 $15.97 $10,480.72 9/16/2010 9/17/2010 $129.67 $18.97 $21.93 $16.23 10594.83 $128.52 $18.48 $21.21 $16.08 $10,508.32 $130.19 $18.81 $21.86 $16.29 10607.85 $128.87 $18.63 $21.43 $16.12 $10,534.28 9/20/2010 $131.79 $18.93 $21.75 $16.55 10753.62 $129.26 $18.68 $21.56 $16.17 $10,556.35 9/21/2010 $131.98 $19.14 $21.64 $16.52 10761.03 $130.02 $18.76 $21.62 $16.29 $10,615.53 9/22/2010 $132.57 $19.01 $21.67 $16.50 10739.31 $130.61 $18.87 $21.62 $16.36 $10,659.18 9/23/2010 $131.67 $18.98 $21.53 $16.14 10662.42 $131.20 $18.91 $21.64 $16.40 $10,683.22 9/24/2010 $134.11 $19.42 $22.09 $16.66 10860.26 $131.34 $18.93 $21.61 $16.32 $10,676.98 9/27/2010 $134.65 $19.24 $22.11 $16.43 10812.04 $132.17 $19.08 $21.75 $16.42 $10,731.96 9/28/2010 $134.89 $19.51 $21.86 $16.44 10858.14 $132.91 $19.13 $21.86 $16.43 $10,755.99 9/29/2010 $135.48 $19.24 $21.87 $16.36 10835.28 $133.51 $19.24 $21.86 $16.43 $10,786.63 9/30/2010 $134.14 $19.20 $21.90 $16.25 10788.05 $134.10 $19.24 $21.86 $16.41 $10,801.23 10/1/2010 $135.64 $19.32 $21.91 $16.36 10829.68 $134.11 $19.23 $21.87 $16.36 $10,797.27
Expert Answer:
Related Book For
Quantitative Analysis for Management
ISBN: 978-0132149112
11th Edition
Authors: Barry render, Ralph m. stair, Michael e. Hanna
Posted Date:
Students also viewed these statistics questions
-
Each team is required to create fictitious stock portfolio by investing a total of $100,000 (paper money, of course! - not real money) in five companies in the Information Technology Industry,...
-
The following table presents sample data for Bluewater (BW), a hedge fund. (Abstract from potential biases in the data.) Month 1 Month 2 0.95% -0.4% 0.18% 0.18% 0.19% -0.9% Return for BW Risk-free...
-
After graduation, you begin your new job. Naturally, you're already thinking about retirement. You estimate you'll need $2 million to comfortably stop working, 40 years from now. If market returns...
-
Ayala Company manufactures four products in a single production facility. The company uses activity-based costing. The company has identified the following activities through its activity analysis:...
-
Lycan, Inc., has 7 percent coupon bonds on the market that have 9 years left to maturity. The bonds make annual payments and have a par value of $1,000. If the YTM on these bonds is 8.4 percent, what...
-
All market-based societies place limits on what can be bought and sold. What determines when it is appropriate to restrict the market? For example, should people be able to sell one of their kidneys?...
-
Brooks Foundry uses a predetermined manufacturing overhead rate to allocate overhead to individual jobs, based on the machine hours required. At the beginning of 2012, the company expected to incur...
-
Describe the psychological, physical, behavioral, and organizational consequences of stress.?
-
Read the Workplace Policies and Procedures Example - Pinkies Pizza and Pasta A: You witness a fellow staff member cough into his hand. The staff member then picks up pre-made sandwiches (without...
-
1. A thin-walled hollow tube rolls without slipping along the floor. The rotational inertia of this tube about its axis through the center is ICM = M R. What is the ratio of its translational kinetic...
-
Prompt For this assignment, analyze the diversification strategy of either Disney or Kimberly-Clark using the documents linked within your Soomo webtext. Explain how critical thinking applies to...
-
When considering principled negotiation, when one person identifies options that are of low cost to them but of high interest to the other party, this is an example of?
-
What does the following statement print to standard output? printf("%d,%d,%d,%d %d", 70 | 6, 70 & 6, 70 || ~6, 70 && ~6, 70 & ~6);
-
The hall of fame baseball player, Joe DiMaggio, set an MLB record of longest hitting streak with 56 games. a.) (5pts) During this streak, DiMaggio had around 4 at-bats per game. If DiMaggio had a...
-
In the background materials, you read about some very traditional theories of motivation such as Maslow's Hierarchy of Needs and Herzberg's Two-Factor Theory. You also learned about how people of...
-
Evaluate tan? (sin1 . 3 O b. 0.5 c. 1/3 O d. V3
-
Determine the center and radius of each circle. Sketch each circle. 4x 2 + 4y 2 9 = 16y
-
Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are as follows for the past 12 weeks: (a) Assuming an initial forecast for week 1 of 17,000 miles, use exponential...
-
Hervis Rent-A-Car has three car rental locations in the greater Houston area: the Northside branch, the West End branch, and the Suburban branch. Customers can rent a car at any of these places and...
-
An airline owns an aging fleet of Boeing 737 jet airplanes. It is considering a major purchase of up to 17 new Boeing model 757 and 767 jets. The decision must take into account numerous cost and...
-
Eyeglass lenses made of crown glass \((n=1.52)\) are given a thin coating of magnesium fluoride \((n=1.38)\) to minimize reflection of light from the lens surface. What is the minimum coating...
-
The width of one pixel in the sensor for a digital camera is about \(2.0 \mu \mathrm{m}\). If the camera lens has a diameter of \(40 \mathrm{~mm}\) and a focal length of \(30 \mathrm{~mm}\), is the...
-
Light of wavelength \(380 \mathrm{~nm}\) strikes the metal target in Figure 34.47. As long as the potential difference \(V_{\mathrm{CT}}\) between the target and the collector is no greater than...
Study smarter with the SolutionInn App