Hello Class,
Re:Week 4 -Part 2 of the Inferential Research and Statistics Project
Writea 700- to 875-word paper that includes the following information:
You have beengiven a dataset(see the attached document) with two sets of interval data (just the numbers, as you must decide what they represent, such as method A results or method B results).
For the Part 2 of the assignment, you will do atTest: Two-Sample Assuming Equal Variances (on excel),to answer the following questions.
1.Copy and paste the output from Excel into a Microsoft®Word document, and answer the following questions:
2.What is the significance level of the comparison?
3.What was the alpha level you identified in Week 3?
4.What was the means and variance for each variable?
5.What was the test statistic?
6.What was the critical value for both the one- and two-tailed test?
7.Was your test one-tailed or two-tailed?
8.Were you able to reject the null hypothesis? In other words, did you prove there was a difference?
9.Talk about what these results mean in everyday language and in context to your chosen scenario.
10.Make a recommendation based on the findings.
Format your paper according to APA guidelines.
Remember toaddheadingsto the paperto identify the main key elements of the assignment.
Additionally,add aconclusionto your paperthatsummarizes the main key elements of the assignment.
Also,add areference pageto your paper.
Using Excel: to do a t Test: Two-Sample Assuming Equal Variances
Open the data set (Excel). (see the attached document.)
1stStep:Column A - row 1 - (label) Group 1 scores
2ndStep:Column A - Rows 2 through 31 - Group 1 scores
3rd Step:Column B - 1 row - (label) Group 2
4thStep:Column B - Rows 2 through 31 -Group 2 scores
5th Step:Select Data analysis
6th Step:Select the t-Test: Two-Sample Assuming Equal Variances
7th Step:Select the rows 1 to 31 of Column A for the Variable 1 Range
8th Step:Select the rows 1 to 31 of Column B for the Variable 2 Range
9th Step:Hypothesized Mean Difference is 0 (add the 0 to this box)
We hypothesized there is no difference (null hypothesis) between the two methods; therefore, we add a 0 to this box.
10th Step:Select labels
We did include labels (column A and column B)
11th Step:Alpha is 0.05 (will automatically appear)
12thStep:SelectNew Worksheet Ply:, then select ok, and a box will appear.
The box will have two means (the mean for Column A and the Mean for Column B) and other numbers for the following:
Mean
Variance
Observation
Hypothesis
df
t Stat
P(t < = t) one-tail
t critical one-tail
P(t < = t) two-tail
t critical one-tail
With Warm Regards,