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 the regression appear significant?
(b) Calculate the Durbin-Watson Test statistic. Is there a serial correlation problem with the data? Explain.
(d) What affect might your answer in part (b) have on your conclusions in part (a)?
| Year | Population |
| 1950 | 2,557,628,654 |
| 1951 | 2,594,939,877 |
| 1952 | 2,636,772,306 |
| 1953 | 2,682,053,389 |
| 1954 | 2,730,228,104 |
| 1955 | 2,782,098,943 |
| 1956 | 2,835,299,673 |
| 1957 | 2,891,349,717 |
| 1958 | 2,948,137,248 |
| 1959 | 3,000,716,593 |
| 1960 | 3,043,001,508 |
| 1961 | 3,083,966,929 |
| 1962 | 3,140,093,217 |
| 1963 | 3,209,827,882 |
| 1964 | 3,281,201,306 |
| 1965 | 3,350,425,793 |
| 1966 | 3,420,677,923 |
| 1967 | 3,490,333,715 |
| 1968 | 3,562,313,822 |
| 1969 | 3,637,159,050 |
| 1970 | 3,712,697,742 |
| 1971 | 3,790,326,948 |
| 1972 | 3,866,568,653 |
| 1973 | 3,942,096,442 |
| 1974 | 4,016,608,813 |
| 1975 | 4,089,083,233 |
| 1976 | 4,160,185,010 |
| 1977 | 4,232,084,578 |
| 1978 | 4,304,105,753 |
| 1979 | 4,379,013,942 |
| 1980 | 4,451,362,735 |
| 1981 | 4,534,410,125 |
| 1982 | 4,614,566,561 |
| 1983 | 4,695,736,743 |
| 1984 | 4,774,569,391 |
| 1985 | 4,856,462,699 |
| 1986 | 4,940,571,232 |
| 1987 | 5,027,200,492 |
| 1988 | 5,114,557,167 |
| 1989 | 5,201,440,110 |
| 1990 | 5,288,955,934 |
| 1991 | 5,371,585,922 |
| 1992 | 5,456,136,278 |
| 1993 | 5,538,268,316 |
| 1994 | 5,618,682,132 |
| 1995 | 5,699,202,985 |
| 1996 | 5,779,440,593 |
| 1997 | 5,857,972,543 |
| 1998 | 5,935,213,248 |
| 1999 | 6,012,074,922 |
| 2000 | 6,088,571,383 |
| 2001 | 6,165,219,247 |
| 2002 | 6,242,016,348 |
| 2003 | 6,318,590,956 |
| 2004 | 6,395,699,509 |
| 2005 | 6,473,044,732 |
| 2006 | 6,551,263,534 |
| 2007 | 6,629,913,759 |
| 2008 | 6,709,049,780 |
| 2009 | 6,788,214,394 |
| 2010 | 6,858,584,755 |
| 2011 | 6,935,999,491 |
| 2012 | 7,013,871,313 |
| 2013 | 7,092,128,094 |
| 2014 | 7,169,968,185 |
Can you please give detailed steps to do on excel?
In: Statistics and Probability
The Bureau of the Census in the United States attempted to count every U.S. resident. Suppose that the counts in the table are obtained for four counties in one region. (Give all answers to four decimal places.)
| County | Race/Ethnicity | ||||
| Caucasian | Hispanic | Black | Asian | American Indian |
|
| Monterey | 163,000 | 140,000 | 25,000 | 39,000 | 5,000 |
| San Luis Obispo | 190,000 | 38,000 | 7,000 | 9,000 | 3,000 |
| Santa Barbara | 230,000 | 121,000 | 12,000 | 24,000 | 5,000 |
| Ventura | 430,000 | 231,000 | 19,000 | 50,000 | 8,000 |
C. If one Hispanic person is selected at random from this region, what is the estimated probability that the selected individual is from Ventura?
(e) If one person is selected at random from this region, what
is the estimated probability that the person is either Asian or
from San Luis Obispo County?
(f) If one person is selected at random from this region, what is
the estimated probability that the person is Asian or from San Luis
Obispo County but not both?
(g) If two people are selected at random from this region, what is
the estimated probability that both are Caucasians?
(h) If two people are selected at random from this region, what is
the estimated probability that neither is Caucasian?
(i) If two people are selected at random from this region, what is
the estimated probability that exactly one is a Caucasian?
(j) If two people are selected at random from this region, what is
the estimated probability that both are residents of the same
county?
(k) If two people are selected at random from this region, what is
the estimated probability that both are from different
racial/ethnic groups?
In: Statistics and Probability
In: Economics
Research in the gaming industry showed that 8% of all slot machines
in the United States stop working each year. Short’s Game Arcade
has 70 slot machines and only 5 failed last year. Use the five-step
hypothesis-testing procedure at the 0.05 significance level to test
whether this data contradicts the research report.
(a) State the null hypothesis and the alternate hypothesis. (Round
your answers to 2 decimal places.)
H0: π =
H1: π ≠
(b) State the decision rule for 0.05 significance level. (Negative
amounts should be indicated by a minus sign. Round your answers to
2 decimal places.)
H0 is rejected if z is not between _______ and _______
(c) Compute the value of the test statistic. (Negative amount
should be indicated by a minus sign. Round your answer to 2 decimal
places.)
(d) Determine the p-value. (Round your answer to 4 decimal
places.)
In: Statistics and Probability
Examine a famous leader here in the United States applying concepts and theories explored in a Leadership course. Follow this outline: Open with an opening paragraph describing the leader and summarizing the leadership theory that you will be addressing. (keep the background information very brief) Name three specific leadership behaviors and three specific leadership traits of this leader. Name the leadership skill and trait that you think best explains the success of this leader, and explain why. Apply this leader’s approach or style to one of the leadership theories include in this class. Explain why this leadership style or approach has been successful for this leader and make logical arguments supporting your case. Write a summarizing paragraph.
In: Operations Management
Background information: A worker in the United States and a worker in China can each produce 1,000 pairs of jeans per week. A worker in the United States can produce 50 cell phones in a week, and a worker in China can produce 100 cell phones in a week. Answer the following questions based on this information.
Part A: If each country attempted to produce both jeans and cell phones, how many jeans and cell phones could each country produce?
What would be the total number of jeans and cell phones produced by the two countries combined? (Show your work.)
Part B: Calculate the opportunity cost of producing jeans for each country. (Show your work.)
Part C: Calculate the opportunity cost of producing cell phones for each country. (Show your work.)
Part D: Determine how many jeans should be produced by each nation. (Show your work).
Part E: If each nation should specialize in producing jeans and cell phones, explain why; use economic terminology you have learned in this unit in your explanation.
Part F: Finally, how many total jeans and cell phones will be produced by the two nations combined after specialization?
In: Economics
. USA Today reported that about 47% of the general consumer population in the United States is loyal to the automobile manufacturer of their choice. Suppose that Chevrolet did a study of a random sample of 1006 Chevrolet owners and found that 490 stated that they would buy another Chevrolet. Test the claim by Chevrolet that the population proportion of consumers loyal to its product is different from 47%. Use = 0.05. (a) State the hypotheses for this test. (b) State the p-value for this test. (c) State your conclusion for the test in the context of the problem statement. (d) Give a 95% confidence interval for the proportion of customers loyal to Chevrolet. (e) Is your confidence interval consistent with your conclusion from the hypothesis test? Explain why or why not.
In: Statistics and Probability
In: Accounting
Some observers believe that interest groups in the United States are slowly eroding democracy—that is, that most groups are interested only in personal gain, not the national interest. Countries such as Japan and Germany have very few interest groups and are thus able to make decisions more quickly with a view toward the public interest. What are some arguments in favor of our pluralist (interest group–driven) type of government? On the other hand, what are some ways that interest groups impede democracy? Which system is more preferable: one with many groups or one with few?
In: Psychology
The mean cost of domestic airfares in the United States rose to an all-time high of $375 per ticket. Airfares were based on the total ticket value, which consisted of the price charged by the airlines plus any additional taxes and fees. Assume domestic airfares are normally distributed with a standard deviation of $100. Use Table 1 in Appendix B. a. What is the probability that a domestic airfare is $550 or more (to 4 decimals)? b. What is the probability that a domestic airfare is $265 or less (to 4 decimals)? c. What if the probability that a domestic airfare is between $310 and $480 (to 4 decimals)? d. What is the cost for the 3% highest domestic airfares? (rounded to nearest dollar)
In: Statistics and Probability