View the step-by-step solution to:

To answer this question, use the Data Analysis Toolpack in Excel and select "t-Test: Two-Sample Assuming Equal Variances" from the list of available...

This question was answered on Jan 01, 2013. View the Answer
To answer this question, use the Data Analysis Toolpack in Excel and select “t-Test: Two-Sample
Assuming Equal Variances” from the list of available tools. Explain your answer (how did you decide if
men spend more) and include the output table. Some studies have shown that in the United States,
men spend more than women buying gifts and cards on Valentine’s Day. Suppose a researcher
wants to test this hypothesis by randomly sampling nine men and 10 women with comparable
demographic characteristics from various large cities across the United States to be in a study. Each
study participant is asked to keep a log beginning one month before Valentine’s Day and record all
purchases made for Valentine’s Day during that one-month period. The resulting data are shown
below. Use these data and a 1% level of significance to test to determine if, on average, men actually
do spend significantly more than women on Valentine’s Day. Assume that such spending is normally
distributed in the population and that the population variances are equal.
Men Women
107.48 125.98
143.61 45.53
90.19 56.35
125.53 80.62
70.79 46.37
83.00 44.34
129.63 75.21
154.22 68.48
93.80 85.84
126.11
Sign up to view the entire interaction

Top Answer

Here is the solution... View the full answer

8417433.xlsx

men
women
107.48
125.98
143.61
45.53
90.19
56.35
125.53
80.62
70.79
46.37
83
44.34
129.63
75.21
154.22
68.48
93.8
85.84
126.11
112.436 69.85778
759.9333 691.0798 Ho: μM ≤ μW
H1: μM > μW...

This question was asked on Jan 01, 2013 and answered on Jan 01, 2013.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards