# Question: a Make an Excel line graph of the exchange rate

(a) Make an Excel line graph of the exchange rate data. Describe the pattern.

(b) Click on the data and choose Add Trendline > Moving Average. Describe the effect of increasing m (e.g., m = 2, 4, 6, etc.). Include a copy of each graph with your answer.

(c) Discuss how this moving aver- age might help a currency speculator.

(b) Click on the data and choose Add Trendline > Moving Average. Describe the effect of increasing m (e.g., m = 2, 4, 6, etc.). Include a copy of each graph with your answer.

(c) Discuss how this moving aver- age might help a currency speculator.

**View Solution:**## Answer to relevant Questions

(a) Make an Excel line graph of the following bond yield data. Describe the pattern. Is there a consistent trend? (b) Use exponential smoothing (MegaStat, MINITAB, or Excel) with α = .20. Use both methods A and B to ...Ages of 56 attendees of a Harry Potter movie are shown. (a) Form seven age classes (10 to 20, 20 to 30, etc.). Tabulate the frequency of attendees in each class. (b) Calculate expected frequencies for each class. (c) ...Use MINITAB's Stat > Basic Statistics > Normality Test to obtain a probability plot for the Ashoka Curry House carry-out order data (see Exercise 15.16). Interpret the probability plot and Anderson-Darling statistic. Was ...Choose either 2 × 2 contingency table shown below (males or females). Research question: At α = .005, is smoking independent of race? (Smoking rates are from Statistical Abstract of the United States, 2001, pp. 16 and 12, ...The actual distribution of car colors for 2006 model car buyers is shown below. Based on the sample of 200 car buyers for 2012 model vehicles, use the multinomial chi-square GOF test at α = .05 to test whether car buyers' ...Post your question