IN VIVO SPREADSHEET Flashcards
(32 cards)
research is the collection and translation of a data set into valuable, usable information. Through this process, a researcher, data engineer or data scientist takes raw data and converts it into a more readable format, such as a graph, report or chart, either manually or through an automated tool.
DATA PROCESSING
a combination of cognitive decisions and mechanical clerical recording of responses in a numerical form with numerous places that errors can occur.
CODING DATA
In most quantitative studies, the data for the variables of interest are collected for numerical analysis. These numerical values are entered into designated fields in the process of coding
Data Coding in Quantitative Research
Two of the most popular programs in use:
1.) IBM SPSS STATISTICS 24
2.) OPEN ACCESS “R” SOFTWARE
an extensible, open-source language and computing environment for Windows, Macintosh, UNIX, and Linux platforms. It performs a wide variety of basic to advanced statistical and graphical techniques at little to no cost to the user
OPEN ACCESS “R” SOFTWARE
like quantitative research, is not a single entity, but a set of related yet individual traditions, aims, and methods
QUALITATIVE DATA
especially helpful to the researcher in handling large amounts of data. However, it must be stressed that the computer applications aid the analysis as a management tool rather than an analytical one. Synthesis of the data is still the interpretive work of the researcher.
newer software packages developed for qualitative data analysis (QDA):
NVivo 12 from QSR (https://www.qsrinternational.com/nvivo/nvivo-products/nvivo12-plus)
MAXQDA (https://www.maxqda.com)
ATLAS.ti 8.4 (https://atlasti.com/).
COMPUTERIZATION
often occur on an ongoing basis with data collection in a reflexive and iterative fashion. There is no clear demarcation of when data collection should end, and analysis should begin.
QUALITATIVE DATA ANALYSES
commonly used by a variety of businesses and employees, including CEOs, managers, assistants, analysts, and sales representatives. Basic spreadsheet concepts and features are described next.
SPREADSHEET SOFTWARE
a group of values and other data organized into rows and columns. Most spreadsheets include formulas that are used to compute calculations based on data entered into the spreadsheet.
Formulas update automatically
No manual computations are required
SPREADSHEET
Widely used Spreadsheet Applications:
1.) MICROSOFT EXCEL
2.) APPLE NUMBERS
3.) GOOGLE SHEETS
1.) A single spreadsheet document is often called a _____
2.) Worksheets are divided into _____and _______.
1.) WORKSHEET
2.) ROW AND COLUMNS
The intersection of a row and a column is called a ______.
Each ______ is identified by its cell address, which consists of the column letter followed by the row number, such as B4 or E22.
CELL
The data entered into a cell is usually a _____________________
1.) LABEL, A CONSTANT VALUE, A FORMULA OR A FUNCTION
1.) ________ are words, column headings, and other nonmathematical data
2.) ________ are numbers without any additional characters (such as 105 or 12740.25).
3.) __________ performs mathematical operations using the content of other cells (such as adding or multiplying the values in the specified cells).
4.) named, preprogrammed formula, such as to compute the average of a group of cells or to calculate a mortgage payment amount
1.) LABELS
2.) CONSTANT VALUES
3.) FORMULAS
4.) FUNCTION
There are two types of cell references
RELATIVE AND ABSOLUTE
By default, all cell references are
RELATIVE REFERENCES
designated in a formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both.
ABSOLUTE REFERENCE
a graphic representation of data. Charts allow users to see what the results of data to better understand and predict current and future data.
A CHART
1.) chart is a chart object that can be inserted into a worksheet
2.) is a chart that is a sheet of its own.
1.) EMBEDDED CHART
2.) CHART SHEET
the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.
WHAT IF ANALYSIS
used by researchers to perform statistical analysis
SPSS statistics software is used to perform only statistical operations.
is a commercially distributed software suite for data management and statistical analysis
SPSS : Statistical Package for Social Sciences
the name of a series of software packages used for data analysis. Its main selling point is that it allows researchers to analyze data without using advanced statistical analysis skills
SPSS
1.) Spreadsheet software
2.) Statistical Analysis software
1.) Excel
2.) SPSS
