Instructions
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 projects 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):
- What are the descriptive statistics for cement prices? (Must use Excel Data Analysis Toolpak.)
- Summarize in your own words what happened to cement prices over this time period. Each of the descriptive statistics calculated should be included in this explanation.
- Create a scatter plot, line graph, or other chart of the cement prices.
Create one Excel file with this information.
0 comments