QA. 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
pages viewed versus the amount spent. Discuss your findings.
QB. Although millions of elephants once roamed across Africa, by the mid-1980s elephant
populations in African nations had been devastated by poaching. Elephants are important to
African ecosystems. In tropical forests, elephants create clearings in the canopy that encourage
new tree growth. In savannas, elephants reduce bush cover to create an environment that is
favorable to browsing and grazing animals. In addition, the seeds of many plant species depend on
passing through an elephant’s digestive tract before germination.
1. Use the geometric mean calculation to find the mean annual change in elephant population for
each country in the 10-year period from 1979 to 1989, 18-year period from 1989 to 2007, and
5-year period from 2007 to 2012. High light those countries that have drop in the population based on the mean annual change. For each of these 3 intervals, list the largest average and
smallest average changes among countries in elephant population.
2. Make a multiple boxplot graph that includes boxplots of the elephant population observations
in each year (1979, 1989, 2007, 2012). Use these boxplots and the results of your analyses in
part 1 above to comment on how the populations of elephants have changed during these time
periods.
| Customer | Day | Browser | Time (min) | Pages Viewed | Amount Spent ($) |
| 1 | Mon | Chrome | 12.0 | 4 | 54.52 |
| 2 | Wed | Other | 19.5 | 6 | 94.90 |
| 3 | Mon | Chrome | 8.5 | 4 | 26.68 |
| 4 | Tue | Firefox | 11.4 | 2 | 44.73 |
| 5 | Wed | Chrome | 11.3 | 4 | 66.27 |
| 6 | Sat | Firefox | 10.5 | 6 | 67.80 |
| 7 | Sun | Chrome | 11.4 | 2 | 36.04 |
| 8 | Fri | Firefox | 4.3 | 6 | 55.96 |
| 9 | Wed | Firefox | 12.7 | 3 | 70.94 |
| 10 | Tue | Chrome | 24.7 | 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 | Chrome | 8.4 | 3 | 84.12 |
| 16 | Thu | Chrome | 9.6 | 4 | 59.20 |
| 17 | Thu | Chrome | 23.3 | 7 | 91.62 |
| 18 | Mon | Chrome | 14.0 | 7 | 126.40 |
| 19 | Fri | Other | 5.6 | 4 | 68.45 |
| 20 | Wed | Chrome | 15.1 | 5 | 32.69 |
| 21 | Sat | Firefox | 16.3 | 5 | 78.58 |
| 22 | Tue | Chrome | 10.2 | 6 | 74.43 |
| 23 | Sun | Chrome | 8.0 | 3 | 32.73 |
| 24 | Tue | Firefox | 8.0 | 2 | 48.66 |
| 25 | Fri | Firefox | 9.6 | 3 | 54.66 |
| 26 | Wed | Chrome | 11.0 | 2 | 40.54 |
| 27 | Sat | Chrome | 16.9 | 5 | 34.69 |
| 28 | Sat | Firefox | 6.0 | 4 | 27.91 |
| 29 | Fri | Firefox | 32.9 | 10 | 155.30 |
| 30 | Mon | Other | 11.8 | 9 | 120.25 |
| 31 | Thu | Chrome | 7.1 | 2 | 41.20 |
| 32 | Fri | Firefox | 18.0 | 8 | 134.40 |
| 33 | Sun | Chrome | 11.8 | 4 | 37.17 |
| 34 | Fri | Chrome | 9.1 | 3 | 52.09 |
| 35 | Tue | Chrome | 7.8 | 5 | 71.81 |
| 36 | Mon | Firefox | 16.5 | 5 | 59.99 |
| 37 | Thu | Firefox | 6.2 | 4 | 84.17 |
| 38 | Sat | Chrome | 11.3 | 4 | 55.58 |
| 39 | Tue | Chrome | 10.6 | 2 | 39.06 |
| 40 | Wed | Chrome | 5.0 | 5 | 36.48 |
| 41 | Tue | Other | 15.9 | 4 | 67.44 |
| 42 | Sat | Chrome | 18.1 | 7 | 60.14 |
| 43 | Fri | Firefox | 10.8 | 4 | 70.38 |
| 44 | Mon | Chrome | 13.3 | 7 | 110.65 |
| 45 | Mon | Chrome | 30.1 | 6 | 104.23 |
| 46 | Fri | Firefox | 13.7 | 4 | 68.17 |
| 47 | Thu | Chrome | 8.1 | 2 | 17.84 |
| 48 | Fri | Chrome | 9.7 | 5 | 103.15 |
| 49 | Mon | Other | 7.3 | 6 | 52.15 |
| 50 | Fri | Chrome | 13.4 | 3 | 98.75 |
| Country | 1979 Elephant Population | 1989 Elephant Population | 2007 Elephant Population | 2012 Elephant Population |
| Angola | 12,400 | 12,400 | 2,530 | 2,530 |
| Botswana | 20,000 | 51,000 | 175,487 | 175,454 |
| Cameroon | 16,200 | 21,200 | 15,387 | 14,049 |
| Cen African Rep | 63,000 | 19,000 | 3,334 | 2,285 |
| Chad | 15,000 | 3,100 | 6,435 | 3,004 |
| Congo | 10,800 | 70,000 | 22,102 | 49,248 |
| Dem Rep of Congo | 377,700 | 85,000 | 23,714 | 13,674 |
| Gabon | 13,400 | 76,000 | 70,637 | 77,252 |
| Kenya | 65,000 | 19,000 | 31,636 | 36,260 |
| Mozambique | 54,800 | 18,600 | 26,088 | 26,513 |
| Somalia | 24,300 | 6,000 | 70 | 70 |
| Tanzania | 316,300 | 80,000 | 167,003 | 117,456 |
| Zambia | 150,000 | 41,000 | 29,231 | 21,589 |
| Zimbabwe | 30,000 | 43,000 | 99,107 | 100,291 |