Question
In: Finance
Please Convert yearly data to quarterly data on excel Income Level Canada United States Year Annual...
Please Convert yearly data to quarterly data on excel
Income Level
Canada United States
Year Annual Annual
2000 22750 59938
2001 23110 58609
2002 23580 57947
2003 25480 57875
2004 29530 57674
2005 34300 58291
2006 37890 58746
2007 41530 59534
2008 44930 57412
2009 43220 57010
2010 44480 55520
2011 47180 54673
2012 51080 54569
2013 52800 56479
2014 52190 55613
2015 47580 58476
2016 43940 60309
2017 43000
2018 44860
Solutions
Expert Solution
Below is the quarterly data of income level for usa and canada which is copied from excel:
| Quarter | Canada Income | USA Income |
| Q1 2000 | 5687.5 | 14984.5 |
| Q2 2000 | 5687.5 | 14984.5 |
| Q3 2000 | 5687.5 | 14984.5 |
| Q4 2000 | 5687.5 | 14984.5 |
| Q1 2001 | 5777.5 | 14652.25 |
| Q2 2001 | 5777.5 | 14652.25 |
| Q3 2001 | 5777.5 | 14652.25 |
| Q4 2001 | 5777.5 | 14652.25 |
| Q1 2002 | 5895 | 14486.75 |
| Q2 2002 | 5895 | 14486.75 |
| Q3 2002 | 5895 | 14486.75 |
| Q4 2002 | 5895 | 14486.75 |
| Q1 2003 | 6370 | 14468.75 |
| Q2 2003 | 6370 | 14468.75 |
| Q3 2003 | 6370 | 14468.75 |
| Q4 2003 | 6370 | 14468.75 |
| Q1 2004 | 7382.5 | 14418.5 |
| Q2 2004 | 7382.5 | 14418.5 |
| Q3 2004 | 7382.5 | 14418.5 |
| Q4 2004 | 7382.5 | 14418.5 |
| Q1 2005 | 8575 | 14572.75 |
| Q2 2005 | 8575 | 14572.75 |
| Q3 2005 | 8575 | 14572.75 |
| Q4 2005 | 8575 | 14572.75 |
| Q1 2006 | 9472.5 | 14686.5 |
| Q2 2006 | 9472.5 | 14686.5 |
| Q3 2006 | 9472.5 | 14686.5 |
| Q4 2006 | 9472.5 | 14686.5 |
| Q1 2007 | 10382.5 | 14883.5 |
| Q2 2007 | 10382.5 | 14883.5 |
| Q3 2007 | 10382.5 | 14883.5 |
| Q4 2007 | 10382.5 | 14883.5 |
| Q1 2008 | 11232.5 | 14353 |
| Q2 2008 | 11232.5 | 14353 |
| Q3 2008 | 11232.5 | 14353 |
| Q4 2008 | 11232.5 | 14353 |
| Q1 2009 | 10805 | 14252.5 |
| Q2 2009 | 10805 | 14252.5 |
| Q3 2009 | 10805 | 14252.5 |
| Q4 2009 | 10805 | 14252.5 |
| Q1 2010 | 11120 | 13880 |
| Q2 2010 | 11120 | 13880 |
| Q3 2010 | 11120 | 13880 |
| Q4 2010 | 11120 | 13880 |
| Q1 2011 | 11795 | 13668.25 |
| Q2 2011 | 11795 | 13668.25 |
| Q3 2011 | 11795 | 13668.25 |
| Q4 2011 | 11795 | 13668.25 |
| Q1 2012 | 12770 | 13642.25 |
| Q2 2012 | 12770 | 13642.25 |
| Q3 2012 | 12770 | 13642.25 |
| Q4 2012 | 12770 | 13642.25 |
| Q1 2013 | 13200 | 14119.75 |
| Q2 2013 | 13200 | 14119.75 |
| Q3 2013 | 13200 | 14119.75 |
| Q4 2013 | 13200 | 14119.75 |
| Q1 2014 | 13047.5 | 13903.25 |
| Q2 2014 | 13047.5 | 13903.25 |
| Q3 2014 | 13047.5 | 13903.25 |
| Q4 2014 | 13047.5 | 13903.25 |
| Q1 2015 | 11895 | 14619 |
| Q2 2015 | 11895 | 14619 |
| Q3 2015 | 11895 | 14619 |
| Q4 2015 | 11895 | 14619 |
| Q1 2016 | 10985 | 15077.25 |
| Q2 2016 | 10985 | 15077.25 |
| Q3 2016 | 10985 | 15077.25 |
| Q4 2016 | 10985 | |
| Q1 2017 | 10750 | |
| Q2 2017 | 10750 | |
| Q3 2017 | 10750 | |
| Q4 2017 | 10750 | |
| Q1 2018 | 11215 | |
| Q2 2018 | 11215 | |
| Q3 2018 | 11215 | |
| Q4 2018 | 11215 |
jeff jeffy answered 5 months agoRelated Solutions
Consider the yearly data of lumber production (in billions of board feet) in the United States...
Consider the yearly data of lumber production (in
billions of board feet) in the United States given as
follows:
year
production
1921
29
1922
35.2
1923
41
1924
39.5
1925
41
1926
39.8
1927
37.3
1928
36.8
1929
38.7
1930
29.4
1931
20
1932
13.5
1933
17.2
1934
18.8
1935
22.9
1936
27.6
1937
29
1938
24.8
1939
28.8
1940
31.2
1941
36.5
1942
36.3
1943
34.3
1944
32.9
1945
28.1
1946
34.1
1947
35.4
1948
37
1949
32.2
1950...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s...
Use the data and Excel to answer this question. It contains the
United States Census Bureau’s estimates for World Population from
1950 to 2014. You will find a column of dates and a column of data
on the World Population for these years. Generate the time variable
t. Then run a regression with the Population data as a dependent
variable and time as the dependent variable. Have Excel report the
residuals.
(a) Based on the ANOVA table and t-statistics, does...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s...
Use the data and Excel to answer this question. It contains the
United States Census Bureau’s estimates for World Population from
1950 to 2014. You will find a column of dates and a column of data
on the World Population for these years. Generate the time variable
t. Then run a regression with the Population data as a dependent
variable and time as the dependent variable. Have Excel report the
residuals.
(a) Based on the ANOVA table and t-statistics, does...
1. Suppose that the price level in the United States is 135 and the price level in...
1. Suppose that the
price level in the United States is 135 and the price level in
Germany is 234. What would absolute purchasing power parity theory
predict the dollar/euro exchange rate to be?
2.
If the United States rate of inflation is 2% and the German rate of
inflation is 5%, what would relative purchasing power parity
predict about the value of the euro relative to the dollar, all
other things equal?
A recent market study produced the following data on annual income level by market area: Annual...
A recent market study produced the following data on annual
income level by market area:
Annual Income Level
Area A
Area B
TOTAL
Up to 50K
1250
2350
3600
50K-80K
1460
1540
3000
Over 80K
265
385
650
TOTAL
2975
4275
7250
1. State the null and alternative hypotheses
for a Chi Square test to determine whether annual income level is
dependent of market area. (2 Points)
2. State the rejection rule using the critical
value approach. Let alpha = 0.05. (2...
Plan B is the common name in the United States and Canada for the emergency contraception...
Plan B is the common name in the United States and Canada for
the emergency contraception drug levonorgestrel. The high dose of
progestogen it delivers has been shown in the lab to inhibit
ovulation, thus rendering fertilization impossible. Some groups,
however, are concerned that if the drug interfered with the
fertilized egg, it could be considered abortive rather than
strictly contraceptive. Researchers enrolled a cohort of fertile
women attending a family planning clinic for emergency
contraception after unprotected intercourse during...
The United States claims that Canada subsidizes the production of softwood lumber and that imports of...
The United States claims that Canada subsidizes the production
of softwood lumber and that imports of lumber damage the interests
of US producers. The United States has imposed a high
tariff on Canadian imports to counter the
subsidy. Canada is thinking of retaliating by refusing
to export water to California. The following table shows
the payoff matrix for the simultaneous game that Canada and the US
are playing
Canada
Export
Don’t Export
United
No Tariff
50, 5
100, 10
States
Tariff
75, 75...
Suppose there are two countries in the world: Canada and the United States. Power plants in...
Suppose there are two countries in the world: Canada and the
United States. Power plants in the United States mid-west burning
high-sulphur coal contributes to the acidification of lakes in
Canada. Explain by using a diagram, if the two countries do nothing
to reduce pollution, then there is a loss in economic
efficiency.
Describe the challenges that Canada and the United States had to overcome to establish themselves as...
Describe the challenges that Canada and the United States had to
overcome to establish themselves as transcontinental powers. (Ch
25)
comment on the HR implications of the United States, Mexico, and Canada Trade Agreement.
comment on the HR implications of the United States, Mexico, and
Canada Trade Agreement.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- If you wanted to store a birthday within code, what class would you use in Java?...
- Explain what is meant by the Theme Park internal and external business environment and use the...
- Description Write a program that prints out your name, the course ID of this class, what...
- A project has an initial cost of $65,475, expected net cash inflows of $12,000 per year...
- Make a program that lets the user enter a positive or negative integer as many times...
- using java, parse a text file to be able to list the word(s) with the highest...
- Consider the following linear programming problem: Maximize 10X + 8Y Subject to: 40X + 24Y <=...
ADVERTISEMENT