Assignment:
Assessment details
Case: AuCement
AuCement produces many types of cement products at its factory in Sydney and sells them in Sydney, Brisbane, Canberra, and Melbourne. Six month ago, the company established a new cement facility to load a new 20Kg packaged cement. The company sells this new product in a competitive price and has boosted its sales with this option. In every contract the price of the product is paid based on its delivery time and customer satisfaction. To investigate more about the sales, they surveyed the customers who have purchased this kind of cement and a sample of 50 receipts was selected from the previous sales. For better comparison, they scaled the delivery time with dividing the hours spent for delivering the product by the travelled kilometres. AuCement file contains data showing the customer's location, the payment type, the delivery time, the amount of customer satisfaction, and the price of sales paid for every tonne of this product by each of the 50 customers.
AuCement would like to use the sample data to determine whether customers who receive their package earlier and are more satisfied about the quality also pays higher prices. The company would also like to investigate the effect that the customer location and the payment type have on sales.
Managerial Report
Use the methods of descriptive statistics to learn about the customers who purchase in higher prices. Include the following in your report:
1. Graphical and numerical summaries for the length of delivery time, the customer satisfaction factor, and the average amount gained per sale. Discuss what you learn about AuCement's new product sales based on this data.
(Hint: for the graphical summaries show histograms for each variable and for the numerical summaries draw a table listing mean, median, standard deviation, min, max and range for each variable).
2. Summarise the frequency, the average sale price, average delivery time, and average customer satisfaction for each city. Discuss the observations you can make about AuCement's business based on the destination city of the sales?
3. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the delivery time and the selling price. Use the horizontal axis for the delivery time of the new product. Discuss your findings.