Reference no: EM13519492

x y
Advertising Weekly Sales
$180 $2,050
$243 $3,760
$204 $1,897
$199 $2,567
$356 $4,330
$605 $5,670
$200 $2,356
$304 $3,456
$105 $1,254
$379 $4,300
$300 $3,250
$402 $4,680
$399 $4,200
$209 $2,400
$245 $1,890
$190 $3,600
$480 $5,700
$515 $5,690
$300 $2,300
$145 $1,700

The Greenfield Service Company's marketing director is interested in analyzing the relationship between her company's sales and the advertising dollars spent. In the course of her analysis, she selected a random sample of 20 weeks and recorded the sales for each week and the amount spent on advertising. These data are contained in the data file called Greenfield.

The Marketing director wishes to know if increasing the amount spent on advertising increases sales. As a first attempt, use a statistical test that will provide the required information. Use a significance level of 0.025. On careful consideration, the marketing manager realizes that it takes a certain amount level of 0.025. On careful consideration, the marketing manager realizes that it takes a certain amount calculate a correlation coefficient for sales of the current week against amount of advertising spent in the previous week and to conduct a hypthesis test to determine if, under this model, increasing the amount spent on advertising increases sales. Again, use a significance level of 0.025.