(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...
-
Give some examples of a need for BI coverage from dependent properties.
-
The specific weight of water is 62.4 lb/ft 3 . a. Assuming 7.48 gal/ft 3 , determine the weight of 1 gal of water. b. Determine the weight of 1 L of water, in N.
-
Jeremy Hawk, accountant for Rainbow International Corp., was injured in an auto accident. Another employee prepared the following income statement for the year ended December 31, 2007: The individual...
-
Shelf mix decision Superstore is a large discount supermarket. Profits have declined, so the manager has collected data on revenues and costs for different food categories. The following data pertain...
-
What is the ball's rate of acceleration of a basketball when the ball reaches the top of its path and starts back down? Assume no air resistance.
-
GWE in store retail is considering closing stores to save a further 20% next year. Given current figures, how many stores would you expect GWE to close? GWE Profit and Loss for (Year 1) Asia...
-
Explain what arguments the plaintiff (Mr. Henderson) could raise to the court to substantiate his lawsuit against the Condo Corporations. 2. Explain what arguments the defendant (Jefferson Property...
-
Explain why collaborative filtering is such a useful technique. How successful do you believe it can be? What might limit its efficacy?
-
Explain how Bayes theorem can be used to develop learning systems.
-
Bayes theorem uses a conditional probability and two prior probabilities to calculate just one conditional probability. That doesnt sound like its very helpful.Discuss this comment.
-
Explain in detail how a Kohonen map might be used to cluster a set of web documents in response to a users keyword query.
-
Explain how Hopfield networks operate.
-
Let p be a polynomial on [a, b] and why is invertible. Then, prove that po : [0,1] [a, b] given by (x) = a + (b a)x. First, explain - is a polynomial on [a, b].
-
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...
-
To determine an optimum sample size when sampling methods are used in a substantive test, all of the following factors must be considered except the a. Variation in the population. b. Risk levels the...
-
Which of the following sample planning factors would influence the sample size for a substantive test of details for a specific account? Expected amount of misstatements No Measure of tolerable...
-
The relationship between the sampling risk of incorrect acceptance and the sample size of substantive tests is a. Inverse. b. Positive. c. Indeterminate. d. None of the above.
Study smarter with the SolutionInn App