Overview
Now that you have read and watched the resources, it is time to apply descriptive techniques to a given scenario.
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. Use this data and Excel file.
- What are the descriptive statistics for cement prices? Must use the Excel Data Analysis ToolPak to calculate these statistics in the Excel file.
- 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 explained in the Excel file.
- Create a scatter plot, line graph, or other chart of the cement prices in the Excel file.
- Create a visualization of data using an AI tool. Include your prompt(s) and provide written comparison points to the Excel chart you made. Be sure to properly cite the source in APA style. Add to the Excel file.
One Excel file with this information is due by the end of Sunday of Week 1. Be sure to review the assignment grading assessment rubric to understand further expectations for each of the four performance criteria for this assignment.