View the step-by-step solution to:

Question

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. Conduct a hypothesis test using this tool. Explain your answer (how you decided if men spend more or not) 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 men and 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 1 month before Valentine's Day and record all purchases made for Valentine's Day during that 1-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.


Make sure you clearly state both the null and the alternative hypotheses in full sentences. Include the output table; then, clearly state the conclusion in the same manner (do not simply say "accept/reject null") and explain how you arrived at this conclusion (based on which metrics). 


Men 

Women 

107.48 

125.98 

143.61 

59.32 

90.19 

96.35 

125.53 

80.62 

70.79 

77.6 

83 

84.34 

129.63 

75.21 

154.22 

68.48

93.8 

65.84 

111.25 

126.11 

78.6 

82.54 

89.35 

123.5

Make sure you use full sentences for the items below. Do not simply say something like "x1<x2" "or "reject null" without a description and explanation of how you arrived at your conclusion.

Null hypothesis:

Alternative hypothesis:

Calculated p or t value:

Conclusion (justify using the metrics):

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.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    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
Let our 24/7 Statistics and Probability tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors