(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. (c) Which value of a do you prefer? (Round your answers to 2 decimal places.) 14-Маy- 24-May- 6-May-04 1.7741 1.7588 1.7908 04 04 17-May- 25-Мay- 7-Маy-04 1.7942 1.7569 1.8335 04 04 10-May- 18-Маy- 26-May- 1.7923 1.7757 1.8342 04 04 04 11-Маy- 19-May- 27-May- 1.7744 1.7839 1.8769 04 04 04 12-May- 20-May- 28-May- 1.7843 1.7710 1.8530 04 04 04 Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 13-Apr- 23-Apr- 1-Apr-04 1.8764 1.8260 1.7674 04 04 14-Apr- 26-Apr- 2-Apr-04 1.8693 1.7802 1.7857 04 04 15-Apr- 27-Apr- 5-Apr-04 1.8140 1.7935 1.7925 04 04 16-Apr- 28-Apr- 6-Apr-04 1.8674 1.8108 1.7720 04 04 19-Apr- 29-Apr- 7-Apr-04 1.8410 1.8155 1.7851 04 04 20-Apr- 30-Apr- 8-Apr-04 1.8525 1.7916 1.7844 04 04 21-Apr- 9-Apr-04 1.8422 1.7780 3-Маy-04 1.7720 04 12-Apr- 22-Apr- 1.8558 1.7688 4-Мay-04 1.7607 04 04 13-Маy- 21-May- 5-Мay-04 1.7832 1.7589 1.7880 04 04 14-May- 24-Мay- 6-Mav-04 1 7741 1 7588 1 7998 (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. (c) Which value of a do you prefer? (Round your answers to 2 decimal places.) 14-Маy- 24-May- 6-May-04 1.7741 1.7588 1.7908 04 04 17-May- 25-Мay- 7-Маy-04 1.7942 1.7569 1.8335 04 04 10-May- 18-Маy- 26-May- 1.7923 1.7757 1.8342 04 04 04 11-Маy- 19-May- 27-May- 1.7744 1.7839 1.8769 04 04 04 12-May- 20-May- 28-May- 1.7843 1.7710 1.8530 04 04 04 Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 13-Apr- 23-Apr- 1-Apr-04 1.8764 1.8260 1.7674 04 04 14-Apr- 26-Apr- 2-Apr-04 1.8693 1.7802 1.7857 04 04 15-Apr- 27-Apr- 5-Apr-04 1.8140 1.7935 1.7925 04 04 16-Apr- 28-Apr- 6-Apr-04 1.8674 1.8108 1.7720 04 04 19-Apr- 29-Apr- 7-Apr-04 1.8410 1.8155 1.7851 04 04 20-Apr- 30-Apr- 8-Apr-04 1.8525 1.7916 1.7844 04 04 21-Apr- 9-Apr-04 1.8422 1.7780 3-Маy-04 1.7720 04 12-Apr- 22-Apr- 1.8558 1.7688 4-Мay-04 1.7607 04 04 13-Маy- 21-May- 5-Мay-04 1.7832 1.7589 1.7880 04 04 14-May- 24-Мay- 6-Mav-04 1 7741 1 7588 1 7998
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 finance questions
-
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...
-
Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling t Date Rate 1 1-Apr-04 1.8564 2 2-Apr-04 1.8293 3 5-Apr-04 1.8140 4 6-Apr-04 1.8374 5 7-Apr-04 1.8410 6 8-Apr-04 1.8325 7 9-Apr-04 1.8322 8...
-
Bingl is one the provinces in Turkey with a very high earthquake risk, since the city center is located on the fault and is very close to the East Anatolian Fault Zone, which is also one of the most...
-
Enter two linear functions into Y1 and Y2 on your calculator. Enter the compositions of the functions as Y3 = Y1 (Y2(x)) and Y4 = Y2(Y1(x)). Graph Y3 and Y4 and look for any relationships between...
-
List the major innovations and trends that contributed to the digital revolution.
-
Determine the moments of inertia and the radius of gyration of the section as shown in Figure 11.28 with respect to the \(x\) and \(y\)-axes. FIGURE 11.28: y 12 mm 12 mm 8 mm 24 mm 24 mm 6 mm 24 mm...
-
Compare the basis of accounting that is used to report governmental activities versus business-type activities.
-
What is MATLAB? Pros and cons.
-
Kaplan Computers manufactures high end computer systems for the graphics design industry. At the present time, the company makes three computers with the following characteristics: Computer 1...
-
1) An SAE 4140 steel panel with thickness 0.10 inches is being replaced with an E-glass fiber reinforced polyester panel with equal flexural stiffness. Calculate the weight and cost differences...
-
What are the implications of globalization and digital connectivity on the manifestation and perception of deviance, especially considering the fluidity of boundaries and the diversification of...
-
How do advancements in communication technologies and the proliferation of digital platforms contribute to the acceleration and diffusion of social change processes?
-
How do emergent macro-level phenomena, such as globalization and technological advancements, catalyze social change across diverse cultural landscapes?
-
It is not always easy to determine how an English word is pronounced based on its spelling. To illustrate the gap between spelling and pronunciation, George Bernard Shaw created the word "ghoti."...
-
How will financial analyst be affected by the advances in AI?
-
Retaining a customer after a complaint is more likely if Retaining a customer after a complaint is more likely if the problem is blamed on the customer. the problem is ignored and continues. the...
-
Write an essay describing the differing approaches of nursing leaders and managers to issues in practice. To complete this assignment, do the following: 1. Select an issue from the following list:...
-
Solve problem 4 with pivot tables and create corresponding pivot charts. Express the counts as percentage of row. What do these percentages indicate about this particular data set? Then repeat,...
-
The file P02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies. a. Create a recoded version of Education, where 0 or 2 is recoded as 1, 4 is recoded as 2, and 6 or 8...
-
The file P03_55.xlsx lists the average salary for each Major League Baseball (MLB) team from 2004 to 2009, along with the number of team wins in each of these years. a. Rearrange the data so that...
-
In the section of his 2007 letter to the shareholders of Berkshire Hathaway titled Fanciful FiguresHow Public Companies Juice Earnings, Warren Buffett referred to the investment return assumption...
-
Based on 2012 revenues, the six largest providers of oilfield services are: 1. Schlumberger Ltd. (NYSE: SLB) Revenues: $42.1 billion Net income: $5.5 billion 2. Halliburton (NYSE: HAL) Revenues:...
-
On 21 September 2000, Intel Corporation (NASDAQ -GS: INTC)3 issued a press release containing information about its expected revenue growth for the third quarter of 2000. The announced growth fell...
Study smarter with the SolutionInn App