Q7) A retailer would like to know if the amount of time a customer spends online has an effect on the amount of money spent by the customer. The file Online_Shopping.xlsx has information on randomly selected customers who made an online purchase. The information contained in this file includes the amount of time each customer spent viewing items on the website (in minutes) and the dollar amount of their purchase. This data should be used to answer Questions 7 through 9.

Based on this data, how much of the variation in the dependent variable can be explained by the explanatory variable?

NOTE: Please enter a numerical value only, and round your response to 4 digits after the decimal point. For example, you would enter the value of .34561 as .3456 in the box below; and .34566 as .3457. If you do not follow these formatting and rounding rules, you may not receive credit for your answer. Q8) Based on the analysis of data in Question 7, are these two variables (amount of time spent viewing items on the website and the dollar amount of purchase) positively or negatively correlated?

Q9) Based on the analysis of data in Question 7, what is the point estimate of the dollar amount of purchase, if the customer stays and browses for 15 minutes? Could you calculate this point estimate using the actual values obtained in your analysis and not the rounded values used to answer the previous questions.

NOTE: Please enter a numerical value only, and round your response to 2 digits after the decimal point. Do not enter the dollar sign ($). For example, you would enter the value of $105.3447 as 105.34 in the box below; and $105.3456 as 105.35. The numbers below are not in thousands, ex: 61,57 is 61.57 , 73,57 is 73.57 etc etc

Time (Minutes)	Purchases ($)
18	61,57
18	73,57
34	84,65
13	68,17
20	69,33
29	85,25
33	87,77
22	79,09
37	88,29
27	82,49
26	72,61
22	75,09
28	75,37
30	76,13
17	63,69
19	62,45
20	68,33
31	74,01
34	76,65
28	75,37
16	69,81
28	71,37
19	63,45
27	77,49
33	76,77
32	73,89
14	57,05
21	74,21
13	69,17
38	83,17
33	77,77
29	72,25
15	60,93
38	83,17
31	72,01
14	67,05
32	74,89
13	71,17
25	69,73
23	64,97
29	78,25
36	81,41
32	81,89
21	70,21
19	72,45
13	62,17
14	63,05
14	72,05
14	60,05
36	77,41
32	77,89
25	75,73
33	80,77
18	68,57
28	74,37
34	76,65
34	76,65
36	85,41
35	78,53
19	68,45
25	73,73
13	70,17
32	81,89
36	77,41
26	80,61
35	88,53
18	69,57
36	76,41
33	75,77
15	69,93
36	91,41
27	75,49
37	91,29
21	74,21
32	77,89
38	84,17
26	80,61
24	68,85
36	81,41
24	78,85
18	61,57
34	84,65
18	75,57
22	68,09
28	83,37
20	71,33
19	63,45
33	75,77
21	73,21
22	78,09
13	58,17
18	61,57
24	75,85
33	77,77
33	76,77
38	92,17
31	85,01
23	70,97
35	89,53
21	73,21
32	75,89
31	85,01
37	89,29
17	66,69
15	64,93
31	76,01
21	74,21
16	70,81
34	88,65
24	67,85
14	64,05
27	81,49
30	79,13
32	73,89
34	78,65
37	88,29
16	73,81
19	73,45
30	85,13
28	73,37
23	76,97
38	81,17
21	67,21
13	63,17
27	78,49
19	68,45
23	77,97
24	66,85
27	81,49
19	66,45
36	77,41
16	59,81
33	79,77
21	69,21
25	67,73
23	65,97
20	73,33
25	80,73
26	71,61
16	73,81
19	63,45
35	78,53
14	66,05
26	73,61
28	79,37
25	75,73
27	69,49
24	73,85
37	91,29
26	82,61