Question

Please finish the following assignments in Excel.

1. Compute the following descriptive statistics for “TV Advertising Spending”

– Mean

– Median

– Skewness

2. Relationship between AD spending and Consumer Preference:

– Draw a scatter plot of two variables.

– Compute a correlation coefficient

– How do you think about the correlation between the two variables?

	TV Advertising Spending (Mil. $)	Consumer Preference Rating
Company 1	3.99	-1.29
Company 2	2.68	0.22
Company 3	3.00	0.12
Company 4	4.48	-0.72
Company 5	3.44	0.61
Company 6	2.99	0.89
Company 7	3.74	1.65
Company 8	4.75	-1.64
Company 9	4.21	-1.59
Company 10	3.86	-0.72
Company 11	2.51	1.01
Company 12	2.58	-1.39
Company 13	3.84	-0.59
Company 14	4.19	-0.60
Company 15	2.90	0.88
Company 16	4.55	-1.78
Company 17	4.69	-3.09
Company 18	3.71	1.23
Company 19	3.83	-0.43
Company 20	3.22	-0.52
Company 21	3.82	-0.01
Company 22	3.27	0.07
Company 23	2.96	-0.43
Company 24	1.63	-0.16
Company 25	1.09	-0.79
Company 26	2.18	0.68
Company 27	3.66	-0.15
Company 28	2.67	-0.38
Company 29	2.53	-0.23
Company 30	1.81	-0.08
Company 31	2.58	0.02
Company 32	2.24	-2.04
Company 33	3.10	1.19
Company 34	3.29	2.26
Company 35	4.67	-2.41
Company 36	3.04	0.67
Company 37	2.48	-1.82
Company 38	1.71	-2.15
Company 39	3.18	1.02
Company 40	2.46	2.18
Company 41	1.67	-0.41
Company 42	2.16	-1.20
Company 43	2.09	0.46
Company 44	1.56	-0.72
Company 45	3.52	0.15
Company 46	4.25	-2.05
Company 47	4.62	0.41
Company 48	3.82	-0.63
Company 49	2.41	0.11
Company 50	2.85	0.12
Company 51	3.08	0.09
Company 52	2.30	-0.59
Company 53	4.41	-0.73
Company 54	3.47	1.01
Company 55	2.47	0.90
Company 56	2.28	1.34
Company 57	2.61	0.09
Company 58	2.69	0.09
Company 59	2.36	1.28
Company 60	2.67	0.35
Company 61	4.70	-2.27
Company 62	3.26	-1.11
Company 63	2.30	1.57
Company 64	4.06	-0.70
Company 65	1.84	-1.28
Company 66	3.59	1.67
Company 67	4.32	-0.40
Company 68	2.74	1.77
Company 69	5.28	-2.71
Company 70	3.22	1.32
Company 71	3.16	1.30
Company 72	2.65	1.29
Company 73	2.68	2.69
Company 74	4.59	-0.80
Company 75	2.41	-0.39
Company 76	2.22	0.42
Company 77	3.68	-0.43
Company 78	3.06	1.97
Company 79	3.27	1.91
Company 80	3.04	0.31
Company 81	3.05	1.84
Company 82	3.07	2.21
Company 83	4.00	-1.00
Company 84	2.15	1.54
Company 85	3.19	1.43
Company 86	1.87	-1.03
Company 87	3.58	-0.61
Company 88	3.97	0.06
Company 89	4.03	-0.54
Company 90	3.49	1.54
Company 91	2.19	1.30
Company 92	1.73	-1.85
Company 93	3.85	0.83
Company 94	3.97	0.38
Company 95	3.18	-1.10
Company 96	2.71	0.93
Company 97	4.05	0.49
Company 98	2.94	-0.31
Company 99	3.73	-0.35
Company 100	3.53	-0.11
Company 101	2.76	0.59
Company 102	3.79	1.02
Company 103	3.55	1.34
Company 104	2.79	1.87
Company 105	2.43	-0.49
Company 106	3.62	0.49
Company 107	1.93	0.67
Company 108	4.14	-0.24
Company 109	3.49	-1.92
Company 110	4.10	-0.13
Company 111	3.75	1.70
Company 112	2.65	-0.81
Company 113	2.02	0.05
Company 114	2.48	-1.12
Company 115	3.28	-1.76
Company 116	3.11	-0.42
Company 117	3.76	-0.27
Company 118	0.84	-1.86
Company 119	3.45	0.03
Company 120	4.13	0.38
Company 121	2.45	-0.35
Company 122	4.00	-0.08
Company 123	1.65	-0.81
Company 124	2.26	2.12
Company 125	3.74	1.56
Company 126	2.92	-0.08
Company 127	2.61	-1.83
Company 128	3.87	-2.13
Company 129	3.59	0.46
Company 130	1.75	-0.97
Company 131	2.97	1.85
Company 132	4.65	-0.72
Company 133	1.32	-0.21
Company 134	4.07	-0.61
Company 135	2.88	-0.19
Company 136	2.80	0.52
Company 137	3.28	1.01
Company 138	3.15	1.69
Company 139	3.27	0.36
Company 140	3.87	-1.33
Company 141	2.90	2.18
Company 142	2.92	0.51
Company 143	3.36	2.68
Company 144	2.67	-0.27
Company 145	4.13	-0.33
Company 146	3.81	0.97
Company 147	2.39	0.90
Company 148	3.37	1.10
Company 149	3.46	2.10
Company 150	3.16	1.41
Company 151	2.65	2.71
Company 152	4.58	-2.48
Company 153	3.03	-0.57
Company 154	2.36	-0.98
Company 155	4.55	-2.70
Company 156	2.85	-0.80
Company 157	3.76	0.53
Company 158	4.17	-0.06
Company 159	2.49	-0.18
Company 160	3.58	-1.27
Company 161	2.88	0.21
Company 162	3.70	0.70
Company 163	2.28	1.16
Company 164	3.36	0.12
Company 165	2.99	1.90
Company 166	1.22	-2.11
Company 167	3.62	0.49
Company 168	3.32	0.77
Company 169	1.80	0.29
Company 170	2.26	-0.82
Company 171	2.87	1.85
Company 172	1.89	0.54
Company 173	3.37	2.45
Company 174	2.90	-0.56
Company 175	2.03	0.46
Company 176	2.27	-0.22
Company 177	3.78	0.19
Company 178	2.79	-0.54
Company 179	1.73	-2.78
Company 180	1.96	-1.74
Company 181	1.78	-0.08
Company 182	1.84	-0.65
Company 183	2.65	0.45
Company 184	1.79	-0.94
Company 185	3.54	0.78
Company 186	2.36	-0.12
Company 187	3.92	-0.49
Company 188	6.05	-7.67
Company 189	0.12	5.32
Company 190	6.21	-6.54
Company 191	0.23	5.12

Answer 1