A sociologist is studying the age of the population in Blue Valley. Ten years ago, the population was such that 20% were under 20 years old, 14% were in the 20- to 35-year-old bracket, 30% were between 36 and 50, 24% were between 51 and 65, and 12% were over 65. A study done this year used a random sample of 210 residents. This sample is given below. At the 0.01 level of significance, has the age distribution of the population of Blue Valley changed? Under 20 20 - 35 36 - 50 51 - 65 Over 65 29 26 65 66 24 Please answer using excel A)  Find the sample test statistic. (Round your answer to two decimal places.) B) Find or estimate the P-value of the sample test statistic. C) Reject or Fail to Reject the Null Hypothesis

An article about the California lottery gave the following information on the age distribution of adults in California: 35% are between 18 and 34 years old, 51% are between 35 and 64 years old, and 14% are 65 years old or older. The article also gave information on the age distribution of those who purchase lottery tickets. The following table is consistent with the values given in the article. Suppose that the data resulted from a random sample of 200 lottery ticket purchasers. Based on these sample data, is it reasonable to conclude that one or more of these three age groups buys a disproportionate share of lottery tickets? Use a chi-square goodness-of-fit test with ? = 0.05. Age of Purchaser Frequency 18–34 36 35–64 130 65 and over 34 Calculate the test statistic. (Round your answer to two decimal places.) ?2 =  Use technology to calculate the P-value. (Round your answer to four decimal places.) P-value =  What can you conclude? The data     strong evidence to conclude…

2. Scores in the first and fourth (final) rounds for a sample of 20 golfers who competed in PGA tournaments are shown in the following table (Golfweek, February 14, 2009, and February 28, 2009). Suppose you would like to determine if the mean score for the first round of a PGA Tour event is significantly different than the mean score for the fourth and final round. Does the pressure of playing in the final round cause scores to go up? Or does the increased player concentration cause scores to come down?         Player First Round Final Round     Sleve McDichael 72 72     Onson Sweemey 68 68     Darryl Archideld 72 72     Anatoli Smorin 68 68     Rey McScriff 73 73     Glenallen Mixon 69 69     Mario McRlwain 74 74     Raul Chamgerlain 69 73     Mike Sernandez 70 73     Tony Smehrik 71 69     Player First Round Final Round     Bobson Dugnutt 73 75…

The owner of Maumee Ford-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year.  Car Age (years) Selling Price ($000) 1 11 12.1 2 8 10.5 3 14 5.7 4 17 4.9 5 9 5.0 6 8 13.4 7 10 10.5 8 14 9.0 9 13 9.0 10 17 4.5 11 6 12.5 12 6 11.5   Click here for the Excel Data Filea. Determine the regression equation. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) a= b=   Estimate the selling price of an 7-year-old car (in $000). (Round your answer to 3 decimal places.) Interpret the regression equation (in dollars). (Round your answer to the nearest dollar amount.)