BUS 207: Assignment 6 a) The independent variable for this data

BUS 207: Assignment 6
a) The independent variable for this data is ‘Advertising Expenses’.
b) The dependent variable for this data is ‘Sales’.
c)
$0 $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 $4,000
$0
$20,000
$40,000
$60,000
$80,000
$1,00,000
$1,20,000
$1,40,000 Sales Versus Advertising expenses
Advertising Expenditure
Sales
d)
$0 $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 $4,000
$0
$20,000
$40,000
$60,000
$80,000
$1,00,000
$1,20,000
$1,40,000
f(x) = 35.1667158221807 x + 6291.6576831365
R² = 0.885842411774408
Sales Versus Advertising expenses
Advertising Expenditure
Sales
e) Correlation coefficient , r = 0.9412 ; Coefficient of determination, R2 = 0.8858 ;
Slope of the regression line, b = 35.17 ; y-intercept of regression line, a = 6291.66
f) The value of the slope shows that there is a $35.17 increase in sales for every dollar
increase in advertising expenses.
g) The coefficient of correlation value, 0.9412, indicate that the two variables,
advertising expenses and sales, have strong and positive statistical relationship.
h) The coefficient of determination value, 0.8858, indicate that advertising expenses
explain 88.58% of the variation in sales.
i) Yes, at 0.01 level of significance, we can conclude that there is a positive
correlation between the advertising expenditure an sales for Woodbon. This is
because the ANOVA significance level of the linear regression analyses is less that
0.01.
ANOVA
df
SS
MS
F
Significance
F