Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please your csv to solve the problem DATAl-_ HeavenlyChocoIates Pages Amount Customer Day Browser Time (min) Viewed Spent (S) 1 Mon Chrome 1 2.0 4

image text in transcribed

Please your csv to solve the problem

image text in transcribedimage text in transcribedimage text in transcribed
DATAl-_ HeavenlyChocoIates Pages Amount Customer Day Browser Time (min) Viewed Spent (S) 1 Mon Chrome 1 2.0 4 54.52 2 Wed Other 1 9.5 6 94.90 3 Mon Chrome 8.5 4 26.68 4 Tue Fire-fox 1 1.4 2 44.73 5 Wed Gnome 1 1.3 4 66.27 6 Sat Fimfox 10.5 6 67.80 7 Sun Chrome 1 1 .4 2 36.04 48 Fri Chrome 9.7 5 103.15 49 Mon Other 7.3 6 52.15 50 Fri Chrome 13.4 3 98.75 Heavenly Chocolates 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 Heavenly Chocolates web site. Include the following in your report. 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. Discuss what you learn about Heavenly Chocolates' online shoppers 2. 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 Heavenly Chocolates' business based on the day of the week? 3. 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 Heavenly Chocolates' business based on the type of browser? 4. Develop a scatter diagram, and compute the sample correlation coefcient 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 ndings. 5. Develop a scatter diagram, and compute the sample correlation coefcient 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 ndings. 6. Develop a scatter diagram, and compute the sample correlation coefcient 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. Discuss your ndings. Customer Day Browser Time (min) Pages Viewed Amount Spent ($) 1 Mon Internet Explorer 12 4 54.52 2 Wed Other 19.5 6 94.9 3 Mon Internet Explorer 8.5 4 26.68 4 Tue Firefox 11.4 2 44.73 5 Wed Internet Explorer 11.3 4 66.27 6 Sat Firefox 10.5 6 67.8 Sun Internet Explorer 11.4 2 36.04 Fri Firefox 4.3 6 55.96 9 Wed Firefox 12.7 3 70.94 10 Tue Internet Explorer 24.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 Internet Explorer 8.4 3 84.12 16 Thu Internet Explorer 9.6 4 59.2 17 Thu Internet Explorer 23.3 91.62 18 Mon Internet Explorer 14 126.4 19 Fri Other 5.6 4 68.45 20 Wed Internet Explorer 15.1 5 32.69 21 Sat Firefox 16.3 5 78.58 22 Tue Internet Explorer 10.2 6 74.43 23 Sun Internet Explorer 8 3 32.73 24 Tue Firefox 8 2 48.66 25 Fri Firefox 9.6 3 54.66 26 Wed Internet Explorer 11 2 40.54 27 Sat Internet Explorer 16.9 5 34.69 28 Sat Firefox 6 4 27.91 29 Fri Firefox 32.9 10 155.3 30 Mon Other 11.8 9 120.2531 Thu Internet Explorer 7.1 2 41.2 32 Fri Firefox 18 8 134.4 33 Sun Internet Explorer 11.8 4 37.17 34 Fri Internet Explorer 9.1 3 52.09 35 Tue Internet Explorer 7.8 5 71.81 36 Mon Firefox 16.5 5 59.99 37 Thu Firefox 6.2 4 84.17 38 Sat Internet Explorer 11.3 4 55.58 39 Tue Internet Explorer 10.6 2 39.06 40 Wed Internet Explorer 5 5 36.48 41 Tue Other 15.9 4 67.44 42 Sat Internet Explorer 18.1 7 60.14 43 Fri Firefox 10.8 4 70.38 44 Mon Internet Explorer 13.3 110.65 45 Mon Internet Explorer 30.1 6 104.23 46 Fri Firefox 13.7 4 68.17 47 Thu Internet Explorer 8. 1 2 17.84 48 Fri Internet Explorer 9.7 5 103.15 49 Mon Other 7.3 6 52.15 50 Fri Internet Explorer 13.4 3 98.75

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

15th edition

1259404781, 007802563X, 978-1259404788, 9780078025631, 978-0077522940

Students also viewed these Mathematics questions

Question

What is meant by organisational theory ?

Answered: 1 week ago

Question

What is meant by decentralisation of authority ?

Answered: 1 week ago

Question

Briefly explain the qualities of an able supervisor

Answered: 1 week ago

Question

Define policy making?

Answered: 1 week ago

Question

Define co-ordination?

Answered: 1 week ago