Microsoft Excel add-in for the statistical analysis of contingency tables

2014 ◽  
Vol 2 (5) ◽  
pp. 90-100
Author(s):  
Peter Slezák ◽  
Pavol Bokes ◽  
Pavol Námer ◽  
Iveta Waczulíková
Keyword(s):  
Statistical Analysis ◽  
Contingency Table ◽  
Contingency Tables ◽  
Visual Basic ◽  
Statistical Analyses ◽  
Contingency Table Analysis ◽  
Microsoft Excel ◽  
Statistical Software ◽  
Visual Basic For Applications ◽  
Table Analysis

This paper introduces “Contingency table analysis”, a freely available menu-driven add-in program for Microsoft EXCEL, written in Visual Basic for Applications (VBA), for basic univariate and bivariate statistical analyses of contingency tables. The program provides modules for the statistical analysis of proportions, 2 × 2 tables, stratified 2 × 2 tables, and R × C tables. We compare the results of the analyses performed using our software with those obtained by commercially available statistical software. The comparison shows that our software performs equally well. The use of the add-in facilitates the convenient prosecution of basic statistical analyses on contingency tables from within EXCEL, sparing us the additional cost, or the inconvenience of alternating between multiple platforms, often incurred in using a commercial statistical package.

DEVELOPMENT OF AUTOMATED EVALUATION OF POSITIONING ACCURACY FOR SPECIALIZED NETWORKS’ POINTS IN TRILATERATION NETWORKS

2020 ◽  
Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов
Keyword(s):  
Coordinate System ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Positioning Accuracy ◽  
Automated Evaluation ◽  
Visual Basic For Applications ◽  
Multiple Configurations

В данной работе рассмотрен принцип работы созданного алгоритма, позволяющего автоматически определять среднюю квадратическую погрешность планового положения пунктов сетей трилатерации и представлены результаты автоматизации данного процесса при различных конфигурациях сети, с использованием пакетов Microsoft Excel, Visual Basic for Applications. This paper presents automatic solution for evaluating accuracy of positioning for specialized networks’ points in a plane coordinate system. The paper presents results of automation of this process through analysis of multiple configurations of trilateral networks using Microsoft Excel, Visual Basic for Applications.

scholarly journals A VBA module simulation for finding optimal lag order in time series models and its use on teaching financial data computation

2020 ◽  
Vol ahead-of-print (ahead-of-print) ◽  
Author(s):  
Alan Mustafa ◽  
Abdulnasser Hatemi-J
Keyword(s):  
Dynamic Model ◽  
Information Criterion ◽  
Visual Basic ◽  
Financial Data ◽  
Data Series ◽  
Time Series Models ◽  
Microsoft Excel ◽  
Step Process ◽  
Visual Basic For Applications ◽  
Multiple Variables

In this study, a tool has been designed and developed for learning about the concept of lag order within a dynamic model, which can be used in any teaching classes on statistics and financial data computation. To show a solution for a complex and multi-step process of finding the optimal lag order for multiple variables data series based on an information criterion a module using Visual Basic for Applications (VBA) for Microsoft Excel (MS Excel) is being developed. This module can be used for estimating a multivariate dynamic model as well as determining the optimal lag order of such a model.

Modeling the Behavior of a 50 MW Direct Steam Generation Plant for Southern Libya Based on the Thermodynamic and Thermophysical Properties of Water Substance

2012 ◽  
Vol 134 (4) ◽  
Author(s):  
Y. Aldali ◽  
B. Davison ◽  
T. Muneer ◽  
D. Henderson
Keyword(s):  
Software Tool ◽  
Visual Basic ◽  
Steam Generation ◽  
Construction Costs ◽  
Microsoft Excel ◽  
Solar Fraction ◽  
Visual Basic For Applications ◽  
Generation Plant ◽  
Direct Steam ◽  
Plant Capacity

This paper presents arguments for the use of direct steam generation (DSG) in preference to other forms of generation in particular locations according to the prevailing environmental and economic conditions. In addition, the paper describes the development of a software tool based on Microsoft Excel and Visual Basic for Applications (VBA), which draws upon established physical relationships in the heat transfer literature to perform plant capacity calculations in a fast and convenient manner. The results of the VBA program determine the solar fraction of the plant, assuming that the plant is in operation for 10 h per day (07:30–17:30 hours), the solar fraction is shown to be 76% and the DSG plant achieves a 76% reduction in emissions. Construction costs are also estimated based on formulae from previous work.

Sign in / Sign up

Export Citation Format

Share Document