Exercise 1.1
Table 1.2 gives data on the Consumer Price Index (CPI) for seven industrialized countries with 1982-1984 = 100 as base of the index.
a. From the given data, compute the inflation rate of each country.
b. Plot the inflation rate for each country against time (i.e. use the horizantal axis for time and the vertical axis for the inflation rate)
c. What broad conclusions can you draw abou the inflation experience in the seven countries?
d. Which countries inflation seems to be most variable? Can you offer any explanation?
## Note here I have to skip several rows and add column names. Have a look at
## the raw data. Column names are c('Year', 'Canada', 'France', 'Germany',
## 'Italy','Japan', 'UK', 'US')
cpi <- read.table("https://raw.githubusercontent.com/cablegui/Econometrics/master/OriginalData/Table%201.2.txt",
skip = 6, col.names = c("Year", "Canada", "France", "Germany", "Italy",
"Japan", "UK", "US"))
colnames(cpi)
## [1] "Year" "Canada" "France" "Germany" "Italy" "Japan" "UK"
## [8] "US"
head(cpi)
## Year Canada France Germany Italy Japan UK US
## 1 1973 40.8 34.6 62.8 20.6 47.9 27.9 44.4
## 2 1974 45.2 39.3 67.1 24.6 59.0 32.3 49.3
## 3 1975 50.1 43.9 71.1 28.8 65.9 40.2 53.8
## 4 1976 53.9 48.1 74.2 33.6 72.2 46.8 56.9
## 5 1977 58.1 52.7 76.9 40.1 78.1 54.2 60.6
## 6 1978 63.3 57.5 79.0 45.1 81.4 58.7 65.2
What does the data contain?
The data consists of the following
CPI in seven industrialized countries, 1973-1997, (1982-1984=100)
What is the ‘Consumer Price Index - CPI’
The Consumer Price Index (CPI) is a measure that examines the weighted average of prices of a basket of consumer goods and services, such as transportation, food and medical care. It is calculated by taking price changes for each item in the predetermined basket of goods and averaging them. Changes in the CPI are used to assess price changes associated with the cost of living; the CPI is one of the most frequently used statistics for identifying periods of inflation or deflation.
Read more: Consumer Price Index (CPI) Definition | Investopedia http://www.investopedia.com/terms/c/consumerpriceindex.asp#ixzz4GOagNNqA
A useful package here would be the zoo package to perform time series calculations
a. From the given data, compute the inflation rate of each country.
library(zoo)
## Warning: package 'zoo' was built under R version 3.2.3
##
## Attaching package: 'zoo'
## The following objects are masked from 'package:base':
##
## as.Date, as.Date.numeric
cpi_ts <- zoo(data.frame(cpi[, 2:ncol(cpi)]), as.Date(paste0(cpi$Year, "-01-01"),
format = "%Y-%m-%d"))
index(cpi_ts)
## [1] "1973-01-01" "1974-01-01" "1975-01-01" "1976-01-01" "1977-01-01"
## [6] "1978-01-01" "1979-01-01" "1980-01-01" "1981-01-01" "1982-01-01"
## [11] "1983-01-01" "1984-01-01" "1985-01-01" "1986-01-01" "1987-01-01"
## [16] "1988-01-01" "1989-01-01" "1990-01-01" "1991-01-01" "1992-01-01"
## [21] "1993-01-01" "1994-01-01" "1995-01-01" "1996-01-01" "1997-01-01"
coredata(cpi_ts)
## Canada France Germany Italy Japan UK US
## [1,] 40.8 34.6 62.8 20.6 47.9 27.9 44.4
## [2,] 45.2 39.3 67.1 24.6 59.0 32.3 49.3
## [3,] 50.1 43.9 71.1 28.8 65.9 40.2 53.8
## [4,] 53.9 48.1 74.2 33.6 72.2 46.8 56.9
## [5,] 58.1 52.7 76.9 40.1 78.1 54.2 60.6
## [6,] 63.3 57.5 79.0 45.1 81.4 58.7 65.2
## [7,] 69.2 63.6 82.2 52.1 84.4 66.6 72.6
## [8,] 76.1 72.3 86.7 63.2 90.9 78.5 82.4
## [9,] 85.6 81.9 92.2 75.4 95.3 87.9 90.9
## [10,] 94.9 91.7 97.1 87.7 98.1 95.4 96.5
## [11,] 100.4 100.4 100.3 100.8 99.8 99.8 99.6
## [12,] 104.7 108.1 102.7 111.5 102.1 104.8 103.9
## [13,] 109.0 114.4 104.8 121.1 104.1 111.1 107.6
## [14,] 113.5 117.3 104.7 128.5 104.8 114.9 109.6
## [15,] 118.4 121.1 104.9 134.4 104.8 119.7 113.6
## [16,] 123.2 124.4 106.3 141.1 105.6 125.6 118.3
## [17,] 129.3 128.7 109.2 150.4 108.1 135.3 124.0
## [18,] 135.5 133.0 112.2 159.6 111.4 148.2 130.7
## [19,] 143.1 137.2 116.3 169.8 115.0 156.9 136.2
## [20,] 145.3 140.5 122.1 178.8 116.9 162.7 140.3
## [21,] 147.9 143.5 127.6 186.4 118.4 165.3 144.5
## [22,] 148.2 145.8 131.1 193.7 119.3 169.4 148.2
## [23,] 151.4 148.4 133.5 204.1 119.1 175.1 152.4
## [24,] 153.8 151.4 135.5 212.0 119.3 179.4 156.9
## [25,] 156.3 153.2 137.8 215.7 121.3 185.0 160.5
inflt_Rate <- (diff(cpi_ts)/lag(cpi_ts, k = -1)) * 100
b. Plot the inflation rate for each country against time (i.e. use the horizantal axis for time and the vertical axis for the inflation rate)
library(ggplot2)
## Warning: package 'ggplot2' was built under R version 3.2.3
library(tidyr)
## Warning: package 'tidyr' was built under R version 3.2.3
# reshape the data
t <- data.frame(Date = index(inflt_Rate), as.data.frame.ts(inflt_Rate))
t <- gather(t, "country", "inflation_rate", -Date)
ggplot(t, aes(x = Date, y = inflation_rate, colour = country)) + geom_line()
c. What broad conclusions can you draw about the inflation experience in the seven countries?
A: There is a downward trend with time.
d. Which countries inflation seems to be most variable? Can you offer any explanation?
# Apply a function on groups of data. tapply will apply the function sd
# (standard deviation) to the inflation rate grouped by country and report
# the country
tapply(t$inflation_rate, t$country, sd)
## Canada France Germany Italy Japan UK US
## 3.590100 4.468094 1.871855 6.295857 5.130746 6.063965 3.277640
A: Italy seems to be the most variable, because its standard deviation is the largest amongst all countries
Exercise 1.2
- Plot the inflation rate of Canada, France, Germany, Italy, Japan and the UK against the US inflation rate.
- Comment generally about the behaviour of the inflation rate in the six countries vis-a-vis the US inflation rate.
- If you find that the six countries inflation rate move in the same direction as the US inflation rate would that suggest that the US inflation causes inflation in the other countries? Why or why not?
a. Plot the inflation rate of Canada, France, Germany, Italy, Japan and the UK against the US inflation rate.
# convert to wide format
tSpread <- spread(t,country, inflation_rate)
ggplot(data=tSpread)+
geom_point(aes(x=tSpread[,c("Canada")], y=tSpread[,c("US")], shape="Canada"))+
geom_point(aes(x=tSpread[,c("France")], y=tSpread[,c("US")],shape="France")) +
geom_point(aes(x=tSpread[,c("Germany")], y=tSpread[,c("US")],shape="Germany")) +
geom_point(aes(x=tSpread[,c("Italy")], y=tSpread[,c("US")],shape="Italy")) +
geom_point(aes(x=tSpread[,c("Japan")], y=tSpread[,c("US")],shape="Japan")) +
geom_point(aes(x=tSpread[,c("UK")], y=tSpread[,c("US")],shape="UK")) +
labs(shape="Countries")+ #Use labs(aesthetic= "name you want for legend"); where aesthetic can be linetype or shape or colour
ylab("") + xlab("") + ggtitle("Inflation rate of US versus \n Canada, France, Germany, Italy, Japan and the UK")
b. Comment generally about the behaviour of the inflation rate in the six countries vis-a-vis the US inflation rate.
A: The behaviour shows that all the countries have different degrees of positive correlation with U.S.
c. If you find that the six countries inflation rate move in the same direction as the US inflation rate would that suggest that the US inflation causes inflation in the other countries? Why or why not?
A: It may or may not in my view as the data is too less to make a certain statement. We need more data to disprove the hypothesis that U.S. inflation rate can cause inflation in other countries.
Exercise 1.3
Table 1.3 gives the foreign exchange rates for seven industrialized countries for years 1977-1998. Except for the United Kingdom, the exchange rate is defined as the number of U.S. dollars for one U.K. pound.
- Plot these exchange rates against time and comment on the general behaviour of the exchange rates over the given time period.
- The dollar is said to appreciate if it can buy more units of a foreign currency. Contrarily, it is said to depreciate if it buys fewer units of a foreign currency. Over the time period 1977-1998, what has been the general behaviour of the U.S. dollar? Incidentally look up any text book on macroeconmics or international economics to find out what factors determine the appreciation or depreciation of a currency.
exchangeRates <- read.table("https://raw.githubusercontent.com/cablegui/Econometrics/master/OriginalData/Table%201.3.txt",
skip = 5, col.names = c("Year", "Canada", "France", "Germany", "Japan",
"Sweden", "Switzer", "UK"))
# check if all the data has been captured
head(exchangeRates)
## Year Canada France Germany Japan Sweden Switzer UK
## 1 1977 1.0633 4.9161 2.3236 268.62 4.4802 2.4065 1.7449
## 2 1978 1.1405 4.5091 2.0097 210.39 4.5207 1.7907 1.9184
## 3 1979 1.1713 4.2567 1.8343 219.02 4.2893 1.6644 2.1224
## 4 1980 1.1693 4.2251 1.8175 226.63 4.2310 1.6772 2.3246
## 5 1981 1.1990 5.4397 2.2632 220.63 5.0660 1.9675 2.0243
## 6 1982 1.2344 6.5794 2.4281 249.06 6.2839 2.0327 1.7480
tail(exchangeRates)
## Year Canada France Germany Japan Sweden Switzer UK
## 17 1993 1.2902 5.6669 1.6545 111.08 7.7956 1.4781 1.5016
## 18 1994 1.3664 5.5459 1.6216 102.18 7.7161 1.3667 1.5319
## 19 1995 1.3725 4.9864 1.4321 93.96 7.1406 1.1812 1.5785
## 20 1996 1.3638 5.1158 1.5049 108.78 6.7082 1.2361 1.5607
## 21 1997 1.3849 5.8393 1.7348 121.06 7.6446 1.4514 1.6376
## 22 1998 1.4836 5.8995 1.7597 130.99 7.9522 1.4506 1.6573
a. Plot these exchange rates against time and comment on the general behaviour of the exchange rates over the given time period.
exchangeRatesTS <- zoo(data.frame(exchangeRates[,2:ncol(exchangeRates)]),as.Date(paste0(exchangeRates$Year,"-01-01"), format="%Y-%m-%d"))
index(exchangeRatesTS)
## [1] "1977-01-01" "1978-01-01" "1979-01-01" "1980-01-01" "1981-01-01"
## [6] "1982-01-01" "1983-01-01" "1984-01-01" "1985-01-01" "1986-01-01"
## [11] "1987-01-01" "1988-01-01" "1989-01-01" "1990-01-01" "1991-01-01"
## [16] "1992-01-01" "1993-01-01" "1994-01-01" "1995-01-01" "1996-01-01"
## [21] "1997-01-01" "1998-01-01"
# reshape the data
t <- data.frame(Date = index(exchangeRatesTS),as.data.frame.ts(exchangeRatesTS))
t <- gather(t,"country", "exchangeRate", -Date)
ggplot(t, aes(x=Date, y=exchangeRate)) + geom_line() + facet_grid(country~., scales = "free")
A: There appears to be an increase in the exchange rate till 1985 after which generally all countries exchange rates have fallen except maybe Sweden and Canada.
b. The dollar is said to appreciate if it can buy more units of a foreign currency. Contrarily, it is said to depreciate if it buys fewer units of a foreign currency. Over the time period 1977-1998, what has been the general behaviour of the U.S. dollar? Incidentally look up any text book on macroeconmics or international economics to find out what factors determine the appreciation or depreciation of a currency.
A: To answer b. I had to look up the web as I dont have experience on this topic. One web source whose explanations made some sense was investopedia. I have no intentions to plagiarise the content on investopedia so the links to these web extracts are clearly defined in my blog.
Causes of a Nation’s Currency Appreciation or Depreciation
Factors that can cause a nation’s currency to appreciate or depreciate include:
Relative Product Prices - If a country’s goods are relatively cheap, foreigners will want to buy those goods. In order to buy those goods, they will need to buy the nation’s currency. Countries with the lowest price levels will tend to have the strongest currencies (those currencies will be appreciating).
Monetary Policy - Countries with expansionary (easy) monetary policies will be increasing the supply of their currencies, which will cause the currency to depreciate. Those countries with restrictive (hard) monetary policies will be decreasing the supply of their currency and the currency should appreciate. Note that exchange rates involve the currencies of two countries. If a nation’s central bank is pursuing an expansionary monetary policy while its trading partners are pursuing monetary policies that are even more expansionary, the currency of that nation is expected to appreciate relative to the currencies of its trading partners.
Inflation Rate Differences - Inflation (deflation) is associated with currency depreciation (appreciation). Suppose the price level increases by 40% in the U.S., while the price levels of its trading partners remain relatively stable. U.S. goods will seem very expensive to foreigners, while U.S. citizens will increase their purchase of relatively cheap foreign goods. The U.S. dollar will depreciate as a result. If the U.S. inflation rate is lower than that of its trading partners, the U.S. dollar is expected to appreciate. Note that exchange rate adjustments permit nations with relatively high inflation rates to maintain trade relations with countries that have low inflation rates.
Income Changes - Suppose that the income of a major trading partner with the U.S., such as Great Britain, greatly increases. Greater domestic income is associated with an increased consumption of imported goods. As British consumers purchase more U.S. goods, the quantity of U.S. dollars demanded will exceed the quantity supplied and the U.S. dollar will appreciate.
Read more: Currency Appreciation and Depreciation - CFA Level 1 | Investopedia http://www.investopedia.com/exam-guide/cfa-level-1/global-economic-analysis/foreign-exchange-parity-influences.asp#ixzz4GXbi9aaS
Some economic terms. From Investopedia
Trade deficits - This number “is a result of the economy” and not “is a cause”. This occurs when there is an increase in the demand for imported goods by country A but there is no or little demand from foreign countries for the exported goods from country A. This often indicates that the economy is growing faster than the foreign countries.
Budget deficits - This number tells you more about government expenditure versus income rather than individual or company expenditure versus income. Government expenses come thru financing activities like war or financing public medical insurance schemes. The investment in war for example by the U.S did not seem to benefit US in any way and rather in my opinion caused a lot of problems for other countries as well. The investment in the medical insurance scheme I rather see as a big benefit to the U.S. people. A country or business experiencing budget deficits due to building infrastructure or making profitable investments that will generate higher revenue or taxes in the future are often considered healthier like India than entities experiencing deficits due to unsustainable expenses. If there is a deficit the government needs to borrow to pay for the expenses as there is not enough income to pay for it.
Typical factors that contribute to a government budget deficit are: slower economic growth than trading partners, high governmental spending, high unemployment rates, or a combination of these factors.
Monetary policy - Monetary policy consists of the actions of a central bank, currency board or other regulatory committee that determine the size and rate of growth of the money supply, which in turn affects interest rates. Monetary policy is maintained through actions such as modifying the interest rate, buying or selling government bonds, and changing the amount of money banks are required to keep in the vault (bank reserves). Broadly, there are two types of monetary policy, expansionary and contractionary.
Expansionary puts money into the economy whereas contractionary sucks it out. Putting more money into an economy will allow private companies to borrow at lower rates and invest in making products which in turn makes the economy buy these products thereby allowing competition by companies within the economy to create better products and higher prices thereby increasing inflation in the economy. This has the added effect that when companies invest more into the business then employment increases.
Expansionary monetary policy increases the money supply in order to lower unemployment, boost private-sector borrowing and consumer spending, and stimulate economic growth. Often referred to as “easy monetary policy,” this description applies to many central banks since the 2008 financial crisis, as interest rates have been low and in many cases near zero.
Contractionary monetary policy slows the rate of growth in the money supply or outright decreases the money supply in order to control inflation; while sometimes necessary, contractionary monetary policy can slow economic growth, increase unemployment and depress borrowing and spending by consumers and businesses. An example would be the Federal Reserve’s intervention in the early 1980s: in order to curb inflation of nearly 15%, the Fed raised its benchmark interest rate to 20%. This hike resulted in a recession, but did keep spiraling inflation in check.
Central banks use a number of tools to shape monetary policy. Open market operations directly affect the money supply through buying short-term government bonds (to expand money supply) or selling them (to contract it). Benchmark interest rates, such as the LIBOR and the Fed funds rate, affect the demand for money by raising or lowering the cost to borrow—in essence, money’s price. When borrowing is cheap or when the cost to borrow (i.e. LIBOR or Fed funds rate is low) thereby incresing money supply, firms will take on more debt to invest in hiring and expansion; consumers will make larger, long-term purchases with cheap credit; and savers will have more incentive to invest their money in stocks or other assets, rather than earn very little—and perhaps lose money in real terms—through savings accounts. This is why the stock market goes up. Policy makers also manage risk in the banking system by mandating the reserves that banks must keep on hand. Higher reserve requirements put a damper on lending and rein in inflation.
Quantitative easing - An unconventional method of policy where the goverenment increases money supply by purchasing varying financial assets from commercial banks. In the US, the Fed loaded its balance sheet with trillions of dollars in Treasury notes and mortgage-backed securities between 2008 and 2013. The Bank of England, the European Central Bank and the Bank of Japan have pursued similar policies. The effect of quantitative easing is to raise the price of securities, therefore lowering their yields, as well as to increase total money supply. Credit easing is a related unconventional monetary policy tool, involving the purchase of private-sector assets to boost liquidity. Finally, signaling is the use of public communication to ease markets’ worries about policy changes: for example, a promise not to raise interest rates for a given number of quarters.
Central banks are often, at least in theory, independent from other policy makers. This is the case with the Federal Reserve and Congress, reflecting the separation of monetary policy from fiscal policy. The latter refers to taxes and government borrowing and spending.
The Federal Reserve has what is commonly referred to as a “dual mandate”: to achieve maximum employment (in practice, around 5% unemployment) and stable prices (2-3% inflation). In addition, it aims to keep long-term interest rates relatively low, and since 2009 has served as a bank regulator. Its core role is to be the lender of last resort, providing banks with liquidity in order to prevent the bank failures and panics that plagued the US economy prior to the Fed’s establishment in 1913. In this role, it lends to eligible banks at the so-called discount rate, which in turn influences the Federal funds rate (the rate at which banks lend to each other) and interest rates on everything from savings accounts to student loans, mortgages and corporate bonds.
Read more: Monetary Policy Definition | Investopedia http://www.investopedia.com/terms/m/monetarypolicy.asp#ixzz4GXi10s1e
What is GDP? From Investopedia
The gross domestic product (GDP) is one of the primary indicators used to gauge the health of a country’s economy. It represents the total dollar value of all goods and services produced over a specific time period; you can think of it as the size of the economy. Usually, GDP is expressed as a comparison to the previous quarter or year. For example, if the year-to-year GDP is up 3%, this is thought to mean that the economy has grown by 3% over the last year.
Measuring GDP is complicated (which is why we leave it to the economists), but at its most basic, the calculation can be done in one of two ways: either by adding up what everyone earned in a year (income approach), or by adding up what everyone spent (expenditure method). Logically, both measures should arrive at roughly the same total.
The income approach, which is sometimes referred to as GDP(I), is calculated by adding up total compensation to employees, gross profits for incorporated and non incorporated firms, and taxes less any subsidies. The expenditure method is the more common approach and is calculated by adding total consumption, investment, government spending and net exports.
As one can imagine, economic production and growth, what GDP represents, has a large impact on nearly everyone within that economy. For example, when the economy is healthy, you will typically see low unemployment and wage increases as businesses demand labor to meet the growing economy. A significant change in GDP, whether up or down, usually has a significant effect on the stock market. It’s not hard to understand why: a bad economy usually means lower profits for companies, which in turn means lower stock prices. Investors really worry about negative GDP growth, which is one of the factors economists use to determine whether an economy is in a recession.
Read more: What is GDP and why is it so important? | Investopedia http://www.investopedia.com/ask/answers/199.asp#ixzz4GY6ToqcU
Exercise 1.4
The data behind the M1 money supply in Figure 1.5 are given in Table 1.4. Can you give reasons why the money supply has been increasing over the time period shown in the table?
Seasonally adjusted M1 Money supply,monthly,1959:01-1999:09
moneySupplyM1 <- read.table("https://raw.githubusercontent.com/cablegui/Econometrics/master/OriginalData/Table%201.4.txt",skip = 3, col.names = c("M1_SUPPLY"))
head(moneySupplyM1)
## M1_SUPPLY
## 1 138.89
## 2 139.39
## 3 139.74
## 4 139.69
## 5 140.68
## 6 141.17
tail(moneySupplyM1)
## M1_SUPPLY
## 484 1108.40
## 485 1104.75
## 486 1101.11
## 487 1099.53
## 488 1102.40
## 489 1093.46
# Add dates column separated by month
moneySupplyM1$Date <- seq(as.Date("1959-01-01"), as.Date("1999-09-01"), by = "1 month")
head(moneySupplyM1)
## M1_SUPPLY Date
## 1 138.89 1959-01-01
## 2 139.39 1959-02-01
## 3 139.74 1959-03-01
## 4 139.69 1959-04-01
## 5 140.68 1959-05-01
## 6 141.17 1959-06-01
tail(moneySupplyM1)
## M1_SUPPLY Date
## 484 1108.40 1999-04-01
## 485 1104.75 1999-05-01
## 486 1101.11 1999-06-01
## 487 1099.53 1999-07-01
## 488 1102.40 1999-08-01
## 489 1093.46 1999-09-01
require(dplyr)
## Loading required package: dplyr
## Warning: package 'dplyr' was built under R version 3.3.1
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
require(ggplot2)
moneySupplyM1 %>% ggplot(aes(x=Date, y=M1_SUPPLY)) + geom_line() + ggtitle("Seasonally adjusted M1 Money supply,monthly,\n1959:01-1999:09")
What is the M1 money supply?
Its the amount of physical money in the form of notes or coins that are in circulation. Does not include money in savings accounts. Its the most liquid form of money that can be quickly converted to cash.
In the data for the M1 money supply there is a steady increase from 1959 to 1999 suggesting that
- the government is printing more money
- there must be an increase in population requiring money to be pumped into the economy
- This could point to inflation as when the prices of goods increases more money is required to purchase the goods.
Exercise 1.5
Suppose you were to develop an economic model of criminal activities, say, the hours spent in criminal activities (e.g. selling illegal drugs). What variables would you consider in developing a model? See if your model matches the one developed by Nobel Laurete economis Gary Becker.
A: I would consider
- Wages - Household income - Number of children born out of wedlock - No of children dropping out of school - No of children enrolling in college
Exercise 1.6
Controlled experiments in economics: On April 7, 2000, President Clinton signed into law a bill passed by both Houses of the U.S. Congress that lifted earnings limitations on Social Security recipients. Until then, recipients between the ages of 65 and 69 who earned more than $17,000 a year would lose 1 dollars worth of Social Security benefit for every 3 dollars of income earned in excess of $17,000. How would you devise a study to assess the impact of this change in the law? Note: There was no income limitation for the recipients over the age of 70 under the old law.
A: What I understand about social security is that it is a government program to benefit people during retirement, disability or medical care. The amount paid out is a function of the persons past wages subject to a max ceiling value. As per the law before April 7 2000, people between the age of 65 to 69 earning above this max ceiling would lose 1 dollar worth of social security benfit for each 3 dollars above $17,000 they earned in the past. According to the solutions manual it suggests to collect data on the number of senior citizens who take up work during this age period. If there is an increase then it suggests that the old law was the reason for the citizens to not work. It also suggests to find out what kind of work do citizens at that age actually do.
Exercise 1.7
The data presented in Table 1.5 was published in the March 1, 1984 issue of the Wall Street Journal. It relates to the advertising budget (in millions of dollars) of 21 firms for 1983 and millions of impressions retained per week by the viewers of products of these firms. The data are based on a survey of 4000 adults in which users of the product were asked to cite a commercial they had seen for the product category in the past week.
- Plot impressions on the vertical axis and advertising expenditure on the horizontal axis.
- What can you say about the nature of the relationship between the two variables?
- Looking at your graph, do you think it pays to advertise? Think about all those commercials shown on Super Bowl Sunday or during teh World Series.
advertImpress <- read.table("https://raw.githubusercontent.com/cablegui/Econometrics/master/OriginalData/Table%201.5.5.txt", skip=4, header= TRUE)
head(advertImpress)
## IMPRESSION ADEXP
## 1 32.1 50.1
## 2 99.6 74.1
## 3 11.7 19.3
## 4 21.9 22.9
## 5 60.8 82.4
## 6 78.6 40.1
tail(advertImpress)
## IMPRESSION ADEXP
## 16 38.0 26.9
## 17 10.0 5.7
## 18 12.3 7.6
## 19 23.4 9.2
## 20 71.1 32.4
## 21 4.4 6.1
Table 1.5 Impact of Advertising Expenditure
a. Plot impressions on the vertical axis and advertising expenditure on the horizontal axis.
b. What can you say about the nature of the relationship between the two variables?
c. Looking at your graph, do you think it pays to advertise? Think about all those commercials shown on Super Bowl Sunday or during teh World Series.
require(dplyr)
require(ggplot2)
advertImpress %>% ggplot(aes(x=ADEXP, y=IMPRESSION)) + geom_point(colour="blue")
A: There does seem to be some positive correlation between the advert expenditure and the amount of retention of these adverts but not always the case. Possibly the retention depends on the circumstances of the individual or even the impact of the advertisement.
Comments
Post a Comment