## Find Trendline and R-squard value from data...

Hi

I have some data:

Matrix(10, 2, {(1, 1) = 0, (1, 2) = 0, (2, 1) = .5, (2, 2) = 3.25, (3, 1) = 1.0, (3, 2) = 5.82, (4, 1) = 1.5, (4, 2) = 7.50, (5, 1) = 2.0, (5, 2) = 8.79, (6, 1) = 2.5, (6, 2) = 9.83, (7, 1) = 3.0, (7, 2) = 10.66, (8, 1) = 3.5, (8, 2) = 11.35, (9, 1) = 4.0, (9, 2) = 11.94, (10, 1) = 4.5, (10, 2) = 12.46})

I want Maple to make a trendline fitting a Logarithmic function. I can make it output some function with this:

LeastSquares(`<,>`(.5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5, 4.0, 4.5), `<,>`(3.25, 5.82, 7.50, 8.79, 9.83, 10.66, 11.35, 11.94, 12.46), x, curve = a+b*ln(x))

It outputs:

5.96497783539274+4.25309474196387*ln(x)

But please notice, the dataset in the function does not have the first 0 and 0. If i do that:

LeastSquares(`<,>`(0, .5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5, 4.0, 4.5), `<,>`(0, 3.25, 5.82, 7.50, 8.79, 9.83, 10.66, 11.35, 11.94, 12.46), x, curve = a+b*ln(x))

It outputs:

Error, (in Matrix) numeric exception: division by zero

Besides that, i need the R-squard value for determinating how well it fits.

If i do the same thing i Excel the data set will give a formular: 5.5464ln(x)-0.2175 with a R-sward value of 0.9985.

How can i do this i maple?

----

Emil Kristensen

## Maple proc; excel data manipulation...

I am trying some data analysis on an Excel worksheet using Maple. I have the following procedure but I don't know how to make it work for a specific subset of cells (this is a psychological studiy, so I want to have all my scores for each subject, located on the rows, and variable, located on a subset of columns). Example: I want to get an array of all the average scores in a rectangle of cells which goes horizontallyfrom A to AB, and vertically from row 1 to 15. Hope you can help me out! Cheers!

MediaRighe := proc (M) local i, j, r, c, S, N; r := LinearAlgebra:-RowDimension(M); c := LinearAlgebra:-ColumnDimension(M); S := Array(1 .. r); for i to r do S[i] := 0; N := 0; for j to c do if M(i, j) <> "-" then S[j] := S[j]+M(i, j); N := N+1 end if end do; S[i] := S[i]/N end do; return S end proc

I also have this for the columns (same thing, basically):

MediaColonne := proc (M) local i, j, r, c, S, N; r := LinearAlgebra:-RowDimension(M); c := LinearAlgebra:-ColumnDimension(M); S := Array(1 .. c); for j to c do S[j] := 0; N := 0; for i to r do if M(i, j) <> "-" then S[j] := S[j]+M(i, j); N := N+1 end if end do; S[j] := S[j]/N end do; return S end proc

Thanks everybody!

## How to perform row summation...

Hi guys! Maple noob here.

I want to get an array of the sums of each and every row of a matrix which I imported from Excel. I can't manage to work my way around with LinearAlgebra-Add, Sum and eval. Maple always shows me the table and not the scalar I am looking for.

I'd also like to know how to tell Maple how to do something on a certain interval of cells of the matrix.

I hope I have been clear and you can help me out :D

Cheers from Italy!

## Will Matrix Browser export data to specific destin...

My attempt to export array data using the Browse>Export option when looking at the data fails to work as needed.

The exported data always start in cell A1 of the Excel worksheet even a different starting cell is entered into the Matrix Browser export window.

In summary, my experience is that the Matrix Browser matrix export in Maple 16 and Maple 17 ignores the information about the intended starting destination cell in the Excel file.

Does anyone find that the Matrix Browser exports to a starting Microsoft Excel cell other than A1?

