Chat with us, powered by LiveChat DAT565_Week5_Discussion.xlsx - STUDENT SOLUTION USA

ScatterPlot

Advertisement ($'000) Sales ($'000)
1068 4489
1026 5611
767 3290
885 4113
1156 4883
1146 5425
892 4414
938 5506
769 3346
677 3673
1184 6542
1009 5088
Slope 4.9215957983
Intercept -25.1682340648

Scatter Plot of Sales & Advertisement

Sales ($'000)

y = 4.9216x – 25.168

R² = 0.6785

106810267678851156114689293876967711841009448956113290411348835425441455063346367365425088

Advertisement ($'000)

Sales ($'000)

Regression

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.8237332977
R Square 0.6785365458
Adjusted R Square 0.6463902004
Standard Error 592.7335727464
Observations 12
ANOVA
df SS MS F Significance F
Regression 1 7415845.78405917 7415845.78405917 21.1077351717 0.0009886904
Residual 10 3513330.8826075 351333.08826075
Total 11 10929176.6666667
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -25.1682340648 1042.2599271088 -0.0241477518 0.9812098234 -2347.4680715242 2297.1316033947 -2347.4680715242 2297.1316033947
X Variable 1 4.9215957983 1.0712359149 4.5943155281 0.0009886904 2.5347334365 7.30845816 2.5347334365 7.30845816
error: Content is protected !!