Questions (1,2 and 3 below ) are solved in the excel, I need to have a solution for Question 4 in a word file and a presentation for the whole project, well organized one.
1. Going through of the Saudi General Authority of Statistics “Attached file” the data available for sea fishing.
2. From the data available, calculate and plot, on a spread sheet, the growth rates of the totalcatch (production) from marine fisheries from both traditional and industrial sources for theyears 2011-2020 (Total Growth, T. Growth, and I. growth).
Growth formula = (𝑷𝒓𝒆𝒔𝒆𝒏𝒕−𝑷𝒂𝒔𝒕)𝑷𝒂𝒔𝒕 × 𝟏𝟎𝟎
3. From the data available, calculate and plot, on a spread sheet, the self-sufficiency ratio (SSR) infish products for Saudi Arabia
SSR = 𝑷𝒓𝒐𝒅𝒖𝒄𝒕𝒊𝒐𝒏(𝑷𝒓𝒐𝒅𝒖𝒄𝒕𝒊𝒐𝒏 𝑰𝒎𝒑𝒐𝒓𝒕𝒔)−(𝑬𝒙𝒑𝒐𝒓𝒕𝒔 𝑹𝒆𝒆𝒙𝒑𝒐𝒓𝒕𝒔) × 𝟏𝟎𝟎
4. What can you say about the result.