Determine if there is a significant correlation between the number of days since a sales campaign started, whether it is a weekday or weekend, and the sales at a particular store. Copy and paste information from the ESP Excel sheet, including the p-value and summarize your results.
Days after sales campaign
Weekday (Monday to Thursday) = 0
Weekend (Friday to Sunday) = 1
Post-sales campaign
1
0
$7,000
2
$7,500
3
$8,000
4
$8,500
5
6
7
8
9
$9,000
10
$9,500
11
$10,000
12
$11,000
13
$11,500
14
$12,000
a. Is the model significant?
b. What is the adjusted coefficient of determination and what does it mean for this problem?
c. What is the slope between the first independent variable and the dependent variable of the regression equation? Is it significant? If so, what does it mean about this problem?
d. What is the slope between the second independent variable and the dependent variable of the regression equation? Is it significant? If so, what does it mean about this problem?
e. Predict a value for the sales on a weekday for day 15.
f. Get a 95% prediction interval.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here