Read and watch the action...

Question

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

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.

Create One Excel file with this information.

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

descriptive-statisticscement-prices-templatespring2023-kg3dns4r.xlsx

Asif · Accepted Answer

Operations Management 1
Operations Management
Name and Number of Student
Date of Submission 
Answer 1: Descriptive Statistics for Cement Prices
Table 1- Descriptive Statistics for Cement Prices
(Source: Self-Created)
Cement Prices Summary:
From the data provided, we can see that the cement prices have been fluctuating over the past several years. The average price was $103.85275, with a standard deviation of $3.579775933. The maximum price of cement was $113.09, while the minimum was $98.2. Additionally, the data shows that the cement prices have been relatively stable over the past several years, with only minor fluctuations.
Answer: 2	
Over the period of January 2013 to January 2023,

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

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment