Show code

Show code

We have multiple sheets in the Excel file. Let's focus on the first sheet which likely contains the data on soil particle size distribution. We'll load this sheet specifically to analyze the distribution.

Show code

The data on soil particle size distribution is located in the first sheet, titled **'Table 1 Physical Properties of the soils at Rijiyar Mallam Village along Bauchi-Jos Road'**. The relevant columns for particle size distribution include:

**Sand (%)**: Percentage of sand particles.**Silt (%)**: Percentage of silt particles.**Clay (%)**: Percentage of clay particles.

These columns provide the basis for understanding the distribution of soil particle sizes at the Rijiyar Mallam Farm.

Show code

Show code

We successfully visualized the average distribution of soil particle sizes at Rijiyar Mallam Farm using a pie chart. The chart illustrates the mean percentages of Sand, Silt, and Clay in the soil samples collected from the farm.

To continue the analysis, we can explore other aspects of the soil properties, such as bulk density, porosity, and the textural class of the soil. These factors are crucial for understanding soil health and fertility. Let's examine these properties next.

A possible research question could be:

This question aims to explore how the physical composition of the soil, in terms of its particle size distribution, affects its bulk density. Bulk density is a key indicator of soil compaction and health.

This hypothesis assumes that variations in the proportions of sand, silt, and clay in the soil do not significantly affect its bulk density.

Show code

The statistical analysis, specifically a Pearson correlation test, was conducted to assess the relationship between soil texture (as a sum of sand, silt, and clay percentages) and bulk density at Rijiyar Mallam Farm. The results are as follows:

**Correlation Coefficient:**-0.2149**P-value:**0.1185

Given the p-value is greater than 0.05, we fail to reject the null hypothesis. This suggests that there is no significant relationship between soil texture and bulk density at Rijiyar Mallam Farm, based on the data analyzed.

To explore the impact of soil texture on crop yield at Rijiyar Mallam Farm, we would need data on crop yields for different plots or areas of the farm, alongside the soil texture data for those same areas. This analysis would involve correlating the proportions of sand, silt, and clay in the soil with the corresponding crop yields to identify any significant patterns or relationships.

If such data is available, we can proceed with the analysis. Otherwise, we would need to collect or obtain this data to conduct a meaningful investigation.

AI-powered data analysis