A) Perform the plots of import/export versus yearly & apply the moving average technique to smooth...
A) Perform the plots of import/export versus yearly & apply the moving average technique to smooth them out using PHSTATS.
B) Please select one of the appropriate forecasting method to predict the import & export (use the data from 1985 to 2018 and try to predict the import/export number of 2019)
| year | Import (Mil$) | Export (Year) |
| 1985 | 3861.7 | 3855.7 |
| 1986 | 4771 | 3106.3 |
| 1987 | 6293.6 | 3497.3 |
| 1988 | 8510.9 | 5021.6 |
| 1989 | 11989.7 | 5755.4 |
| 1990 | 15237.4 | 4806.4 |
| 1991 | 18969.2 | 6278.2 |
| 1992 | 25727.5 | 7418.5 |
| 1993 | 31539.9 | 8762.9 |
| 1994 | 38786.8 | 9281.7 |
| 1995 | 45543.2 | 11753.7 |
| 1996 | 51512.8 | 11992.6 |
| 1997 | 62557.7 | 12862.2 |
| 1998 | 71168.6 | 14241.2 |
| 1999 | 81788.2 | 13111.1 |
| 2000 | 100018.2 | 16185.2 |
| 2001 | 102278.4 | 19182.3 |
| 2002 | 125192.6 | 22127.7 |
| 2003 | 152436.0969 | 28367.94286 |
| 2004 | 196682.0339 | 34427.77246 |
| 2005 | 243470.1048 | 41192.01012 |
| 2006 | 287774.3526 | 53673.00834 |
| 2007 | 321442.8669 | 62936.89158 |
| 2008 | 337772.6278 | 69732.83754 |
| 2009 | 296373.8835 | 69496.67861 |
| 2010 | 364952.6336 | 91911.08094 |
| 2011 | 399371.2326 | 104121.5236 |
| 2012 | 425619.0826 | 110516.6157 |
| 2013 | 440430.0196 | 121746.1886 |
| 2014 | 468474.8949 | 123657.2034 |
| 2015 | 483201.6554 | 115873.3653 |
| 2016 | 462419.9916 | 115594.7845 |
| 2017 | 505220.2333 | 129797.5872 |
| 2018 | 539675.5908 | 120148.1411 |
Homework Answers
A) PLOTS of import/ export versus year -
Using moving average of order 3 for both import and export -
| Year | Import (Mil$) | Export (Year) | MA Import | MA Export |
| 1985 | 3,861.70 | 3,855.70 | ||
| 1986 | 4,771.00 | 3,106.30 | ||
| 1987 | 6,293.60 | 3,497.30 | 4,975.43 | 3,486.43 |
| 1988 | 8,510.90 | 5,021.60 | 6,525.17 | 3,875.07 |
| 1989 | 11,989.70 | 5,755.40 | 8,931.40 | 4,758.10 |
| 1990 | 15,237.40 | 4,806.40 | 11,912.67 | 5,194.47 |
| 1991 | 18,969.20 | 6,278.20 | 15,398.77 | 5,613.33 |
| 1992 | 25,727.50 | 7,418.50 | 19,978.03 | 6,167.70 |
| 1993 | 31,539.90 | 8,762.90 | 25,412.20 | 7,486.53 |
| 1994 | 38,786.80 | 9,281.70 | 32,018.07 | 8,487.70 |
| 1995 | 45,543.20 | 11,753.70 | 38,623.30 | 9,932.77 |
| 1996 | 51,512.80 | 11,992.60 | 45,280.93 | 11,009.33 |
| 1997 | 62,557.70 | 12,862.20 | 53,204.57 | 12,202.83 |
| 1998 | 71,168.60 | 14,241.20 | 61,746.37 | 13,032.00 |
| 1999 | 81,788.20 | 13,111.10 | 71,838.17 | 13,404.83 |
| 2000 | 1,00,018.20 | 16,185.20 | 84,325.00 | 14,512.50 |
| 2001 | 1,02,278.40 | 19,182.30 | 94,694.93 | 16,159.53 |
| 2002 | 1,25,192.60 | 22,127.70 | 1,09,163.07 | 19,165.07 |
| 2003 | 1,52,436.10 | 28,367.94 | 1,26,635.70 | 23,225.98 |
| 2004 | 1,96,682.03 | 34,427.77 | 1,58,103.58 | 28,307.81 |
| 2005 | 2,43,470.10 | 41,192.01 | 1,97,529.41 | 34,662.58 |
| 2006 | 2,87,774.35 | 53,673.01 | 2,42,642.16 | 43,097.60 |
| 2007 | 3,21,442.87 | 62,936.89 | 2,84,229.11 | 52,600.64 |
| 2008 | 3,37,772.63 | 69,732.84 | 3,15,663.28 | 62,114.25 |
| 2009 | 2,96,373.88 | 69,496.68 | 3,18,529.79 | 67,388.80 |
| 2010 | 3,64,952.63 | 91,911.08 | 3,33,033.05 | 77,046.87 |
| 2011 | 3,99,371.23 | 1,04,121.52 | 3,53,565.92 | 88,509.76 |
| 2012 | 4,25,619.08 | 1,10,516.62 | 3,96,647.65 | 1,02,183.07 |
| 2013 | 4,40,430.02 | 1,21,746.19 | 4,21,806.78 | 1,12,128.11 |
| 2014 | 4,68,474.89 | 1,23,657.20 | 4,44,841.33 | 1,18,640.00 |
| 2015 | 4,83,201.66 | 1,15,873.37 | 4,64,035.52 | 1,20,425.59 |
| 2016 | 4,62,419.99 | 1,15,594.78 | 4,71,365.51 | 1,18,375.12 |
| 2017 | 5,05,220.23 | 1,29,797.59 | 4,83,613.96 | 1,20,421.91 |
| 2018 | 5,39,675.59 | 1,20,148.14 | 5,02,438.61 | 1,21,846.84 |
B) From the above plots, it is evident that exponential smoothing method of forecasting will be most suitable. The exponential smooth results with dampening factor 0.9 and forecast for 2019 are shown below.
| Year | Import (Mil$) | Export (Year) | Exponential Smoothing Import | Exponential Smoothing Export |
| 1985 | 3,861.70 | 3,855.70 | ||
| 1986 | 4,771.00 | 3,106.30 | 3,861.70 | 3,855.70 |
| 1987 | 6,293.60 | 3,497.30 | 4,680.07 | 3,181.24 |
| 1988 | 8,510.90 | 5,021.60 | 6,132.25 | 3,465.69 |
| 1989 | 11,989.70 | 5,755.40 | 8,273.03 | 4,866.01 |
| 1990 | 15,237.40 | 4,806.40 | 11,618.03 | 5,666.46 |
| 1991 | 18,969.20 | 6,278.20 | 14,875.46 | 4,892.41 |
| 1992 | 25,727.50 | 7,418.50 | 18,559.83 | 6,139.62 |
| 1993 | 31,539.90 | 8,762.90 | 25,010.73 | 7,290.61 |
| 1994 | 38,786.80 | 9,281.70 | 30,886.98 | 8,615.67 |
| 1995 | 45,543.20 | 11,753.70 | 37,996.82 | 9,215.10 |
| 1996 | 51,512.80 | 11,992.60 | 44,788.56 | 11,499.84 |
| 1997 | 62,557.70 | 12,862.20 | 50,840.38 | 11,943.32 |
| 1998 | 71,168.60 | 14,241.20 | 61,385.97 | 12,770.31 |
| 1999 | 81,788.20 | 13,111.10 | 70,190.34 | 14,094.11 |
| 2000 | 1,00,018.20 | 16,185.20 | 80,628.41 | 13,209.40 |
| 2001 | 1,02,278.40 | 19,182.30 | 98,079.22 | 15,887.62 |
| 2002 | 1,25,192.60 | 22,127.70 | 1,01,858.48 | 18,852.83 |
| 2003 | 1,52,436.10 | 28,367.94 | 1,22,859.19 | 21,800.21 |
| 2004 | 1,96,682.03 | 34,427.77 | 1,49,478.41 | 27,711.17 |
| 2005 | 2,43,470.10 | 41,192.01 | 1,91,961.67 | 33,756.11 |
| 2006 | 2,87,774.35 | 53,673.01 | 2,38,319.26 | 40,448.42 |
| 2007 | 3,21,442.87 | 62,936.89 | 2,82,828.84 | 52,350.55 |
| 2008 | 3,37,772.63 | 69,732.84 | 3,17,581.46 | 61,878.26 |
| 2009 | 2,96,373.88 | 69,496.68 | 3,35,753.51 | 68,947.38 |
| 2010 | 3,64,952.63 | 91,911.08 | 3,00,311.85 | 69,441.75 |
| 2011 | 3,99,371.23 | 1,04,121.52 | 3,58,488.55 | 89,664.15 |
| 2012 | 4,25,619.08 | 1,10,516.62 | 3,95,282.96 | 1,02,675.79 |
| 2013 | 4,40,430.02 | 1,21,746.19 | 4,22,585.47 | 1,09,732.53 |
| 2014 | 4,68,474.89 | 1,23,657.20 | 4,38,645.56 | 1,20,544.82 |
| 2015 | 4,83,201.66 | 1,15,873.37 | 4,65,491.96 | 1,23,345.97 |
| 2016 | 4,62,419.99 | 1,15,594.78 | 4,81,430.69 | 1,16,620.63 |
| 2017 | 5,05,220.23 | 1,29,797.59 | 4,64,321.06 | 1,15,697.37 |
| 2018 | 5,39,675.59 | 1,20,148.14 | 5,01,130.32 | 1,28,387.57 |
| 2019 | 5,35,821.06 | 1,20,972.08 |
Add Answer to:
A) Perform the plots of import/export versus yearly & apply
the moving average technique to smooth...
The following table shows the average U.S. movie theatre ticket prices for the years from 1985...
The following table shows the average U.S. movie theatre ticket prices for the years from 1985 to 2004. Average U.S. Movie Theatre Ticket Prices Year Price Year Price 1985 $3.55 1995 $4.35 1986 3.71 1996 4.42 1987 3.91 1997 4.59 1988 4.11 1998 4.69 1989 3.99 1999 5.06 1990 4.22 2000 5.39 1991 4.21 2001 5.65 1992 4.15 2002 5.80 1993 4.14 2003 6.03 1994 4.08 2004 6.21 Use the information in the table and the roster method to represent...
The information below describes the real GDP per capita for a country for the period from...
The information below describes the real GDP per capita for a
country for the period from 1985 through to 2001.
If a new business cycle began in 1985, how long was this
cycle?
In which year did the peak occur? The trough occurred in which
year?
How long was the expansion? How long was the recession?
Year 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 Real GDP per Capita 6,000 6,300...
The data set on the right contains the real per capita GDP for 2 countries from the Penn World Table (PWT) version 9.1 (Feenstra et al., 2015). The column names are the country codes, OMN and PSE. You may copy the dataset to Excel or R to do the computati
YearOMN197011266197176221972632319735051197473381975802219768360197793611978965919791092719801149919811280319821276619831242319841306419851403219861019219871005419888809198992381990105911991991819921026319931004519949747199510199199611054199711784199811560199913501200016173200116853200218508200320329200425768200526647200638458200740960200847136200938538201040305201144477201247334201344979201440855201532460201629939201728249
help please! :) Ox- (rounded to two decimal places) 8. [-/2.22 Points] DETAILS Below is the...
help please! :)
Ox- (rounded to two decimal places) 8. [-/2.22 Points] DETAILS Below is the number of disease cases for a county by year of diagnosis. Year # cases Year # cases Year #cases Year # cases 1983 11 1990 225 1997 173 200495 1984 28 1991 243 1998 137 2005 98 1985 61 1992 | 346 1999 137 2006 112 1986 73 1993 387 2000 123 2007 87 1987 136 1994 299 2001 119 1988 153 1995 249...
7. Study the table below and identify the following: a. years in which the economy expanded...
7. Study the table below and identify the following: a. years in which the economy expanded b. years in which the economy contracted c. peaks d. troughs Year 1998 Annual Percentage Change in Real GDP (2007 $) -3.1 2.6 5.7 5.2 2.8 4.6 Year 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 Annual Percentage Change in Real GDP (2007 $) 4.1 5.4 5.4 1.4 2.7 2.0 3.1 3.2 2.4 2.2 1.1 -2.9...
Use the Housing_Interest Rate database YEAR MONTH FIXED_RATE% STARTS in $100 # Houses SOLD 1990 1...
Use the Housing_Interest Rate database YEAR MONTH FIXED_RATE% STARTS in $100 # Houses SOLD 1990 1 9.81 1551 45 1990 2 9.97 1437 50 1990 3 10.03 1289 58 1990 4 10.14 1248 52 1990 5 10.22 1212 50 1990 6 10.21 1177 50 1990 7 10.2 1171 46 1990 8 9.99 1115 46 1990 9 9.99 1110 38 1990 10 10.06 1014 37 1990 11 10.11 1145 34 1990 12 9.87 969 29 1991 1 9.75 798 30 1991...
Because the Florida manatee population is threatened, the Florida Maatee Sanctuary Act of 1978 was enacted...
Because the Florida manatee population is threatened, the Florida Maatee Sanctuary Act of 1978 was enacted to protect the species. Scientists interested in the relationship between the number of manatee deaths and time collected the data shown in the table. Manatee Deaths 174 163 146 192 201 416 242 232 269 272 325 305 380 276 396 416 Manatee Deaths Year 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 Year 1991...
Estimate the 100-year flood discharge and gauge height for Spring Creek in Houserville using the data...
Estimate the 100-year flood discharge and gauge height for Spring Creek in Houserville using the data provided. First, calculate the Rank (1 being the flood with the greatest discharge) and Recurrence Time, using the formula RT-(n+1) m is the number of yearly peak flood data- 20 in this case, and m is the rank of the peak discharge), filling in the results for the table below. Rank Recurrence Time Discharge (cfs) 318 687 440 351 476 Year 1985 196 1987...
Using the Consumer Price Index (CPI) detailed in the table below, Year CPI CPI Year 2003...
Using the Consumer Price Index (CPI) detailed in the table below, Year CPI CPI Year 2003 1989 1990 1991 1992 1993 1994 1995 124.0 130.7 136.2 140.3 144.5 148.2 152.4 156.9 160.5 163.0 2004 2005 2006 2007 2008 2009 2010 184.0 188.9 195.3 201.6 207.3 215.3 214.5 218.1 224.9 229.6 233.0 236.7 237.0 240.0 1996 1997 1998 1999 2000 2011 2012 2013 2014 166.6 172.2 177.1 179.7 2001 2002 2015 2016 Instructions: Enter your responses rounded to one decimal place...
A. Use a 3-year moving average to forecast the quantity of fish for the years 1983 through 2006 for these data...
A. Use a 3-year moving average to forecast the quantity of fish for the years 1983 through 2006 for these data. Compute the error of each forecast and then determine the mean absolute deviation of error for the forecast. B. Use exponential smoothing and a = 0.2 to forecast the data through 2006. Let the forecast for 1981 equal the actual value for 1980. Compute the error of each forecast and then determine the mean absolute deviation of error for...
The information below describes the real GDP per capita for a
country for the period from 1985 through to 2001.
If a new business cycle began in 1985, how long was this
cycle?
In which year did the peak occur? The trough occurred in which
year?
How long was the expansion? How long was the recession?
Year 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 Real GDP per Capita 6,000 6,300...
help please! :)
Ox- (rounded to two decimal places) 8. [-/2.22 Points] DETAILS Below is the number of disease cases for a county by year of diagnosis. Year # cases Year # cases Year #cases Year # cases 1983 11 1990 225 1997 173 200495 1984 28 1991 243 1998 137 2005 98 1985 61 1992 | 346 1999 137 2006 112 1986 73 1993 387 2000 123 2007 87 1987 136 1994 299 2001 119 1988 153 1995 249...
7. Study the table below and identify the following: a. years in which the economy expanded b. years in which the economy contracted c. peaks d. troughs Year 1998 Annual Percentage Change in Real GDP (2007 $) -3.1 2.6 5.7 5.2 2.8 4.6 Year 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 Annual Percentage Change in Real GDP (2007 $) 4.1 5.4 5.4 1.4 2.7 2.0 3.1 3.2 2.4 2.2 1.1 -2.9...
Because the Florida manatee population is threatened, the Florida Maatee Sanctuary Act of 1978 was enacted to protect the species. Scientists interested in the relationship between the number of manatee deaths and time collected the data shown in the table. Manatee Deaths 174 163 146 192 201 416 242 232 269 272 325 305 380 276 396 416 Manatee Deaths Year 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 Year 1991...
Estimate the 100-year flood discharge and gauge height for Spring Creek in Houserville using the data provided. First, calculate the Rank (1 being the flood with the greatest discharge) and Recurrence Time, using the formula RT-(n+1) m is the number of yearly peak flood data- 20 in this case, and m is the rank of the peak discharge), filling in the results for the table below. Rank Recurrence Time Discharge (cfs) 318 687 440 351 476 Year 1985 196 1987...
Using the Consumer Price Index (CPI) detailed in the table below, Year CPI CPI Year 2003 1989 1990 1991 1992 1993 1994 1995 124.0 130.7 136.2 140.3 144.5 148.2 152.4 156.9 160.5 163.0 2004 2005 2006 2007 2008 2009 2010 184.0 188.9 195.3 201.6 207.3 215.3 214.5 218.1 224.9 229.6 233.0 236.7 237.0 240.0 1996 1997 1998 1999 2000 2011 2012 2013 2014 166.6 172.2 177.1 179.7 2001 2002 2015 2016 Instructions: Enter your responses rounded to one decimal place...
A. Use a 3-year moving average to forecast the quantity of fish for the years 1983 through 2006 for these data. Compute the error of each forecast and then determine the mean absolute deviation of error for the forecast. B. Use exponential smoothing and a = 0.2 to forecast the data through 2006. Let the forecast for 1981 equal the actual value for 1980. Compute the error of each forecast and then determine the mean absolute deviation of error for...
Most questions answered within 3 hours.
-
Discuss the similarities and differences between static and
flexible Budgeting and Capital budgeting. · Why is...
asked 1 minute ago -
With the demand for more nutritional food options growing,
Nutriment Biotech is positioned to become a...
asked 15 minutes ago -
A sample of hydrogen gas collected at a
pressure of 1.41 atm and a temperature of...
asked 10 minutes ago -
Clark Heter is an industrial engineer at Lyons Products. He
would like to determine whether there...
asked 8 minutes ago -
he plant started to purify its wastewater before discharging it
into the lake. How long will...
asked 9 minutes ago -
A
firm purchased telephone equipment for cash. By mistake, the person
who recorded the transaction debited...
asked 11 minutes ago -
A 1.50 kg sample of water at 15.0°C is in a calorimeter. You
drop a piece...
asked 11 minutes ago -
Thiazyl fluoride, F3NS is a colourless gas. Using concepts of
electronegativity, formal charge etc. determine the...
asked 11 minutes ago -
In August 1992, after three years of development,
Colgate-Palmolive (CP) is about to add a new,...
asked 17 minutes ago -
1.Calculate the volume in liters of a 3.10 M KCl solution to
obtain 0.15 mol of...
asked 33 minutes ago -
The payback method is often criticized because it ignores the
time value of money and cashflows...
asked 36 minutes ago -
The overall population for Region A is 122122 million people.
The labor force contains 5151 million...
asked 56 minutes ago