OnlineNursingOwl
← All nursing posts

Accounting · Studypool

Excel Spreadsheet

Overview

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 Chocolates 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 pages viewed, and the amount spent by each of the 50 customers are contained in the file

HeavenlyChocolates.

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. Please include

histograms and boxplot for each variable, and add detailed statistics including Mean, Standard

Deviation, Median, Mode, Variance, Minimum, Maximum, and Range. Discuss what you learn

about Heavenly Chocolates’ online shoppers from these numerical summaries. (for the

histogram plot: Plot of “Time”: lower group <=5, upper group >=30, bin width=2; Plot of

“Pages Viewed”: 10 bins; Plot of “Amount$”: bin width=20)

2. For each day of week, and for each type of browser: Summarize the frequency and the mean

amount spent per transaction. Discuss the observations you can make about Heavenly

Chocolates’ business based on the day of the week and the type of browser?

3. Develop a scatter chart, and compute the sample correlation coefficient to explore the

relationship between the time spent on the web site vs. the dollar amount spent, as well as web