Archive |
|
Archived news from our company:
|
Removing small value labels from Excel charts |
Value labels on charts help in understanding the presented data.
However, if there are too many labels, the less important ones tend to clutter the image.
Removing them may help in making the results easier to analyze.
The Excel VBA macro presented here removes labels of values smaller than a given value.
|
Market Research in Poland - 2012 |
Summary of turnovers of market research companies in Poland in the years 1996-2012
based on the newest data published by OFBOR.
|
|
In the new version of SPSS-2-Excel:
-
Added handling of SPSS data files up to version 21, including:
- long variable names,
- long text values (> 255 characters).
-
And some fixes:
-
reading LST and SPO files when values in the value labels section were documented using '*'
(value is too wide for the defined format of the variable),
- importing data from SPSS files,
- copying tables to the clipboard,
-
small fixes of the user interface
(more detailed messages, resizing columns in list views, resizing dialog windows, etc.).
|
|
Mindshare Baltics became a user of the
YAC Data Analyzer program.
|
|
ARKET Market Research became a user of the
SPSS-2-Excel program.
|
Complex queries in Access :-) |
Something lighter for the weekend - complex queries in Access...
|
|
A new version of our program for coding open text responses is ready -
YAC Text Recoder.
In this version we added response (and code) sorting by their similarity to a given string.
You can download the demo version from here.
|
|
Bureau of Research and Statistical Analysis became a user of the
SPSS-2-Excel program.
|
|
Smart Media Solutions (Latvia) became a user of the
YAC Data Analyzer program.
|
Market Research in Poland - 2011 |
Summary of turnovers of market research companies in Poland in the years 1996-2011
based on the newest data published by OFBOR.
|
SPSS Syntax - COUNT Function |
Questions coded using multiple variables (multi-coded questions, batteries of scales)
vs. the COUNT function - to quickly get the number of mentions for a single response or a set of responses.
|
Market Research in Poland - 2010 - is MillwardBrown SMG/KRC still really at the top? |
A small experiment with the analysis of turnovers of merged market research companies in Poland in the years 1996-2010
based on the data published by OFBOR and available information on company mergers.
|
Removing small value labels from PowerPoint charts |
Value labels on charts help in understanding the presented data.
However, if there are too many labels, the less important ones tend to clutter the image.
Removing them may help in making the results easier to analyze.
The PowerPoint VBA macro presented here removes labels of values smaller than a given value.
|
Market Research in Poland - 2010 |
Summary of turnovers of market research companies in Poland in the years 1996-2010
based on the newest data published by OFBOR.
|
|
A new version of our program for coding open text responses is ready -
YAC Text Recoder.
In this version we reintroduced automated coding.
You can download the demo version from here.
|
|
CBOS Foundation became a user of the
YAC DataGate Suite program.
|
|
MEC Active Engagement became a user of the
YAC Data Analyzer program.
|
|
In this version of YAC Data Kit we added the following definitions:
- excludeSysMis that defines the default handling of system missing values,
- hideRowsCols that defines the default display of empty rows and columns in analysis tables.
Version history: here.
|
|
IQS GROUP became a user of the
YAC Data Analyzer program.
|
|
In this version of YAC Data Kit we added
the "substStats" attribute to show means (as percents) instead of frequencies.
Version history: here.
|
Single- and multi-choice responses (not questions) |
Usually, questions are defined as either single- or multiple-choice.
But, actually, you should look as responses as single- or multiple-choice.
And responses of these two types may be mixed in a single question.
|
|
Aegis Media Central Services became a user of the
YAC Data Analyzer program.
|
|
In this version of YAC Data Kit we added:
- "fixedRecordsets" directive that, when set, blocks changing of the record set in an existing analysis.
- "stdStats" and "advStats" directives for defining standard and advanced statistics.
- "stats" directive in record set definition for limiting available statistics for analyses based on that record set.
- "hidden" directive in record set definition for blocking analyses based on that record set.
- "Mark different base record sets" check box to the Statistics parameter
that turns on markers that are displayed next to results that were calculated based on a non-default record set.
Version history: here.
|
Market Research in Poland - 2009 |
Summary of turnovers of market research companies in Poland in the years 1996-2009
based on the newest data published by OFBOR.
|
|
In this version of YAC Data Kit we added user definitions -
new questions can be defined based on existing questions, and then used just like standard survey questions.
|
|
A language guide
and documentation on reserved words
were added to the pages of our DataGate Suite program.
|
Nested randomized blocks |
In version 2.10 of YAC Interview Kit
we introduced blocks to group other blocks, pages, and questions.
What's more, the order of elements in a block may be randomized.
In this text we discuss this feature in greater details,
especially on nesting blocks (with randomization).
|
Names of variables in continuous surveys |
The management of data from continuous studies is not easy.
In this text we show a method of assigning names (identifiers) to variables,
so that typical data processing and analysis operations on multi-wave surveys is a bit easier.
This method also safeguards against certain types of errors.
|
|
Wszechnica Polska - Higher School of the Universal Education Society in Warsaw became a user of our
DataGate Suite program.
The full list of YAC Software's clients can be found here.
|
Example of quota checking |
A bit more complex example of quota control
in our YAC Interview Kit software.
|
|
In this version of YAC Data Kit we added new statistics:
- Row sum - Row Sum - sum of cells in a row, grouped by questions.
- Column sum - Col Sum - sum of cells in a column, grouped by questions.
- Row share (of column sums) - Row Share of Col Sums - share in the row of the sum of cells in the cell's column, grouped by questions.
- Column share (of row sums) - Col Share of Row Sums - share in the column of the sum of cells in the cell's row, grouped by questions.
Version history: here.
|
Quotas in YAC Interview Kit |
YAC Interview Kit has mechanisms
for controlling quotas during a survey.
In this text we go into more detail about the constructs implemented in YIK's scripting language
and how these map to client's requirements and the questions in the questionnaire.
|
|
A new version of our system for questionnaire based research is ready -
YAC Interview Kit.
- Added: introduction of blocks for grouping nested blocks, pages, and questions.
- Added: questions on a page can now be displayed in random order.
- Added: blocks, pages, and questions in a block can now be displayed in random order
- Added: added right-to-left display of response elements (text, radio buttons / check boxes).
- Added: limiting the maximum number of responses a respondent may select in multi-choice questions.
- Added: introduction of test surveys (with more strict access control than demonstration surveys).
Version history: here.
|
|
In this version of YAC Data Kit we introduced:
- Filtering questions in the target group and questions dialog windows.
- Calculation Base parameter can now display the record set against which the calculations are being run.
- Restricting the lists of questions in the target group and questions dialog windows to the selected record set.
- Forcing a minimum number of waves in analyses.
- Survey expiry date after which a survey becomes unaccessible.
|
Handling missing data in filter expressions |
Handling of missing data in filtering expressions is discussed in this text -
filter expression such as may be found in questionnaire scripts or data analysis programs (for instance - target group definitions).
The solution is based on 3-valued logic with the values of TRUE, FALSE, and MISSING (DATA).
|
|
A new version of our system for questionnaire based research is ready -
YAC Interview Kit.
- Added: support for references to responses in grid questions in variables,
preconditions, and randomization instructions in questions and axes.
- Added: optional identifier for axes.
- Added: $files and $surveys variables.
- Added: optional exporting of data of unfinished interviews.
- Changed: certain question identifiers are now reserved and cannot be used in questionnaires.
- Changed: fixed testing of parts of questionnaires (to/from cursor, highlighted block)
when pre or mask instructions were defined in the selected block.
Version history: here.
|
|
Subpages with GaduSonda polls prepared for Mediarun - Polls@Mediarun.
You know a bit of Polish? - come and see how this works!
|
|
In this version of YAC Data Kit we introduced data file protection based on hardware keys.
|
|
A new version of our program for coding open text responses is ready -
YAC Text Recoder.
In this version:
- When importing data, the project file is checked for consistency.
- When importing data / opening Fixed-ASCII data, the data file is checked for consistency.
- And we fixed various small issues.
You can download the demo version from here.
|
SPSS Syntax Tips |
Several short tips on using the SPSS command language - SPSS Syntax.
These tips are based on the most frequent phrases found in search logs leading to these pages:
- Recode values by cases instead of by variables.
- Recode multi-value variables into dichotomous variables.
- Automatically execute data processing instructions.
- Change the order of variables in a data file.
- Automatically save you data after execution of data processing instructions.
Pretty simple stuff, but helps a lot when working with SPSS. :-)
|
|
A new version of our system for questionnaire based research is ready -
YAC Interview Kit.
- Viewing respondent data directly in YAC Interview Manager.
- Fixes in support for Internet Explorer, version 6 and 7.
- Exporting long text responses directly to SPSS data files.
- Small changes in the questionnaire scripting language (page width, rejectedURL).
Version history: here.
|
|
Official release of the versino with analyses of TV audience data.
|
|
The WOLNE ZAWODY.pl (FREE PROFESSIONS) portal,
that we had the pleasure to work on, enters the testing phase.
You know a bit of Polish? - come and see how it works!
|
|
A new version of our program for coding open text responses is ready -
YAC Text Recoder.
In this version we added:
- handling of long text responses in SPSS data files (up to 32767 characters),
- optional view of full response texts in the recoding window.
You can download the demo version from here.
|
|
A new version of our system for questionnaire based research is ready -
YAC Interview Kit.
- Added: panel instruction in survey definition for restricting surveys to panelists of the given panel.
- Added: noback and noret attributes in pages and questions
that block respondents from going back to previous questions.
- Added: action instruction in pages and questions - execute an action when the respondents leaves a question or a page.
- Added: quota actions - finish the interview with quota status.
- Added: pre instruction in pages and responses - show pages and responses when a condition is met.
- Added: mask instruction in questions and axes and nomask attribute in responses -
show or hide those responses there were selected by the respondents in some previous question.
- Added: references to questions in the rand instruction -
show responses in the same order as in a previous, randomized, question.
- Added: quota limits with min and max identifiers in ranges.
- Added: variables - references to earlier responses in question and response texts.
Version history: here.
|
noback vs. noret |
A short post on two possible instructions that block respondents
from going back to previous questions in computer aided interviewing systems,
and especially in system where respondents fill out the questionnaires themselves (be it CASI or CAWI).
|
Market Research in Poland - 2008 |
Summary of turnovers of market research companies in Poland in the years 1996-2008
based on the newest data published by OFBOR.
|
|
Market Monitoring Center became a user of the
YAC Data Analyzer program.
|
YAC Data Kit - version 3.04.c |
Various small enhancements and fixes.
|
|
A new version of our system for questionnaire based research is ready -
YAC Interview Kit.
- Added: page instruction for grouping questions on a single screen.
- Changed: question nocls attribute was replaced by page seq attribute.
- Added: auto questions that allow for passing responses via links to the questionnaire.
- Added: logo instruction - a survey specific logo can be displayed on the questionnaire screens.
- Changed play definition to better handle video content.
Version history: here.
|
|
A new version of our program for coding open text responses is ready -
YAC Text Recoder.
In this version response text unification options were added:
- Trim leading blanks - deletes blanks from the front of the response,
- Trim trailing blanks - deletes blanks from the end of the response,
- Remove repeating blanks - contracts consecutive blanks into a single blank,
- Unify case - changes all texts to lowercase thus unifying responses that differ only by case,
- Unify diacritics - changes all diacritics into respective ANSI characters.
You can download the demo version from here.
|
Searching for Values in 2D Tables |
A quick hint on how to search for data in Excel in two-dimensional tables (cross-tabulations).
|
|
ERESTE became a user of the
YAC Data Analyzer program.
|
Effective Reach and Optimization |
This article discusses some nuances of press media plan optimization
where the possible solutions are limited by criteria defined for Effective Reach
or for the CPP (Cost per Point) and CPT (Cost per Thousand) indicators
in their versions based on Effective Reach.
|
|
A new version of our system for questionnaire based research is ready -
YAC Interview Kit.
In this version we added an internet "store" -
if respondents are awarded points for taking part in surveys,
they can exchange those points for various kinds of prizes.
Moreover, respondents:
- Have access to lists of available surveys, finished interviews, and missed surveys.
- Have access to their personal data where they can also update that data.
- Have access to a catalog of products with detailed descriptions for each product.
- Can review their basket and can order selected products.
- Can view the history of their "purchases".
Version history: here.
|
|
Although the GaduSonda project started some time ago,
now, after conducting 14 surveys and over 13,000 interviews,
and having over 4,000 panelists, we can confidently invite
market research institutes and departments to cooperate with us on new research projects.
|
Referencing Cells in Excel |
Two exercises that should help Excel users (and users of other spreadsheets) refer to other cells in formulae.
Relative and absolute references are discussed using two examples:
calculating percents given counts, and calculating the multiplication table.
|
Open All and Merge |
An Excel macro that shows how multiple sheets may be moved into a single common workbook.
|
|
Full data from the General Social Survey imported into our YAC Data Kit software.
The file can be downloaded from here.
The data is also available on our YDOL
server.
You can find more information on the project's page.
|
|
At the IV Congress on Youth Marketing
we will be presenting the survey platform GaduSonda.
The congress is being organized by ECU Marketing, part of Informedia Polska Sp. z o.o.,
and will be held on 23-24 October 2008 in the Polonia Palace Hotel, Warsaw.
We will be talking about our project during the session
conducted by the President of Inquiry, Agnieszka Gornicka.
The topic of the session is: "How to Ask to Get Them Talking - Youth in Market Research".
Come and take a look!
|
|
PBS DGA became a user of our
YAC Text Recoder program.
|
|
A new version of our program for coding responses to open ended questions -
YAC Text Recoder - is ready.
The main change in this version is that now you can assign many codes to a single text response.
But there are also other additions:
- non-numeric code identifiers are now supported,
- direct access to SPSS data files (.sav) is now supported,
- code counts are reported on line in the code list of the recoding window,
- recodes are written to the project file independently of saving numeric data to the data file.
You can also test the demonstration versions of this program.
|
|
Our presentation "Respondents in the Net - Market Research among Existing Internet Communities" (Marta Trybulec, Michal Trybulec)
has been accepted for this year's
IX Polish Congress of Market and Opinion Researchers.
Come and take a look!
|
|
First version of our new software for data acquisition -
YAC Interview Kit - is ready.
CAPI and CAWI surveys are supported, also data exporting to various formats, including
YAC Data Kit.
All typical question types,
are supported, as well as quota control, filters, multi-media content, and custom layouts.
You can also test demonstration versions of these programs.
|
|
GfK Polonia became a user of our
SPSS-2-Excel program.
|
|
Data from the General Social Survey imported into our
YAC Data Kit software,
also available on our YDOL
server.
You can find more information on the project's page.
|
Market Research in Poland - 2007 |
Summary of turnovers of market research companies in Poland in the years 1996-2007
based on the newest data published by OFBOR.
|
|
Academy of Humanities and Economics in Lodz became a user of our
DataGate Suite program.
|
|
A new project is starting in GG Network (previously: Gadu-Gadu) - GaduSonda - conducting market research surveys
among the instant messagener' users and among Gadu-Gadu's internet communities.
YAC Software will create the interviewing software, will be handling day to day survey management, data processing, and analysis tasks,
as well as contacts with GaduSonda's clients.
|
|
An update to our data entry software DataGate Suite is available
for download.
|
|
Official release of the system with the YAC Data On-Line application.
|
|
P&P Consulting became a user of our
SPSS-2-Excel program.
|
|
2 Research Poland became a user of our
DataGate programs.
|
|
Starcom became a user of the
YAC Data Analyzer program.
|
|
Go to the Download page to try out
the demonstration version of the YAC Data Builder application (YDB-Lite) and the full version
of YAC Data Analyzer.
|
|
4P research mix became a user of the
YAC Data Analyzer program.
|
|
Ipsos Poland became a user of our
YAC Data Analyzer and
DataGate programs.
|
|
Marta Trybulec
will be our new Marketing Boss - welcome aboard!
|
|
YAC Data On-Line now includes a second functionality
- a viewer of predefined reports (alongside already available wizards for defining new analyses).
Reports may contain tables and charts, and can be recalculated for predefined target groups and/or waves.
This allows for very quick distribution of results to clients.
|
|
In version 2.30 of YAC Data Kit many analytical functions were added / enhanced:
- significance tests for means and fractions on any given level of significance,
- option for showing table margins,
- new statistics: variance and standard deviation,
- parameter for showing calculation base (for each cell),
- exclusion of system missing data from calculation bases,
- faster calculation of media plans and faster optimization,
- more and enhanced analysis wizards,
- option for hiding empty rows and/or columns.
Moreover, presentation of result was enhanced (e.g. base coloring, distinction of differing bases, percent signs).
|
|
YAC Data On-Line (YDOL) preview,
a version of our data analysis program that runs under internet browsers, is already available for your evaluation -
please use this link to go the application's pages.
|
|
Inquiry became a user of our
DataGate programs.
|
|
YAC Data Kit in version 2.20 adds the possibility to define
and analyze questions
that are defined by several dimensions (or axes), such as:
- opinions x evaluation (how strongly respondents agree or disagree with an opinion) with labeled and numeric scales,
- statements x brands (which brands fit a given statement),
- statements x brands x scale (how well each brand fits a given statement).
Based on tables with results from multi-dimensional questions,
new types of charts may be easily prepared.
|
|
ARC Rynek i Opinia, already the 5th market research institute, became a user of the
YAC Data Analyzer program.
|
|
YAC Data Builder 2.10 - the program for importing data into YAC Data Analyzer -
in the previous version was a console application. Currently it is an
integrated GUI environment that contains a fully functional script editor for .dbs files
and many functions that help and ease script preparation and data processing:
- an import utility that loads data directly from SPSS (.sav) files and allows for defining the data's structure (modules, question definitions),
- syntax highlighting,
- column blocks,
- search / replace with regular expressions and incremental search,
- multi-level undo and redo,
- macro recording and playback,
- script validation,
- data processing directly from the editor,
- run YAC Data Analyzer automatically on the processed data,
- make-type utility that processes only the changed parts of the documentation and data,
- and many, many more...
The previous console version is still available (for batch processing).
Press analysis extensions in YAC Data Analyzer 2.10 include:
- handling of readership data by days for dailies in general analysis and media plans,
- handling of data on the number of issues, circulation and sales (also by days of the week and by regions),
- calculation of indicators based on the number of issues, circulation and sales (e.g. cost of insertions / sales),
- automatic importing and displaying of data collected by Polish Audit Bureau of Circulation (Zwiazek Kontroli Dystrybucji Prasy).
Moreover, many smaller extensions were added that should help in day-to-day program usage.
|
|
I-Metria became a user of the
YAC Data Analyzer program.
|
|
Pentor-Poznan became a user of the
YAC Data Analyzer program.
|
|
YAC Data Analyzer 2.00 introduces
press
media plan
optimization.
Genetic and randomization algorithms are used to find media plans that meet one or more criteria,
but can also optimize for two or more values (such as OTS 1+ and Freq) at the same time.
Optimization for two or more target groups is also supported.
Full export of reports (including charts) was also added to the program.
|
|
Our client, TNS OBOP,
also became a user of the YAC Data Analyzer program.
|
|
ACNielsen Poland became a user of the
YAC Data Analyzer program.
|
|
The next version of YAC Data Analyzer (1.20) introduces
press readership data analysis,
with calculation of advertising campaign indicators (media plan).
You can compute all kinds of readership indicators, such as last issue readership,
average issue readership, season cycle readership, number of issues read,
number of contacts with an issue, readers per copy, and many more. Moreover, the following functions are available:
- preselection of titles based on the regions they are issued in,
- seamless transition from the readership analysis module to the media planning module, or rather the possibility of joint analysis
of readership and media planning indicators,
- OTS and OTS+ computations on any level (e.g. OTS 10, OTS 20+),
- merging of OTS levels (e.g. OTS 1:3),
- analysis of all indicators by waves of the survey and in various target groups,
- crossing of all indicators with other questions,
- analysis of coreadership and structure,
- simultaneous analysis of many price lists,
- analysis of only those readership and media plan indicators which are of interest to the user,
- all data may be analyzed for groups of titles,
- the CPP and CPM indicators are available in GRP, Reach, and Effective reach flavors (for any level of effective reach, e.g. OTS 3+),
- population estimation of the indicators: AIR, GRP (i.e. Gross Impressions), OTS, OTS+.
In price lists you can define advertisement prices for all titles and various types of ads,
and you can set a default price - one that will be automatically taken for new analyses. Price list comparison
allow to take into account all kinds of promotions, discounts, packages, and other kinds of special offers.
|
|
In the new version of YAC Data Analyzer (1.10) you can analyze
radio audience data.
The following indicators may be computed: spontaneous and prompted awareness, weekly and daily reach, and reach in quarters.
The analysis may be crossed by the places of listening and radio signal source.
You can also analyze the mean time of listening, market share, and average quarter audience.
The program allows for trends analysis, comparison of target groups,
calculation of audience structure, colistening of stations and crossing of all indicators
by any of the other questions.
All this in flexible pivot tables with the possibility of estimation of the results to the surveyed population,
sorting, aggregated analysis for groups of stations, days of the week, time segments and other parameters.
You also get: preselection of stations based on emission regions and easy report exports to other applications.
|
|
After nearly four months of intensive work we are ready to present the first version
of our analytical software: YAC Data Analyzer. Most of our efforts were directed
at creating a general platform for the development of various kinds of analyses in the future,
but with this version you already get multi-dimensional pivot tables with nested parameters,
a fully operational charting module, multi-wave analysis, complex filter (target group) definitions,
standard descriptive statistics, analysis of weighted data, and automatic data recalculation
after installation of new data. The application is bilingual (Polish-English with the possibility of extension to other languages),
the survey texts may be in one, two or more languages.
|
|
Millward Brown SMG/KRC contracted us to prepare software which would help in processing data
from the survey of outdoor advertising. In the study, with the help of GPS, data was collected on the positions of billboards
and on respondents' routes through the city (Wroclaw). Our first application
visualized these positions and routes, and calculated billboards closest to respondents. The second program processed the collected data
to compute reach and other media indicators.
|
|
On this day, the company YAC Software was formed -
we are planning to develop software for the market research industry,
concentrating on analytical and data processing applications.
|
Top
|