Question

Case Heavenly Chocolates Web Site Transactions .

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.

A portion of the data is shown in the table that follows:

Customer	Day	Browser	Time (Min)	Pages Viewed	Amount Spent ($)
1	Mon	IE	12.0	4	54.52
2	Wed	Other	19.5	6	94.90
3	Mon	IE	8.5	4	26.68
4	Tues	Firefox	11.4	2	44.73
5	Wed	IE	11.3	4	66.27
6	Sat	Firefox	10.5	6	67.80
7	Sun	IE	11.4	2	36.04
48	Fri	IE	9.7	5	103.15
49	Mon	Other	7.3	6	52.15
50	Fri	IE	13.4	3	98.75

Heavenly Chocolates Web Site Transactions 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.

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 Heavenly Chocolates’ business based on the day of the week? Discuss.

3.Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. What observations can you make about Heavenly Chocolate’s business based on the type of browser? Discuss.

PLEASE SHOW WHOLE WOORKBOOK PHOTO AND SHOW EXCEL FORMULAS. IF ANY CHARTS OR GRAPHS ARE USED PLEASE ADD A TEXT BOX WITH HOW YOU GENERATED THE ITEM. Thank you!

Answer 1

1.

The descriptive statistics for the variables are obtained using Data Analysis pack in Excel is as follows:

1.Click 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:

The mean and standard deviation of time spent on website are 12.81 and 6.06 minutes. The mean and standard deviation of number of pages viewed are 4.82 and 2.04. The mean and standard deviation of Amount spent are 68.13 and 32.34.

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,

The histogram obtained for number of pages viewed is,

Similarly the histogram obtained for Amount spent per transaction is,

2.

The frequency, total dollars spent and the mean amount spent per transaction for each day of the week are obtained as follows:

Day	No. of Transactions	Total Amount Spent	Average Amount Spent ($)
Sun	5	$218.15	$43.63
Mon	9	$813.38	$90.38
Tue	7	$414.86	$59.27
Wed	6	$341.82	$56.97
Thu	5	$294.03	$58.81
Fri	11	$945.43	$85.95
Sat	7	$378.74	$54.11
Total	50	$3,406.41	$68.13

3.

The frequency, total dollars spent and the mean amount spent per transaction for each type of browser are obtained as follows:

Browser	No. of Transactions	Total Amount Spent	Average Amount Spent ($)
Firefox	16	$1,228.21	$76.76
Internet Explorer	27	$1,656.81	$61.36
Other	7	$ 521.39	$74.48
Total	50	$3,406.41	$68.13