• The Korean Journal of Nuclear Medicine Technology
• /
• v.20 no.2
• /
• pp.69-74
• /
• 2016

Purpose Using a regression formula of the trendline near the coefficient of determination (R2) "1" by substituting the dependent variable of the standard curve to calculate the values of the independent variable. To determine the suitability of a regression equation by comparing the difference between the independent variables of the standard curve and the predicted independent variables. Materials and Methods Perkin Elmer Gamma-Counter machine was used for Standard curve of regression methods. TSH. TG-Ag (Thyroglobulin Antigen), Insulin that used materials and method test to compare the result from the Excel trendline of the regression formula. Results Each of the value of coefficient of determination ($R^2$) and Trendline $R^2=1$, Polynomial Trendline for TSH, $R^2=1$, Polynomial Trendline for TG-Ag, $R^2=0.9994$, Polynomial Trendline for Insulin. Conclusion We confirmed that IRMA immune method is found to the nearest trends elected a standard curve using polynomial trendline. The independent variables to predict the trend by using a polynomial trendline formula containing the error was a limitation.

• School Mathematics
• /
• v.8 no.3
• /
• pp.265-290
• /
• 2006

The purpose of this study is to search an effective teaching & learning program by examining how much does Excel affect on problem solving of linear function. This study was based on qualitative case study. Teaching experiment was performed for seven periods with five students in 8th graders. Pre and posts tests were attempted to analyze the changes of student's ability on problem solving of linear function. The analysis of tests were performed in category with correct process-object perspective, near process-object perspective, incorrect process-object perspective. According to this study, the subjects showed an improvement on problem solving perspective of linear function. This meant that lessons using Excel had influenced on the problem solving of linear function. We noticed that exploring the learning environment with Excel could supplement paper-and-pencil environment. We believed that Excel with an intuitive dynamic and explorative skills can play a role in scaffolding to support problem solving of linear function.

• Proceedings of the Korea Water Resources Association Conference
• /
• 2017.05a
• /
• pp.334-334
• /
• 2017

Representative particle sizes(RPS) are commonly used for particle size distribution of heterogeneous sediment such as bed material. RPS can provide not only information of mean characteristics of sediment, but also other properties like sorting, skewness, kurtosis. For sediment including sand and clay material, RPS is estimated through two steps. The first is experimental step for calculating weight of each size class, the next is interpolation step to get RPS by using the graph plot. At the second step, graph method known as direct reading of value along the interpolation line in the graph plot is commonly used. This method is often time-consuming job. In this study we developed a new program to get RPS by using MS Excel. Simple linear and semi-log interpolation are used. When compared with conventional graph method(direct reading), simple linear shows 5.31%, while semi-log 1.29% of relative difference. We developed MS Excel program for estimation of RPS automatically.

• Journal of Educational Research in Mathematics
• /
• v.15 no.1
• /
• pp.75-105
• /
• 2005

This study explored a mathematical modeling flow and the effect of interactions among students and between a student and Excel on modeling in a small group modeling environment with Excel. This is a case study of three 8th graders' modeling activity using Excel during their extra lessons. The conclusions drawn from this study are as follows: First, small group modeling using Excel was formed by formulating 4∼10 modeling cycles in each task. Students mainly formed tables and graphs and refined and simplified these models. Second, students mainly formed tables, algebraic formulas and graphs and refined tables considering each variable in detail by obtaining new data with inserting rows. In tables, students mainly explored many expected cases by changing the values of the parameters. In Graphs, students mainly identified a solution or confirmed the solution founded in a table. Meanwhile, students sometimes constructed graphs without a purpose and explored the problem situations by graphs mainly as related with searching a solution, identifying solutions that are found in the tables. Thus, the teacher's intervention is needed to help students use diverse representations properly in problem situations and explore floatingly and interactively using multi-representations that are connected numerically, symbolically and graphically. Sometimes students also perform unnecessary activities in producing data by dragging, searching a solution by 'trial and error' and exploring 'what if' modeling. It is considered that these unnecessary activities were caused by over-reliance on the Excel environment. Thus, the teacher's intervention is needed to complement the Excel environment and the paper-and-pencil environment properly.

• Journal of Korean Medicine Rehabilitation
• /
• v.28 no.1
• /
• pp.85-96
• /
• 2018

Objectives This study was performed to compare the electrical methods of motor points mapping using surface EMG and electric probe (Pointer Excel II). Methods 32 healthy adults (male 16, female 16) were selected. and classified into two groups; surface EMG group, electric probe (Pointer Excel II) group. In surface EMG group, motor points were searched by recoding the compound muscle potentials. In electric probe (Pointer Excel II) group, motor points were searched by scanning the skin with Pointer Excel II at low level stimulation. The locations of the motor points were expressed as X and Y values in relation to the reference line. The horizontal reference line was set as elbow crease and the vertical reference line was set as the line connecting coracoid process to the center of the horizontal reference line. The data was analyzed by 'Independent T-test' and 'equivalence test'. Results 1. The motor points of short head and long head of biceps brachii muscle were located at about 2/3 length of the vertical reference line from coracoid process and about 1/5~1/4 length of the half of the horizontal reference line from the vertical reference line in both group. 2. The motor points of the short head were located more distally and close to the vertical reference line (p<0.001). 3. In surface EMG group, the motor points of the long head were located more laterally in the female than male. And the motor points of the long head were located more distally in the left side than right side (p<0.05). In electric probe (Pointer Excel II) group, similar tendency was observed but there was no statistically significant difference (p>0.05). 4. As a result of the equivalence test between surface EMG group and electric probe (Pointer Excel II) group, the confidence intervals of the difference were within the equivalence limit. Therefore, the locations of the motor points searched by two ways are equa l (p>0.05, equivalence interval=3%). Conclusions The results indicate that electric probe (Pointer Excel II) can be used to search the motor points instead of surface EMG. This might improve the clinical efficiency when using the motor points to treat muscle dysfunction.

