Introduction to Computer Science

A Quick Look at Curve Expert 1.40

CurveExpert is a comprehensive curve fitting system for Windows. XY data can be modelled using a toolbox of linear regression models, nonlinear regression models, interpolation, or splines. Over 30 models are built-in, but custom regression models may also be defined by the user. Full-featured graphing capability allows thorough examination of the curve fit. The process of finding the best fit can be automated by letting CurveExpert compare your data to each model to choose the best curve. This program was designed to be simple but powerful, so that all users can obtain a model for their data quickly and easily.
The image to the left is from version 1.4. A manual for curve expert can be found here.

Start by going to drive Y and then into my directory and then to CURVEExpert and then to curxpt. Click on cvxpt32.exe

Lets look at the population for Australia from 1950 to 2000. We can get the data from census data. Go to this site and click on Data Access. Pick Australia and select the years from 1950 to 2009 and submit. What we would like to do now is the grab these populations and insert them into CurveExpert. See if you can do this.

DO NOT TYPE. WORK OUT A WAY TO CUT AND PASTE.

When it is stored in CurveExpert then use curve finder to draw a graph.

Expand the graph size so you can see some predictions that this graph makes.

HERE is the Method

1. Copy the row of values from the web site.

2. Paste it into excel. It will enter as single cell so you need to expand it across multiple cells using the text to columns support under the Data tab.

3. Select the row of values and under the home tab go to format and then format cells and remove the comma selection. This should remove the commas.

4. We now must turn the row into a column. Do this by copying the row and then click on the cell at the top of the column you want to paste. Right click and select Paste Special with the transpose option clicked. This will paste the data as a column.

5. To the left of this column create a new column with the numbers 1950, 1951, ... 2000. Use a formula to copy it down.

6. You can do one of two things here. a) you can copy and paste these two columns into notepad and save the file as name.dat or b) you can see if you can paste the data directly into CurveExpert.

7. Once it is in CurveExpert it should look like the following. Note the graph. It is not what you might have expected. Is this what you would get with another country, say the US?