Question
Parkville Candies would like to use the sample data to determine whether online shoppers who spend more time and view more pages also spend more
Parkville Candies 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 Parkville Candies web site. Include the following in your report.
Using the 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 trans-action. Discuss what you learn about Parkville Candies' online shoppers from these numerical summaries.
Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week. Discuss the observations you can make about Parkville Candies' business based on the day of the week?
Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Discuss the observations you can make about Parkville Candies' business based on the type of browser?
Develop a scatter chart, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the dollar amount spent. Use the horizontal axis for the time spent on the web site. Discuss your findings.
Develop a scatter chart, and compute the sample correlation coefficient to explore the relationship between the number of web pages viewed and the amount spent. Use the horizontal axis for the number of web pages viewed. Discuss your findings.
Develop a scatter chart, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed.
Time (min) Pages Viewed Amount Spent (S) 12.0 4 54.52 19.5 6 94.90 8.5 26.68 11.4 44.73 11.3 4 66.27 10.5 67.80 11.4 36.04 4.3 waNa 55.96 10 12.7 70.94 24.7 68.73 12 13.3 54.04 13 14.3 48.05 14 11.7 64.16 15 24.4 10 158.51 16 8.4 3 84.12 17 9.6 59.20 18 23.3 91.62 19 14.0 126.40 20 5.6 68.45 15.1 32.69 a UI VIA 16.3 78.58 23 10.2 74.43 24 8.0 32.73 25 8.0 48.66 26 9.6 54.66 11.0 40.54 28 16.9 5 34.69 29 6.0 4 27.91 30 32.9 10 155.30 11.8 9 120.25 7.1 2 41.20 33 18.0 8 134.40 34 11.8 37.17 35 9.1 52.09 36 7.8 71.81 16.5 59.99 38 6.2 84.17 39 11.3 55.58 40 10.6 U NA 39.06 5.0 36.48 12 15.9 67.44 43 18.1 60.14 44 10.8 70.38 45 13.3 110.65 46 30.1 104.23 13.7 68.17 18 8.1 17.84 19 9.7 103.15 50 7.3 52.15 51 13.4 98.75Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started