• Journal of Bio-Environment Control
• /
• v.10 no.3
• /
• pp.187-196
• /
• 2001

Asparagus varieties popular in the foreign countries were collected and tested on their productivities and qualities for five years under rain shelter and open field conditions. Among the tested varieties, cultivars of UC309 and Excel showed superior productivity to the others in spear weight but the initial growth was not different among the tested varieties. However, the growth index was higher than the other varieties. According to the result from eight-year experiment, the best variety in productivity and quality were UC309 and Excel both for rain shelter and open field cultivations. To avoid the damage caused by stem blight, rain shelter and soil surface mulching treatments were tested with var. Excel. The spear sprouting and first harvesting date were a few days earlier in rain shelter cultivation than in open field, but there were no differences among the mulching materials. The number of spears and the spear weight per plant were increased in rain shelter cultivation, especially with rice straw and black P.E. mulching treatments. Marketable yield also increased by 253% in black P.E film mulching in rain shelter cultivation compared to non-mulching in open field. The stem blight examined in the autumn, 1997 was not observed under rain shelter treatment, but severe damage was observed in the open field regardless of the mulching materials. In the experiments, high asparagus yield could be achieved by black P.E. film mulching in rain shelter cultivation without the occurrence of stem blight.

• Journal of the Korean Data and Information Science Society
• /
• v.17 no.3
• /
• pp.811-820
• /
• 2006

We introduce a program that enhances the interest and understanding of students in Statistics. This program explains various statistical concepts and procedures by showing detailed steps of calculations with graphs and simulations. This program utilizes a readily accessible Excel VBA.

• Journal of Korean Ophthalmic Optics Society
• /
• v.16 no.1
• /
• pp.107-116
• /
• 2011

Purpose: The review article was written to establish an excel program that could calculate minimal Dk of contact lens without $O^2$ deficiency and actual $O^2$ concentration on cornea when contact lens were being fitted by changing lens-related factors. Methods: An excel program was formulated to calculate the thickness of post-lens lacrimal layer, Dk of contact lens and $O^2$ concentration on cornea. Results: With the excel program established, minimal $O^2$ concentration needed on cornea could be calculated when the thickness of post-lens lacrimal layer was changed by varying lens-related factors. A different route in the excel program was needed to choose based on the shape of lacrimal layer. The thickness of lacrimal layer was determined by the shape of meniscus made of tear between lens edge and cornea with flat fit. Thus, the $O^2$ concentration showing negative number in calculation decreased on peripheral cornea with flatter fitting and actual $O^2$ concentration would be zero on cornea. With tight fitting, the thickness of post-lens lacrimal layer is much thicker than lens itself thus negative number in calculation by the excel program is shown indicating zero oxygen on cornea. It can cause $O^2$ deficiency regardless of Dk of contact lens. Conclusions: The calculation of thickness of post-lens lacrimal layer and $O^2$ concentration on cornea by the established excel program is suggested to avoid $O^2$ deficiency when fitting state is varied by changing lens-related factors.

• Korean Journal of Agricultural and Forest Meteorology
• /
• v.20 no.2
• /
• pp.228-232
• /
• 2018

Process-based crop models have been used to assess the impact of climate change on crop production. These models are implemented in procedural or object oriented computer programming languages including FORTRAN, C++, Delphi, Java, which have a stiff learning curve. The requirement for a high level of computer programming is one of barriers for efforts to develop and improve crop models based on biophysical process. In this study, we attempted to develop a Chinese cabbage model using Microsoft Excel with Visual Basic for Application (VBA), which would be easy enough for most agricultural scientists to develop a simple model for crop growth simulation. Results from Soil-Plant-Atmosphere-Research (SPAR) experiments under six temperature conditions were used to determine parameters of the Chinese cabbage model. During a plant growing season in SPAR chambers, numbers of leaves, leaf areas, growth rate of plants were measured six times. Leaf photosynthesis was also measured using LI-6400 Potable Photosynthesis System. Farquhar, von Caemmerer, and Berry (FvCB) model was used to simulate a leaf-level photosynthesis process. A sun/shade model was used to scale up to canopy-level photosynthesis. An Excel add-in, which is a small VBA program to assist crop modeling, was used to implement a Chinese cabbage model under the environment of Excel organizing all of equations into a single set of crop model. The model was able to simulate hourly changes in photosynthesis, growth rate, and other physiological variables using meteorological input data. Estimates and measurements of dry weight obtained from six SPAR chambers were linearly related ($R^2=0.985$). This result indicated that the Excel/VBA can be widely used for many crop scientists to develop crop models.

• Journal of the Korea Society of Computer and Information
• /
• v.9 no.3
• /
• pp.201-209
• /
• 2004

In this paper, You can design drawing to safekeep and manage equipments in order to utilize efficiently by making use of Visio, and can convert stored data into Office data after inputting user attributes of each equipment. that means that you can analyze each data by using functions of Excel after changing Visio safe attributes into Excel data and XML data, and control and utilize data effectively by converting XML data into DB ones. Additionally. you can use on deliveration of useful information on shopping mall. At last, we present how to share and utilize transformed equipments on the web by designing and making and transforming Data type for good management of equipments of computers existed in university.