Assume you are analyzing soil properties based on data collected from various locations. Using

Microsoft Excel, perform the following tasks:

a$)$ Calculate the porosity and void ratio for each soil sample based on your assumptions about soil

types and properties.

b$)$ Determine the specific gravity of the soil for each sample.

c$)$ Create a scatter plot illustrating the relationship between moisture content and porosity. Analyze

any trends observed.

Submit your Excel spreadsheet containing calculations and graphical representations, along with a

brief explanation of your assumptions.