EBK STATISTICS FOR BUSINESS & ECONOMICS
12th Edition
ISBN: 8220100460463
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17.4, Problem 24E
FRED® (Federal Reserve Economic Data), a database of more than 3000 U.S. economic time series, contains historical data on foreign exchange rates. The following data show the foreign exchange rate for the United States and China (Federal Reserve Bank of St.Louis website). The units for Rate are the number of Chinese yuan to one U.S. dollar.
| Year | Month | Rate |
| 2007 | October | 7.5019 |
| 2007 | November | 7.4210 |
| 2007 | December | 7.3682 |
| 2008 | January | 7.2405 |
| 2008 | February | 7.1644 |
| 2008 | March | 7.0722 |
| 2008 | April | 6.9997 |
| 2008 | May | 6.9725 |
| 2008 | June | 6.8993 |
| 2008 | July | 6.8355 |
- a. Construct a time series plot. Does a linear trend appear to be present?
- b. Using Minitab or Excel, develop the linear trend equation for this time series.
- c. Use the trend equation to forecast the exchange rate for August 2008.
- d. Would you feel comfortable using the trend equation to forecast the exchange rate for December 2008?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Use the average annual consumer price index table to convert the 1978 minimum wage from actual dollars
to 1996 dollars. Is the result consistent with the entry in the accompanying minimum wage table?
Click the icon to view the table of federal minimum wages.
The 1978 minimum wage in 1996 dollars is $.
(Round to the nearest cent as needed.)
Federal Minimum Wages
Year
1938
1939
1945
1950
1990
1956
1961
1967
1968
pe
1974
1976
1978
1979
1981
1990
1991
1996
1997
2007
2008
2009
Actual Dollars 1996 Dollars
$2.78
$3.39
$3.49
$0.25
$0.30
$0.40
$0.75
90.19
$1.00
$1.25
$1.40
91.00
$1.60
$2.00
22:00
$2.30
$2.50
$2.65
22.0
$2.90
222
$3.35
$3.50
$4.25
$4.75
$5.15
$5.85
$6.55
$7.25
$4.88
67.90
$5.77
$6.41
20.70
$6.58
$7.21
66.27
$6.37
20:37
$6.34
20:20
$6.38
20:30
$6.27
90:20
$5.78
$4.56
$4.90
$4.75
$5.03
$4.42
$4.77
$5.12
-
X
Average Annual
Consumer Price Index (CPI)
(1982-1984 = 100)
Year CPI Year CPI Year CPI
1976 56.9 1989 124.0 2001 177.1
1977 60.6 1990 130.7 2002 179.9
1978 65.2 1991 136.2 2003…
Create a line chart for the closing price for all years and a stock chart for the high/low/close prices for 2011 through 2012 in the accompanying s&p 500 data.
Then choose the correct sock chart for the high/low/close prices for 2011 through 2012
Use the accompanying data table regarding retirement funds. Complete parts (a) through (d) below.
a. Construct a growth and value table that tabulates type, market cap, risk,and rating.
Chapter 17 Solutions
EBK STATISTICS FOR BUSINESS & ECONOMICS
Ch. 17.2 - Consider the following time series data. Week 1 2...Ch. 17.2 - Refer to the time series data in exercise 1. Using...Ch. 17.2 - Exercises 1 and 2 used different forecasting...Ch. 17.2 - Consider the following time series data. Month 1 2...Ch. 17.3 - Consider the following time series data. Week 1 2...Ch. 17.3 - Consider the following time series data. Month 1 2...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Refer again to the gasoline sales time series data...Ch. 17.3 - With the gasoline time series data from Table...Ch. 17.3 - With a smoothing constant of = .2, equation...
Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in ...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - The U.S. Census Bureau tracks the median price for...Ch. 17.4 - Consider the following time series data. a....Ch. 17.4 - Prob. 18ECh. 17.4 - Consider the following time series. a. Construct a...Ch. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - Prob. 22ECh. 17.4 - The president of a small manufacturing firm is...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Automobile unit sales at B. J. Scott Motors, Inc.,...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - Prob. 27ECh. 17.5 - Consider the following time series. a. Construct a...Ch. 17.5 - Consider the following time series data. a....Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Prob. 33ECh. 17.5 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Consider the following time series data. a....Ch. 17.6 - Refer to exercise 35. a. Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies. Inc., supplies milk to several...Ch. 17 - Prob. 44SECh. 17 - Prob. 45SECh. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Canton Supplies, Inc., is a service firm that...Ch. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Hudson Marine has been an authorized dealer for CD...Ch. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise 53....Ch. 17 - Refer to the Hudson Marine data in exercise 53. a....Ch. 17 - Forecasting Food and Beverage Sales The Vintage...Ch. 17 - Forecasting Lost Sales The Carlson Department...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- California’s minimum wage (in dollars per hour) has increased substantially over the last 20 years, as seen in the table below. Date 3/1/98 1/1/01 1/1/02 1/1/07 1/1/08 7/1/14 1/1/16 1/1/17 1/1/18 Minimum Wage $5.75 $6.25 $6.75 $7.50 $8.00 $9.00 $10.00 $10.50 $11.00 Which of these graphic displays should be used to show the rate of change, or trend, of these minimum wage rates over time? a. A pie chart b. A table displaying the mean and median c. A bar graph d. A line grapharrow_forwardASAParrow_forward16. A new car costs $28 500. It loses 11.4% of its value each year after it is purchased. Determine the value of the car after 3 years. a. $19282.38 b. $19821.93 c. $29400.38 d. $365.13arrow_forward
- Please solve this questionarrow_forwardCalculate the missing information for the purchase. Item SellingPrice(in $) SalesTaxRate SalesTax(in $) ExciseTax Rate ExciseTax TotalPurchase Price book 8 0 0 $11.88arrow_forwardThe Manana Corporation had sales of $71.2 million this year. Its accounts receivable balance averaged $6.3 million. How long, on average, does it take the firm to collect on its sales? (Hint: Use 365 days for a year.) a. The collection period is days. (Round to one decimal place.)arrow_forward
- Find the accumulated amount at the end of 6 months on an $400 deposit in the bank paying simple interest at the rate of 3% year. O a. The accumulated amount is $406. Ob. The accumulated amount is $413. OC The accumulated amount is $418. Od. The accumulated amount is $411. O e. The accumulated amount is $416. QUESTION 4 Carlos invested $7,000 in a money market mutual fund that pays interest on a daily basis. The balance in his account at the end of 8 mo (245 days) was $7,432. Find t which Carlos's account earned interest over this period (assume a 365-day year). O a. 6.18%. О .6.38%. Oc. 9.34%. O d.9.24%. QUESTION 5 In the last 3 years, mutual fund A grew at the rate of9.5% year compounded quarterly. Over the same period, mutual fund B grew at the rate of 9.6%/year compounded s Which mutual fund has a better rate of return? Click Save and Submit to save and submit. Click SaE All Answers to saue all answers.arrow_forwardUsing the currency cross rate table, convert US$649.00 to Canadian dollars. Canadian U.S. Euro Japanese British Australian dollar dollar yen pound dollar 1.3907 1.5804 0.0121 1.1603 0.0081 0.0076 Canadian dollar U.S. dollar Euro Japanese yen British pound 0.7191 0.6328 0.8618 82.64 123.46 131.58 0.4431 0.6014 0.6982 1.7364 Australian dollar 1.1002 1.4986 US$649.00 will purchase C$ (Round to the nearest cent as needed.) 0.0051 0.0125 2.2569 1.6628 1.4323 197.65 2.5025 0.9089 0.6673 0.5759 79.78 0.3996arrow_forwardCalculate the missing information for the stock. (Round current yield to the nearest tenth of a percent.) Company Earningsper Share AnnualDividend Current Priceper Share CurrentYield(as a %) Price-EarningsRatio a medical case management company $6.39 $1.50 $38.34 %arrow_forward
- Which term refers to the capital or the sum of money invested? Final Amount Interest Principal Maturity valuearrow_forwardThe value of Kenya shillings visa in US Dollar for the first eight days of August 2018 is given us 95.11, 95.10, 95.15, 95.10 ,95.30,95.39,95.50 and 95.41. find the forecast of exchange rates on the 9th day.arrow_forwardBetty Smith is the owner of Accurate Tax Service. For the year ending April 30, 2019, the following information is available for this service business. At the beginning of this accounting period, the balance in the Betty Smith, Capital account was $31,800. Following is a summary of activities during this accounting period: Betty Smith, capital withdrawn: $17,100 Revenue from income tax preparation: $71,400 Revenue from monthly clients: $45,600 Salaries expense: $11,000 Advertising expense: $630 Rent expense: $7,000 Automobile expense: $1.100 Office supplies expense: $7,200. Note: You should assume that all profit (or loss) accrued during this accounting period is absorbed into the Betty Smith, Capital account at the end of the period. Following are the account balances at the end of this accounting period (except Betty Smith, Capital): Cash: $59,600 Accounts receivable: $3,800 Office furniture and fixtures: $12,200 Office machines and computers: $17,000 Automobile: $8,300 Accounts…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
What Are Research Ethics?; Author: HighSchoolScience101;https://www.youtube.com/watch?v=nX4c3V23DZI;License: Standard YouTube License, CC-BY
What is Ethics in Research - ethics in research (research ethics); Author: Chee-Onn Leong;https://www.youtube.com/watch?v=W8Vk0sXtMGU;License: Standard YouTube License, CC-BY