Question

Heavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago, the company developed a web site and began selling its products over the Internet. Web-site sales have exceeded the company’s expectations, and management is now considering strategies to increase sales even further. To learn more about the web-site customers, a sample of 50 Heavenly Chocolate transactions was selected from the previous month’s sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the web site, the number of web pages viewed, and the amount spent by each of the 50 customers are contained in the file named HeavenlyChocolates.

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? SHOW ALL WORK AND FORMULAS IN EXCEL!!!

Customer Pages Viewed Time (min) 12.0 19.5 8.5 11.4 113 WONG 10.5 11.4 4.3 12.7 24.7 13.3 14.3 11.7 24.4 8.4 Day Mon Wed Mon Tue Wed Sat Sun Fri Wed Tue Sat Sun Sun Mon Fri Thu Thu Mon Fri Wed Sat Tue Sun Tue Fri Wed Sat Sat Fri Mon Thu Fri Sun Fri Tue Mon Thu 23.3 14.0 5.6 15.1 16.3 10.2 8.0 8.0 Browser Internet Explorer Other Internet Explorer Firefox Internet Explorer Firefox Internet Explorer Firefox Firefox Internet Explorer Other Firefox Other Firefox Internet Explorer Internet Explorer Internet Explorer Internet Explorer Other Internet Explorer Firefox Internet Explorer Internet Explorer Firefox Firefox Internet Explorer Internet Explorer Firefox Firefox Other Internet Explorer Firefox Internet Explorer Internet Explorer Internet Explorer Firefox Firefox Internet Explorer Internet Explorer Internet Explorer Other Internet Explorer Firefox Internet Explorer Internet Explorer Firefox Internet Explorer Internet Explorer Other Internet Explorer 9.6 11.0 16.9 6.0 32.9 11.8 7.1 18.0 11.8 NOWANANOWANO ANWNWANA Amount Spent (5) 54.52 94.90 26.68 44.73 66.27 67 80 36.04 55.96 70.94 68.73 54.04 48.05 64.16 158.51 84.12 59.20 91.62 126.40 68.45 32.69 78.58 74.43 32.73 48.66 54.66 40.54 34.69 27.91 155.30 120.25 41.20 134.40 37.17 52.09 71.81 59.99 84.17 55.58 39.06 36.48 6744 60.14 70.38 110.65 104 23 68.17 17.84 103.15 52.15 98.75 9.1 7.8 16.5 62 Sal 11.3 10.6 5.0 15.9 18.1 10.8 13.3 Tue Wed Tue Sat Fri Mon Mon Fri Thu Fri Mon Fri 30.1 13.7 8.1 9.7 7.3 134

Answer 1

Total Dollars Spent = 3406.31 dollars

Row Labels	Sum of Amount Spent ($)
Sun	218.15
Mon	813.38
Tue	414.86
Wed	341.82
Thu	294.03
Fri	945.43
Sat	378.64
Grand Total	3406.31

Observation: It can be seen from above table that most of the amount is Spent on Fridays and least amount is spent on Sundays

Row Labels	Sum of Amount Spent ($)
Firefox	1228.21
Internet Explorer	1656.71
Other	521.39
Grand Total	3406.31

Observation: 48.62 % of Customers use Internet Explorer as their Browser. Company can plan to use digital media to advertise more through Internet Explorer.

Row Labels	Sum of Pages Viewed
Sun	21
Mon	58
Tue	28
Wed	25
Thu	19
Fri	53
Sat	37
Grand Total	241

Observation: Most Pages are viewed on Mondays