How to Produce Prediction Map in GIS With ArcGIS and Excel?



$ 100.001-250.000


  • Tipología


  • Metodología


  • Horas lectivas


  • Inicio

    Fechas disponibles

"Since the late 1980s, the widely popular and efficient geographic information system (GIS) has facilitated the development of new machine learning, data-driven, and empirical methods that reduce generalization errors. 

In the this course, i have shared a famous and solid bivariate technique (Frequency ratio), to help you start your first prediction map using ArcMap and Excel only.

UPDATES March 2019: Course full data was uploaded with Section 2.

I will explain the spatial correlation between; prediction factors, and the dependent factor. Also, how to find the autocorrelations between; the prediction factors, by considering their prediction importance or contribution. Finally, I will Produce susceptibility map using; Microsoft Excel and ESRI ArcGIS only. Model prediction validation will be measured by most common statistical method of Area under the curve (AUC).


Información importante

¿Qué objetivos tiene esta formación?: "UPDATES March 2019: Course full data was uploaded with Section 2.
You’ll have my continuous support, taking your hand step-by-step to develop your first high quality map using real data
Writing a journal article, MOST WELCOME, I am available to help you to produce a scientific article qualified for peer review acceptance
I will be with you to interpret the results, we will discuss about the technical issues as well as how to make your results meaningful
Free access to all my previous publications techniques and methods: Search for "

¿Esta formación es para mí?: "Students and researchers of environmental engineering sciences, Ecology, and Other Natural Sciences
Any discipline who wanted to start easily using GIS in producing susceptibility mapping purposes and hazard assessment
Beginner in geographical information system software's, looking for quick self development"

Requisitos: "UPDATES March 2019: Course full data was uploaded with Section 2. No prior statistical modelling background needed Interest in developing a valid susceptibility map for geosciences applications using real life Data Prior Familiarity With the Geographic information systems Basic experience in ArcGIS software from Esri and Microsoft Excel This Course Will be Demonstrated on a Windows OS"

Sedes y fechas disponibles





Fechas disponibles Inscripciones abiertas


  • Excel
  • Testing
  • ArcGIS
  • MS Excel
  • GIS
  • Geographic
  • Model
  • Map
  • Spatial
  • ESRI

Programa académico

"Introduction to prediction mapping methods with GIS Introduction to common statistical based model and Frequency ratio (FR) concept Training and testing data preparation Introduction to the course data Training and testing data preparation using ArcGIS Training and testing data preparation using Open source QGIS (Extra) Data preparation Independent factors classification Pixels amount consistency of independent factors maps Tabulate the area of training data Frequency ratio model preparation in Excel Data transfer from ArcGIS to Excel Model parameters calculations in Excel Calculate the Frequency ratio values Calculate the prediction rate values Calculate the prediction rates using pairwise comparison method Prediction map production Reclassify the covariates using frequency ratio values Produce prediction map using the prediction rates Produce prediction map using the pairwise comparison Model evaluation using Area Under Curve (AUC) model Final map reclassification in ArcGIS Area Under Curve (AUC) calculation in Excel Issues appeared during Area under curve calculations"

How to Produce Prediction Map in GIS With ArcGIS and Excel?

$ 100.001-250.000