Respond in detail to each question with at least 1-2 summary paragraph. Review the rubric prior to responding.

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.

Add an additional 10 rows of data to the existing table prior to your analysis. 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.

Note, You will include the data table as an upload to the assignment. The purpose of adding the additional data roles is to ensure academic integrity and to provide you with the opportunity to have unique sets of data.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.

Customer Day Browser Time (min) Pages Viewed Amount Spent ($)1 Tue Google 12.0 4 54.522 Wed Edge 19.5 6 94.903 Mon Google 8.5 4 26.684 Mon Safari 11.4 2 44.735 Wed Google 11.3 4 66.276 Sat Edge 10.5 6 67.807 Sun Google 11.4 2 36.048 Sat Safari 4.3 6 55.969 Wed Safari 12.7 3 70.9410 Tue Google 24.7 7 68.7311 Sat Edge 13.3 6 54.0412 Mon Safari 14.3 5 48.0513 Mon Other 11.7 7 64.1614 Mon Safari 24.4 10 158.5115 Fri Google 8.4 3 84.1216 Thu Google 9.6 4 59.2017 Thu Google 23.3 7 91.6218 Mon Google 14.0 7 126.4019 Fri Edge 5.6 4 68.4520 Wed Google 15.1 5 32.6921 Tue Safari 16.3 5 78.5822 Tue Google 10.2 6 74.4323 Sun Google 8.0 3 32.7324 Tue Safari 8.0 2 48.6625 Fri Safari 9.6 3 54.6626 Wed Google 11.0 2 40.5427 Sat Google 16.9 5 34.6928 Fri Safari 6.0 4 27.9129 Fri Safari 32.9 10 155.3030 Mon Other 11.8 9 120.2531 Thu Google 7.1 2 41.2032 Fri Safari 18.0 8 134.4033 Sun Google 11.8 4 37.1734 Fri Google 9.1 3 52.0935 Tue Google 7.8 5 71.8136 Sun Safari 16.5 5 59.9937 Thu Safari 6.2 4 84.1738 Sat Google 11.3 4 55.5839 Tue Google 10.6 2 39.0640 Wed Google 5.0 5 36.4841 Tue Other 15.9 4 67.4442 Thu Google 18.1 7 60.1443 Fri Safari 10.8 4 70.3844 Thu Google 13.3 7 110.6545 Thu Google 30.1 6 104.2346 Fri Safari 13.7 4 68.1747 Thu Google 8.1 2 17.8448 Fri Google 9.7 5 103.1549 Mon Other 7.3 6 52.1550 Fri Google 13.4 3 98.75Add in 10 additional rows of data prior to conducting your analysis
https://bit.ly/3Hplcd1