Curve fitting software makes sense of test data
An
Adept Scientific product story
Edited by the Engineeringtalk editorial team
Jan 27, 2004
XLfit 4 is a novel software addon for Microsoft Excel that enables automated curve fitting, statistical analysis and results presentation.
XLfit 4 is a novel software addon for Microsoft Excel that enables automated curve fitting, statistical analysis and results presentation.
Developed by ID Business Solutions (IDBS) - leading provider of integrated data management, analysis and decision-making software - XLfit extends the functionality of Excel to provide a straight-forward and efficient way for researchers to carry out all their curve fitting and statistical analysis within the familiar Excel environment.
XLfit 4 offers more than 70 predefined linear and nonlinear mathematical models and equations, as well as allowing researchers to apply custom equations and fitting models to data sets.
According to Thomas Harding, Data Analysis Software Specialist at Adept: "Many scientists use Excel for their data manipulation and storage.
They don't need the time-consuming steps involved in moving data between applications for curve fitting or statistical analysis.
Unlike stand-alone proprietary packages, XLfit extends the functionality of Excel with research-strength curve fitting and high quality statistics, combined with the required charting capabilities.
This really will change the way many scientists work".
Neil Kipling, IDBS' Chairman and Chief Executive Officer added: "IDBS' goal is to help maximise the research productivity of our customers.
Sometimes that means keeping it simple.
XLfit 4 does exactly that - without compromising on functional sophistication - by empowering researchers in any quantitative discipline to carry out advanced statistical and curve fitting work with ease within the industry-standard spreadsheet environment".
XLfit 4 comprises three designer tools.
The "Fit Designer" helps users choose the right curve-fit model and equation.
Users are aided in their selection by a preview pane that visualises the data even before the model is applied and with descriptions of the extensive range of mathematical models available.
Researchers choose the best-fit model for a particular data set using statistical criteria such as the T-test and F-test of statistical significance.
Fit and parameter statistics can be edited, and custom models and parameters added as required.
The application includes a full set of discovery research curve fitting models, including exponential, power series, sigmoidal, hyperbolic, yield density, linear, polynomial, dose response, inhibition curves, equilibrium binding (single and multiple site analysis) and slow binding.
XLfit 4 comes with an extended range of models and features such as 3D fitting and charting, PA2, global fitting and automatic outlier rejection.
These models allow researchers to entirely automate the fitting processes without leaving Excel and to generate the required results fast.
The "Chart Designer" offers extended style and display options, allowing users to tailor every aspect of an XLfit chart's appearance, including curve style, colour, data point symbols, fonts, titles, axis labels, and grid and intersect lines.
Any number of curves can be overlaid in a worksheet and annotations may be displayed anywhere on the graph.
Design settings can be saved as chart templates and reapplied to other XLfit 4 charts.
XLfit 4 also offers full, high quality printing facilities.
The seamless integration of XLfit 4 with the Microsoft Office suite ensures that when an XLfit chart is copied and pasted into other applications such as Word or PowerPoint, there is full access to the chart and display details, which may then be edited and saved within the new application - users simply double click a chart to activate it and amend any aspect they choose.
The "Statistics Designer" enables users to apply predefined and customised statistical equations and fitting models to an Excel worksheet - users can edit the formulas directly to build their own functions with VBA (Visual Basic for Applications).
XLfit provides a host of statistical equations for different statistics categories including linear correlation coefficients, Spearman's rank correlation, analysis of variances, student T-test and linear regression analysis.
XLfit is available to buy from Adept Scientific.
Not what you're looking for? Search the site.
Contact Adept Scientific
Tel +44 1462 480055
Other Adept Scientific stories
-
Curve-fitting software validated by NPL
The United Kingdom's National Physical Laboratory has tested and validated the numerical correctness of the curve-fitting component of the XLfit 4 add-on for Excel. -
Maple provides analysis for CAD systems
Maple supplies analysis capabilities to CAD systems, giving users of NX software the ability to analyse and optimise designs. -
MeasX enhances data acquisition system
MeasX has released version 11 of its Dasylab data acquisition system laboratory, which is now available from Adept Scientific. -
Adept announces software seminars
UK technical software specialists Adept Scientific has announced a series of free informative webinars that introduce research staples, Endnote, Endnote Web and Reference Manager. -
Adept and SPC plan to host industry event
Adept Scientific and SPC software developers Northwest Analytical are organising an exclusive industry SPC event.
Browse by category
-
Capital Equipment (3,507)
- Capital Equipment (1)
- Compressors and Air Treatment (537)
- Electrical hardware (131)
- Electronics Manufacturing, Tools, Instruments (192)
- Machinery and Production Equipment (1,128)
- Manufacturing Machinery and Plant Equipment (474)
- Production line blowers and fans (73)
- Robotics, Handling and Storage (971)
- Consultancy and Services (920)
-
Control and Instrumentation (5,117)
- Cabling, Conduit, Signal Conditioning (814)
- CNC and Motion Controllers (189)
- Control and Instrumentation (2)
- HMIs/Operator Interfaces (296)
- Logic Controllers, Timers and Relays (96)
- Mid-range and Large PLCs (203)
- Plant- and Machine-Wide Communications (1,201)
- Plantwide control (1,350)
- Power Supplies, Uninterruptible Power (574)
- Smaller-Sized PLCs (392)
-
Drives, Motors and Controls (3,432)
- Drives, Motors and Controls (2)
- Industrial Drives/Controls (1,290)
- Industrial Motors (501)
- Linear Drives and Motors (120)
- Precision Motors and Gears (429)
- Stepper and Servo Drives, Motors, Controls (1,088)
-
Electrical and Electronic Equipment Design (4,296)
- Batteries, chargers and circuit protection (582)
- Connectors, Terminals, Busbars, Slip Rings (715)
- Electrical and Electronic Components (647)
- Electrical and Electronic Equipment Design (3)
- Electrical and Electronic Subassemblies (374)
- Enclosures and Equipment Cooling Fans (721)
- Knobs, Handles and Enclosure Hardware (430)
- PCs and Embedded Systems (824)
-
Engineering Design Software (6,348)
- 2D CAD software (203)
- 3D CAD software (1,187)
- CAM, CNC, production management software (581)
- Data, document management software (322)
- Electrical design software (166)
- Engineering Design Software (17)
- FEA and structural analysis software (376)
- File conversion software, data capture (358)
- Fluid, thermal, noise, vibration software (339)
- Materials design and moulding design software (152)
- Maths, charting, statistics, QA software (325)
- PLM and collaboration software (663)
- Process, instrumentation, automation software (269)
- Publishing and documentation software (234)
- Rendering, visualisation, styling software (206)
- Simulation, modelling, validation software (950)
-
Engineering Industry News, Resources (6,205)
- Electronic Resources for Engineers (278)
- Engineering Business News, Views (388)
- Engineering Conferences (438)
- Engineering Education, Resources, Standards (850)
- Engineering Exhibitions, Events (575)
- Engineering Guides, Newsletters (365)
- Engineering Industry Developments, Awards (636)
- Engineering Industry News, Resources (4)
- Engineering Industry Reports, Surveys (597)
- Engineering Recruitment, Employment (219)
- Engineering Seminars (415)
- Engineering Training Courses (457)
- Health and Safety Consultancy, Software (180)
- Health and Safety Events, Training, News (285)
- Health and Safety Legislation (403)
- Health and Safety Strategy, Risk Assessment (115)
- Machine Building (4,612)
-
Materials and Processing (3,025)
- Materials and components (2,263)
- Materials and Processing (5)
- Materials processing and testing (291)
- Rapid Prototyping (466)
-
Monitoring, Measurement and Quality (5,639)
- Data Acquisition Hardware and PC I/O Boards (488)
- Data acquisition Software and Communications (505)
- Data loggers (425)
- Electrical and Electronic Testing, PAT Equipment (642)
- Form/co-ordinate, optical, vision instruments (759)
- Gauges, Indicators and Instruments (448)
- Materials testing equipment (431)
- Monitoring, Measurement and Quality (1)
- Telecomms/network test equipment, software etc (158)
- Testing and Calibration Services and Information (518)
- Testing, analysing and monitoring equipment (1,264)
-
Powertrain Design (3,704)
- Bearings (977)
- Chains and belts (333)
- Gears, brakes, couplings and engines (1,474)
- Hydraulic Components (475)
- Lubricants (441)
- Powertrain Design (3)
-
Sensors (7,266)
- Accelerometers and Vibration Sensors (448)
- Barcode Sensors (103)
- Flowmeters and Flow Sensors (641)
- Gas, Chemical, Radiation, Magnetic Sensors (290)
- Humidity and Environmental Sensors (158)
- Level Sensors and Leak Detectors (537)
- Linear Position Sensors (413)
- Loadcells, Force Sensors, Torque Sensors (727)
- Pressure sensors (639)
- Proximity Sensors (712)
- Rotary Position, Tilt and Angular Sensors (560)
- Sensors (10)
- Temperature sensors (621)
- Vision and Colour Sensors (1,407)
- Small Mechanical Components, Joining, Tools (2,037)
- Valves, Pumps, Process Hardware (3,719)
