Question

Browser Customer Day Time (min) Pages Viewed Amount Spent (S) 1 Mor Chrome 12.0 54.52 2 Wed Other 19.5 94.90 Мор Chrome 8.5 26.68 Tue Firefox 11.4 2 44.73 Wed Chrome 11.3 66.27 Firefox 6 Sat 10.5 6 67.80 Sun Chrome 11.4 36.04 Fri Firefox 4,3 55.96 Wed Firefox 12.7 3 70.94 10 Tue Chrome 24.7 68.73 13.3 11 Sat Other 54.04 12 Sun Firefox 14.3 48.05 13 Sun Other 11.7 64.16 Firefox 14 Mor 24.4 10 158.51 15 Fri Chrome 8.4 84.12 16 Thu Chrome 9,6 59.20 17 Thu Chrome 23.3 91.62 18 Мор Chrome 14.0 7 126.40 Fri 19 Other 5.6 68.45 Wed 20 Chrome 15.1 32.69 Firefox 78.58 21 Sat 16.3 27 Tue Chrome 10.2 74.43 Sun Chrome 8.0 T 32.73 Firefox 24 Tue 8.0 48.66 25 Fri Firefox 9.6 T 54.66 Wed 26 Chrome 11.0 40.54 27 Sat Chrome 16.9 5 34.69 28 Sat Firefox 6.0 27.91 Fri Firefox 29 32 9 10 155.30 30 Mon Other 11.8 120.25 31 Thu Chrome 7.1 41.20 Fri Firefox 32 18.0 134,40 33 Sun Chrome 11.8 37.17 Fri 34 Chrome 9.1 52.09 35 Tue Chrome 78 5 71.81 16.5 36 Mon Firefox 59.99 Thu 6.2 84.17 32 Firefox 38 Sat Chrome 11.3 4 55.58 39 Tue Chrome 10.6 39.06 Wed 40 Chrome 5,0 36.48 41 Tue Other 15.9 67,44 47 Sat Chrome 18.1 60.14 43 Fri Firefox 10.8 70.38 40 Mor Chrome 13.3 110.65 45 Мор Chrome 30.1 6 104.23 46 Fri Firefox 13.7 68.17 Thu Chrome 8.1 17.84 48 Fri Chrome 97 103.15 49 Мо. Other 7.3 52.15 50 Fri Chrome 13.4 98.75

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 company’s 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 month’s 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 site pages viewed, and the amount spent by each of the 50 customers are contained in the file named Shoppers. The data is provided to you in the Excel file labeled “HeavenlyChocolates”.

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 from these numerical summaries (Included should be mean, median, mode, variance, standard deviation, five number summary and hisrograms). Use Excel for the histograms.

Answer 1

1.Answer Date: --23/6/2019 - - The descriptive statistics for the variables are obtained using Data Analysis pack in Excel is as follows: 1Click the Data tab in the menu bar. 2.Click on Data Analysis in the Analysis group 3.Choose Descriptive statistics from the list of Analysis tools. 4.Click OK. 5.Select the Input Range of the variables. 6.Check the Labels and Summary Statistics options. 7.Click OK. The descriptive statistics are obtained as follows: Statistics Time (min) Pages Viewed Amount Spent (S) Mean Standard Error 12.81 4.82 68.13 0.29 0.86 4.57 Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 11.4 4.5 62.15 11.4 4 #N/A 6.06 2.04 32.34 36.76 4.15 1046.12 0.17 2.40 0.88 1.45 0.65 1.05 28.6 8 140.67 4.3 2 17.84 32.9 10 158.51 640.5 241 3406.41 50 50 50

The histogram for the variable Time is obtained as follows: 1.Prepare Bin ranges before going to data analysis tool pack. 2.Click the Data tab in the menu bar. 3.Click Data Analysis in the Analysis group. 4.Choose Histogram from the list of Analysis tools. 5.Click OK. 6.Select the Input range of the variable. 7.Select Bin range. 8.Check the Labels and Chart Output options. 9.Click OK. The histogram obtained for the variable Time (min) spent on website is, Histogram 25 20 20 16 15 10 8 3 2 1 0 0 4.9 9.9 14.9 19.9 24.9 29.9 34.9 More Time (Min) The histogram obtained for number of pages viewed is, Frequency C

Histogram 20 18 18 15 16 14 12 10 7 7 8 6 3 4 0 0 2 4 6 8 10 More Pages Viewed Similarly the histogram obtained for Amount spent per transaction is, Frequeney

Histogram 16 14 12 10 8 6 4 2 Amount Spent (S) Part 1 The variables are right skewed. Frequeney 19.99 39.99 59.99 79.99 99.99 119.99 139.99 159.99 More