Question

Fill in the Blank: The marketing director Macy's is interested in analyzing the relationship between the company's weekly sales and the advertising dollars spent. A random sample of 20 weeks is collected with the recorded sales for each week and the amount spent on advertising.

Download the Excel file provided, run a regression analysis and fill in the blank cells. Then answer the questions using the information below. Assume a = 0.05 and t critical value of 1.734.

Round any decimals to the hundredths place (2 decimal places).

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

	df	SS	MS	F	Significance F
Regression	1	?	31,425,843.57	91.011	?
Residual	18	6,215,317.43	345,295.41
Total	19	37,641,161.00
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	460.57	330.39	1.394	0.1803	-233.56	1154.69
Advertising	9.70	1.02	?	0.0000	?	?

Answer 1