Showing 1–12 of 19 results

Comparing SPSS vs Excel

Published on: 2022-04-25نُشِرَ بتاريخ: 2022-04-25

Data Analysis, Excel VS SPSS Statistics

An important question occurs to many of people interested in the field of data analysis or people who may need to use data analysis programs either for work or research; “What is the difference between Excel and SPSS? And when is each of them recommended?”.

In this article we provide a brief description of the advantages and disadvantages, this description is categorized according to the specialization or field of the required data analysis:

First: data analysis for academic research

We absolutely recommend using SPSS, as it offers very wide statistical analyses that has endless options. In this field, Excel cannot in any way provide what SPSS does.

For example, SPSS provides:

Parametric and non-parametric tests with wide options that include many tests required for researchers who are not specialized in statistics.
Regression and correlation analysis of its various types, linear and non-linear, with tests for them and analysis options that are widely related to them.
Time series analysis.
Questionnaire reliability tests.
Neural networks analysis.
Factorial analysis.
Survival analysis.
Statistical quality control analysis and charts.

Along with many other statistical analyses that serve academic fields.

Second: data analysis for non-academic research

It can be classified into several levels of data analysis:

Descriptive data analysis:

In general, the two programs are able to provide all the analyses required in descriptive statistical analysis, but Excel contains some minor flaws, such as that it does not arrange the answers according to their logical order, but rather in an alphabetical order, and it can’t provide calculations related to questions that include texts in addition to calculations related to their own order (Ordinal data) such as calculating the Likert Scale.

SPSS is characterized by providing tools for analyzing multi-select questions and with advanced options, which Excel does not provide, therefore, we need to use functions to get those analyses which options are limited with problems with the percentage that we get from it.

Disaggregation analysis:

It can be said that both programs are reliable in this aspect, except in the case of multiple and complex disaggregation/cross-tabulation with multi-select questions, in these cases, Excel becomes slower and less effective, while SPSS offers all options, no matter how complex they are, at the same speed required for descriptive statistical analysis and simple disaggregation. In addition to aforementioned, there are features such as filtering and data splitting features provided by SPSS, which accelerate data analysis to a very big scale, as it is possible to analyze the required data for 20 regions separately to be done at the same speed of analyzing data for one region, while in Excel, this means doing 20 times the work.

SPSS provides the features of descriptive analysis and data disaggregation much faster than we may think, as some analyses that take a week using Excel can be completed in just a few minutes using SPSS.

Third: Analyzing data of demographic indicators

When talking about demographic indicators, we find a challenge facing each of these two programs. In SPSS, we can perform numerous, complex and very fast arithmetic operations that outperform Excel, however, SPSS has some minor weaknesses that are important at the same time; among the most important matters that have been noticed in this regard is conducting multi-column conditional arithmetic operations, as SPSS provides multi-column arithmetic operations, but these operations do not contain multiple conditions, on the other hand, Excel provides this feature with a wide variety of conditional and effective functions.

Fourth: Data management and linking databases in the analysis

In this particular aspect, we find the clear distinction of Excel, as with the Power Query package, it offers features of data management, merging, and the possibility for aggregation and cleaning the data, in addition to the ability to link various databases without merging them, and analyzing them together with all types of analyses.

As for SPSS program, it does not include the feature of analyzing isolated databases without the need to merge them, on the other hand, it can solve a large part of this problem by merging databases, but this entails many challenges and great possibilities for error. When merging more than one database, there is usually a repetition of cases to match the other database, and this means that when we analyze the database that has been duplicated, we must perform operations that cancel this repetition in order to obtain correct analyses.

The features of data management and analyzing isolated databases together is considered as a great advantage of Excel, but in most cases it is not required, as it is only needed in complex and advanced projects.

On the other hand, SPSS program in the Data menu provides many features that can only be described as great, and the lines of this article are insufficient to talk about them, but they can be briefly described by saying that they gives data management some features that can outperform Excel in some aspects, such as the Unpivot or Restructure features that SPSS provides including features that are far more advanced and powerful than Excel.

Fifth: Weighting

