Scenario Given

Week 4 Apply
Part 1:
Using the Microsoft Excel, you will need to compute the following using the data set below:

• Calculate the group statistics:

Calculate the mean
Calculate the standard deviation
• Calculate the independent sample tests (t-test for equality of means):

Identify t value
Identify the degrees of freedom value
Identify the Significance value
Identify the Standard Error Difference

Scenario:

An advertising agency is interested in learning how to fit its commercials to the interests and needs of the viewing audience. It asked samples of 41 men and 41 women to report the agency amount of television watched daily. Use the data located here to test the manager’s claim that there is a significant gender difference in television viewing.

Part 2:
Using MS Word create a document in APA format that includes the following:

• Cover Page
• Introduction (summary of the paper’s contents)
• Body paragraphs that address the following:
State the null and alternative hypotheses
Make a decision about the null hypothesis
Draw a conclusion from the analysis
What are the implications of this analysis for the advertising agency?
• Conclusion
• Reference Page
• Image(s) from Microsoft Excel
Print screen the image(s) by having the image displayed on your screen and then holding down both the CTRL button and the END button which should have the PRTSC function on it.
Go to the MS Word document and hold down both the CTRL button and the V button.

• Any computations that were not done in Microsoft Excel for the data set should be listed separately under the image(s).
Format Requirements
Document Tyttpe

Microsoft Excel and Microsoft Word

Paper Size

8.5 X 11″

Length

1-2 pages

Margins

1″

Font

Times or Times New Roman, 12 pt.

Line Spacing

Double. No extra double space between paragraphs please.

In-text Citations & Reference List Style

APA

Paper Structure

Cover Page
Introduction
Body
Conclusion
References
Microsoft Excel Image(s)
Calculations not included in Microsoft Excel image(s)
File Naming Convention

LastName_FirstName_Week4_Apply
Example: Doe_John_Week4_Apply