Solutions Statistics

Suppose that I start a small home business that makes healthy, organic cookies and cakes for dogs th

Question: Suppose that I start a small home business that makes healthy, organic cookies and cakes for dogs that can be purchased for special holidays (e.g., cakes for birthdays, heart-shaped cookies for Valentine’s Day, etc.). I am interested in learning how much I should spend on advertising. I find data for the past year (2005) about advertising expenditures (X) and sales (Y) for 7 small companies that also cater to individuals who own dogs. I obtain the following set of data (both advertising expenditures and sales are reported in thousands of dollars).

Company	X	Y	*\[X-\bar{X}\]*	*\[Y-\bar{Y}\]*	*\[(X-\bar{X})(Y-\bar{Y})\]*
1	3	70	-1.57	-38.57	60.61
2	4	120	-0.57	11.43	-6.53
3	5	110	0.43	1.43	0.61
4	5	100	0.43	-8.57	-3.67
5	6	140	1.43	31.43	44.90
6	5	120	0.43	11.43	4.90
7	4	100	-0.57	-8.57	4.90
Mean	4.57	108.57
SD	0.98	21.93

(a) What is the deviation score for sales for Company 7? (1 point)

(b) What is the sum of the deviation scores for sales? (1 point)

(d) What would be the predicted sales for a company who spent $10,000 on advertising? (4 points)

(e) Based on these data, what decision should I make about spending money on advertising my dog cuisine? Provide a justification for your answer. (3 points).

(f) Over the next few days, I find data on advertising expenditures and sales on 7 additional dog companies. These are reported below.

Company X Y

8 8 130

9 9 110

10 9 100

11 10 100

12 12 90

13 12 80

14 13 80

Create a scatterplot of X and Y for all 14 companies (the next page is designed to resemble graph paper to make this easier). Does this scatterplot support your answer to part (e) of this question? Why or why not? (3 points)

Price: $2.99

Solution: The answer consists of 4 pages
Deliverables: Word Document