One of the very important aspects of data analysis, especially with regard to demographic statistics, humanitarian needs analysis and advanced market research, is the Weighting feature, which helps to calculate the data after taking into account a weight that expresses, for example, the population of the governorate or the studied area, which gives it an amount of needs that is commensurate with its size.

This feature is not provided by Excel, if we wanted to calculate the weights manually using functions in it, this sometimes causes problems in the results, especially in the disaggregation analyses.

In SPSS, once you choose the option of Calculating Weights, it will be automatically applied to all calculations whatever they are, even on charts, and we can stop calculating weights with only one click.

This is a simple comparison between the two programs, we hope this comparison gives a preliminary perspective and help data analysis specialists and institutions that need to build the capacities of their team in this field to choose the most suitable program for them.

 

By:
Ghaith Albahr: CEO of INDICATORS

Customer experience testing

Published on: 2022-03-05نُشِرَ بتاريخ: 2022-03-05

It is the impression you leave on your customer at every stage of his journey to purchase a product or service, which leads him to think of your brand and promote it among his acquaintances and friends.

The difference between customer experience and customer service:
Customer Service

It consists of interactions with the customer in order to obtain the offered product or service, giving the customer the information he wants to know, and receiving complaints and inquiries.

Customer Experience

It can be simply explained as accompanying the customer from the beginning to the end of the journey, i.e. the purchase of the product and the impressions it provides at each stage of his communication with the company and the impressions about the product or service after purchase.

Customer service can be considered as part of the customer experience, as they are strongly related, but there is a difference between them.

To simplify the Customer Experience term, the following example can be used:
Suppose we have a movie, to produce this movie, we need:
1. Director – Executive Director – Sound Director – Cameraman – Producer… (Management Team).
2. The actors and all the individuals who appear in front of the camera.. (Employees who are in direct contact with clients).
3. The script, the dialogue, and the area in which the movie is filmed … (the tools used to produce the product or service offered by the company).
4. Current viewers..(existing clients and potential clients).

We have a highly professional script, dialogue, venue, director, lighting and sound engineer, and cameraman, but the experience of the actors is low, or we could say that it is not good, will the viewers get the aim or the moral of the movie? (Of course not) and this is the biggest mistake that current companies and institutions make with regard to the customer experience, as they focus on the management team so that they have high expertise to produce the product or service and do not care about the employees who are in direct contact with the customer who is the face of the work, the thing that negatively affect the company’s reputation, and may lead to the loss of existing customers and failure to get new ones.

The Importance Of Customer Experience

It is very important for the continuous growth of a business, as ensuring a positive customer experience contributes to:
• Building brand loyalty among customers.
• Activating your product or service and embed it in the minds of customers.
• Creating marketing opportunities by customers themselves, by writing positive comments and impressions that are more important than paid advertisements and promotions, and more influential on other customers.

On the other hand, customers want to feel connected to their favorite brand and want to feel that it knows them, respects them and cares about them. For example, suppose there are two cafes that are close to each other, and they have the same brand of coffee and the same qualities, but one of them is more expensive than the other, and the most expensive pays attention to its customers and their details, for example: He says to his customers: (Your usual drink?) which leads customers to go to the most expensive, because it satisfies the customer’s needs of drinking coffee with a feeling of care and good treatment.

Customer Experience Methodology
1. Developing customer journey map

A customer journey map is defined as a story supported by a map that includes all the interactions and communications that the customer has with the company in order to obtain a particular product or service.

Whereas a map is drawn for all potential customer paths during his journey in order to obtain a product or service and identify all channels and interactions that the customer can make at each stage of the map.

2. Evaluating the integration of operations in companies

Evaluating each of the stages that the customer goes through in order to obtain a specific product or service in terms of customer satisfaction and whether it is integrated or not, this is done through studying the customer’s experience in each of the operations in detail.

3. CRM Evaluation

It is done through an assessment of the company’s interaction with current and future customers, where customer data with the company is analyzed in order to get the best path of customer relations, with a focus on retaining old customers.

4. Experimental implementation of customer experience

It is one of the most important stages of studying customer satisfaction or customer experience, and it is done through conducting an experimental implementation of a customer journey after developing the previous tools, and accompanying the customer from the stage of purchasing the product until reaching the post-purchase stage, to get the feedback of the customer about the product, and knowing all stages and paths he went through during his journey with the company.

