solve questions as instructed, data is attached *add screenshot when software as excel or other is usedPart 2: Confidence Intervals During the recovery from the Great Recession of 2007-2009, the economic situation for many families improved. However, in 2011 the recovery was slow and it was uncertain as to how much had really changed on the national level. To estimate the national average of the percent of low-income working families, a representative simple random sample of the percent of low-income working families from each of the country’s reporting jurisdictions could be used to calculate a point estimate and create a related confidence interval. With this confidence interval a better picture of the nation’s recovery can be had and legislative decisions can be made. 6. Describe in two or three sentences how a simple random sample of size n=20 could be obtained from the full list of jurisdictions provided for use with this assignment. 7. A researcher reported that a sample of size n=30 produced a sample mean of 32.56% and a sample standard deviation of 6.56%. Use this information to calculate a 90% confidence interval for the national average for the “percent of low-income working families”. Provide the upper and lower limits of the confidence interval and the margin of error. (Round the limits to two decimal places.) 8. Provide an explanation as to why it would be very unlikely that a different sample of size n=30 would produce the same confidence interval. 9. Provide an appropriate statistical interpretation of the 90% confidence interval found in number 7. 10. If a limited amount of federal funds have been allocated to assist jurisdictions whose “percent of low-income working families” exceeds a threshold based on the upper limit of a confidence interval, what would be the effect of using a confidence level that is higher than 90%? 11. If a public official requests funds based on a confidence interval provided by constituents in his/her district, would this raise any ethical concerns, or constitute a misuse of statistics, or both? Provide at least two sentences to respond to the situation presented. Part 3: Hypothesis Testing In 2011, the national percent of low-income working families had an approximately normal distribution with a mean of 31.3% and a standard deviation of 6.2% (The Working Poor Families Project, 2011). Although it remained slow, some politicians claimed that the recovery from the Great Recession was steady and noticeable. As a result, it was believed that the national percent of low-income working families was significantly lower in 2014 than it was in 2011. To support this belief, a spring 2014 sample of n=16 jurisdictions produced a sample mean of 29.8% for the percent of low-income working families, with a sample standard deviation of 4.1%. Using α=0.10 significance level, test the claim that the national average percent of low-income working families had improved by 2014. 12. Clearly restate the claim associated with this test, and state the null and alternate hypotheses. 13. Provide two or three sentences to state the type of test that should be performed based on the hypotheses. Additionally, state the assumptions and conditions that justify the appropriateness of the test. 14. Use technology to identify, and then provide the test statistic and the resulting P-value associated with the given sample results. Provide a statement that explains the interpretation of the P-value. (Print or copy-and-paste the output that identified these values, or any other form of evidence that technology was used.) 15. State, separately, both the decision/result of the hypothesis test, and the appropriate conclusion/statement about the claim.

A finance manager employed by an automobile dealership believes that the number of cars sold in his local market can be predicted by the interest rate charged for a loan. Interest Rate (%) Number of Cars Sold (100s) 3 10 5 7 6 5 8 2 The finance manager performed a regression analysis of the number of cars sold and interest rates using the sample of data above. Shown below is a portion of the regression output. Regression Statistics Multiple R 0.998868 R2 0.997738 Coefficient Intercept 14.88462 Interest Rate -1.61538 Are there factors other than interest rate charged for a loan that the finance manager should consider in predicting future car sales? Is interest rate charged for a loan the most important factor to be considered in predicting future car sales? Explain your reasoning.The dealership's vice-president of marketing has requested a sales forecast at the prevailing interest rate of 7%. As finance manager, what reasons would you convey to the vice-president in recommending this forecasting model? Is the prediction of car sales at 7% a reflection of the current downturn in the economy? How might this impact the dealership's business?