DATA ANALYSIS TOOLPACK - 94258

Solution Posted by
academicgeek

academicgeek

Rating : (8)A+
Solution Detail
Price: $35.00
  • From: Business,
  • Posted on: Wed 25 Nov, 2015
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description
PROBLEM: 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 The following pages shows the answered I received with clear process, solutions and comparisons, but instead putting 9 men entries and 10 women; he put it opposite. Please correct entries and results. The observations are wrong there are 9 men and 10 women t-Test: Two-Sample Assuming Equal Variances Men Women Mean 112.436 69.85778 Variance 759.9333378 691.0798 Observations 10 9 Pooled Variance 727.5316939 Hypothesized Mean Difference 0 Df 17 t Stat 3.4356271 P(T<=t) one-tail 0.001577404 t Critical one-tail 1.739606716 P(T<=t) two-tail 0.003154808 t Critical two-tail 2.109815559
Solution Description

PROBLEM:

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

Attachments
men_vs_women.xls
men_vs_women.xl...
men_vs_women.docx
men_vs_women.do...