Do you have any questions? We are ready to help
info@legitpapershub.com
Chat online
My Account

  • Home
  • Blog
  • Why Us
  • Contact Us
  • Services
Join
Order Now

  • Home
  • Blog
  • Why Us
  • Contact Us
  • Services
Join
Order Now
  • Home
  • Blog
  • Why Us
  • Contact Us
  • Services

Business Analytics

  1. 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:

  • 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. (5 marks)

(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)

  • 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? (2 marks)
  • 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. (2 marks)
  • 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. (2 marks)
  • 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.(2 marks)
  1. Ambulance Victoria has an official Response Time (RT) targets: Respond to incidents within 15 minutes for 85% of incidents state-wide. Response times are an important measure of the service they provide. The response times are measured from the receipt of the triple zero (000) call until paramedics arrive on scene. Response times are influenced by many factors including traffic, distance required to travel, availability of ambulances and demand for the services. They designate those patients that require urgent paramedic and hospital care as “Code 1,” and these patients receive a “lights and sirens” response. The AmbulanceVictoria file provides information about their Code 1 response time performance by Local Government Area (LGA) in the 3rd quarter of the financial year 2015-2016.

 

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:

  • 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 with its formula. What does the scatter chart indicate about the average response time over the total number of incidents for these Victoria’s LGAs? (2 marks)
  • 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? (2 marks)
  • Create frequency distributions, percent frequency distributions and intervals in a table for the number of incidents using bin size of 250 incidents. Then, draw a histogram for the frequencies. Interpret the results. Do any data points appear to be outliers in this distribution? (3 marks)
  • 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? (3 marks)
  • 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.(2 marks)

                                                                 SAMPLE SOLUTION

 

 

  1. 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:

  • 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. (5 marks).

Graphical Summaries

 

Sample Solutions

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus hendrerit. Pellentesque aliquet nibh nec urna. In nisi neque, aliquet vel, dapibus id, mattis vel, nisi. Sed pretium, ligula sollicitudin laoreet viverra, tortor libero sodales leo, eget blandit nunc tortor eu nibh. Nullam mollis. Ut justo. Suspendisse potenti.

Get sample solution

Order Now

Sed egestas, ante et vulputate volutpat, eros pede semper est, vitae luctus metus libero eu augue. Morbi purus libero, faucibus adipiscing, commodo quis, gravida id, est. Sed lectus. Praesent elementum hendrerit tortor. Sed semper lorem at felis. Vestibulum volutpat, lacus a ultrices sagittis, mi neque euismod dui, eu pulvinar nunc sapien ornare nisl. Phasellus pede arcu, dapibus eu, fermentum et, dapibus sed, urna.

Morbi interdum mollis sapien. Sed ac risus. Phasellus lacinia, magna a ullamcorper laoreet, lectus arcu pulvinar risus, vitae facilisis libero dolor a purus. Sed vel lacus. Mauris nibh felis, adipiscing varius, adipiscing in, lacinia vel, tellus. Suspendisse ac urna. Etiam pellentesque mauris ut lectus. Nunc tellus ante, mattis eget, gravida vitae, ultricies ac, leo. Integer leo pede, ornare a, lacinia eu, vulputate vel, nisl.

Suspendisse mauris. Fusce accumsan mollis eros. Pellentesque a diam sit amet mi ullamcorper vehicula. Integer adipiscing risus a sem. Nullam quis massa sit amet nibh viverra malesuada. Nunc sem lacus, accumsan quis, faucibus non, congue vel, arcu. Ut scelerisque hendrerit tellus. Integer sagittis. Vivamus a mauris eget arcu gravida tristique. Nunc iaculis mi in ante. Vivamus imperdiet nibh feugiat est.

Ut convallis, sem sit amet interdum consectetuer, odio augue aliquam leo, nec dapibus tortor nibh sed augue. Integer eu magna sit amet metus fermentum posuere. Morbi sit amet nulla sed dolor elementum imperdiet. Quisque fermentum. Cum sociis natoque penatibus et magnis xdis parturient montes, nascetur ridiculus mus. Pellentesque adipiscing eros ut libero. Ut condimentum mi vel tellus. Suspendisse laoreet. Fusce ut est sed dolor gravida convallis. Morbi vitae ante. Vivamus ultrices luctus nunc. Suspendisse et dolor. Etiam dignissim. Proin malesuada adipiscing lacus. Donec metus. Curabitur gravida

Share

What we also cover

Assignment writing Services

Essay writing Services

Thesis writing Services

Research Paper Services

Dissertation Services

PhD writing Services

Write My Paper
Manage Orders

Ready to order legit papers

Write My Paper

About Us

We are a solution for students. Students need to do well in school. They need to understand what they are taught and have this reflect in their grades.

Our Services

• Essay Writing Service
• Coursework Writing Service
• Report Writing
• Dissertation Writing Service
• Assignment Writing Service

 

• Essay Writing Service
• Coursework Writing Service
• Report Writing
• Dissertation Writing Service
• Assignment Writing Service

 

• Essay Writing Service
• Coursework Writing Service
• Report Writing
• Dissertation Writing Service
• Assignment Writing Service

We Accept

Contact Us

info@legitpapershub.com
support@legitpapershub.com

© 2021 legitpapershub.com. All Rights Reserved.
      WhatsApp us