Descriptive Statistics And Data Visualization: Analysis Of A Cement Sales Dataset And Ambulance Response Time Performance

Summary Statistics for Delivery Time, Customer Satisfaction, and Sales Price

1. The histogram and the summary statistics for the variable length of delivery time is shown below:

According to the summary statistics, the mean delivery time is 0.3788 minutes/ton.km, The range of the delivery time is 0.73 minutes/ton.km.

The Histogram and summary statistics for the variable Customer satisfaction is shown below: 

According to the summary statistics, the mean customer satisfaction is 5.10, The range of the customer satisfaction is 9 and the standard deviation is 2.01.  

The Histogram and summary statistics for the variable Sales Price is shown below:

 
According to the summary statistics, the mean sale price is 404.18 ($/ton), The range of the sale price is 175 ($/ton) and the standard deviation is 41.96 ($/ton).  

1. The frequency table for, the average sale price, average delivery time, and average customer satisfaction for each city is given below: The graph is shown below:

The graph is shown below:

According to the above frequency table and bar graph for each city. The frequency of “Sydney” city is highest which is19 and the frequency of the “Canberra” is lowest which is 6 for the sales price, customer satisfaction and delivery time.

1. The scatter diagram between the delivery time and the sales price is shown below:

The above scatterplot indicates a negative relationship between the sales price and the delivery time, as the delivery time increases the sale price decreases.

The sample correlation coefficient between the delivery time and the selling price is -0.434 which indicates a moderate negative relationship between the sales price and the delivery time.

1. The scatter diagram between the delivery time and the customer satisfaction is shown below:

The above scatterplot indicates a negative relationship between the customer satisfaction and the delivery time, as the delivery time increases the customer satisfaction decreases.

The sample correlation coefficient between the delivery time and the customer satisfaction is -0.736 which indicates a strong negative relationship between the customer satisfaction and the delivery time.

1. The scatter diagram between the sale price and the customer satisfaction is shown below:

The above scatterplot indicates a positive relationship between the customer satisfaction and the sale price, as the customer satisfaction increases the sale price increases.

The sample correlation coefficient between the customer satisfaction increases the sale price is 0.492 which indicates a moderate positive relationship between the customer satisfaction increases the sale price.

1. The scatter chart to examine the relationship between the average response time and the total number of incidents is shown below:

The above scatter chart indicates a negative relationship between the average response time and the total number of incidents, as the total number of incidents increases the average response time decreases.

The regression line is:

The slope of the regression line is  which is negative and so it depicts that average response time is expected to decrease (or increase) by 0.191 percentages as “number of incidents” increases (decreases) by one.

The average response time will be 1107 .25 when the number of incidents is zero.

1. The scatter chart to examine the relationship between the percentage of less than 15 minutes response times and the average response time is shown below:

The above scatter chart indicates a negative relationship between the percentage of less than 15 minutes response times and the average response, as the percentage of less than 15 minutes response times increases the average response time decreases.

The regression line is:

The slope of the regression line is  which is negative and so it depicts that average response time is expected to decrease (or increase) by 1145.328 percentages as “percentage of less than 15 minutes response times” increases (decreases) by one. The average response time will be 1641 when the percentage of less than 15 minutes response times is zero.

1. The frequency distributions, percent frequency distributions and intervals in a table for the number of incidents using bin size of 250 incidents is calculated as below:

The histogram for the frequencies is shown below:

According to the obtained frequency distribution and histogram, the maximum frequency is obtained for the class interval 160-170 number of incidents.

1. The combinations of LGA categories and rating are most represented in the Ambulance Victoria data is shown below:

For the LGA category “Shire” the most of the ratings are obtained which is 39.

The table for the area with average response time more than 15 minutes (900 seconds) corresponding to the rating is shown below:

Thus, for the LGA categories the rating “Good” is most represented for average response time more than 15 minutes (900 seconds). The above rankings will similarly indicates about the other quarters of the year.  

1. The average incidents happened in each combination of category-rating pair of areas in the data set is shown below:

 
According to the above obtained Pivot table, the maximum average number of incidents is obtained for “City” and minimum average number of incidents is obtained for “Borough”.

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order