Please use csv to solve the question
DATAl-_ HeavenlyChocoIates Pages Amount Customer Day Browser Time (min) Viewed Spent (S) 1 Mon Chrome 1 2.0 4 54.52 2 Wed Other 1 9.5 6 94.90 3 Mon Chrome 8.5 4 26.68 4 Tue Fire-fox 1 1.4 2 44.73 5 Wed Gnome 1 1.3 4 66.27 6 Sat Fimfox 10.5 6 67.80 7 Sun Chrome 1 1 .4 2 36.04 48 Fri Chrome 9.7 5 103.15 49 Mon Other 7.3 6 52.15 50 Fri Chrome 13.4 3 98.75 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. Managerial Report 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 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 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 coefcient 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 ndings. 5. Develop a scatter diagram, and compute the sample correlation coefcient 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 ndings. 6. Develop a scatter diagram, and compute the sample correlation coefcient 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 ndings. Customer Day Browser Time (min) Pages Viewed Amount Spent ($) 1 Mon Internet Explorer 12 4 54.52 2 Wed Other 19.5 6 94.9 3 Mon Internet Explorer 8.5 4 26.68 4 Tue Firefox 11.4 2 44.73 5 Wed Internet Explorer 11.3 4 66.27 6 Sat Firefox 10.5 6 67.8 Sun Internet Explorer 11.4 2 36.04 Fri Firefox 4.3 6 55.96 9 Wed Firefox 12.7 3 70.94 10 Tue Internet Explorer 24.7 68.73 11 Sat Other 13.3 6 54.04 12 Sun Firefox 14.3 5 48.05 13 Sun Other 11.7 7 64.16 14 Mon Firefox 24.4 10 158.51 15 Fri Internet Explorer 8.4 3 84.12 16 Thu Internet Explorer 9.6 4 59.2 17 Thu Internet Explorer 23.3 91.62 18 Mon Internet Explorer 14 126.4 19 Fri Other 5.6 4 68.45 20 Wed Internet Explorer 15.1 5 32.69 21 Sat Firefox 16.3 5 78.58 22 Tue Internet Explorer 10.2 6 74.43 23 Sun Internet Explorer 8 3 32.73 24 Tue Firefox 8 2 48.66 25 Fri Firefox 9.6 3 54.66 26 Wed Internet Explorer 11 2 40.54 27 Sat Internet Explorer 16.9 5 34.69 28 Sat Firefox 6 4 27.91 29 Fri Firefox 32.9 10 155.3 30 Mon Other 11.8 9 120.2531 Thu Internet Explorer 7.1 2 41.2 32 Fri Firefox 18 8 134.4 33 Sun Internet Explorer 11.8 4 37.17 34 Fri Internet Explorer 9.1 3 52.09 35 Tue Internet Explorer 7.8 5 71.81 36 Mon Firefox 16.5 5 59.99 37 Thu Firefox 6.2 4 84.17 38 Sat Internet Explorer 11.3 4 55.58 39 Tue Internet Explorer 10.6 2 39.06 40 Wed Internet Explorer 5 5 36.48 41 Tue Other 15.9 4 67.44 42 Sat Internet Explorer 18.1 7 60.14 43 Fri Firefox 10.8 4 70.38 44 Mon Internet Explorer 13.3 110.65 45 Mon Internet Explorer 30.1 6 104.23 46 Fri Firefox 13.7 4 68.17 47 Thu Internet Explorer 8. 1 2 17.84 48 Fri Internet Explorer 9.7 5 103.15 49 Mon Other 7.3 6 52.15 50 Fri Internet Explorer 13.4 3 98.75
