(a-1) Select an Excel line graph of the following bond yield data. Seved U.S. Treasury 10-Year...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(a-1) Select an Excel line graph of the following bond yield data. Seved U.S. Treasury 10-Year Bond Yields at Week's End (n = 52 weeks) Week Yield Week Yield Week Yield Week Yield 4/2/04 4/9/04 4/16/04 4/23/04 4/30/04 5/7/04 5/14/04 5/21/04 5/28/04 6/4/04 6/11/04 6/18/04 6/25/04 7/2/04 7/9/04 7/16/04 7/23/04 7/30/04 ৪/6/04 8/13/04 8/20/04 8/27/04 9/3/04 9/10/04 9/17/04 9/24/04 10/1/04 10/8/04 10/15/04 10/22/04 12/31/04 1/7/05 1/14/05 1/21/05 1/28/05 2/4/05 2/11/05 2/18/05 2/25/05 3/4/05 3/11/05 3/18/05 3/25/05 4.10 4.78 4.25 4.44 4.36 4.64 4.35 4.43 4.51 4.62 4.23 4.40 4.58 4.61 4.18 4.34 4.64 4.71 10/29/04 11/5/04 11/12/04 11/19/04 11/26/04 12/3/04 12/10/04 12/17/04 12/24/04 4.20 4.34 4.77 4.56 4.27 4.29 4.96 4.43 4.37 4.21 4.89 4.38 4.32 4.31 4.83 4.40 4.35 4.43 4.89 4.34 4.50 4.52 4.95 4.36 4.34 4.60 4.90 4.29 4.31 4.66 4.84 4.19 4.36 4.74 Yield A US Treasury 10-Year Bond Yileds at Weeks End (n=52 weeks) 525 5.05 4.65 4.25 Yield B US Treasury 10-Year Bond Yileds at Weeks End (n-52 weeks) 525 505 485 4.65 445 425 405 Yield C US Treasury 10-Year Bond Yileds at Weeks End (n=52 weeks) 5.25 5.05 4.65 4.45 4.25 Yield D US Treasury 10-Year Bond Yileds at Weeks End (n=52 weeks) 545 5.25 5.05 A5 4.65 445 425 (b) Perform exponential smoothing with a = 20. Use both methods A and Bto initialize the forecast. Record the statistics of fit. (Round the Mean squared error to 3 decimal places, percent values to 1 decimal place and Forecast to 2 decimal places.) .20 Mean squared error Mean absolute percent error Forecast for period 53 (c) Do the smoothing again with a = 10 and then with a = 30, recording the statistics of fit. (Round the Mean squared error to 3 decimal places and percent values to 1 decimal place.) .10 30 Mean squared error Mean absolute percent error (d) Compare the statistics of fit for the three values of a. (a-1) Select an Excel line graph of the following bond yield data. Seved U.S. Treasury 10-Year Bond Yields at Week's End (n = 52 weeks) Week Yield Week Yield Week Yield Week Yield 4/2/04 4/9/04 4/16/04 4/23/04 4/30/04 5/7/04 5/14/04 5/21/04 5/28/04 6/4/04 6/11/04 6/18/04 6/25/04 7/2/04 7/9/04 7/16/04 7/23/04 7/30/04 ৪/6/04 8/13/04 8/20/04 8/27/04 9/3/04 9/10/04 9/17/04 9/24/04 10/1/04 10/8/04 10/15/04 10/22/04 12/31/04 1/7/05 1/14/05 1/21/05 1/28/05 2/4/05 2/11/05 2/18/05 2/25/05 3/4/05 3/11/05 3/18/05 3/25/05 4.10 4.78 4.25 4.44 4.36 4.64 4.35 4.43 4.51 4.62 4.23 4.40 4.58 4.61 4.18 4.34 4.64 4.71 10/29/04 11/5/04 11/12/04 11/19/04 11/26/04 12/3/04 12/10/04 12/17/04 12/24/04 4.20 4.34 4.77 4.56 4.27 4.29 4.96 4.43 4.37 4.21 4.89 4.38 4.32 4.31 4.83 4.40 4.35 4.43 4.89 4.34 4.50 4.52 4.95 4.36 4.34 4.60 4.90 4.29 4.31 4.66 4.84 4.19 4.36 4.74 Yield A US Treasury 10-Year Bond Yileds at Weeks End (n=52 weeks) 525 5.05 4.65 4.25 Yield B US Treasury 10-Year Bond Yileds at Weeks End (n-52 weeks) 525 505 485 4.65 445 425 405 Yield C US Treasury 10-Year Bond Yileds at Weeks End (n=52 weeks) 5.25 5.05 4.65 4.45 4.25 Yield D US Treasury 10-Year Bond Yileds at Weeks End (n=52 weeks) 545 5.25 5.05 A5 4.65 445 425 (b) Perform exponential smoothing with a = 20. Use both methods A and Bto initialize the forecast. Record the statistics of fit. (Round the Mean squared error to 3 decimal places, percent values to 1 decimal place and Forecast to 2 decimal places.) .20 Mean squared error Mean absolute percent error Forecast for period 53 (c) Do the smoothing again with a = 10 and then with a = 30, recording the statistics of fit. (Round the Mean squared error to 3 decimal places and percent values to 1 decimal place.) .10 30 Mean squared error Mean absolute percent error (d) Compare the statistics of fit for the three values of a.
Expert Answer:
Related Book For
Applied Statistics in Business and Economics
ISBN: 978-0073521480
4th edition
Authors: David Doane, Lori Seward
Posted Date:
Students also viewed these economics questions
-
(a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 decimal places.) 2 2005 2006 2007 2008 2009 2010 mean
-
(b) Perform simple exponential smoothing (using Excel's Data Analysis or other software such as Minitab) using a = .05, 10, 20, and 50. The degree of smoothing (Click to select) dramatically as a is...
-
(a) Plot the data on U.S. general aviation shipments.
-
1. Estimate the model Debt = 30 + 1lnc + 32Unemp + . Is unemployment significant at the 5% level? 2. You are told that the unemployment rate might have a quadratic influence on monthly debt payments....
-
Harlan Venture Inc. (HV) operates a restaurant named Harlan's, which is located in Toronto. The shareholder, Taufiq Noorani, is concerned whether the system and controls in place at the restaurant...
-
In Problems 4358, find the exact value of each of the remaining trigonometric functions of . sin = 0 W/N tan 0 < 0
-
Match each of the objectives listed, 1 through 15, with its most appropriate perspective: financial, internal business, customer, or learning and growth. In addition, for each objective listed,...
-
A mine is for sale for $240,000. It is believed the mine will produce a profit of $65,000 the first year, but the profit will decline $5000 a year after that, eventually reaching zero, whereupon the...
-
CASE STUDY The term ordinary share is usually applied to a share where the holder has no priority in being a dividend or receiving a capital contribution in the event of the firm going into...
-
Bruce also requires a calculation of taxable income for the most recent year ended December 31, 2019. The calculation should be prepared in Excel. He has also requested that you prepare the year-end...
-
Quantitative reasoning is important both in the workplace and at home. I am going to assume that as a student in this class you are going to study the material, observe how it is used by looking at...
-
A's restaurant is failing so she applies for B's show Kitchen Nightmares. B comes to help and the show invests $750,000 during filming to save A's business. In order to maintain their success, A must...
-
Financing Charges and Net Present Value The president of the company is not convinced that the interest expense should be excluded from the calculation of the net present value. He points out that,...
-
Year 2018 2019 Note: all dollar figures are in millions Current assets $5,028 $5,974 Current liabilities $7,905 $8,952 Current ratio 63.61% 66.73% Year 2018 2019 Note: all dollar figures are in...
-
What is the likely consequence on the U.S. market for tobacco products of the event listed below? Sixteen states sue the major tobacco company for billions of dollars because of tobacco- related...
-
Problem2(4 points) Totty Company is considering the following project to produce a product. Year After-tax Cash Flow in $ 0 -100.000 1 33.950 2 33.850 3 33.950 4 33.450 The management believes if the...
-
Imran Berhad considering the purchase of new fully automated machine to replace an loder manually operates one.
-
Sundial Technologies produces and sells customized network systems in New Brunswick. The company offers a 60-day, all software and labor-and an extra 90-day, parts-only- warranty on all of its...
-
Faced with rising fax costs, a firm issued a guideline that transmissions of 10 pages or more should be sent by 2-day mail instead. Exceptions are allowed, but they want the average to be 10 or...
-
(a) Make an Excel graph of the data on the number of certified organic farms in the United States. (b) Discuss the underlying causes that might explain the trend or pattern. (c) Use Excel, MegaStat,...
-
At the Eureka library, the mean time a book is checked out is 13 days, the median is 10 days, and the mode is 7 days. (a) Sketch the distribution, based on these statistics. (b) What factors might...
-
The primary purpose of control self-assessment is to: a. Educate stakeholders about the reliability of different types of controls b. Make stakeholders aware of the differences between inherent risk,...
-
Which of the following arguments is most likely to be used in terms of having information systems auditors perform a staff role within an organization: a. Makes better use of scarce information...
-
Which of the following arguments is most likely to be used in support of decentralizing the information systems audit function within an organization: a. A shortage of skilled information systems...
Study smarter with the SolutionInn App