N22 v fx A B C D Female Male 2 8 1 3 3 5 4 8 5 7 3 2 7 6 1 8 8 2 9 5 6 10 6 4 11 5 2 12 4 9 13 2 3 14 9 4 15 8 16 6 17 8 2 18 2 6 19 12 20 5 4 21 6 5 22 9 3 23 1 1 24 3 25 4 6 26 6 7 27 8 4 28 7 1 29 5 2 Number of books +30 31 32 33 34 35 Number of booksClipboard G9 X A B C D 1 Females Males 2 8 1 3 3 5 4 8 5 3 6 6 8 2 9 5 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 No of good FriendsClipboard Font F13 X v fx A B C D 1 2000 2010 2 20.5 25.7 3 17.5 23.4 4 15.1 19.6 5 17.8 23.7 6 14.6 19.2 7 10.3 16.5 8 13.4 18.0 9 17.7 22.4 10 16.8 20.7 11 16.7 19.4 12 11.5 23.5 13 12.9 17.1 14 16.9 20.2 15 17.0 22.0 16 18.6 24.1 17 18.7 22.9 18 13.4 22.8 19 19.2 24.5 20 19.7 25.2 21 16.1 20.7 22 17.7 19.4 23 13.1 18.3 24 18.2 25.4 25 14.3 22.3 26 19.8 26.8 27 19.2 23.2 obesity +Clipboard Font F13 X fix A B C D 28 14.3 18.7 29 16.3 23.2 30 15.5 21.6 31 14.5 17.9 32 13.5 19.0 33 14.1 19.8 34 14.5 20.6 35 18.1 23.5 36 18.4 23.4 37 18.9 23.0 38 16.8 22.9 39 16.4 20.3 40 18.7 24.0 41 14.3 18.5 42 18.4 25.8 43 14.7 21.2 44 17.4 24.6 45 17.2 25.5 46 13.7 17.5 47 14.9 18.9 48 15.9 23.7 49 15.6 21.3 50 19.9 27.5 51 17.1 21.6 52 15.1 19.5 53 54 obesity +Clipboard H19 X Y A B C ADV Sales 5 50 OO N 5 250 7 700 6 450 6 6.5 600 8 1000 8 3.5 75 g 4 150 10 4.5 200 11 6.5 550 12 7 750 13 7.5 800 14 7.5 900 15 8.5 1100 16 7 600 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Sales +Excel Case Study Direction: Use Microsoft Excel to answer the following questions (Excel Instructions are provided in different file) 1. Determinants of Sales: A firm wants to investigate the effect of advertising on sales. Data on sales and advertising expenditures are gathered for 20 stores. Given the variable sale (SALES, in $100) and the variable advertising expenditures (ADV, in $100), use the data file SALES to answer the following question: a. Construct a descriptive statistics table of the mean, standard deviation, minimum and maximum of the two variables. Interpret your findings. b. What is the correlation coefficient of SALES and ADV? Is the sign and magnitude of the coefficient consistent with expectation? Explain. c. Depict a scatter plot of the relationship between the two variables. Is your finding consistent with finding in (b)? Explain. d. What implication does this result have for the firm? Explain briefly. 2. An Economist was interested in sex differences in the number of books a person reads (see file: Number of Books). Two random samples were taken, one of men and the other, and the number of books read during the last month was recorded. Is there a difference with respect to the number of books read by females and males? 3. An Economist was interested in sex differences in the sociability of teenagers (see file: Number of Good Friends). Using the number of good friends as a measure, he compared the sociability of eight female and seven male teenagers. Is there a difference in the average with respect to sociability between teenage females and males? 4. An Economist was interested in comparing obesity levels among the US states (see file: obesity). Compute: a. The mean, standard deviation, minimum and maximum of the two variables and interpret the results. b. Find the correlation coefficient and interpret your finding. c. is there a difference between the average obesity over the two years. What can you conclude