-
QUESTION
business analytics
Type of Paper Company Analysis
Order Instructions
upload all the info by email
| Subject | Business | Pages | 6 | Style | APA |
|---|
Answer
Week 4 – Business Analytics (ISYS3374)
Exercise
Number 1-4 are answered fully in the excel sheet.
The following data are collected from an online retailer that sells items via internet.
- Provide the scatter plot for the number of pages visited and time spent in the webpage.
This company does an online retail business for both first hand and second hand items. It is one of the renowned players in the global market. The company is imaginary hence the data has been generated by the author
- Provide the scatter plot for the number of pages visited and time spent in the webpage. Label the data in the plot by whether the person did a purchase or not?
- Provide the scatter plot for the number of pages visited and time spent in the webpage for those who purchased. Show the size of purchase in the plot.
- Summarise the data based on the type of browser used.
- What is the average purchase amount of people who spent between 20 and 30 seconds?
From the graph, only 4 people averagely 20-30 seconds in the website as marked green in the data table below
- What is the average purchase amount of people who spend between 10 and 20 seconds and visited less than or equal to 4 pages? (Hint: note that for this part you need to drag “number of pages visited” to the filter area in the pivot table and then when the filter appears in your pivot table, in the filter you need to only tick 1,2,3 and 4)
Only person 1 person visited the visited the website for between 10 and 20 seconds and visited less than or equal to 4 pages as marked yellow below.
|
Customer ID |
Time spend on web |
Number of page visited |
Purchase |
Browser |
|
1 |
18 |
6 |
10 |
Chrome |
|
2 |
17 |
7 |
0 |
Firefox |
|
3 |
39 |
4 |
25 |
Chrome |
|
4 |
23 |
4 |
0 |
Explorer |
|
5 |
48 |
10 |
96 |
Firefox |
|
6 |
26 |
6 |
23 |
Firefox |
|
7 |
54 |
2 |
0 |
Chrome |
|
8 |
15 |
6 |
50 |
Safari |
|
9 |
7 |
5 |
0 |
Firefox |
|
10 |
19 |
5 |
6 |
Chrome |
|
11 |
40 |
3 |
10 |
Chrome |
|
12 |
33 |
4 |
0 |
Firefox |
|
13 |
30 |
1 |
0 |
Safari |
|
14 |
57 |
8 |
65 |
Chrome |
|
15 |
49 |
5 |
0 |
Safari |
|
16 |
33 |
4 |
10 |
Chrome |
|
17 |
33 |
1 |
8 |
Safari |
|
18 |
41 |
2 |
10 |
Chrome |
|
19 |
35 |
5 |
97 |
Chrome |
|
20 |
51 |
3 |
0 |
Chrome |
|
21 |
44 |
4 |
18 |
Chrome |
|
22 |
13 |
2 |
10 |
Safari |
|
23 |
36 |
1 |
0 |
Chrome |
|
24 |
31 |
3 |
18 |
Safari |
|
25 |
63 |
4 |
16 |
Chrome |
|
26 |
43 |
7 |
0 |
Safari |
|
27 |
63 |
8 |
0 |
Chrome |
|
28 |
48 |
6 |
0 |
Explorer |
|
29 |
13 |
6 |
60 |
Safari |
|
30 |
44 |
2 |
0 |
Explorer |
|
31 |
23 |
7 |
18 |
Chrome |
|
32 |
34 |
6 |
79 |
Safari |
|
33 |
28 |
7 |
79 |
Safari |
|
34 |
42 |
3 |
0 |
Safari |