# statistics worksheet The critical z-value is calculated using Excel function

Anonymous
timer Asked: Jan 3rd, 2018
account_balance_wallet \$15

Question description

need help with a 10 question worksheet from my QNT/275 class. Some questions have multiple parts and there is plenty of time to have it completed. Can you please help me?

Practice Set 4 QNT/275 Version 6 University of Phoenix Material Practice Set 4 Practice Set 4 1. Find z for each of the following confidence levels. Round to two decimal places. A. 90% B. 95% C. 96% D. 97% E. 98% F. 99% 2. For a data set obtained from a random sample, n = 81 and x = 48.25. It is known that σ = 4.8. A. What is the point estimate of μ? Round to two decimal places B. Make a 95% confidence interval for μ. What is the lower limit? Round to two decimal places. C. Make a 95% confidence interval for μ. What is the upper limit? Round to two decimal places. D. What is the margin of error of estimate for part b? Round to two decimal places. 3. Determine the sample size (nfor the estimate of μ for the following. A. E = 2.3, σ = 15.40, confidence level = 99%. Round to the nearest whole number. B. E = 4.1, σ = 23.45, confidence level = 95%. Round to the nearest whole number. C. E = 25.9, σ = 122.25, confidence level = 90%. Round to the nearest whole number. 4. True or False. a.The null hypothesis is a claim about a population parameter that is assumed to be false until it is declared false. A. True B. False b. An alternative hypothesis is a claim about a population parameter that will be true if the null hypothesis is false. A. True B. False c. The critical point(s) divide(s) is some of the area under a distribution curve into rejection and nonrejection regions. A. True B. False Copyright © 2017 by University of Phoenix. All rights reserved. 1 Practice Set 4 QNT/275 Version 6 d. The significance level, denoted by α, is the probability of making a Type II error, that is, the probability of rejecting the null hypothesis when it is actually true. A. True B. False e. The nonrejection region is the area to the right or left of the critical point where the null hypothesis is not rejected. A. True B. False 5. A Type I error is committed when A. A null hypothesis is not rejected when it is actually false B. A null hypothesis is rejected when it is actually true C. An alternative hypothesis is rejected when it is actually true 6. Consider H0: μ = 45 versus H1: μ < 45. A random sample of 25 observations produced a sample mean of 41.8. Using α = .025 and the population is known to be normally distributed with σ = 6. A. What is the value of z? Round to two decimal places. B. Would you reject the null hypothesis? 1. Reject Ho 2. Do not reject Ho 7. The following information is obtained from two independent samples selected from two normally distributed populations. n1 = 18 x1 = 7.82 σ1 = 2.35 n2 =15 x2 =5.99 σ2 =3.17 A. What is the point estimate of μ1 − μ2? Round to two decimal places. B. Construct a 99% confidence interval for μ1 − μ2. Find the margin of error for this estimate. Round to two decimal places. 8. The following information is obtained from two independent samples selected from two populations. n1 =650 x1 =1.05 σ1 =5.22 n2 =675 x2 =1.54 σ2 =6.80 Test at a 5% significance level if μ1 is less than μ2. a) Identify the appropriate distribution to use. Copyright © 2017 by University of Phoenix. All rights reserved. 2 Practice Set 4 QNT/275 Version 6 A. t distribution B. normal distribution b) What is the conclusion about the hypothesis? A. Reject Ho B. Do not reject Ho 9. Using data from the U.S. Census Bureau and other sources, www.nerdwallet.com estimated that considering only the households with credit card debts, the average credit card debt for U.S. house- holds was \$15,523 in 2014 and \$15,242 in 2013. Suppose that these estimates were based on random samples of 600 households with credit card debts in 2014 and 700 households with credit card debts in 2013. Suppose that the sample standard deviations for these two samples were \$3870 and \$3764, respectively. Assume that the standard deviations for the two populations are unknown but equal. a) Let μ1 and μ2 be the average credit card debts for all such households for the years 2014 and 2013, respectively. What is the point estimate of μ1 − μ2? Round to two decimal places. Do not include the dollar sign. b) Construct a 98% confidence interval for μ1 − μ2. Round to two decimal places. Do not include the dollar sign. 1. What is the lower bound? Round to two decimal places. 2. What is the upper bound? Round to two decimal places. c) Using a 1% significance level, can you conclude that the average credit card debt for such households was higher in 2014 than in 2013? Use both the p-value and the critical-value approaches to make this test. A. Reject Ho B. Do not reject Ho 10. Gamma Corporation is considering the installation of governors on cars driven by its sales staff. These devices would limit the car speeds to a preset level, which is expected to improve fuel economy. The company is planning to test several cars for fuel consumption without governors for 1 week. Then governors would be installed in the same cars, and fuel consumption will be monitored for another week. Gamma Corporation wants to estimate the mean difference in fuel consumption with a margin of error of estimate of 2 mpg with a 90% confidence level. Assume that the differences in fuel consumption are normally distributed and that previous studies suggest that an estimate of sd=3sd=3 mpg is reasonable. How many cars should be tested? (Note that the critical value of tt will depend on nn, so it will be necessary to use trial and error.) Copyright © 2017 by University of Phoenix. All rights reserved. 3

## Tutor Answer

psumanrec
School: UIUC

Please find answer along with Excel Sheet.

Confidence Level
0.9
0.95
0.96
0.97
0.98
0.99

Critical z-value
1.64
1.96
2.05
2.17
2.33
2.58

Confidence Interval Estimate for the Mean
Data
Population Standard Deviation
Sample Mean
Sample Size
Confidence Level
Intermediate Calculations
Standard Error of the Mean
Z Value
Interval Half Width
Confidence Interval
Interval Lower Limit
Interval Upper Limit

4.8
48.25
81
95%

0.5333
-1.9600
1.05

47.20
49.30

Z Test of Hypothesis for the Mean
Data
Null Hypothesis
m=
Level of Significance
Population Standard Deviation
Sample Size
Sample Mean
Intermediate Calculations
Standard Error of the Mean
Z Test Statistic
Lower-Tail Test
Lower Critical Value
p -Value
Reject the null hypothesis

45
0.025
6
25
41.8

1.2000
-2.6667

-1.9600
0.0038

Z Test for Differences in Two Means
Data
Hypothesized Difference
Level of Significance
Population 1 Sample
Sample Size
Sample Mean
Population Standard Deviation
Population 2 Sample
Sample Size
Sample Mean
Population Standard Deviation
Intermediate Calculations
Difference in Sample Means
Standard Error of the Difference in Means
Critical z-value
Margin of error

0
0.01
18
7.82
2.35
15
5.99
3.17

1.83
0.9883
2.58
2.55

Lower Limit

-0.72

Upper Limit

4.38

Z Test for Differences in Two Means
Data
Hypothesized Difference
Level of Significance
Population 1 Sample
Sample Size
Sample ...

flag Report DMCA
Review

Anonymous
Totally impressed with results!! :-)

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors