(b) Perform simple exponential smoothing (using Excel's Data Analysis or other software such as Minitab) using...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(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 varies dramatically as a is increased. (e) Which value of a do you prefer? (Round your answers to 2 decimal places.) (d) Is exponential smoothing appropriate for this kind of data? Yes Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date 1-Apr-94 2-Apr-04 5-Apr-04 6-Apr-04 7-Apr-84 8-Apr-04 9-Apr-94 12-Apr-84 5-May-04 6-May-04 7-May-04 18-May-04 11-May-04 12-Мay-в4 Rate Rate 1.7874 Date Rote Date 1.8260 23-Apr-84 26-Apr-84 27-Apr-84 28-Apr-84 29-Арг-64 38-Apr-84 3-May-04 4-May-04 21-May-64 24-May-04 25-May-04 26-Мay-в4 27-May-04 28-May-04 1.8584 13-Apr-04 14-Apr-04 15-Apr-84 16-Apr-84 1.8363 1.7752 1.7785 1.8104 1.8155 1.7857 1.8140 1.7925 1.7720 1.8474 1.7656 1.7744 1.8418 19-Аpг-84 1.8525 20-Apr-04 21-Apr-84 22-Apr-84 13-May-84 14-May-04 17-May-84 18-May-04 19-May-84 20-May-84 1.7816 1.8422 1.8558 1.7620 1.7784 1.7720 1.7507 1.788e 1.7808 1.7732 1.7554 1.7641 1.7692 1.7595 1.7942 1.8535 1.7693 1.7695 1.8342 1.8869 1.7644 1.7727 1.7743 1.7610 1.8730 U.S. Manufactured General Aviation Shipments, 2009-2015 Year Qtr 1 Qtr 2 Qtr 3 Qtr 4 477 Total Year Qtr Planes 2009 310 408 390 1,585 2009 Qtr1 310 377 Qtr2 Qtr3 2010 243 281 433 1,334 408 2011 268 289 286 480 1,323 390 2012 305 358 339 514 1,516 Qtr4 477 2013 329 413 353 520 1,615 2010 Qtr1 243 2014 345 380 379 527 1,631 Qtr2 377 2015 296 374 378 544 1,592 Qtr3 281 Qtr4 433 2011 Qtr1 268 LearningStats Qtr2 289 Qtr3 Qtr4 286 Copyright © 2019 by The McGraw-Hill Companies 480 2012 Qtr1 305 Qtr2 358 This spreadsheet is intended solely for educational purposes by Qtr3 339 licensed users of Connect Qtr4 514 2013 Qtr1 329 Qtr2 413 Qtr3 353 Source: General Aviation Manufacturers Association (www.gama.aero). Quarterly shipments may not add to annual total because some manufacturers only report annual totals. Qtr4 520 2014 Qtr1 345 Qtr2 380 Qtr3 379 Qtr4 527 2015 Qtr1 296 374 378 Qtr2 Qtr3 Qtr4 544 (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 varies dramatically as a is increased. (e) Which value of a do you prefer? (Round your answers to 2 decimal places.) (d) Is exponential smoothing appropriate for this kind of data? Yes Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date 1-Apr-94 2-Apr-04 5-Apr-04 6-Apr-04 7-Apr-84 8-Apr-04 9-Apr-94 12-Apr-84 5-May-04 6-May-04 7-May-04 18-May-04 11-May-04 12-Мay-в4 Rate Rate 1.7874 Date Rote Date 1.8260 23-Apr-84 26-Apr-84 27-Apr-84 28-Apr-84 29-Арг-64 38-Apr-84 3-May-04 4-May-04 21-May-64 24-May-04 25-May-04 26-Мay-в4 27-May-04 28-May-04 1.8584 13-Apr-04 14-Apr-04 15-Apr-84 16-Apr-84 1.8363 1.7752 1.7785 1.8104 1.8155 1.7857 1.8140 1.7925 1.7720 1.8474 1.7656 1.7744 1.8418 19-Аpг-84 1.8525 20-Apr-04 21-Apr-84 22-Apr-84 13-May-84 14-May-04 17-May-84 18-May-04 19-May-84 20-May-84 1.7816 1.8422 1.8558 1.7620 1.7784 1.7720 1.7507 1.788e 1.7808 1.7732 1.7554 1.7641 1.7692 1.7595 1.7942 1.8535 1.7693 1.7695 1.8342 1.8869 1.7644 1.7727 1.7743 1.7610 1.8730 U.S. Manufactured General Aviation Shipments, 2009-2015 Year Qtr 1 Qtr 2 Qtr 3 Qtr 4 477 Total Year Qtr Planes 2009 310 408 390 1,585 2009 Qtr1 310 377 Qtr2 Qtr3 2010 243 281 433 1,334 408 2011 268 289 286 480 1,323 390 2012 305 358 339 514 1,516 Qtr4 477 2013 329 413 353 520 1,615 2010 Qtr1 243 2014 345 380 379 527 1,631 Qtr2 377 2015 296 374 378 544 1,592 Qtr3 281 Qtr4 433 2011 Qtr1 268 LearningStats Qtr2 289 Qtr3 Qtr4 286 Copyright © 2019 by The McGraw-Hill Companies 480 2012 Qtr1 305 Qtr2 358 This spreadsheet is intended solely for educational purposes by Qtr3 339 licensed users of Connect Qtr4 514 2013 Qtr1 329 Qtr2 413 Qtr3 353 Source: General Aviation Manufacturers Association (www.gama.aero). Quarterly shipments may not add to annual total because some manufacturers only report annual totals. Qtr4 520 2014 Qtr1 345 Qtr2 380 Qtr3 379 Qtr4 527 2015 Qtr1 296 374 378 Qtr2 Qtr3 Qtr4 544
Expert Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these mathematics questions
-
For 7a-c, use u1= 4. Round your answers to the nearest thousandth. a. For a geometric series with r = 0.7, find S10 and S40. b. For r = 1.3, find S10 and S40. c. For r = 1, find S10 and S40. d. Graph...
-
Complete the following ANOVA table. *Round your answer to 2 decimal places, the tolerance is +/-0.01. **Round your answer to 3 decimal places, the tolerance is +/-0.001. *** Round your answer to 2...
-
Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling t Date Rate 1 1-Apr-04 1.8584 2 2-Apr-04 1.8363 3 5-Apr-04 1.8140 4 6-Apr-04 1.8474 5 7-Apr-04 1.8410 6 8-Apr-04 1.8525 7 9-Apr-04 1.8422 8...
-
Various statistical software packages tend to provide different measures of association. Use statistical software to calculate the Goodman-Kruskal gamma, Somers D, or Kendalls tau-a for the space...
-
Flexible wages play a critical role in removing an economy from a recessionary gap. Do you agree or disagree? Explain your answer.
-
For a fin that is effectively infinite in length, what would the tip temperature be?
-
Blood flows at volume rate \(Q\) in a circular tube of radius \(R\). The blood cells concentrate and flow near the center of the tube, while the cell-free fluid (plasma) flows in the outer region....
-
Refer to Matthias Medical's financial statements, presented in Exercise 12-8. Required Calculate the following market measure ratios for 2013. a. Earnings per share (average of 418,000 shares...
-
What is the present value of a perpetual stream of cash flows that pays $6,500 at the end of year one and the annual cash flows grow at a rate of 4% per year indefinitely, if the appropriate discount...
-
Thunder Attractions, an amusement park, is considering a capital investment in a new exhibit. The exhibit would cost 136,000 and have an estimated useful life of 5 years. It will be sold for 60,000...
-
In this assignment, you'll make ASCII art using cout statements. The following is a program that prints a 4-level triangle. This assignment has 3 steps. Iteratively add to the starter program each...
-
In a Modigliani-Miller world, Publicvehicle Inc. is an automobile company that is completely equity financed. The company value next year will be 75m (p=0.2), 90m (p=0.5) or 100m (p=0.3). [Note that...
-
On December 31, 2019, Cooley Company purchased 60% of McKnight Company's common shares for $1,575,000. McKnight Company recorded net income of $1 million and paid cash dividends of $250,000 in 2020....
-
Use the drop down list to make an Income Statement with the data below. Use formulas to enter the data below the lines. Find Retained Earning. Cash crop sales Cash livestock sales Item Cash operating...
-
outstanding stock is composed of 1 0 , 0 0 0 shares of $ 1 0 0 par, noncumulative, preferred 8 % stock, and 5 0 , 0 0 0 shares of no - par common stock. Preferred dividends have been paid every year...
-
a) Determine the rate on the FRA(6x9) contract if the 6-month and 9-month LIBOR rates are 2.00% and 2.10%, respectively. Use day-counts of 182 and 272 for the two LIBOR rates b) Determine the dollar...
-
A four-year project promises to pay 0.56% interest per month. An investor is trying to decide between investing in this project or investing in a semi-annually compounded four-year GIC. Above what...
-
Multiple Choice Questions: 1. The largest component of aggregate demand is? a. Government purchases. b. Net exports. c. Consumption. d. Investment. 2. A reduction in personal income taxes, other...
-
In the Walton Bookstore example with a discrete demand distribution, explain why an order quantity other than one of the possible demands cannot maximize the expected profit.
-
A large buyer of household batteries wants to decide which of two equally priced brands to purchase. To do this, he takes a random sample of 100 batteries of each brand. The lifetimes, measured in...
-
A toy company has assigned you to analyze the factors influencing the sales of its most popular doll. The number of these dolls sold during the last 23 years is given in the file P11_57.xlsx. The...
-
Which forecasting technique is more qualitative, the Delphi method or linear regression?
-
A road-paving crew required 8 hours to repave a 3-mile stretch of road, using \($5,000\) in materials. The crew consisted of three workers who each earn \($25\) an hour. Calculate a multifactor...
-
An automobile assembly plant produced 600 cars during a 5-day workweek. It then produced 500 cars the following week, although it only operated 4 days due to a national holiday. During which week was...
Study smarter with the SolutionInn App