Case

Data

Territory ID	No. of Stores (in hundred)	No. of Dealers (in hundred)	No. of Popular Brands	Population (in thousand)	Sales (in $mil)	Urban Type	Region		Dependent,Indepenent Variables	Pearson's Correlation Coefficient r	Relationship (strength + direction)
1	7	10	11	71	42	City	South		Sales & Population
2	5	0	13	73	26	Suburb	South		Sales & No. Stores
3	24	55	12	104	46	City	South		Sales & No. Pop Brands
4	24	52	8	112	63	City	North		Sales & No. Dealers
5	1	21	13	70	14	Suburb	North
6	11	4	11	45	19	Suburb	South
7	7	20	13	82	36	City	North
8	23	58	9	128	12	Suburb	South
9	13	27	9	103	20	City	South
10	22	28	9	115	22	Suburb	South
11	7	10	6	71	55	City	South
12	5	0	13	73	29	City	North
13	24	55	8	135	46	City	South
14	24	52	14	66	16	Suburb	North
15	1	21	13	70	14	City	North
16	11	4	11	45	19	City	South
17	7	20	13	62	16	Suburb	South
18	23	58	9	128	12	Suburb	South
19	13	27	3	103	20	City	South
20	22	28	9	115	22	Suburb	South
21	13	14	3	89	22	Suburb	North
22	16	21	4	139	64	City	South
23	16	57	3	111	24	Suburb	North
24	8	3	12	68	3	City	North
25	12	22	13	73	34	City	North
26	14	20	11	85	13	Suburb	South
27	1	9	14	56	8	City	North
28	0	29	14	68	14	Suburb	South
29	11	20	14	67	4.5	City	North
30	6	9	9	62	7	Suburb	South
31	3	12	15	58	12	Suburb	North
32	13	21	12	96	33	City	North
33	10	34	8	114	46	City	North
34	12	7	13	70	29	Suburb	South
35	17	16	16	100	21	Suburb	South
36	15	37	9	143	48	City	North
37	16	27	13	102	27	City	South
38	12	51	6	153	80	City	South
39	15	37	9	143	47	Suburb	South
40	16	27	13	102	27	City	South
41	12	51	6	153	80	City	North
42	14	72	4	140	40	Suburb	South
43	16	70	5	134	67	City	North
44	12	7	13	70	29	City	South
45	17	16	16	100	19	Suburb	South
46	3	12	15	58	23	City	North
47	13	21	12	96	33	City	North
48	10	34	8	114	43	Suburb	South
49	14	72	4	140	40	Suburb	South
50	16	33	12	36	19	Suburb	North
51	10	34	8	114	47	City	North
52	14	72	4	122	37	Suburb	South
53	16	70	5	121	65	City	South

First, calculate the descriptive statistics (mean and standard deviation) of each variable. Next, determine the correlation coefficients between sales and each potential correlated variable in the data set. Interpret what these correlations mean. Include the magnitude and direction of each relationship. Is territory number an appropriate variable for a correlation? Why or why not?