Business Analytics
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.
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.
4) Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the delivery time and the customer satisfaction. Use the horizontal axis for the delivery time of the new product. Discuss your findings.
5) Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the customer satisfaction and the sale price of new product. Use the horizontal axis to represent the customer satisfaction. Discuss your findings.
Managerial Report
Use the data-visualization methods presented in this chapter to explore these data and discover relationships between the variables. Include the following in your report:
1) Create a scatter chart to examine the relationship between the average response time and the total number of incidents. Include a trend line for this scatter chart. What does the scatter chart indicate about the average response time over the total number of incidents for these Victoria’s LGAs?
2) Create a scatter chart to examine the relationship between the percentage of less than 15 minutes response times and the average response time. What does this scatter chart indicate about the relationship between the percentage of less than 15 minutes response times and the average response time?
3) Create a frequency distribution, percent frequency distribution, and histogram for the number of incidents. Use bin size of 100 incidents. Interpret the results. Do any data points appear to be outliers in this distribution?
4) Create a PivotTable for these data. Use the PivotTable to generate a cross tabulation for LGA categories and rating. Determine which combinations of LGA categories and rating are most represented in the Ambulance Victoria data. Now filter the data to consider only area with average response time more than 15 minutes (900 seconds). What combinations of LGA categories and rating are most represented? What does this indicate about how the ranking of the LGAs may be defined for the other quarters of the year?
5) Use the PivotTable to display the average incidents happened in each combination of category-rating pair of areas in the data set. Interpret the results.