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.

1. 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 transaction. Discuss what you learn about Heavenly Chocolates online shoppers from these numerical summaries. Please include at least one histogram, as well as a frequency table, bar chart and pie chart for the Browser data. SHOW ALL WORK AND FORMULAS USED 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 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