5. Analyzing Customer Satisfaction

This stage begins after the customer purchases the product or service and gives feedback on his journey with the company and the product or service, whereas the customer’s opinions and feedback are analyzed to reach the problems that the customer may face, and the positive and negative things that he can see in the product, then the necessary measures are taken to address these matters.

6. Studying the customer’s perception about the company

This is done by conducting a short questionnaire for the customer, in which he is asked about all of the stages of his journey, the nature of the relationship at each stage, and his views on how to make the service or journey better, and then analyzing the data coming from the customers to obtain comprehensive and general perceptions to improve the stages of the customer’s journey.
Example of customers’ journey:
For example, what does Google say about its customer experience testing?
If users can’t spell, it’s our problem
If they don’t know how to form the query, it’s our problem
If they don’t know what words to use, it’s our problem
If they can’t speak the language, it’s our problem
If there’s not enough content on the web, it’s our problem
If the web is too slow, it’s our problem

The purpose of customer experience testing is to be concerned with customer needs rather than the amount of sales.
The focus must change from absolutely focusing on the product to focusing on the customer experience to Improve the product based on results, and from being concerned about the broad market to being concerned about the individuals who connect you to the broad market.

By:
Ghaith Albahr: CEO of INDICATORS
Anas Attar Sabbagh: Research officer in INDICATORS

Dell’s success story

Published on: 2020-04-10نُشِرَ بتاريخ: 2020-04-10

By:
Reem Barakat

From its beginnings Dell company worked as a leader in the “build-to-order” approach, providing individual computers that were made to the customer’s request, and according to the Neronet-academy website the beginning of the company was from the apartment of a college student named “Dell” and His first clients were on a low income so he started to collect computers By himself and sell it to his customers directly.

In 1985, Dell sold the first computer designed by his company from the Turbo PC, and participated in many exhibitions to show his strength in the competition, and one of the things that made his product unique is the design of a computer with good specifications and a competitive price for a wide range of customers, and that was the result of his constant proximity to His clients, which enabled him to know their needs. Over time, Dell outperformed many competitors, and in the 1990s it ranked fourth in the first 10 companies that won customer confidence, both Security and technical.
One of the most important elements of the company’s success was its constant focus on research and development and market research, so it owned an analysis department that oversaw pricing, web analytics, and supply chain analytics, and also hired researchers in customer service, It has built tools and system to study customer satisfaction and obtain feedback, as well as a prompt and accurate complaints response system, By exploiting the development of the Internet and the emergence of social media, it was able to study customer satisfaction more accurately and respond to all customer complaints, no matter how many, which increased consumer confidence in the company and its products In addition to its reversal of complaints and feedback analyzes on developing its products and improving its quality, this increased its success, market share and ability to compete, which reflected on increasing its profits significantly and making it maintain its name as one of the world’s largest companies in the computer industry.

Field heroes 1 – Ethics of data collection

Published on: 2018-11-01نُشِرَ بتاريخ: 2018-11-01

Posted by admin Leave a comment
field-heroes-1-data-collection-ethics
Various institutions and organizations in their endeavors in seeking flawless implementation of their services conduct extensive studies before implementing their projects to have a better assessment for the needs of beneficiaries, and to identify ways in which these needs can be effectively and efficiently addressed.
Conducting these studies requires the existence of a field staff which conducts periodic visits to the targeted group to collect data and submit it to the analysts that turn this data into clear results that reflect the situation of the target group. It should be noted that the credibility of the concluded results depends on the accuracy of the data obtained in the field.
Proper collection of data and its success in achieving its objectives require the field researcher to be equipped with many skills, such as strong observation skills, the ability to use and employ the different senses, the ability to communicate with the participants to build upon the information they give, and having experience in the use of various data collection tools.
However, having expertise and skill alone is not sufficient for a field researcher to ensure the success of the data collection process and to acquire accurate information, which in turn leads to reaching objective results that reflect the condition of the target group. In order to reach that, field researcher must adhere to moral and ethical data collection principles which are defined as a set of standards and behavioral rules that govern and regulate the work of the field researcher while conducting data collection process.
In this guide we will mention the most important standards and ethics that the field researcher must adhere to

