Case Heavenly Chocolates Web Site Transactions .
Heavenly Chocolates manufactures and sells quality chocolateproducts at its plant and retail store located in Saratoga Springs,New York. Two years ago, the company developed a Web site and beganselling its products over the Internet. Web site sales haveexceeded the company’s expectations, and management is nowconsidering strategies to increase sales even further. To learnmore about the Web site customers, a sample of 50 HeavenlyChocolate transactions was selected from the previous month’ssales. Data showing the day of the week each transaction was made,the type of browser the customer used, the time spent on the Website, the number of Web site pages viewed, and the amount spent byeach of the 50 customers are contained in the file namedShoppers.
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 Chocolateswould like to use the sample data to determine whether onlineshoppers who spend more time and view more pages also spend moremoney during their visit to the Web site. The company would alsolike to investigate the effect that the day of the week and thetype of browser have on sales.
Managerial Report
Use the methods of descriptive statistics to learn about thecustomers who visit the Heavenly Chocolates Web site. Include thefollowing in your report.
1.Graphical and numerical summaries for the length of time theshopper spends on the Web site, the number of pages viewed, and themean amount spent per transaction. Discuss what you learn aboutHeavenly Chocolates’ online shoppers from these numericalsummaries.
2.Summarize the frequency, the total dollars spent, and the meanamount spent per transaction for each day of week. Whatobservations can you make about Heavenly Chocolates’ business basedon the day of the week? Discuss.
3.Summarize the frequency, the total dollars spent, and the meanamount spent per transaction for each type of browser. Whatobservations can you make about Heavenly Chocolate’s business basedon the type of browser? Discuss.
PLEASE SHOW WHOLE WOORKBOOK PHOTO AND SHOW EXCEL FORMULAS. IFANY CHARTS OR GRAPHS ARE USED PLEASE ADD A TEXT BOX WITH HOW YOUGENERATED THE ITEM. Thank you!
