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 Heavenly Chocolates would like to use the sample data to determine whether online shoppers who spend more time and view more pages also spend more money during their visit to the web site. The company would also like to investigate the effect that the day of the week and the type of browser have on sales. Descriptive Statistics Chapter 2 Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates web site. Include the following in your report. 1. Graphical and numerical summaries for the length of time the shopper spends the web site, the number of pages viewed, and the mean amount spent per trans- action. Discuss what you learn about Heavenly 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. Discuss the observations you can make about Heavenly Chocolates' business based on the day of the week? 3. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Discuss the observations you can make about Heavenly Chocolates' business based on the type of browser? 4. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the dollar amount spent. Use the horizontal axis for the time spent on the web site. Discuss your findings. 5. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the number of web pages viewed and the amount spent. Use the horizontal axis for the number of web pages viewed. Discuss your findings. 6. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss your findings. Managerial Report on 241