Case Problem: Heavenly Chocolates Web Site Transactions

HeavenlyChocolatesmanufacturesandsellsqualitychocolateproductsatitsplantandretailstorelocatedinSaratogaSprings,NewYork.Twoyearsago,thecompanydevelopedawebsiteandbegansellingitsproductsovertheInternet.Websitesaleshaveexceededthecompanysexpectations,andmanagementisnowconsideringstrategiestoincreasesalesevenfurther.Tolearnmoreaboutthewebsitecustomers,asampleof50HeavenlyChocolatetransactionswasselectedfromthepreviousmonthssales.Datashowingthedayoftheweekeachtransactionwasmade,thetypeofbrowserthecustomerused,thetimespentonthewebsite,thenumberofwebpagesviewed,andtheamountspentbyeachofthe50customersarecontainedinthefilenamedHeavenlyChocolates.(PleaserefertotheHeavenlyChocolatesData)

Heavenly Chocolates would like to use the sample data to determine whether onlineshoppers who spend more time and view more pages also spend more money during theirvisit to the web site. The company would also like to investigate the effect that the day of theweek and the type of browser have on sales.

ManagerialReportUse the methods of descriptive statistics to learn about the customers who visit theHeavenly Chocolates web site. Include the following in your report.

1.Graphicalandnumericalsummariesforthelengthoftimetheshopperspendsonthewebsite,thenumberofpagesviewed,andthemeanamountspentpertransaction.Discusswhatyou learn about Heavenly Chocolates online shoppers from these numerical summaries.

2.Summarizethefrequency,thetotaldollarsspent,andthemeanamountspentpertransactionforeachdayofweek.DiscusstheobservationsyoucanmakeaboutHeavenlyChocolates business based on the day of the week?

3.Summarizethefrequency,thetotaldollarsspent,andthemeanamountspentpertransactionforeachtypeofbrowser.DiscusstheobservationsyoucanmakeaboutHeavenlyChocolates business based on the type of browser?4.Developascatterdiagram,andcomputethesamplecorrelationcoefficienttoexploretherelationshipbetweenthetimespentonthewebsiteandthedollaramountspent.Usethehorizontal axis for the time spent on the web site. Discuss your findings.

5.Developascatterdiagram,andcomputethesamplecorrelationcoefficienttoexploretherelationshipbetweenthenumberofwebpagesviewedandtheamountspent.Usethehorizontal axis for the number of web pages viewed. Discuss your findings.

6.Developascatterdiagram,andcomputethesamplecorrelationcoefficienttoexploretherelationshipbetweenthetimespentonthewebsiteandthenumberofpagesviewed.Usethehorizontal axis to represent the number of pages viewed. Discuss your findings.

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