A series of guides for the data collectors to increase their skills in data collection for various research sectors.

Titles of the guides:

1. Data Collection ethics.
2. Individual and KI interviews.
3. Focus Group Discussion.
4. Field visit/Observation.

focus group discussions – Field heroes 3

Published on: 2018-11-03نُشِرَ بتاريخ: 2018-11-03

A series of guides for the data collectors to increase their skills in data collection for various research sectors.

Titles of the guides:

1. Data Collection ethics.

2. Individual and KI interviews.

3. Focus Group Discussion.

4. Field visit/Observation.

the third guide from the Field Heroes series is focus group discussions FGDs, which aims to develop the skills of enumerators and researchers in this field.
focus group discussions FGDs considers one of the hardest tools in data collection in terms of facilitating the session and ensuring the orientation of the discussions in a way that helps to obtain the data intended for the session, in addition to the sensitive role of the documented session and the ability to discuss and record useful information.

Worked on this guide:

Ghath Humaidan: manager of data collection teams

Khaled Brram: data analysis officer

Emad Al-Sari: market analysis specialist

Anas Jamous: field coordinator for data collection

Azzam Al-hadi: data quality officer

supervision Ghaith Al Bahr consultant in statistical Studies

Design: Omar Ghafrah- Faysal Al-Mashhadani

Report language: Arabic

Individual interviews – Field heroes 2

Published on: 2018-11-02نُشِرَ بتاريخ: 2018-11-02

Individual interviews
Individuals’ interviews are one of the most important tools in qualitative data collection and can be defined as an open talk between a field researcher and a person or group of people to discuss a set of questions related to a particular subject to obtain the data needed for the study, based on the knowledge of the participant or participants about the details of the subject under study.
Individuals’ interviews take between one hour to one hour and a half, and it can be done directly through a personal meeting between the field researcher and the participant, which is the most prevailing and appropriate form of conducting interviews, or by using modern means of communication such as Skype.
Advantages of individuals’ interviews:
Individuals’ interviews have many advantages, from which we can mention:
1-Individuals interviews are considered suitable for collecting data on important and sensitive issues such as those related to family matters or violence against children.
2-It is considered an opportunity for the field researcher to know the participant closely and help to obtain verbal answers and nonverbal indications that reinforce answers, such as expression changes on the participant’s face, his movements and emotional impressions, all that can be used in the data analyses process.
3-Individuals interviews help to motivate the participant to answer questions, ensure a correct interpretation of the questions and allow the participant to inquire about any ambiguity about the questions asked, and therefore, answers are more accurate and the percentage of errors is lower.
4- Individuals interviews are considered the best tools for data collection in illiterate communities, and in cases where the participant does not know how to read and write.
5-When doing individuals interviews, the field researcher is able to ask new questions related to the topic in question-based on the answers of the participant, and these questions help him get what he thinks is useful data.
6-Individuals’ interviews provide the field researcher with additional information about the subject in question and help him understand it well.
7-Individual interviews provide a good amount of data, where the percentage of replies and answers is higher than answers in written forms.
8-Individual interviews are considered the most appropriate way to collect data from important people, such as people with important positions in higher management.
9-Individual interviews allow the field researcher to return to the participant to ask more questions or inquire about some of the answers.

A series of guides for the data collectors to increase their skills in data collection for various research sectors.

Titles of the guides:

1. Data Collection ethics.

2. Individual and KI interviews.

3. Focus Group Discussion.

4. Field visit/Observation.

The second guide is the individual interviews, This guide includes six main themes:

The advantages of individual interviews, the disadvantages of individual interviews, the types of individual interviews, the preparation of individual interviews, conducting the individual interviews, the common mistakes that field researchers make when conducting interviews

Worked on this guide:

Ghath Humaidan: manager of data collection teams

Khaled Brram: data analysis officer

Emad Al-Sari: market analysis specialist

Anas Jamous: field coordinator for data collection

Azzam Al-hadi: data quality officer

supervision Ghaith Al Bahr consultant in statistical Studies

Design: Omar Ghafrah- Faysal Al-Mashhadani

Report language: Arabic

INVESTMENT STUDIES BENEFITS AND MOST IMPORTANT TOOLS

