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 companys 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 months 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