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 1 week 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.
Please show your work 9.3.1 The income of males in each state of the United States,...
Please show your work
9.3.1
The income of males in each state of the United States,
including the District of Columbia and Puerto Rico, are given in
table #9.3.3, and the income of females is given in table #9.3.4
("Median income of," 2013). Is there enough evidence to show that
the mean income of males is more than of females? Test at the 1%
level.
Table #9.3.3: Data of Income
for Males
$42,951
$52,379
$42,544
$37,488
$49,281
$50,987
$60,705
$50,411...
Costco Wholesale Corporation owns and operates membership warehouses in the United States, Canada, United Kingdom, Mexico,...
Costco Wholesale Corporation owns and operates membership
warehouses in the United States, Canada, United Kingdom, Mexico,
Japan, Australia, and Spain. Costco also engages in retail
operations through majority owned subsidiaries in Korea and Taiwan.
The outside equity interests (not owned by Costco) in the Korean
and Taiwanese subsidiaries are presented collectively as
noncontrolling interests in Costco’s consolidated financial
statements.
Access Costco’s 2015 10-K annual report and answer the
following:
1. How does Costco present the noncontrolling interest in the
following...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Why are Not for Profits susceptible to sophisticated scams?
- How does the idea of a ‘social license to operate’ impact an airport? ?
- Write a business report (addressed to your supervisor) focused on how your company (Samsung) should use...
- A 7800 kg rocket blasts off vertically from the launch pad with a constant upward acceleration...
- For the short essay assignment you will compare Pablo Neruda’s “Ode to a Large Tuna in...
- Case Study As the marketplace for goods and services becomes increasingly global, businesses must understand and...
- Business risk is comprised of (a) price risk, (b) credit risk and (c) pure risk Defined...
ADVERTISEMENT