Published on: 2020-04-08نُشِرَ بتاريخ: 2020-04-08

How to establish a successful business?

By:
Reem Barakat & Ghaith Albahr

What are the reasons for the failure of startups?
Have you ever wondered why most businesses fail in the first years of their establishment?

Do you know what are the most important reasons for the failure of these businesses? Did you know the relevance of that to market research? Do you know what is the investment research and

what it’s role in ensuring the success of startups?
According to Small Business Trends site only 56% of companies reach the fifth year since their establishment, the most important reason for the failure of companies is the lack of need for the services they provide or wrong in the way the service is offered Which represented 42% of the reasons of companies failure, as for the rest of reasons, they were related to wrong pricing, as the price of the product was not estimated compared to competing products and the added value that it provides, releasing the product in the market in a wrong way, the wrong design of the product because it was user un-friendly, and customers’ feedback has not been followed up and product development not followed so that it overrides its issues.

yus-1

The previous research and many other researches about the reasons of failure of startups and entrepreneurs also indicate that customers have not been studied by the company’s founders, and lack of information about competitors and competing products , in addition to absence of product development in a way that can gain customer satisfaction and achieve competitiveness in the market, they are the main reasons why companies are gradually fail until they reach the stage of collapse and closure.
An example of that was EXEC company, according to Startup Graveyard website EXEC provided cleaning services requested online but the company has suffered from many problems and closed by its founders after facing huge loss due to lack of experience in the field, In addition to the obstacles of getting customers because of the lack of design service that meet their needs, this resulted in the company diversifying its services, where quality has not been concentrated in one service and waste their efforts in several services and what made the problem bigger was the neglecting Follow up of customer satisfaction and feedback, so the company did not notice its mistakes in time.

What is the relationship between the investment research and the feasibility study?

Most companies carry out brief feasibility studies focusing only on financial and technical details, and don’t focus on product design, customer behavior analysis, and study the competitors in the market, this is because some countries do not grant licenses to the companies without conducting feasibility study and that what make it a formal procedure to fulfill the governmental conditions which makes companies fall into a lot of issues because the feasibility study is not correct and most of these issues result from leniency in things that could be more than important to the company’s success. One of the mistakes that companies make is underestimating the importance of investment research which can reduce the waste of the seed capital and guarantee the achievement of revenue that help the company survive and guarantee its market share. Moreover, the important role that investment research plays is increasing the accuracy of the feasibility study by providing information about the customer behavior and the competitor that affects in expecting the costs, revenue and financial analysis, in addition to marketing plan and activities, Thus it can be said that the establishment of a company without relying on studying the market is one of the biggest reasons for its failure.

What are the steps to implement the investment research?

An investment research can be defined as one of the methodologies of market researches, it is devoted to being a market research for the establishment of the company and considered as a provider of information that required to complete the feasibility study, to obtain an effective investment research, It should be implemented in four steps:

1-Idea Validation:

which comes in the first steps of the investment research in order to test the correctness of the idea of the business that we want to establish. The idea validation contains three sections which is the availability of internal capabilities for project success, this means the seed capital, the expertise that can increase the business’s chances of success, and the expertise required to complete business requirements and the possibility of finding them. this is followed by testing the market environment related to business field, the most important thing that related to that is the competition environment and suppliers, customers, and the ability to enter new competitors. In the end comes the evaluation of the economic environment in the country, such as labor regulations, economic stability, available technology, energy and everything related to environmental affairs affected by this type of work.

2-White Paper:

before starting the detailed market research, many questions must be answered that helps in define the company’s scope of work and market research, including: does the company have to sell in the local market or export other countries? Which countries it have opportunity in? or which local territories? Which customer segments are recommended to target? What are product attributes that make it competitive (in terms of quality, product shape and size…)? What are the products that are in high demand recently?. Usually the data of the white paper data are collected from secondary data (Previous researches, government and customs sources), it collects information about the last three years. It can be said that the goal of the white paper is to search for any gaps in the market and use them as a market entry from which the company can benefit in order to competition and acquisition of its market share.

3-Market Research:

