(a) Make a line chart and fit an m-period moving average to the exchange rate data...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(a) Make a line chart and fit an m-period moving average to the exchange rate data shown above with m= 2, 3, 4, and 5 periods. For each method, state the last MA value. (Round your answers to 4 decimal places.) m-period Next period forecast 2 3 4 5 (b) Which value of m do you prefer? The preferred m value is5 overreacting to dalily fluctuations. . This value of m Using this allows one to forecast the weekly or monthly trends without (e) is a moving average appropriate for this kind of data? Yes . a moving average is appropriate Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 13-Apr- 23-Apr- 04 1-Apr-04 1.8564 1.8160 1.7674 04 14-Apr- 04 26-Apr- 2-Apr-04 1.8293 1.7902 1.7857 04 15-Apr- 27-Apr- 5-Apr-04 1.8140 1.7785 1.7925 04 04 28-Apr- 04 16-Apr- 6-Apr-04 1.8374 1.8004 1.7720 04 19-Apr- 29-Apr- 7-Apr-04 1.8410 1.8055 1.7751 04 04 20-Apr- 30-Apr- 8-Apr-04 1.8325 1.7914 1.7744 04 04 21-Apr- 9-Apr-04 1.8322 1.7720 3-May-e4 1.7720 04 12-Apr- 22-Apr- 1.8358 1.7684 4-May-04 1.7907 04 04 13-маy- 5-May-04 1.7932 21-May- 04 1.7584 1.7880 04 24-May- 6-May-04 1.7941 14-May- 04 1.7572 1.7908 04 17-May - 25-May- 7-May-04 1.7842 1.7695 1.8135 04 04 10-May- 18-May- 26-May- 1.7723 1.7695 1.8142 04 04 04 11-May- 19-Мay- 27-May- 1.7544 1.7827 1.8369 04 04 04 12-May- 20-Мay- 28-May- 1.7743 1.7710 1.8330 04 04 04 (a) Make a line chart and fit an m-period moving average to the exchange rate data shown above with m= 2, 3, 4, and 5 periods. For each method, state the last MA value. (Round your answers to 4 decimal places.) m-period Next period forecast 2 3 4 5 (b) Which value of m do you prefer? The preferred m value is5 overreacting to dalily fluctuations. . This value of m Using this allows one to forecast the weekly or monthly trends without (e) is a moving average appropriate for this kind of data? Yes . a moving average is appropriate Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 13-Apr- 23-Apr- 04 1-Apr-04 1.8564 1.8160 1.7674 04 14-Apr- 04 26-Apr- 2-Apr-04 1.8293 1.7902 1.7857 04 15-Apr- 27-Apr- 5-Apr-04 1.8140 1.7785 1.7925 04 04 28-Apr- 04 16-Apr- 6-Apr-04 1.8374 1.8004 1.7720 04 19-Apr- 29-Apr- 7-Apr-04 1.8410 1.8055 1.7751 04 04 20-Apr- 30-Apr- 8-Apr-04 1.8325 1.7914 1.7744 04 04 21-Apr- 9-Apr-04 1.8322 1.7720 3-May-e4 1.7720 04 12-Apr- 22-Apr- 1.8358 1.7684 4-May-04 1.7907 04 04 13-маy- 5-May-04 1.7932 21-May- 04 1.7584 1.7880 04 24-May- 6-May-04 1.7941 14-May- 04 1.7572 1.7908 04 17-May - 25-May- 7-May-04 1.7842 1.7695 1.8135 04 04 10-May- 18-May- 26-May- 1.7723 1.7695 1.8142 04 04 04 11-May- 19-Мay- 27-May- 1.7544 1.7827 1.8369 04 04 04 12-May- 20-Мay- 28-May- 1.7743 1.7710 1.8330 04 04 04
Expert Answer:
Answer rating: 100% (QA)
a The mperiod Moving Average MA forecast The 2period Moving Average MA values are obtained in excel by taking the average of the current period and the immediately previous period data value Similarly ... View the full 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
-
Northport's Sandwiches acquired equipment on April 1, 2024, for $22,000. The company estimates a residual value of $2,800 and a five-year service life. Required: Calculate depreciation expense using...
-
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...
-
A pack of iron bolts is such that the difference in masses or weights of successive sizes is the same bolt being of mass 13.5 grams and the largest is 94.5 grams. If the total mass of the complete...
-
Fellowes and Associates Chartered Accountants is a successful mid-tier accounting firm with a large range of clients across Canada. During the financial year 2011, Fellowes and Associates gained a...
-
In Problems 5358, convert each angle in radians to degrees. Express your answer in decimal form, rounded to two decimal places. 7
-
Part 1: Calculating Short-Term Measurements The following annual information is available for Lakewood Industries, an investment center: a. Calculate ROI (return on investment). Base your...
-
The adjusted trial balance for Madrasah Co. is presented in the following worksheet for the month ended April 30, 2012. InstructionsComplete the worksheet and prepare a classified balancesheet....
-
What is the purpose of the Alternative Minimum Tax (AMT) in the federal tax system? a. To provide tax breaks for low-income individuals b. To ensure high-income individuals pay a minimum amount of...
-
When one hears the word entrepreneur, many faces come to mind. Elon Musk, Sara Blakely, Warren Buffet, Martha Stewart, Bill Gates, and Daymond John are just a few that might spring to mind. There are...
-
1. Why urban planners should avoid conflict of interest that may influence decision making using biblical references 2. How a conduct is important for urban planners not to take advantage of the...
-
Syarikat SriNuri Food Industries is a halal ovalette manufacturer in Malaysia. The ovalette production process begins with the Mixing Department, where key ingredients such as Monoglyceride,...
-
On September 1, Mr. Smith sold short 120 shares of A Inc. stock at $120 per share and also sold short 240 shares of B Corp. stock for $240 per share. The initial and maintenance margin requirement...
-
You have just finished your finance degree and struck it rich with a high paying, $75,000/year job in downtown Phoenix. Your parents have agreed to help you purchase a condo, townhome or house in the...
-
A bond pays a coupon of $21 two times each year and matures in 19 years. The yield is 3.93%. How much is it worth today? Answer:
-
HONDA Inc. is using Just-in-Time Production System and Backflush Cost Accounting System for the year ended December 31, 2016. The following information was provided for the year 2016: A. Raw...
-
Finn does side work as a chef. For his most recent event, he spent six hours cooking and prepping at $50/hour. His clients provided all the raw foods and materials shown below from a list he sent...
-
The National Collegiate Athletic Association (NCAA) and the National Federation of State High School Associations (NFHS) set a new standard for non-wood baseball bats. Their goal was to ensure that...
-
A random sample of 21 nickels measured with a very accurate micrometer showed a mean diameter of 0.834343 inch with a standard deviation of 0.001886 inch. (a) Why would nickel diameters vary? (b)...
-
Three samples of each of three types of PVC pipe of equal wall thickness are tested to failure under three temperature conditions, yielding the results shown below. Research questions: Is mean burst...
-
Students in nutrition classes at two high schools were asked to keep track of the number of times during the past month that they ordered from a fast-food chain restaurant. (a) The re-search...
-
Information systems auditors should be most concerned about management's decision to undertake outsourcing of the information systems function when: a. A long-term contract with the outsourcing...
-
Which of the following statements about the implications of privacy legislation for auditors most likely is false? a. As users of personal data, auditors will be exempt from privacy legislation...
-
Which of the following is not an implication of interorganizational information systems and virtual organizations for the conduct of audit work? a. Processing controls become more important than...
Study smarter with the SolutionInn App