Normális eloszlású sokaság szórására vonatkozó hipotézis tesztelésére a khi-négyzet próbát kell alkalmazni. Ennek végrehajtását teszi egyszerűvé és jól áttekinthetővé Microsoft Excel Visual Basic for Applications szolgáltatásával elkészült alkalmazás, melynek fejlesztése kerül bemutatásra. Egyetlen űrlap biztosítja az adatok megadását, valamint eredmények megjelenítését űrlapon elhelyezett vezé...

Abstract—The paper focuses to the process of modeling and computer simulation of the real experiment. Step by step there is shown system identification and creation of mathematical model of determination of optimum reaction time of whey acidic for the hydrolysis of proteins of lupine flour. Computer simulation model created in MS Excel spreadsheet and visualized in MS Excel XYZ surface chart is...

Spreadsheet software, notably Microsoft Excel©, can be used very effectively for analyzing logistics and supply chain issues. Spreadsheet allow analysis from many different perspectives and can be modified and enhanced to reflect new situations and options. Our purpose in this article is to demonstrate the efficiency of a problemsolving algorithm that uses Microsoft Excel add-in tools Premium S...

Different actors like teachers, course designers and content providers need to gain more information about the way the resources provided with Moodle are used by the students so they can adjust and adapt their offer better. In this contribution we show that Excel Pivot Tables can be used to conduct a flexible analytical processing of usage data and gain valuable information. An advantage of Exc...

We begin by considering the expectations of the creators of VisiCalc, the first spreadsheet. The emphasis is on the nature of the spreadsheet grid. The grid is taken as a presentational method for showing a solution to a Sudoku puzzle. We consider methods or approaches for the solution. We look at the relationship between this model and academic papers on the methods for describing and categori...

Many scheduling dispatching rules are intuitive and processes which people utilize in every day life. As an example, when faced with a variety of tasks due at different times one often implements the earliest due date scheduling rule: the next task worked on is the one with the earliest due date. Other common scheduling dispatching rules have the nice property of being easy to understand, there...

Ordering queries within a workload and ordering joins in a query are important problems in databases [1]. We give algorithms for the query sequencing problem that scale (small space) and are efficient (low runtime) as compared to earlier work [4]. The errors are small in practice and we are able to further reduce them using geometric repair. We provide a computational comparison of TSP solvers ...

Data clustering refers to the method of grouping data into different groups depending on their characteristics. This grouping brings an order in the data and hence further processing on this data is made easier. This paper explains the clustering process using the simplest of clustering algorithms the K-Means. The novelty of the paper comes from the fact that it shows a way to perform clusterin...

Creating user defined functions (UDFs) is a powerful method to improve the quality of computer applications, in particular spreadsheets. However, the only direct way to use UDFs in spreadsheets is to switch from the functional and declarative style of spreadsheet formulas to the imperative VBA, which creates a high entry barrier even for proficient spreadsheet users. It has been proposed to ext...