its main goal is to provide all the information that necessary to build the feasibility study and to establish a company in the right way. One of the most important information that provides is product description and the best way to release it to suit the needs of the market and the customers, or if it is a service, it should be designed in a way that meets the customer’s need as well as studying the competitiveness in market and all the details of competing products or services and alternative products, in addition to information regarding the appropriate marketing ways and sales channels, furthermore all information related to the legal conditions for establishing the company, and all the costs required for financial analysis in the feasibility study. The information provided by the market research should be as detailed as possible because any neglect of important details may be reflected for example on a product’s failure to compete, or on costs that were not taken into account. The market research is usually based on primary data that are collected directly through interviews with potential customers and consulting experts…

4-Feasibility Study:

The feasibility study covers four main topics: legal study, technical study, marketing study and financial study.

What should I keep in mind when implement an investment research?

It is necessary to pay attention to the fact that the investment research is a cumulative process, so it doesn’t take place once and ends, as we have noted in the steps of the investment research as a sequential process that helps build accumulated knowledge on how to ensure the success of our business, in addition to this, the importance of having flexibility in work during the establishment stage, including that the results of the investment research are not considered conclusive, are rather tested and modified according to the results that we obtain during the testing process. In other words, to ensure the success of the business and the investment research, it is advised to continue during the first years of the life of the company, especially in the first two years, that the products and services of the company be released in the market within limited segments of the customers and read the reactions and feedback, in addition to searching for issues that customers suffer from and turning them into opportunities by developing products to solve these issues, and trying to discover customers problems with competitors to try to take advantage of them to increase the market share of the company . All these details mean that we should not limit the investment research to the stage before the company launching, but rather we must continue to read the market and develop the business model.

Sources:

INDICATORS Company
Startup Graveyard
Small business trends

Issues of Asking Direct Questions

Published on: 2022-05-24نُشِرَ بتاريخ: 2022-05-24

Researchers and workers of all research fields (monitoring and evaluation, market research, opinion polls… etc.) usually work on identifying a set of research topics (usually called either research topics, key questions, or hypotheses…), then derive the questions that will be asked in the research tools from these topics. The problem I noticed that many researchers have, especially those working on developing #questionnaires / #research_tools, is that the phrasing of the questions uses almost the same words as the research topics. i.e., If we had a question about “the needs that would help increase the level of inclusion of people with disabilities in education”, the researcher asked people with disabilities “What are the needs that would help increase the level of your inclusion in education?”.

This method of phrasing results in many problems that would lead to not obtaining correct results or to a failure in answering the questions of the research, and this happens because:

1. The research topic may include terms that the participants are not familiar with, as academic terms are often used in research topics, therefore, other equivalent words that are used in real life must be used.
2. Most of the main research topics are complicated which cannot be answered by answering a single question, rather, they should be partitioned into sub-topics. Those sub-topics shall be phrased into questions (taking into consideration the appropriate amendment of the phrasing also), therefore, presenting the research topic directly and literally will cause confusion for the respondents, as they will be facing a broad and general question that is difficult for them to answer in this way.
3. In most cases, the participants do not have a level of knowledge that would help them answer the question in this form, this means that when studying the needs of people with disabilities that are required to increase their inclusion in education, it is better to ask the questions that related to the problems and difficulties they face that hinder their access to an appropriate education, with the necessity of emphasizing that asking about these problems and difficulties must be in a detailed way.

In summary, it can be said that the process of developing questionnaires appears to be easy for workers in this field, especially non-specialists, and anyone can work on the development of the questionnaires, but the experience, especially at the time of receiving data after all the efforts exerted for structuring the sample, and research methodology, shows that the data are useless, and this is due to the wrong design of the questionnaires.

Questionnaires can be expressed as the clearest example of the phrase “deceptively simple”, as anyone can develop a questionnaire, but the challenge comes with the obtained data. I recommend all workers in the field of research to improve their skills in #questionnaire_writing, and concentrate on the applied references, as most of the books only tackle theoretical aspects.

By:
Ghaith Albahr: CEO of INDICATORS

Issues of Dealing with Missing Values

Published on: 2022-05-20نُشِرَ بتاريخ: 2022-05-20

A lot of data analysis programs do not have the ability to distinguish between many values, namely:
· Missing Values
· Blanks
· Zero

