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
" Solid work, thanks. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 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