3:55 HeavenlyChocolate XLSX 17 KB Time (min) Customer Day Browser Pages Viewed Amount Spent ($) Chrome 1 Mon 12.0 4 54.52 Other Wed 19.5 2 6 94.90 Chrome 3 Mon 8.5 4 26.68 Firefox 4 Tue 11.4 2 44.73 Chrome 5 Wed 11.3 4 66.27 Firefox 67.80 6 Sat 10.5 6 Chrome 7 Sun 11.4 2 36.04 8 Fri Firefox 4.3 55.96 Firefox 9 Wed 12.7 3 70.94 Chrome 68.73 10 Tue 24.7 11 Sat Other 13.3 54.04 Firefox 12 Sun 14.3 5 48.05 13 Sun Other 11.7 7 64.16 Firefox 14 Mon 24.4 10 158.5 Chrome 15 Fri 8.4 3 84.12 Thu Chrome 16 9.6 4 59.20 Thu 17 Chrome 23.3 91.62 126.40 18 Mon Chrome 14.0 Fri Total $/day Avg $/day 19 Other 5.6 4 68.45 Chrome 20 Wed 15.1 5 32.69 Mon 813.38 90.38 414.86 246.92 Firefox 78.58 59.27 21 Sat 16.3 5 Tues Chrome 22 Tue 10.2 6 74.43 Wed 49.38 Chrome Fri 23 Sun 8.0 3 32.73 945.43 85.95 Firefox 378.74 24 Tue 8.0 2 48.66 Sat 54.11 Firefox Fri 218.15 25 9.6 3 54.66 Sun 43.63 Chrome 26 Wed 11.0 2 40.54 Chrome 27 Sat 16.9 5 34.69 Firefox 28 Sat 6.0 27.91 Firefox 29 Fri 32.9 10 155.30 Other 30 Mon 11.8 120.25 Thu Chrome 31 7.1 2 41.20 Firefox 134.40 32 Fri 18.0 Chrome 33 Sun 11.8 4 37.17 Fri Chrome 34 9.1 3 52.09 Chrome 35 Tue 7.8 71.81 Firefox Firefox 36 Mon 16.5 5 59.99 Thu 84.17 37 6.2 4 Chrome 38 Sat 11.3 4 55.58 Chrome 39 Tue 10.6 2 39.06 Wed Chrome 40 5.0 5 36.48 Other 41 Tue 15.9 4 67.44 Chrome 42 Sat 18. 7 60.14 Firefox 43 Fri 10.8 4 70.38 Chrome 44 Mon 13.3 110.65 Chrome 45 Mon 30.1 6 104.23 Firefox 68.17 46 Fri 13.7 4 Thu Chrome 47 8.1 2 17.84 Chrome 48 Fri 9.7 5 103.15 49 Mon Other 7.3 6 52.15 Fri Chrome 50 13.4 3 98.75 Open Excel X Heavenly Chocolates 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. Descriptive Statistics Chapter 2 Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates web site. Include the following in your report. 1. Graphical and numerical summaries for the length of time the shopper spends the web site, the number of pages viewed, and the mean amount spent per trans- action. Discuss what you learn about Heavenly Chocolates' online shoppers from these numerical summaries. 2. 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 Heavenly Chocolates' business based on the day of the week? 3. 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 Heavenly Chocolates' business based on the type of browser? 4. Develop a scatter diagram, 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. 5. Develop a scatter diagram, 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. 6. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss your findings. Managerial Report on 241

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
3:55
HeavenlyChocolate
XLSX 17 KB
Time (min)
Customer
Day
Browser
Pages Viewed
Amount Spent ($)
Chrome
1
Mon
12.0
4
54.52
Other
Wed
19.5
2
6
94.90
Chrome
3
Mon
8.5
4
26.68
Firefox
4
Tue
11.4
2
44.73
Chrome
5
Wed
11.3
4
66.27
Firefox
67.80
6
Sat
10.5
6
Chrome
7
Sun
11.4
2
36.04
8
Fri
Firefox
4.3
55.96
Firefox
9
Wed
12.7
3
70.94
Chrome
68.73
10
Tue
24.7
11
Sat
Other
13.3
54.04
Firefox
12
Sun
14.3
5
48.05
13
Sun
Other
11.7
7
64.16
Firefox
14
Mon
24.4
10
158.5
Chrome
15
Fri
8.4
3
84.12
Thu
Chrome
16
9.6
4
59.20
Thu
17
Chrome
23.3
91.62
126.40
18
Mon
Chrome
14.0
Fri
Total $/day Avg $/day
19
Other
5.6
4
68.45
Chrome
20
Wed
15.1
5
32.69
Mon
813.38
90.38
414.86
246.92
Firefox
78.58
59.27
21
Sat
16.3
5
Tues
Chrome
22
Tue
10.2
6
74.43
Wed
49.38
Chrome
Fri
23
Sun
8.0
3
32.73
945.43
85.95
Firefox
378.74
24
Tue
8.0
2
48.66
Sat
54.11
Firefox
Fri
218.15
25
9.6
3
54.66
Sun
43.63
Chrome
26
Wed
11.0
2
40.54
Chrome
27
Sat
16.9
5
34.69
Firefox
28
Sat
6.0
27.91
Firefox
29
Fri
32.9
10
155.30
Other
30
Mon
11.8
120.25
Thu
Chrome
31
7.1
2
41.20
Firefox
134.40
32
Fri
18.0
Chrome
33
Sun
11.8
4
37.17
Fri
Chrome
34
9.1
3
52.09
Chrome
35
Tue
7.8
71.81
Firefox
Firefox
36
Mon
16.5
5
59.99
Thu
84.17
37
6.2
4
Chrome
38
Sat
11.3
4
55.58
Chrome
39
Tue
10.6
2
39.06
Wed
Chrome
40
5.0
5
36.48
Other
41
Tue
15.9
4
67.44
Chrome
42
Sat
18.
7
60.14
Firefox
43
Fri
10.8
4
70.38
Chrome
44
Mon
13.3
110.65
Chrome
45
Mon
30.1
6
104.23
Firefox
68.17
46
Fri
13.7
4
Thu
Chrome
47
8.1
2
17.84
Chrome
48
Fri
9.7
5
103.15
49
Mon
Other
7.3
6
52.15
Fri
Chrome
50
13.4
3
98.75
Open Excel
X
Transcribed Image Text:3:55 HeavenlyChocolate XLSX 17 KB Time (min) Customer Day Browser Pages Viewed Amount Spent ($) Chrome 1 Mon 12.0 4 54.52 Other Wed 19.5 2 6 94.90 Chrome 3 Mon 8.5 4 26.68 Firefox 4 Tue 11.4 2 44.73 Chrome 5 Wed 11.3 4 66.27 Firefox 67.80 6 Sat 10.5 6 Chrome 7 Sun 11.4 2 36.04 8 Fri Firefox 4.3 55.96 Firefox 9 Wed 12.7 3 70.94 Chrome 68.73 10 Tue 24.7 11 Sat Other 13.3 54.04 Firefox 12 Sun 14.3 5 48.05 13 Sun Other 11.7 7 64.16 Firefox 14 Mon 24.4 10 158.5 Chrome 15 Fri 8.4 3 84.12 Thu Chrome 16 9.6 4 59.20 Thu 17 Chrome 23.3 91.62 126.40 18 Mon Chrome 14.0 Fri Total $/day Avg $/day 19 Other 5.6 4 68.45 Chrome 20 Wed 15.1 5 32.69 Mon 813.38 90.38 414.86 246.92 Firefox 78.58 59.27 21 Sat 16.3 5 Tues Chrome 22 Tue 10.2 6 74.43 Wed 49.38 Chrome Fri 23 Sun 8.0 3 32.73 945.43 85.95 Firefox 378.74 24 Tue 8.0 2 48.66 Sat 54.11 Firefox Fri 218.15 25 9.6 3 54.66 Sun 43.63 Chrome 26 Wed 11.0 2 40.54 Chrome 27 Sat 16.9 5 34.69 Firefox 28 Sat 6.0 27.91 Firefox 29 Fri 32.9 10 155.30 Other 30 Mon 11.8 120.25 Thu Chrome 31 7.1 2 41.20 Firefox 134.40 32 Fri 18.0 Chrome 33 Sun 11.8 4 37.17 Fri Chrome 34 9.1 3 52.09 Chrome 35 Tue 7.8 71.81 Firefox Firefox 36 Mon 16.5 5 59.99 Thu 84.17 37 6.2 4 Chrome 38 Sat 11.3 4 55.58 Chrome 39 Tue 10.6 2 39.06 Wed Chrome 40 5.0 5 36.48 Other 41 Tue 15.9 4 67.44 Chrome 42 Sat 18. 7 60.14 Firefox 43 Fri 10.8 4 70.38 Chrome 44 Mon 13.3 110.65 Chrome 45 Mon 30.1 6 104.23 Firefox 68.17 46 Fri 13.7 4 Thu Chrome 47 8.1 2 17.84 Chrome 48 Fri 9.7 5 103.15 49 Mon Other 7.3 6 52.15 Fri Chrome 50 13.4 3 98.75 Open Excel X
Heavenly Chocolates 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.
Descriptive Statistics
Chapter 2
Use the methods of descriptive statistics to learn about the customers who visit the
Heavenly Chocolates web site. Include the following in your report.
1. Graphical and numerical summaries for the length of time the shopper spends
the web site, the number of pages viewed, and the mean amount spent per trans-
action. Discuss what you learn about Heavenly Chocolates' online shoppers from
these numerical summaries.
2. 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
Heavenly Chocolates' business based on the day of the week?
3. 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
Heavenly Chocolates' business based on the type of browser?
4. Develop a scatter diagram, 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.
5. Develop a scatter diagram, 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.
6. Develop a scatter diagram, and compute the sample correlation coefficient to
explore the relationship between the time spent on the web site and the number of
pages viewed. Use the horizontal axis to represent the number of pages viewed.
Discuss your findings.
Managerial Report
on
241
Transcribed Image Text:Heavenly Chocolates 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. Descriptive Statistics Chapter 2 Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates web site. Include the following in your report. 1. Graphical and numerical summaries for the length of time the shopper spends the web site, the number of pages viewed, and the mean amount spent per trans- action. Discuss what you learn about Heavenly Chocolates' online shoppers from these numerical summaries. 2. 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 Heavenly Chocolates' business based on the day of the week? 3. 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 Heavenly Chocolates' business based on the type of browser? 4. Develop a scatter diagram, 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. 5. Develop a scatter diagram, 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. 6. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss your findings. Managerial Report on 241
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 4 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman