Report Of Analysis About Heavenly Chocolates Web Site Transactions

Report of analysis about Heavenly Chocolates web site transactions

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.

There is a simply view on Table 1.1 about the 3 variables.
Table 1.1 Simply view on numerical summaries Time (min)
Pages Viewed
Amount Spent ($)
Mean
12.8
5
68.13
Median
11.4
5
62.15
Minimum
4.3
2
17.84
Maximum
32.9
10
158.51
Range
28.6
8
140.67
Variance
36.8
4
1046.12
Standard Deviation
6.1
2
32.34
Q1 (first quartile)
8.5
3
43.85
Q2 (second quartile)
11.4
5
62.15
Q3 (third quartile)
15.3
6
84.13
Total
640.5
241
3406.41

It will be more specific on Figures below to see each bin of every variable.

Figure 1.1 Frequency of the length of time

Figure 1.2 Frequency of pages viewed

Figure 1.3 Frequency of dollar amount spent

From the figures, it can be explored that most customers viewed the Web site below 16 minutes and less than 8 pages. Most of them spent no more than 90 dollars to buy the products.

It is straight to learn the change of 3 variables and how the data related to the mean in Figure 1.4.

Figure 1.4 Deep learning about variables with their means

As for amount spent of each transaction, it has a big up and down amount each customer so the mean of money has little meaning for report. However, data of each customer in pages viewed and time used is closed to the mean, it says that customer almost spent similar time to view the Web site and view similar pages to decide their buying behavior.

2. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week.

It is straight to learn the business behavior for every day from Table 2.1.
Table 2.1 Numerical summaries for each of the week
Day
Customers frequency
Totle dollars spent ($)
Mean amount spent ($)
Mon
9
813.38
90.38
Tue
7
414.86
59.27
Wed
6
341.82
56.97
Thu
5
294.03
58.81
Fri
11
945.43
85.95
Sat
7
378.74
54.11
Sun
5
218.15
43.63

According to Table 2.1, customers buy more products on Friday and Monday, but buy little on Thursday and Sunday. They also willing to spent more money on Friday and Monday. Sunday has little attractive to customers on buying behavior. It will be clearer of the change about customers’ behavior on every day in Figure 2.1.

Figure 2.1 Customers behavior on each day of week

3. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser.

It is straight to learn the business behavior for each type of browser from Table 3.1.

Table 3.1 Numerical summaries for each type of browser
Browser
Customers frequency
Totle dollars spent ($)
Mean amount spent ($)
Firefox
16
1228.21
76.76
Internet Explorer
27
1656.81
61.36
Other
7
521.39
74.48

According to Table 3.1, Internet Explorer is more popular in customers but their mean amount spent is minimum of the survey. People who use Firefox seem like to spent more money on buying behavior. It will be clearer of the change about customers’ behavior and the browser they used in Figure 3.1.
Figure 3.1 Customers’ behavior for using different browsers

4. Relationship between the time spent on the Web site and the dollar amount spent.

By computing, the correlation coefficient of time spent and dollar spent is 0.580047616. It is closer to positive 1 than 0. So there is a positive relationship between 2 variables which can also be observed in Figure 4.1. It can be concluded that the longer the customers view the Web site, the more money they spent to buy products.

Figure 4.1 Scatter diagram of time spent and dollar spent

5. Relationship between the number of Web site pages viewed and the dollar amount spent.

By computing, the correlation coefficient of Web site pages viewed and dollar spent is 0.723666923. It is closer to positive 1 than 0. So there is a strong positive relationship between 2 variables which can also be observed in Figure 5.1. That means people usually buy more if they viewed more Web site pages.

Figure 5.1 Scatter diagram of Web site pages viewed and dollar spent

6. Relationship between the time spent on the Web site and the number of pages viewed.

By computing, the correlation coefficient of time spent and the number of pages viewed is 0.595567524. It is closer to positive 1 than 0. So there is a positive relationship between 2 variables which can also be observed in Figure 6.1. It is saying that people viewed more pages will take longer time.

Figure 6.1 Scatter diagram of time spent and the number of pages viewed