Question 2

Where do CFOs get their money news? According to Robert Half International, 47% get their money news from newspapers, 15% get it from communication/colleagues, 12% get it from television, 11% from the Internet, 9% from magazines, 5% from radio, and 1% do not know. Suppose a researcher wants to test these results. She randomly samples 76 CFOs and finds that 40 of them get their money news from newspapers. Does the test show enough evidence to reject the findings of Robert Half International? Use a = .05. Make sure you clearly state both the null and the alternative hypotheses in full sentences. Following your calculations, 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). Question 3 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. Unit 3 [GB513: Business Analytics] 3 of 4 Some studies have shown that in the United States, men spend more than women buying gifts and cards on Valentines 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 Valentines Day and record all purchases made for Valentines 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 Valentines 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