# Confidence Interval Lab Work in Excel

Feb 3rd, 2012
Studypool Tutor
Price: \$40 USD

Tutor description

Head shots on - How to find a C.I? What are the formulas to use in excel to find C.I? Apply an Hypothesis on C.I? And few lab questions?

Word Count: 1758
Showing Page: 1/8
Please provide GRAPHS ( excel? ) if possible. Thanks a lot!1. Confidence Interval using the mean scores for each year - ( 8 sentences?)- Accurately determine confidence intervals for the population mean using scores from each year.- Determine and state clearly whether each confidence interval contains the population mean. Explain why or why not.- Accurately interpret the meaning of the confidence intervals.2. Hypothesis Test comparing 2009 mean test score to population mean test score - ( 8 sentences?)- State the null hypothesis, alternative hypothesis, and identify the claim being tested.- State the test being used and significance level alpha.- Determine the test statistic and p-value or critical value.- State whether the null hypothesis was rejected or not and explain why.- Explain the results of the test as it pertains to the claim being tested in the context of the project question.3. Hypothesis Test comparing mean scores of males and females - ( 8 sentences?)- State the null hypothesis, alternative hypothesis, and identify the claim being tested.- State the test being used and significance level alpha.- Determine the test statistic and p-value or critical value.- State whether the null hypothesis was rejected or not and explain why.- Explain the results of the test as it pertains to the claim being tested in the context of the project question.4. Hypothesis Test comparing mean scores of Whites and Hispanics - ( 8 sentences?)- State the null hypothesis

## Review from student

Studypool Student
" <3 it, thanks for saving me time. "

1820 tutors are online

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