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

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

#### Top Answer

Here is the solution... View the full answer