The manager of a discount store would like to determine whether there is a relat
ID: 3390448 • Letter: T
Question
The manager of a discount store would like to determine whether there is a relationship between the number of customers who visit the store each day and the dollar value of sales that day. A random sample of 20 days was taken and the number of customers in the store and the dollar value of sales were recorded for each day. The sample results are shown below.
Day
Customers
Sales
Day
Customers
Sales
1
907
11,200
11
679
7,630
2
926
11,050
12
872
9,430
3
506
6,840
13
924
9,460
4
741
9,210
14
607
7,640
5
789
9,420
15
452
6,920
6
889
10,080
16
729
8,950
7
874
9,450
17
794
9,330
8
510
6,730
18
844
10,230
9
529
7,240
19
1010
11,770
10
420
6,120
20
621
7,410
As a part of the study, the manager would like to estimate the correlation between the two variables and conduct a test to determine if the linear relationship between sales and customers is positive.
What % of the variation in the dependent variable is explained by the independent variable?
Day
Customers
Sales
Day
Customers
Sales
1
907
11,200
11
679
7,630
2
926
11,050
12
872
9,430
3
506
6,840
13
924
9,460
4
741
9,210
14
607
7,640
5
789
9,420
15
452
6,920
6
889
10,080
16
729
8,950
7
874
9,450
17
794
9,330
8
510
6,730
18
844
10,230
9
529
7,240
19
1010
11,770
10
420
6,120
20
621
7,410
Explanation / Answer
Sol)
The regression equation is
y=a+bx
where y is sales and x is customers
From above analysis
correlation coefficient is 0.9549. There is Positive correlation between two variables
And The fitted regression equation is
y=2423.044 +8.729 (customers)
And % of the variation in the dependent variable is explained by the independent variable is R2 =0.911
SUMMARY OUTPUT Regression Statistics Multiple R 0.954913 R Square 0.911859 Adjusted R Square 0.906963 Standard Error 501.4952 Observations 20 ANOVA df SS MS F Regression 1 46833541 46833541 186.2188 Residual 18 4526954 251497.5 Total 19 51360495 Coefficients Standard Error t Stat P-value Intercept 2423.044 480.9646 5.037885 8.55E-05 Customers 8.729338 0.63969 13.6462 6.21E-11Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.