2D3D Scientific Calculator User Manual

Example of importing data from Excel into 2D3D Calculator  
The example below shows two rows of data.  Row 2 represents the independent variable we will call X and Row 3 represents the dependant variable we call "Y"  where Y is equal to some function of X     Y=F(x)   (See corresponding picture) Click here to see full size of image

Excel data in rows equation linear fit regression

 

The first thing to do is to transpose the data by highlighting the data with your mouse, then select the "copy" option under the "Edit" menu.  (See corresponding picture) Click here to see full size image

Copying data from excel linear fit regression

 

Now open a new spread sheet by clicking on the new spread sheet button  (See corresponding picture) Clicke here to see full size image

 

Next you need to transpose the data from Rows to Columns. This is done by selecting the "Past Special" option located under the "Edit" menu.  
Now select the "Transpose" option located at the bottom of the selection window. (See corresponding picture) Clicke here to see full size image

Next you need to save the data as a tab delimited text file.  This just means that the your data will be saved in a .TXT file where you data is separated by tabs.  (See corresponding picture) Clicke here to see full size image

After you have saved this file, you can close Excel and open the 2D3D calculator program and select the "ANALYZE RAW DATA" button in the middle of the screen.  

linear regression - analyze raw data scientific calculator

Now select the "Open Text File" option located under the "File" menu.
This will bring up import option screen.  The "Tab" option will be enabled by default.

 

Click here to see ful size image.

 

 

Click on the "OK" Button. This will bring the data into the 2D3D Scientific Calcualtor Program.  The graph will show column 0 by default.  If you want to display multiple columns then hold down your shift key and click on columns 1, 2,3...etc.  If you want to plot an X-Y plot then select the "Chart Type" option and select 2D XY.

 

Click here to see larger image

 

Example of Creating a 7th Order Polynomial Fit Equation Regression With 1 column of data.  
 Open the 2D3D calculator program, select the "Analyze Raw Data"  Button.  linear regression - analyze raw data scientific calculator
If you do not have data then choose the "Open" option under the "file" menu.
Select the file called Mars-gravity.bna  
Your screen should now look like this

Now click on the   Button  
The default type of fit will be "Polynomial".   You can change the background colors of the graph, and the line colors and line widths. 

You can also change the precision of the fit, to have more accuracy. 

 

The equation shows up in the white box at the bottom of the screen. Unfortunately it is not setup to do a copy and paste.  This will be available in the next version of the software.   

 

Example of Creating a 7th Order Polynomial Fit Equation Regression With 2 columns of data- XY data where Y=F(x)  
Open the 2D3D calculator program, select the "Analyze Raw Data"  Button.  linear regression - analyze raw data scientific calculator
If you do not have XY then click on the link below. This will open a .txt file.  Choose the "save as" command.   data/hw-1.txt     Choose a place on your hard drive to save this text file.   Then go to the 2D3D Scientific Engineering Calculator program and select the "Open Text File" command located under the "File" menu.  Then select the file you just saved to your hard drive.  

 

This will bring you to the text import screen.  The "tab" option is selected by default.  Click on the OK button.

If you used the data shown above your screen should look like this.

Note that the "COL 0" option is selected by default.  Hold your shift key down and select "COL 1" .  
Next select the "2D XY" plot option  

Your screen should now look like this.

Now click on the button.  
Your screen should look like this.  The default order is 5, if you want seventh order polynomial fit, change this parameter to 7.
You can also change the precision of the fit, to have more accuracy. 
The equation shows up in the white box at the bottom of the screen. Unfortunately it is not setup to do a copy and paste.  This will be available in the next version of the software.