Read and watch the action items in the Week 1, 1.4 Analytics - Descriptive Techniques module. These resources are provided to study and complete this submission.

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

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

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.

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

One Excel file with this information is due end of Sunday of Week 1. Be sure to review dropbox grading assessment rubric with these instructions to understand further expectations on each of the three performance criteria for this assignment.

Date	Dollars
April2024	110.6
January2024	108.25
October2023	107.5
July2023	104.6
April2023	100.4
	106.7
October2022	109.45
July2022	105.9
April2022	102.2
January2022	105.25
October2021	109.5
July2021	100.1
July2020	101.84
April2020	100.3
January2020	105.75
October2019	113.09
July2019	99.12
April2019	102.5
January2019	105.76
October2018	107.62
July2018	99.26
April2018	101.76
January2018	105.76