Question

In: Statistics and Probability

The data below lists the population of the United States each year from 2000 until 2010....

The data below lists the population of the United States each year from 2000 until 2010. (Hint: see Chapter 7 Project Part 1) a. (4 points) Use EXCEL to make a scatter plot and find a linear model of your data. Let the horizontal axis represent the years after 2000 (the year 2000 would be 0) and let the vertical axis represent the US population in millions. Provide a title for your graph, label both the vertical and horizontal axes, and make sure the linear model is included on your graph. Copy the scatter plot with the linear model and paste it into your document. b. (3 points) Identify the slope and y-intercept of your linear model and explain what both of these values mean in the context of the data given labeling with correct units. Please use complete sentences. (hint: see last page of part 1 of the project). Year US Population in Millions 2000 282.16 2001 284.97 2002 287.62 2003 290.11 2004 292.81 2005 295.52 2006 298.38 2007 301.23 2008 304.09 2009 306.77 2010 309.3

Solutions

Expert Solution

Year US Population(In Millions)
2000 282.16
2001 284.97
2002 287.62
2003 290.11
2004 292.81
2005 295.52
2006 298.38
2007 301.23
2008 304.09
2009 306.77
2010 309.3

Estimation Method in Excel (Manual as well as by using formula)

Linear Model
y=aX+b
a b
2.728364 -5174.645455
Formula Used
= Linest([y value range],[x value range])

(Make sure to select two cells to use this formula and press ctrl+shift+ Enter to execute the formula)

Manual Method

The independent variable is YearsYears, and the dependent variable is US PopulationUSPopulation. In order to compute the regression coefficients, the following table needs to be used:

Years US Population Years*US Population Years2 US Population2
2000 282.16 564320 4000000 79614.2656
2001 284.97 570224.97 4004001 81207.9009
2002 287.62 575815.24 4008004 82725.2644
2003 290.11 581090.33 4012009 84163.8121
2004 292.81 586791.24 4016016 85737.6961
2005 295.52 592517.6 4020025 87332.0704
2006 298.38 598550.28 4024036 89030.6244
2007 301.23 604568.61 4028049 90739.5129
2008 304.09 610612.72 4032064 92470.7281
2009 306.77 616300.93 4036081 94107.8329
2010 309.3 621693 4040100 95666.49
Sum = 22055 3252.96 6522484.92 44220385 962796.1978

Based on the above table, the following is calculated:(in excel)

Therefore, based on the above calculations, the regression coefficients (the slope m, and the y-intercept n) are obtained as follows:

US Population(in Millions) = −5174.6455 + 2.7284*(Years)

Interpretation

For Slope

When there is increase in one year(X value)  then there is 2.7284 times increase in the US population(in millions).

For intercept

The intercept (often labeled the constant) is the expected mean value of Y when all X=0.

Here intercept values is negative which do not have physical  Interpretation in this context but it says that when year is 0 the population values is negative 5174.6455 (in millions).


Related Solutions

The data below is a random sample of 3 observations drawn from the United States population....
The data below is a random sample of 3 observations drawn from the United States population. Use the data to answer the following questions i. Find 95% confidence intervals of the population mean of experience and wage. ii. Estimate ρe,w, the correlation between the variables experience and wage. iii. Find βˆ 1 and βˆ 0, the estimates of the parameters in the following regression equation wage = β0 + β1education + ϵ iv. Predict wages for a person with 15...
The number of cell phone subscribers in the United States between the years 2000 and 2010...
The number of cell phone subscribers in the United States between the years 2000 and 2010 is approximated by the function N(t) = 385.474 1 + 2.521e−0.214t (0 ≤ t ≤ 10) where N(t) is measured in millions and t is measured in years, with t = 0 corresponding to the year 2000.† How many cell phone subscribers were there in the United States in 2000? (Round your answer to one decimal place.) million subscribers. If the trend continued, how...
Between 2000 - 2010: What are the main goods and services the United States traded internationally?...
Between 2000 - 2010: What are the main goods and services the United States traded internationally? What trade barriers were in place during that decade? What are two pros and two cons of the trade barriers used?
Each year lists of the fastest-growing and fastest-dying industries in the United States are published by...
Each year lists of the fastest-growing and fastest-dying industries in the United States are published by various sources. Do some research to find three industries from each of these two lists for the current year and briefly explain why you think these industries are either growing or dying. For each industry, explain what is likely happening in capital markets and what the likely effect will be on the industry long-run average cost curve. Updated answer needed please.
In the United States, 7.8% of the population has diabetes. The CDC compiles data from an...
In the United States, 7.8% of the population has diabetes. The CDC compiles data from an SRS of 1200 people. a.What would be the mean number of people who have diabetes from such a sample? What would be the standard deviation? b.Use the Normal approximation to estimate the probability that at least 115 people (out of the 1200) would have diabetes?
The population from 1975 to 2015 are given below Year 1980 1995 2010 2020 Population In...
The population from 1975 to 2015 are given below Year 1980 1995 2010 2020 Population In 1000s 10 20 32 44 Use the data given in the table to draw the population – time relation in X-Y graph Use the Graphical extension Method to find the population in 2050 According to the plotted graph, use only one method (Geometric Increase method or Arithmetic Increase method) to find the population in 2050 (Explain why you select this method) Use the estimated...
This data table lists the most common types of cancer in the United States, and includes...
This data table lists the most common types of cancer in the United States, and includes information on the known or likely carcinogens, estimated cases per year, and estimated deaths per year in 2014. Cancer in the United States (Ranked by number of cases) Cancer Known or Likely Carcinogenes or Factors Estimated cases (2014) Estimated deaths (2014) Breast Estrogen; possibly dietary fat 235,000 40,400 Prostate Testosterone; possibly dietary fat 233,000 29,500 Lung Cigarette smoke 224,000 159,000 Colon and rectum High...
10.The distribution of vehicles sales in the United States in the year 2000 was the following:...
10.The distribution of vehicles sales in the United States in the year 2000 was the following: Type of car Small Midsize Large Luxury % 32.8 44.8 9.4 3.0 A simple random sample of 500 vehicles sales was taken this year and the Distribution is as follow: Type of car Small Midsize Large Luxury % 133 249 47 71 At the 5% significant level, do the data provides sufficient evidence to conclude that the distribution of vehicle sales this year has...
In reference to the year 2000 national census, the distribution of United States households according to...
In reference to the year 2000 national census, the distribution of United States households according to type of living arrangement is given in the table below. An SRS of 500 households gives the observed frequencies, by household type, for the city of Aurora, Illinois. Ethnic Origin    Census Percent    Observed frequency from sample Married, with children                        25%                                                  95 Married, with no children                    20%                                                110 Single parent                                    5%                                                    35 Single individual                               15%                                                 65 One person                                      20%                                                 120 Other (roommate,...
From the data for 46 states in the United States for 1992, Baltagi obtained the following...
From the data for 46 states in the United States for 1992, Baltagi obtained the following regression results:                                               LogC=  4.3- 1.34 log P +0.17 log Y                                                     Se=(0.91)  (0.32)       (0.20)                                    R2=0.27 Where C= cigarette consumption, Packs per year               P= real price per pack               Y= real disposable income per capita What is the elasticity of demand for cigarettes with respect to price? Is it statistically significant? What is the income elasticity of demand for cigarettes? Is it statistically significant? What is the overall significance of the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT