Read and watch the action items:https://youtu.be/4_9vGqQaCFkhttps://youtu.be/ZdcoTVYJNF4These resources are provided to study and complete this submission.Assignment:A consulting agency has...

Read and watch the action items:

https://youtu.be/4_9vGqQaCFk

https://youtu.be/ZdcoTVYJNF4

These resources are provided to study and complete this submission.

Assignment:

A consulting agency has a specialty of supporting global government entities in a public-private partnership to plan and implement infrastructure improvement needs. This consulting agency is evaluating customers to prioritize which countries to target. A major cost on their construction project is cement, so they researched supplier prices per pound for each quarter over the past several years (


attached is this data in an Excel file, select title from 1.4 Course Content to obtain attachment and see assessment rubric with performance criteria for this submission


):

1. 
   
   
   

   What are the descriptive statistics for cement prices? Must use Excel Data Analysis Toolpak and submit Excel file in this dropbox.

   
   
   
   




2. 
   
   
   

   Summarize in your own words what happened to cement prices over this time period. Each of the descriptive statistics calculated with the Excel Data Analysis Toolpak should be included in this explanation.

   
   
   
   




3. 
   
   
   

   Create a scatter plot, line graph, or other chart of the cement prices.

   
   
   
   

Create One Excel file with this information.

See attached rubric to understand further expectations on each of the three performance criteria for this assignment.

Sheet1 DateDollars January 2023104.6 October 2022100.4 July 2022106.7 April 2022109.45 January 2022105.9 October 2021102.2 July 2021105.25 April 2021109.5 January 2021100.1 October 2020103.6 July 2020104.25 April 2020106.75 January 2020101.84 October 2019100.3 July 2019105.75 April 2019113.09 January 201999.12 October 2018102.5 July 2018105.76 April 2018107.62 January 201899.26 October 2017101.76 July 2017105.76 April 2017108.21 January 2017100.13 October 2016102.31 July 2016106.7 April 2016104.76 January 201699.7 October 201599.92 July 2015107.76 April 2015105.1 January 201598.67 October 2014105.61 July 2014106.43 April 2014107.76 January 2014103.7 October 201399.7 July 2013101.7 April 2013100.89 January 201398.2