Q 3B: Draw the Line chart using EXCEL for the following variables and write your interpretations. Looking at the graph/ numbers (in the table) what type of correlation is suspected between crop area of wheat and cereals? (5 Marks)
| Year | AREA UNDER CULTIVATION Wheat (Lakh hectares) | AREA UNDER CULTIVATION Coarse Cereals (Lakh hectares) |
| 1965–66 | 126 | 443 |
| 1970–71 | 182 | 460 |
| 1975–76 | 205 | 438 |
| 1980–81 | 223 | 418 |
| 1985–86 | 230 | 395 |
| 1990–91 | 242 | 363 |
| 1995–96 | 250 | 309 |
| 2000–01 | 257 | 303 |
| 2005–06 | 265 | 291 |
| 2010–11 | 291 | 283 |
| 2015–16 | 304 | 244 |
| 2020–21 | 311 | 241 |
SOLUTION:
This negative correlation can be attributed to several factors. One possible explanation is changing market demands and customer preferences. As agriculture and food industries evolve, the demand for distinct crops can also shift. Farmers may reply to this by adjusting their cultivation patterns and focusing greater on crops that are in higher demand, such as wheat. Therefore, the crop region for coarse cereals may enjoy a decline because of this substitution effect.
Furthermore, profitability can impact farmers’ decisions regarding crop cultivation. If developing wheat proves to be extra economically advantageous compared to coarse cereals, farmers may also prioritize wheat production and decrease the cultivation location for coarse cereals. This economic issue could contribute to the located negative correlation.
Additionally, government policies and agricultural support applications may also play a position. Subsidies or incentives provided for wheat production could encourage farmers to allocate more land for wheat cultivation, consequently leading to a lower inside the crop location for coarse cereals.
However, it is essential to word that the interpretation of the terrible correlation based solely on the graph has barriers. Correlation does no longer set up causation, and other underlying elements would possibly impact the discovered trends. Elements such as changes in agricultural practices, technological improvements, environmental conditions, and regional versions may also contribute to the patterns found within the graph.
In conclusion, the graph surely indicates a negative correlation between the crop area of wheat and coarse cereals. Because the crop location for wheat expands or remains stable, the crop area for coarse cereals tends to decrease over time. This bad correlation suggests an ability substitution effect, influenced via changing market demands, profitability, government policies, and other agricultural factors.
Note: The above solution is only for reference purposes, Do not copy any answers or it will lead to the rejection of the paper.
MBA & BBA Complete guidance under one roof since 2010
Executive Coaching | Distance & Regular Management Courses | Specialized Classes | Projects & Assignments | Internship
Digital Marketing Courses Online & Offline Classes | One one One Tutoring
MAKAUT | Calcutta University | IBS | IIBS | ISWBM | ICFAI | NMIMS | AMITY | Symbiosis | IGNOU | Osmania & other universities
9748882085 | 7980975679