This weakness of data analysis programs also extends to the failure of many data analysts to distinguish between these values, therefore, these values are not being distinguished or dealt with, and data are not being analyzed based on these differences.

Some may think that these differences are not very important, and they ignore them and leave dealing with them to data analysis programs, but in most cases, this gives catastrophic results that many people do not realize.

I will attempt to illustrate these differences through some examples:

1. If we want to analyze the average income of households in a country suffering from a crisis, it was noticed that a high percentage of respondents said that they have no income of any kind, and the percentage of these respondents is over 40% of the surveyed families. Data analysts dealt with these cases as missing values, the thing that gave results that are utterly different from the situation of society, as the socio-economic indicators in this case will show, for example, that only 10% of HHs are below the extreme poverty line, but the truth is that the percentage is more than 50%, because whoever does not have any income must be considered as his income is zero rather than a missing value, because the missing value is not included in the calculations, while the value zero is, and thus affects the percentages and the general average of income. In the opposite case, in the event of asking about the monthly salary, the salary of a person who does not have a job will be considered as a missing value rather than a zero, as he is unemployed and the salary is not calculated as a zero.
2. Many programs do not consider the blanks in the text questions as a missing value. For example, we find that the SPSS program does not consider the empty cell in the text questions as a missing value, but rather considers it a valid value, as in the Gender column, if it is a text question, the program will calculate the empty values, the thing that significantly affects results such as percentages, knowing that those who did not indicate their gender (male or female) should be considered a missing value.
3. In the SPSS, when trying to calculate a new data column from other columns, we find that some of the codes (formulas) can deal with the missing values effectively and some formulas cannot, for example when trying to calculate the total number of the family members out of the family members of each group, and we used the (sum) formula. We notice that SPSS gives the sum result even if there is a missing value in one of the categories, while calculating as a manual sum will give the sum result as a missing value when any of the cases with a missing value is encountered.

The cases in which there are issues in defining the missing values are unlimited, and I do not advise in any case to give the data analysis program nor the data analyst alone the freedom to guess and deal with those values, as the appropriate treatment and definition of the empty value must be determined, as we explained in the income case, the missing value must be considered as zero, while in the salary case, it must be considered a missing value, and in our third example, the empty cells of any category of family members must be considered zero, knowing that from the beginning, data collectors must be told that if a family does not have any member of a certain category, they must not leave a missing value, rather, they should fill it with a zero.

By:
Ghaith Albahr: CEO of INDICATORS

observation – Field heroes 4

Published on: 2018-11-04نُشِرَ بتاريخ: 2018-11-04

Posted by admin Leave a comment
A series of guides for the data collectors to increase their skills in data collection for various research sectors.

Titles of the guides:

1. Data Collection ethics.

2. Individual and KI interviews.

3. Focus Group Discussion.

4. Field visit/Observation.

the fourth and final guide of the Field Heroes series, which provides an explanation of the appropriate mechanisms and procedures for collecting data through observation, which is usually done through a field visit to the project site.

The observation is one of the most important tools of data collection because it helps us to obtain information about the expressed needs, which are more credible than the felt needs of the people, and it’s also the main tool in the methodology of Design Thinking developed by Ideo to help create innovative products.

Worked on this guide:

Ghath Humaidan: manager of data collection teams

Khaled Brram: data analysis officer

Emad Al-Sari: market analysis specialist

Anas Jamous: field coordinator for data collection

Azzam Al-hadi: data quality officer

supervision Ghaith Al Bahr consultant in statistical Studies

Design: Omar Ghafrah- Faysal Al-Mashhadani

Report language: Arabic

Ordinal Questions , Challenges and Issues

Published on: 2022-05-23نُشِرَ بتاريخ: 2022-05-23

