Assignment One: Application of Descriptive Statistics

Subject Title: Quantitative Methods

Subject Code: BAC21 A

Assessment Title: Case Problem 1

Assessment type: Individual

Weighting: 20%

Submission type: Turn tin

Word count: Not Applicable

Format / Layout of Assessment: Cover page Introduction (summary of case) Managerial report Conclusion References (if any) Appendices (if any)

Assessment instructions: Descriptive statistics are used to describe\summarize the characteristics of a sample or data set; this type of statistics can help decision makers understand the collective properties of the elements of a data sample. Managers use descriptive statistics to look at trends, understand relationships between numbers, and make sound business decisions.

This assignment focuses on this type of statistics. Students are given a case (next page) and a data set (data for each student on excel sheet available on Moodle) to analyse and make a managerial report.

This assessment requires students to focus on the key learnings from the lectures on descriptive statistics and how they apply to real-life situations.

Case problem: Heavenly Chocolates Website Transactions Heavenly Chocolate manufacturers and sells quality chocolate products at its plant and retail stores located in New York. Two years ago, the company developed a website and began selling its products over the Internet. Website sales have exceeded the company's expectations, and management is now considering strategies to increase sales even further. To learn more about the website customers, a sample of 20 Heavenly Chocolate transactions was selected from the previous month's sales. Data shows the day of the week each transaction was made, the type of browser the customer used, the time spent on the website, the number of website pages viewed, and the amount spent by each customer.

Managerial Report: Use the methods of descriptive statistics, students need to include the following in their report:

1. Graphical and numerical summaries for the length of time the shopper spends on the website, the number of pages viewed, and the mean amount spent per transaction. Discuss what you learn about Heavenly Chocolate's online shoppers from these numerical summaries. 2. Develop a scatter diagram and compute the sample correlation coefficient to explore the relationship between the number of website pages viewed and the amount spent and discuss.

X Assignment 1. Data set (1) [Protected View] - Excel BISHAL THAKURI BT - Share Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do File Home X i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing B2 : X Tue P D E F G H K L M N O A B Customer Day Browser Time (min) Pages viewed Amount spent ($) Tue Firefox 12 4 10 Wed Internet Explorer 12 100 Sat Google Chrome 19 110 Sun Google Chrome 11 44 18 6 0 0 V O UT A W N - Fri Safari 66 99 7 6 0 VO UI A W N Mon Other Fri Google Chrome 13 36 Tue Firefox 20 103 Mon Google Chrome 12 88 Thur Internet Explorer 12 98 W W W A N N OU A A N N O CI O A A AA 11 Wed Safari 19 12 Sat Google Chrome 13 Fri Firefox 14 Sun Internet Explorer 15 Thurs Safari 16 Fri Google Chrome 17 Sun Firefox 12 18 Thurs Internet Explorer 10 19 Sat Safari 20 Other 10 Tue 35 36 37 38 39 40 1457363 1333520 1400381 1476575 1480484 1482640 1485943 1490066 1491016 1494617 1495077 1495301 1496050 1496616 1498457 1499957 1501257 1501338 1501620 150163 ... + 100% Ready 4:16 PM w X 17C ENG O Lrc Type here to search 1/10/2021