http://manuals.pqstat.pl/ 2026-04-24T20:52:10+00:00 http://manuals.pqstat.pl/ http://manuals.pqstat.pl/lib/tpl/dokuwiki/images/favicon.ico text/html 2022-02-09T20:20:10+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:adddelpl Adding, removing and exporting datasheets The first blank datasheet is opened automatically with a new project. Subsequent datasheets can be added to the project via: * menu File→New datasheet (Ctrl+D) * New datasheet button in the Project Manager text/html 2022-02-09T20:39:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:edycjapl Editing data Selection of a consistent area in a worksheet can be done with mouse or keyboard (Arrow keys + Shift). During selection, the size of the selection (number of rows and columns) is continuously displayed in the message bar. You can select the entire worksheet by simply clicking in the upper left corner of the worksheet with the mouse, or by selecting menu text/html 2022-02-09T20:36:44+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:formcellpl Variable properties For each column of the worksheet, we can set its properties such as codes, labels and format. Setting the properties of a variable is possible by * selecting Variable Properties → Codes/Labels/Format from the context menu on the number above the column header, text/html 2022-02-09T20:52:09+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:formulapl Formulas Defining a formula is a way to recalculate data, resulting in new values in variables. The window for defining formulas is opened via Data→Formulas... Formulas assigned to a datasheet variable as the format of that variable are stored with the worksheet data. Their result is automatically recalculated when any of the input data is changed. Formula can be assigned in th text/html 2022-02-09T20:55:19+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:genpl Data generation There are two methods of data generation: * The first method uses simple dragging of the contents from the selected cells to the neighboring cells using the mouse pointer. This method lets you generate the same values (text or numbers) in neighboring columns or rows. text/html 2022-02-09T20:23:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:insdatapl Inputting data into a datasheet The datasheets are empty when created. The user enters data themselves, copies previously prepared data from another data sheet, or imports it. The amount of data a worksheet can hold is limited to 4 million rows and 1000 columns. Each cell can contain a maximum of 40 characters. text/html 2022-02-09T20:44:19+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:kontrawpl Converting a contingency table into raw data The operation of changing a contingency table into raw data is available after selecting menu Data→Create raw data... In the data transformation window, enter the appropriate numbers and row and column headings and confirm your choice with text/html 2022-02-10T20:48:50+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:macppl Similarity matrix The relationship between objects can be expressed by their distances or more generally by their dissimilarity. The further apart the objects are, the more dissimilar they are, while the closer together they are, the greater their similarity. It is possible to examine the distance of objects in terms of many features, e.g. when compared objects are cities, their similarity can be defined, among others, based on: length of the road that connects them, population density, GDP pe… text/html 2022-02-09T21:06:26+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:misspl Missing data In research we very often encounter missing data, this is natural in particular for survey data. There are situations in which missing data provides valuable information. For example: the number of missing data items in response to a question about support for political parties gives an idea about the number of undecided people who do not like (or do not admit to liking) certain political groups. Small numbers of missing data are not a problem in statistical analyses. A large numb… text/html 2022-02-11T17:59:15+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:normstandpl Transformations The transformation window is accessed via Data→Transform... Data transformation is the alteration of data so that it meets certain criteria, such as meeting the criteria for normality of distribution or extending within a specified range. text/html 2022-02-10T20:29:42+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:probkowaniepl Sampling simulation The sampling window is opened via Data→Sampling simulation ... Sampling simulation is a way of generating multinomial distribution data. It involves assigning a given number of cases to categories, in a user-specified manner. The generated data is returned in a new datasheet. The generation can be repeated, so that the datasheet will have many generated columns depending on the number of repetitions of this operation set in the sampling window. text/html 2022-02-09T20:42:43+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:rawkontpl Converting raw data into a contingency table The operation of changing raw data into a contingency table is available after selecting menu Data→Create table... Normally, the entire data sheet is available for this operation (this is the default setting), but if you start the transformation by selecting a piece of data, then in the data transformation window you will have the option to limit the available area to the selection only. text/html 2022-02-09T20:40:22+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:sortapl Sorting data Sorting options are available by selecting menu Data→Sort... or Sort... functionality from the context menu on the number above the column header. Normally you sort the whole datasheet (this is the default setting for sorting), but if you start sorting by selecting a piece of data, then in the sorting window you will have the option to limit the sorting area only to the selection. text/html 2022-02-11T18:01:09+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:stanposrbezposrpl Direct and indirect standardization We bring up the direct and indirect standardization window for epidemiological coefficients via Data→Standardization... Indirect and direct standardization applies to frequency coefficients, e.g. prevalence rates. Direct comparison of raw rates between different populations, usually living in different geographical areas and differing in factors that may influence the rates (e.g. age), may hide the differences. In order to remove the influence of populati… text/html 2022-02-09T20:25:48+00:00 Anonymous (anonymous@undisclosed.example.com) http://manuals.pqstat.pl/en:statpqpl:usepl:arkpl:windpl Datasheet window The rows and columns of the datasheet are indicated by consecutive natural numbers. Each column in the space marked in gray can be given its own heading. At the top of the datasheet is the Message bar. This is where the current user information is displayed. The left part of the bar informs about the size of the selected area [number of rows, number of columns], the middle part displays the value located in the selected cell, and the right part is for the user's information co…