The ordinal questions, where the participant is asked to answer several options in order of priority contain many issues.
I will talk through my observation of many cases about these questions focusing on the negatives points:
1. The process of arranging options according to the most important and less important is a cumbersome and time-consuming process, so it is noted that most participants do not answer them seriously, and therefore the order obtained is inaccurate.
2. In the questions in which we choose the most three important answers in an orderly way, the order tends to follow the order of the same answers in the design of the questionnaire, meaning that the participants tend to choose the answers that are mentioned to them at the beginning as the most important.
3. A big problem with the analysis of the ordinal questions is due to the weakness of most statistical programs, and the lack of ready-made analytical methods for these questions, so the data analyst is forced to do manual calculations, which causes issues in the analysis.
4. A problem in the outputs of the analysis: -Calculating the order as weights will give a result that may exceed the real value, meaning that the numerical result that we will get does not express a real value, but rather expresses the weight and importance of this option compared to the other options and not the percentage of those who chose it.
-Many data analysts have difficulty dealing with these questions, so they tend to use inappropriate methods such as displaying the analysis of the first priority only, displaying the analysis of each priority separately, or analyzing the question as a usual multi-select question.
-An error in calculating weights, the weighting system in statistics is not arbitrary, that is, in cases, it is considered in the form of degrees 1, 2, 3, or in the form of probabilities or percentages of the original answers…etc.
-An error in defining the weights of the answers, as the first priority should take the number 3 and the third should take the number 1, knowing that the logical order is the opposite, but as a final value it must give a higher number to the first priority, and this is usually the mistake that some data analysts made.
5. Issues with the report writers where some of them are confused about how to present and discuss the results in the report correctly.
6. Problems in the disaggregation of ordinal questions with other questions, as the question exists in several columns in the database, in addition to the need to take into account the weights, and to the disaggregation with one or more questions, which leads to many data analysts to make mistakes in analyzing these questions

By:
Ghaith Albahr: CEO of INDICATORS

Outliers Processing

Published on: 2022-05-20نُشِرَ بتاريخ: 2022-05-20

Some data analysts do not grant any attention to outliers, and they may have first heard this term while reading this article. Outliers have a significant impact on many statistical indicators, and the methods of handling and processing them are related to many factors, some of which are simple, and some are more complex and related to the type of statistical indicator, as the data analyst must know the classification of the Smooth Parameters and the that’s not, and this indicates the degree to which it is affected by the outliers.

For example, the mean is considered one of the best indicators/coefficients of central tendency, but it is extremely affectable by outliers compared to the median, knowing that the median is not considered an accurate coefficient compared to the mean.

Within the following lines, I will try to tackle an important aspect related to the outliers, which is the simplest, it’s the methods of processing outliers:

Methods of processing outliers:
1. Revision of the source: we revise the source in order to check the value, if there is an entry mistake, it is corrected, such as writing the age for a study about children as 22 by mistake instead of 2, so, we simply discover that it is an entry mistake and correct it.
2. Logical processing of outliers: Mistakes of outliers can be discovered through logical processing, simply, when studying the labor force, for example, the data of a person who is 7 years old are deleted because he is not classified as a labor force.
3. Distinguishing between what to keep and what to delete: This process is considered very exhausting, as there are no precise criteria for accepting or rejecting outliers. In this regard, SPSS program offers a useful feature, which is classifying outliers into two types, Outliers (which are between the first/third quartile and one and a half of the inter-quartile range), and Extreme values (which are between one and a half to three times the inter-quartile range), in other words, data far from the center of the data and data extremely far from it, in this case this classification can be adopted by accepting outliers and deleting extreme values.
4. Replacing the outliers that have been deleted: The last and most sensitive step is the decision to deal with the deleted outliers, whether to keep them deleted (as missing values) or replace them, the challenge begins with the decision to replace them, as leaving them as missing values entails consequences and challenges, similarly, replacing them also entails consequences and challenges. The decision of replacing deleted outliers is followed by the appropriate methodology for replacement, as the process of replacing missing values is also complicated and has various methodologies and options, each of these methodologies will have an impact in a way on the results of data analysis (I will talk about replacing missing values in another post).

It is not simple to summarize the methodologies for dealing with outliers within these few lines, as deleting outliers puts us in front of other options; shall we leave it as a missing value or replace it with alternative values? Also, when we delete outliers and reanalyze the data, we will find that new outliers have appeared, these values were not considered outliers considering the database before it was modified (before deleting the outliers in the first stage), therefore, I recommend Data Analysts to study more about this topic, considering the extent of studying they need based on the volume and sensitivity of the data.

By:
Ghaith AlBahr (Mustafa Deniz): CEO of INDICATORS