Excel Spreadsheet

Heavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago, the company developed a web site and began selling its products over the Internet. Web site sales have exceeded the company’s expectations, and management is now considering strategies to increase sales even further. To learn more about the web site customers, a sample of 50 Heavenly Chocolates transactions was selected from the previous month’s sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the web site, the number of web pages viewed, and the amount spent by each of the 50 customers are contained in the file

HeavenlyChocolates.

1. Graphical and numerical summaries for the length of time the shopper spends on the web site,

the number of pages viewed, and the mean amount spent per transaction. Please include

histograms and boxplot for each variable, and add detailed statistics including Mean, Standard

Deviation, Median, Mode, Variance, Minimum, Maximum, and Range. Discuss what you learn

about Heavenly Chocolates’ online shoppers from these numerical summaries. (for the

histogram plot: Plot of “Time”: lower group <=5, upper group >=30, bin width=2; Plot of

“Pages Viewed”: 10 bins; Plot of “Amount$”: bin width=20)

2. For each day of week, and for each type of browser: Summarize the frequency and the mean

amount spent per transaction. Discuss the observations you can make about Heavenly

Chocolates’ business based on the day of the week and the type of browser?

3. Develop a scatter chart, and compute the sample correlation coefficient to explore the

relationship between the time spent on the web site vs. the dollar amount spent, as well as web

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