Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Continuous Nowhere Differentiable Functions The Monsters Of Analysis

Authors: Marek Jarnicki, Peter Pflug

1st Edition

3319126709, 9783319126708

More Books

Students also viewed these Mathematics questions

Question

Define job pricing. What is the purpose of job pricing?

Answered: 1 week ago

Question

What are some companywide pay plans? Briefly discuss each.

Answered: 1 week ago