3:55HeavenlyChocolateXLSX 17 KBTime (min)CustomerDayBrowserPages ViewedAmount Spent ($)Chrome1Mon12.0454.52OtherWed19.52694.90Chrome3Mon8.5426.68Firefox4Tue11.4244.73Chrome5Wed11.3466.27Firefox67.806Sat10.56Chrome7Sun11.4236.048FriFirefox4.355.96Firefox9Wed12.7370.94Chrome68.7310Tue24.711SatOther13.354.04Firefox12Sun14.3548.0513SunOther11.7764.16Firefox14Mon24.410158.5Chrome15Fri8.4384.12ThuChrome169.6459.20Thu17Chrome23.391.62126.4018MonChrome14.0FriTotal $/day Avg $/day19Other5.6468.45Chrome20Wed15.1532.69Mon813.3890.38414.86246.92Firefox78.5859.2721Sat16.35TuesChrome22Tue10.2674.43Wed49.38ChromeFri23Sun8.0332.73945.4385.95Firefox378.7424Tue8.0248.66Sat54.11FirefoxFri218.15259.6354.66Sun43.63Chrome26Wed11.0240.54Chrome27Sat16.9534.69Firefox28Sat6.027.91Firefox29Fri32.910155.30Other30Mon11.8120.25ThuChrome317.1241.20Firefox134.4032Fri18.0Chrome33Sun11.8437.17FriChrome349.1352.09Chrome35Tue7.871.81FirefoxFirefox36Mon16.5559.99Thu84.17376.24Chrome38Sat11.3455.58Chrome39Tue10.6239.06WedChrome405.0536.48Other41Tue15.9467.44Chrome42Sat18.760.14Firefox43Fri10.8470.38Chrome44Mon13.3110.65Chrome45Mon30.16104.23Firefox68.1746Fri13.74ThuChrome478.1217.84Chrome48Fri9.75103.1549MonOther7.3652.15FriChrome5013.4398.75Open ExcelX

Question
Asked Sep 18, 2019

Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Discuss the observation you can make about heavenly chocolates business based on the type of browser? 

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
help_outline

Image Transcriptionclose

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

fullscreen
check_circle

Expert Answer

Step 1

From the given table the summarized ta...

Browser Total number of pages viewed Total Amount Spent Average
Chrome
27
1656.81
61.36
Firefox
1228.21
16
76.76
Other
7
521.39
74.48
help_outline

Image Transcriptionclose

Browser Total number of pages viewed Total Amount Spent Average Chrome 27 1656.81 61.36 Firefox 1228.21 16 76.76 Other 7 521.39 74.48

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Math

Statistics

Measures

Related Statistics Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Biologists conducted experiments to determine whter a deficiency of carbon dioxide in the soil affec...

A: For the given data, measures of center can be obtained.Mean: Arithmetic mean is the center value of ...

question_answer

Q: 3. A national retailer has completed an internal survey on its social media strategy. The key questi...

A: Let us first test whether “the opinion of the store manager” and “the region they belong to” are ind...

question_answer

Q: Please, I need a detailed and a step by step solutions to the problem. I don't have a strong backgro...

A: Hello, thank you for the question, Part c requires the use of other platform and the solution is too...

question_answer

Q: Determine the simplified sum of 7/24 and 1/6

A: The simplified sum is as follows:

question_answer

Q: A marble is drawn from a box containing 33 yellow, 22 white, and 19 blue marbles. Find the odds in f...

A: Odds in favour:The ratio of number of ways that an outcome can occur compared to how many ways it ca...

question_answer

Q: At Cityville High School, 36% of the students participate in sports, 36% of the students participate...

A: Consider S is an event when a student participates in sports and A is an event when a student partic...

question_answer

Q: A botanist is interested in flower growth around the fields of her house. She finds the flower growt...

A: Growth function is given by G(x) = 20 -3xIn the graph, G(x) will be on y-axis and minutes will be on...

question_answer

Q: Find the sample variance and standard deviation.21, 13, 6, 9, 12Choose the correct answer below. Fil...

A: The formula for sample variance is given by:

question_answer

Q: Question attached

A: Given Data2 independent variables and 65 observationsSSR = 12370.8 , SST =35963, Sb1=0.33, Sb2=0.20S...