This exporting with Matrix Browser worked find in Maple 15.  It has been broken in Maple 16 and 17, including Maple 17.02.

Thanks.

I was successful in getting the Maple add-in to load into Excel 2013 but the help file accessed in the Add-In Ribbon is not found.  Does anyone know where in Excel that file can be loaded?

## Excel 2007-2010-2013 integration with Maple 17...

Hello, everyone!

Last week I’ve encountered problems with integration of Maple 17 in Microsoft Office Excel 2013. The Maplesoft note on the point (http://www.maplesoft.com/support/faqs/detail.aspx?sid=32651) offers some ways of fixing it up, though I’ve run all of them the problem is the same:

While the connection is established, after entering the formula “=Maple(“x+x”)”, the Excel returns “Critical Error in Formula”

Before contacting the Maplesoft Technical Support, I want to ask here whether someone had the same case and managed to solve it.

## Export data calculated in a for loop...

Hello,

it is more or less my first time using maple for my research. During my mesurements I collect data and store those in an excel sheet. The I made calculations row by row.

I figured out how to import the excel sheet and calculate row by row. Maple calculates the correct results, but how can I easily store the results again, for example row by row in an excel sheet or csv?

This is my code:

> restart;#Range of the Matrix A1:KXXXXprint(??);

## When can Maple support for Excel 2010...

The "ExcelTools" seems can work based on Excel 2003 format,which can only support 2^16 rows.Excel 2010 format cantains much more rows and columns. So I want to know when maple can support Excel 2010?

## Open a Maple worksheet from VBA Excel...

How to open a Maple worksheet from VBA Excel?The Shell command, just open the application of maple, but not open the specified worksheet.Gracias

## Plotting data from excel file in Maple...

Hi,

I have an excel file with 10 columns by 10008 rows, the first one represent the time and the others represents some measuremts. And I would like to plot the columns which represent the measurements versus the first column which represent the time in Maple.

Do you have any idea how I can do this?

Thank you

## Problems with Excel import...

Hey guys,

I do have a problem with Excel Import.

What I wanna do is import 2 collumns from a Excel-File.

The first Column are the X-coordinates and in the second column are the y-coordinates.

After the import of the two columns (each with around 1000 rows) I would like to run a formula for each of this x/y pairs. Means for example a formula i1:=2*x+y or something like this.

And I would like to get the results also in a...

## data smoothing using cubic spline...

Hello everyone,

I have data in Excel sheet. I want to make the data smooth using cubic spline.

My try can be found in the attached maple sheet. In my try, i was unable to see the

difference bewteen the exact data and the interpolated data. Please have a look and

help to smooth the given data in the attached Excel sheet.

Cubic_spline_smoothi.mw

## Exporting Maple plots in xls format...

I am generating a number of plots in Maple but would like to be able to collect the data points from the Maple plots and export them into an excel spreadsheet or similar spreadhseet program so that they can be loaded into other plotting software programs such as OriginLab.

Is there a way to export the data points from plots produced in Maple into an .xls or .dat format?

## Exporting results from Maple in table form...

Hello All ,

I would liek to know if ther is a way to tabulate the results in a matrix form , like matlab does .Each time i copy paste it in excel and do the text to colum to sort out the results.It would save me a lot of time if anyone has an idea about this.

Like in the file i have results of various parameters displayed but how do i tabulate it.

Steam_800_below_crit.mw

## Can't figure out how to export loops to excel....

Here is my code:

restart:
with(LinearAlgebra):with(plots):with(ExcelTools):
n:=0.8:    e:=1:   h2:=0.01:
for N from 20 by 10 to 100 do
for b from 0.01 by 0.05 to 0.26 do
for h from 0.02 by 0.02 to 0.2 do
for h1 from 0.015 by 0.015 to 0.105 do
A1:=proc(N::posint,b1,e1,h0,h11,h21) local M;
M:=Matrix(N,(i,j)->if i=j then e elif abs(i-j)=1 then h else 0 fi);
M[1,2...

 1 2 3 4 5 Page 3 of 5
﻿