a. Compute descriptive statistics for TIME, PAGES VIEWED, and AMOUNT SPENT [ Hin

Question

a. Compute descriptive statistics for TIME, PAGES VIEWED, and AMOUNT SPENT [Hint: Use the DATA ANALYSIS tool in Excel; choose DESCRIPTIVE STATISTICS; in the Input Range, enter D1:F51 – Excel will compute desstats for the three variables simultaneously.]

b. Compute the correlation coefficients among the three variables [Hint: Use the DATA ANALYSIS tool in Excel; choose CORRELATION; in the Input Range, enter D1:F51 – Excel will compute correlation coefficients for the three variables simultaneously.].

c. Using the Excel results, summarize the data and comment on your findings. Carefully interpret the correlation coefficient

Customer Day Browser Time (min) Pages Viewed Amount Spent ($) 1 Mon Internet Explorer 12.0 4 54.52 2 Wed Other 19.5 6 94.90 3 Mon Internet Explorer 8.5 4 26.68 4 Tue Firefox 11.4 2 44.73 5 Wed Internet Explorer 11.3 4 66.27 6 Sat Firefox 10.5 6 67.80 7 Sun Internet Explorer 11.4 2 36.04 8 Fri Firefox 4.3 6 55.96 9 Wed Firefox 12.7 3 70.94 10 Tue Internet Explorer 24.7 7 68.73 11 Sat Other 13.3 6 54.04 12 Sun Firefox 14.3 5 48.05 13 Sun Other 11.7 7 64.16 14 Mon Firefox 24.4 10 158.51 15 Fri Internet Explorer 8.4 3 84.12 16 Thu Internet Explorer 9.6 4 59.20 17 Thu Internet Explorer 23.3 7 91.62 18 Mon Internet Explorer 14.0 7 126.40 19 Fri Other 5.6 4 68.45 20 Wed Internet Explorer 15.1 5 32.69 21 Sat Firefox 16.3 5 78.58 22 Tue Internet Explorer 10.2 6 74.43 23 Sun Internet Explorer 8.0 3 32.73 24 Tue Firefox 8.0 2 48.66 25 Fri Firefox 9.6 3 54.66 26 Wed Internet Explorer 11.0 2 40.54 27 Sat Internet Explorer 16.9 5 34.69 28 Sat Firefox 6.0 4 27.91 29 Fri Firefox 32.9 10 155.30 30 Mon Other 11.8 9 120.25 31 Thu Internet Explorer 7.1 2 41.20 32 Fri Firefox 18.0 8 134.40 33 Sun Internet Explorer 11.8 4 37.17 34 Fri Internet Explorer 9.1 3 52.09 35 Tue Internet Explorer 7.8 5 71.81 36 Mon Firefox 16.5 5 59.99 37 Thu Firefox 6.2 4 84.17 38 Sat Internet Explorer 11.3 4 55.58 39 Tue Internet Explorer 10.6 2 39.06 40 Wed Internet Explorer 5.0 5 36.48 41 Tue Other 15.9 4 67.44 42 Sat Internet Explorer 18.1 7 60.14 43 Fri Firefox 10.8 4 70.38 44 Mon Internet Explorer 13.3 7 110.65 45 Mon Internet Explorer 30.1 6 104.23 46 Fri Firefox 13.7 4 68.17 47 Thu Internet Explorer 8.1 2 17.84 48 Fri Internet Explorer 9.7 5 103.15 49 Mon Other 7.3 6 52.15 50 Fri Internet Explorer 13.4 3 98.75

Explanation / Answer

(a)

(b)

(c) there is positive and significant ( alpha=0.05) correlation between all the three pairs of variable.

using correlation table

Time (min) Pages Viewed Amount Spent ($) Mean 12.81 4.82 68.1282 Standard Error 0.857482076 0.288118 4.574098102 Median 11.4 4.5 62.15 Standard Deviation 6.063313905 2.037305 32.34375786 Sample Variance 36.76377551 4.150612 1046.118672 Kurtosis 2.404049076 0.168787 0.876546457 Skewness 1.449831932 0.64639 1.049045436 Range 28.6 8 140.67 Minimum 4.3 2 17.84 Maximum 32.9 10 158.51 Sum 640.5 241 3406.41 Count 50 50 50

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.