MIS604 week 1 homework

Directions

Respond in detail to each question with at least 1-2 summary paragraph. Review the rubric prior to responding.

Parkville Candies would like to use the sample data to determine whether online shoppers who spend more time and view more pages also spend more money during their visit to the web site. The company would also like to investigate the effect that the day of the week and the type of browser have on sales. managerial Report

Use the methods of descriptive statistics to learn about the customers who visit the Parkville Candies web site. Include the following in your report.

Add an additional 10 rows of data to the existing table prior to your analysis. Using the 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 trans-action. Discuss what you learn about Parkville Candies’ online shoppers from these numerical summaries.

Note, You will include the data table as an upload to the assignment. The purpose of adding the additional data roles is to ensure academic integrity and to provide you with the opportunity to have unique sets of data.

Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week. Discuss the observations you can make about Parkville Candies’ business based on the day of the week?

Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Discuss the observations you can make about Parkville Candies’ business based on the type of browser?

Develop a scatter chart, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the dollar amount spent. Use the horizontal axis for the time spent on the web site. Discuss your findings.

Develop a scatter chart, and compute the sample correlation coefficient to explore the relationship between the number of web pages viewed and the amount spent. Use the horizontal axis for the number of web pages viewed. Discuss your findings.

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
Tue
Wed
Mon
Mon
Wed
Sat
Sun
Sat
Wed
Tue
Sat
Mon
Mon
Mon
Fri
Thu
Thu
Mon
Fri
Wed
Tue
Tue
Sun
Tue
Fri
Wed
Sat
Fri
Fri
Mon
Thu
Fri
Sun
Fri
Tue
Sun
Thu
Sat
Tue
Wed
Tue
Thu
Fri
Thu
Browser
Google
Edge
Google
Safari
Google
Edge
Google
Safari
Safari
Google
Edge
Safari
Other
Safari
Google
Google
Google
Google
Edge
Google
Safari
Google
Google
Safari
Safari
Google
Google
Safari
Safari
Other
Google
Safari
Google
Google
Google
Safari
Safari
Google
Google
Google
Other
Google
Safari
Google
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
Thu
Fri
Thu
Fri
Mon
Fri
Google
Safari
Google
Google
Other
Google
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
Add in 10 additional rows of data prior to conducting y
conducting your analysis