Homework Answers
A.
To draw a scatter plot on excel:
1. Take 'A' as Year and 'B' as debt.
2. Now, select cells A14:B14.
3. On the Insert tab, click the "Scatter Chart" command.
4. Now, Choose the type with "No lines".
5. Various "Chart tools" will open.There you can select Design, Layout and Format as per your requirement.
6. Your scatter plot is ready.
B To find the best fit line from the scatter plot in Part A - Go to the "Layout", click on "Trendline" and select "Linear trendline".
C In the "Trendline" Choose more " more trendline options". There Click on "Display equation on chart". This will be the slope of the chart.
Slope of the chart is
y = 960.58x + 3640.3
From there, average rate of change is computed.
Average rate of change from 2000 to 2004
= (Debt in year 2004 - Debt in year 2000)/4
= (7,379 - 5,807)/4
= 393
D.
Average rate of change from 2006 to 2008
= (Debt in year 2006 - Debt in year 2008)/3
= (10,025 - 8,507)/3
= 506
E.
Average rate of change from 2010 to 2012
= (Debt in year 2010 - Debt in year 2012)/3
= (16,066- 13,562)/3
= 834.66
F. To predict the national debt in 2020, we will select "Linear Forecast Trendline" instead of "Linear trendline". From there we can see that the coressponding value of Y-axis for the year 2020 is 20,000.
So, the national debt predicted for the year 2020 is $20,000 billions.
Add Answer to:
National Debt: The size of the total debt by the United States Federal government continues to...
7.9 3.3 2. Consider the following data from 2001 - 2017, column 1 is the year,...
7.9 3.3 2. Consider the following data from 2001 - 2017, column 1 is the year, the 2nd column is the unemployment rate, and the 3rd column is the inflation rate. Plot the data using a scatter plot and argue whether in your opinion, the Phillips Curve has validity. 2001 5.7 1.6 2002 6.0 2.4 2003 5.7 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 4.1 3.0 0.7
Question Completion Status: Year Unemployment rate 2001 4.7 2002 5.8 2003 6.0 2004 5.5 2005 5.1...
Question Completion Status: Year Unemployment rate 2001 4.7 2002 5.8 2003 6.0 2004 5.5 2005 5.1 2006 4.6 2007 4.6 2008 5.8 2009 9.3 2010 96 2011 89 2012 8.1 National Bureau of Labor Statistic Source: Use your cakulator to draw a time series plot for this data and describe the trend you A 8.87 see, B. The unemployment rate is steadily increasing from 2001 to 2012 Predict the unemployment rate for 2013 using a 5-year moving average с. В...
Please find in the figure (Source: The World Bank) the GDP of Italy in the last...
Please find in the figure (Source: The World Bank) the GDP of Italy in the last 17 years. The pale line represents the Nominal GDP of Italy measured at current prices (GDP in year X is computed using prices of year X), whereas the dark line shows GDP measured at 2010 prices (base year). 1. a. b. c. Provide a general comment on the picture, pointing out the most relevant economic aspects. [3p] What can we say about inflation in...
Reserve Problems Chapter 11 Section 2 Problem 1 The department of health studied the number of...
Reserve Problems Chapter 11 Section 2 Problem 1 The department of health studied the number of patients who need liver transplantation. The following data are the Liver Transplantation Waiting List (LTWL), where y is the size (in number of patients) and x is the corresponding year: 1351 17802741 384047616737744373667597821082068423 8889 * 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Round your intermediate answers to four decimal places (e.g. 98.7654). (a) Fit the simple linear regression...
Use it and Excel to answer this question. It contains the United States Census Bureau’s estimates...
Use it 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) (4 marks) Based on the ANOVA table and t-statistics,...
Men and women have lived in poverty since the beginning of time. Even today millions of...
Men and women have lived in poverty since the beginning of time. Even today millions of people live below the poverty line. Source:US Census Bureau."Table 7. Poverty in People, by Sex." 1. Use the table below to answer the questions. Year 2000 (t=0) 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Men Below Poverty Line (in millions) 136.274 137.558 139.558 140.931 142.433 143.803 145.486 146.655 147.562 149.237 149.737 Women Below Poverty Line (in millions) 142.670 143.917 145:759...
Stat 1102- Please answer each part of the question correctly! A.) find an equation for the least squares line, letting x equal the number of years since 2001. the equation is Y= ____ x +_____ B.) Base...
Stat 1102- Please answer each part of the question
correctly!
A.) find an equation for the
least squares line, letting x equal the number of years since
2001.
the equation is Y= ____ x +_____
B.) Based on the answer to part (a), at approximately what rate
is consumer credit growing per year?
the consumer credit is growing $_____ billion per year
C.) Use the result from part (a) to predict the amount of
consumer credit in the year 2016...
The department of health studied the number of patients who need liver transplantation. The following data...
The department of health studied the number of patients who need liver transplantation. The following data are the Liver Transplantation Waiting List (LTWL), where y is the size (in number of patients) and x is the corresponding year: y 1274 1701 2695 3760 4848 6805 7560 7474 | 7772 8477 8568 8574 9031 * 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Round your intermediate answers to four decimal places (e.g. 98.7654). (a) Fit the...
The department of health studied the number of patients who need liver transplantation. The following data...
The department of health studied the number of patients who need liver transplantation. The following data are the Liver Transplantation Waiting List (LTWL), where y is the size (in number of patients) and x is the corresponding year: y1375 1803 2772 386348416935 7635|7555 776684638412 8568 8921 x2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Round your intermediate answers to four decimal places (e.g. 98.7654) (a) Fit the simple linear regression model using the method of...
The department of health studied the number of patients who need liver transplantation. The following data...
The department of health studied the number of patients who need liver transplantation. The following data are the Liver Transplantation Waiting List (LTWL), where y is the size (in number of patients) and x is the corresponding year: y 1316 1848 2851 3819 47806835 7703 7601 782984938459 8680 9056 * 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Round your intermediate answers to four decimal places (e.g. 98.7654). (a) Fit the simple linear regression model...
7.9 3.3 2. Consider the following data from 2001 - 2017, column 1 is the year, the 2nd column is the unemployment rate, and the 3rd column is the inflation rate. Plot the data using a scatter plot and argue whether in your opinion, the Phillips Curve has validity. 2001 5.7 1.6 2002 6.0 2.4 2003 5.7 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 4.1 3.0 0.7
Question Completion Status: Year Unemployment rate 2001 4.7 2002 5.8 2003 6.0 2004 5.5 2005 5.1 2006 4.6 2007 4.6 2008 5.8 2009 9.3 2010 96 2011 89 2012 8.1 National Bureau of Labor Statistic Source: Use your cakulator to draw a time series plot for this data and describe the trend you A 8.87 see, B. The unemployment rate is steadily increasing from 2001 to 2012 Predict the unemployment rate for 2013 using a 5-year moving average с. В...
Please find in the figure (Source: The World Bank) the GDP of Italy in the last 17 years. The pale line represents the Nominal GDP of Italy measured at current prices (GDP in year X is computed using prices of year X), whereas the dark line shows GDP measured at 2010 prices (base year). 1. a. b. c. Provide a general comment on the picture, pointing out the most relevant economic aspects. [3p] What can we say about inflation in...
Reserve Problems Chapter 11 Section 2 Problem 1 The department of health studied the number of patients who need liver transplantation. The following data are the Liver Transplantation Waiting List (LTWL), where y is the size (in number of patients) and x is the corresponding year: 1351 17802741 384047616737744373667597821082068423 8889 * 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Round your intermediate answers to four decimal places (e.g. 98.7654). (a) Fit the simple linear regression...
Men and women have lived in poverty since the beginning of time. Even today millions of people live below the poverty line. Source:US Census Bureau."Table 7. Poverty in People, by Sex." 1. Use the table below to answer the questions. Year 2000 (t=0) 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Men Below Poverty Line (in millions) 136.274 137.558 139.558 140.931 142.433 143.803 145.486 146.655 147.562 149.237 149.737 Women Below Poverty Line (in millions) 142.670 143.917 145:759...
Stat 1102- Please answer each part of the question
correctly!
A.) find an equation for the
least squares line, letting x equal the number of years since
2001.
the equation is Y= ____ x +_____
B.) Based on the answer to part (a), at approximately what rate
is consumer credit growing per year?
the consumer credit is growing $_____ billion per year
C.) Use the result from part (a) to predict the amount of
consumer credit in the year 2016...
The department of health studied the number of patients who need liver transplantation. The following data are the Liver Transplantation Waiting List (LTWL), where y is the size (in number of patients) and x is the corresponding year: y 1274 1701 2695 3760 4848 6805 7560 7474 | 7772 8477 8568 8574 9031 * 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Round your intermediate answers to four decimal places (e.g. 98.7654). (a) Fit the...
The department of health studied the number of patients who need liver transplantation. The following data are the Liver Transplantation Waiting List (LTWL), where y is the size (in number of patients) and x is the corresponding year: y1375 1803 2772 386348416935 7635|7555 776684638412 8568 8921 x2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Round your intermediate answers to four decimal places (e.g. 98.7654) (a) Fit the simple linear regression model using the method of...
The department of health studied the number of patients who need liver transplantation. The following data are the Liver Transplantation Waiting List (LTWL), where y is the size (in number of patients) and x is the corresponding year: y 1316 1848 2851 3819 47806835 7703 7601 782984938459 8680 9056 * 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Round your intermediate answers to four decimal places (e.g. 98.7654). (a) Fit the simple linear regression model...
Most questions answered within 3 hours.
-
A small body of mass m performs small oscillations sliding (no
rolling) along the bottom of...
asked 2 minutes ago -
The electric field in the region between two oppositely charged,
parallel, conducting plates has a magnitude...
asked 1 minute ago -
A simple random sample was taken to test the claim that the
population mean is no...
asked 1 hour ago -
A set of length measurements are obtained with the values 165.6
± 0.3, 165.1± 0.4,166.4± 1.0,...
asked 1 hour ago -
1. Which of the following is true about unconscionable
contracts?
a. A term is substantially unconscionable...
asked 15 minutes ago -
A company is interested in estimating the costs of lunch
in their cafeteria. After surveying employees,...
asked 48 minutes ago -
A 0.2m diameter ball with an initial velocity of 8m/s rolls up a
hill without slipping....
asked 30 minutes ago -
I want to redraft the solution, using other words , use your own
words don't copy...
asked 19 minutes ago -
Hyundai Motors is considering threesites—A, B,C —at which to
locate a factory to build its new-model...
asked 21 minutes ago -
Learning Outcomes:
Upon the successful completion of this module, you should
understand the following concepts:
Strategic...
asked 22 minutes ago -
Identify four of the five major types of organizations within
the federal bureaucracy, and give examples...
asked 31 minutes ago -
The following data have been obtained
for the effect of solvent composition on the solubility of...
asked 31 minutes ago