Part 2

Analyze the data from Part 1 using MicrosoftÂ® ExcelÂ® software.Â

Write a 700- to 875-word paper that includes the following information:

Â· Describe what method you are using to compare groups.

Â· Copy and paste the output into a MicrosoftÂ® Word document, and also answer the following questions:

o What is the significance level of the comparison?

o What was the alpha level you identified in Week 3?

o What was the means and variance for each variable?

o What was the test statistic?

o What was the critical value for both the one- and two-tailed test?Â

o Was your test one-tailed or two-tailed?

o Were you able to reject the null hypothesis? In other words, did you prove there was a difference?

Â· Talk about what these results mean in everyday language and in context to your chosen scenario.

Â· Make a recommendation based on the findings.

Format your paper according to APA guidelines.

Example of Output You Would Use to Answer These Questions

t Test: Two-Sample Assuming Equal Variances

Â Â Â Â Â Â Â Variable 1

Â Â Â Â Â Â Variable 2

Mean

4.875

8

Variance

5.267857143

18.28571429

Observations

8

8

Pooled variance

11.77678571

Hypothesized mean difference

0

df

14

t stat

-1.821237697

P(T <= t) one-tail

0.045002328

t Critical one-tail

1.761310136

P(T <= t) two-tail

0.090004655

t Critical two-tail

2.144786688

Part 3

Create a 12- to 15-slide presentation using the information you gathered and submitted in Weeks 3 & 4. Include the following:

Â· Describe the problem, and provide some brief background about the situation.

Â· Explain the research hypothesis.

atleast 100 words for speaker notes

Â· Describe your sample and your sampling method.

Â· Explain the four steps of the research process you followed, and define the critical value and the test statistic your analysis provided.

Â· Provide the main finding of the study. What did you prove or fail to prove?

Â· Provide recommendations based on your findings.

Â

Format any citations in your presentation according to APA guidelines.