J&J Chocolates Online

Buying chocolate online is always an original way to surprise family and friends on Christmas, birthdays, Valentine's Day or other special occasions. The wide range of exquisite gift ideas you can find on their website will exceed your expectations.

J&J Chocolates manufactures and sells high-quality and specialty chocolate products at its factory plant and retail store located in central New Jersey. A couple of years ago, the company developed its e-commerce website and began selling its products over the Internet. Website sales have exceeded the companys expectations, and management is now considering strategy to increase sales even further. To learn more about the website customers, a sample of 50 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 website, the number of website pages viewed, and the amount spent by each of the 50 customers are contained in the company Excel file named Shoppers.exl.

J&J Chocolates would like to use the sample data to study its customers behavior and determine if online shoppers who spend more time and view more pages also spend more money during their visit to the website. The company would also like to investigate the effect that the day of the week and the type of browser have on sales.

The project requires a report in a professional format. The total pages are limited to no more than 10 pages. You may have snapshots of Excel in the report.

Managerial Report:

Use the methods of descriptive statistics to learn about the customers who visit the J&J Chocolates website. Include the following in your report.

1. Graphical and numerical summaries for (1) the length of time the shopper spends on the website, (2) the number of pages viewed, and (3) the mean amount spent per transaction. Discuss what you learn about J&J 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. What observations can you make about J&J Chocolates business based on the day of the week, from Monday through Sunday? Please try to provide insightful discussion.

3. Develop a scatter diagram and compute the sample correlation coefficient to explore the relationship between (1) the time spent on the website and (2) the dollar amount spent. Use the horizontal axis for the time spent on the website. Some discussion is expected.

4. Develop a scatter diagram and compute the sample correlation coefficient to explore the relationship between (1) the number of website pages viewed and (2) the dollar amount spent. Use the horizontal axis for the number of website pages viewed. Discuss please.

5. Develop a scatter diagram and compute the sample correlation coefficient to explore the relationship between (1) the time spent on the website and (2) the number of website pages viewed. Use the horizontal axis to represent the number of website pages viewed. Discuss please.

6. Based on the observation and results above, please develop some strategy or business solutions for J&J Chocolates.

Customer Day Wed 1 2 Mon 3 4 5 Mon Tue Wed Sat Sun 6 Browser Other Internet Explorer Internet Explorer Firefox Internet Explorer Firefox Internet Explorer Firefox Firefox Internet Explorer Other Firefox 7 8 Fri 9 Wed 10 Tue Sat 11 12 Sun Sun 13 Other 14 15 16 Mon Fri Thu Thu 17 18 Mon 19 20 21 22 23 Fri Wed Sat Tue Sun Tue Fri Wed Sat 24 25 Time (min) Pages Viewed Amount Spent (S) 17.5 4 109.00 12.0 4 54.52 8.5 4 26.68 11.4 2 44.73 11.3 4 66.27 10.5 6 67.80 11.4 2 36.04 4.3 6 55.96 12.7 3 70.94 24.7 7 68.73 13.3 6 54.04 14.3 5 48.05 11.7 7 64.16 24.4 10 158.51 8.4 3 84.12 9.6 4 59.20 23.3 7 91.62 14.0 7 126.40 5.6 4 68.45 15.1 5 32.69 16.3 5 78.58 10.2 6 74.43 8.0 3 32.73 8.0 2 48.66 9.6 3 54.66 11.0 2 40.54 16.9 5 34.69 6.0 4 27.91 32.9 10 155.30 11.8 9 120.25 7.1 2 41.20 18.0 8 134.40 11.8 4 37.17 9.1 3 52.09 7.8 5 71.81 16.5 5 59.99 6.2 4 84.17 11.3 4 55.58 10.6 2 39.06 5.0 5 36.48 15.9 4 67.44 18.1 7 60.14 10.8 4 70.38 13.3 7 110.65 30.1 6 104.23 13.7 4 68.17 8.1 2 17.84 9.7 5 103.15 7.3 6 52.15 13.4 3 98.75 26 27 28 Sat 29 30 Fri Mon Thu Fri 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 31 32 33 Sun Fri 34 35 36 Tue Mon Thu 37 38 39 Sat Tue Wed 40 41 Tue 42 Sat 43 Fri 44 45 46 47 Mon Mon Fri Thu Fri Mon Fri 48 49 50 Customer Day Wed 1 2 Mon 3 4 5 Mon Tue Wed Sat Sun 6 Browser Other Internet Explorer Internet Explorer Firefox Internet Explorer Firefox Internet Explorer Firefox Firefox Internet Explorer Other Firefox 7 8 Fri 9 Wed 10 Tue Sat 11 12 Sun Sun 13 Other 14 15 16 Mon Fri Thu Thu 17 18 Mon 19 20 21 22 23 Fri Wed Sat Tue Sun Tue Fri Wed Sat 24 25 Time (min) Pages Viewed Amount Spent (S) 17.5 4 109.00 12.0 4 54.52 8.5 4 26.68 11.4 2 44.73 11.3 4 66.27 10.5 6 67.80 11.4 2 36.04 4.3 6 55.96 12.7 3 70.94 24.7 7 68.73 13.3 6 54.04 14.3 5 48.05 11.7 7 64.16 24.4 10 158.51 8.4 3 84.12 9.6 4 59.20 23.3 7 91.62 14.0 7 126.40 5.6 4 68.45 15.1 5 32.69 16.3 5 78.58 10.2 6 74.43 8.0 3 32.73 8.0 2 48.66 9.6 3 54.66 11.0 2 40.54 16.9 5 34.69 6.0 4 27.91 32.9 10 155.30 11.8 9 120.25 7.1 2 41.20 18.0 8 134.40 11.8 4 37.17 9.1 3 52.09 7.8 5 71.81 16.5 5 59.99 6.2 4 84.17 11.3 4 55.58 10.6 2 39.06 5.0 5 36.48 15.9 4 67.44 18.1 7 60.14 10.8 4 70.38 13.3 7 110.65 30.1 6 104.23 13.7 4 68.17 8.1 2 17.84 9.7 5 103.15 7.3 6 52.15 13.4 3 98.75 26 27 28 Sat 29 30 Fri Mon Thu Fri 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 31 32 33 Sun Fri 34 35 36 Tue Mon Thu 37 38 39 Sat Tue Wed 40 41 Tue 42 Sat 43 Fri 44 45 46 47 Mon Mon Fri Thu Fri Mon Fri 48 49 50