Copying Data from MS Excel (or some other source) into Lists and Spreadsheet on the TI-Nspire

[Eddie]

Is there a way to copy and paste data from a spreadsheet in MS Excel
(or from a text file that contains data) into the Lists and
Spreadsheets on the TI-Nspire Teacher Software so that I do not have
to manually type in a particularly long data set?

[Edward Deleon]

Yes. Copy from Excel and paste into the Nspire using Ctrl-V on the calculator keyboard.

--
edward....@gmail.com
301-841-5221

[Eddie]

I tried that several times before I posted the question...I keep
getting this error message: "The contents cannot be pasted because
the copy and paste areas have incompatible sizes."

> edward.m.del...@gmail.com
> 301-841-5221

[Sean Bird]

Try it with one column of data at a time.

[Eddie]

That's odd....I have done the same thing about 15 times and then it
finally worked....I am working on a project for a graduate statistics
course and never really paid much attention to this....but on both the
Nspire and the TI-84, when you do confidence intervals and hypothesis
testing, the menus do not give you the option to pick your
alpha....the default is 95 %. I know that is the most common one to
use but I wonder why you are not given the choice to pick your own
alpha? On one or two menus it does (Zinterval and Tinterval). Anyone
know why?

> > > edward.m.del...@gmail.com- Hide quoted text -
>
> - Show quoted text -

[lee kucera]

You can use any size interval you want--just type in 99 and you'll get
it. 95 is simply the default value.
lk

lee kucera
a.p. statistics
leek...@gmail.com

[Eddie]

Where in the menu? When I am in a Calculator page and I press
Statistics and Stat Tests....I do not see that option anywhere!

> leekuc...@gmail.com- Hide quoted text -

[lee kucera]

On the 84+, in all of the intervals it asks for C-Level. The choice
displayed is simply the last level you used. Arrow down to that and
replace it with whatever value you want.
On the Nspire, once you choose Data or Stats and get to the input
menu, again it asks for C Level. 95% is the default, you can arrow
down to any previous values you have used in this problem OR enter the
level of your choice. If working from data, I prefer to do the
calculations within the Lists and Spreadsheet mode because then the CI
will automatically change with any changes in the data.
lk

[Eddie]

I knew that on the ZInterval and TInterval it gave you the option, but
I did not see the option (for example) when I am doing a two-sampled t-
test or z-test....I have done them by hand and on the calculator with
a TI-84 (when I taught Statistics) and on the TI-Nspire (in this
graduate class) on a few problems.....but I have had to do hypothesis
tests at alpha=0.1, alpha=0.05, and alpha=0.01 in this class......and
I know how to do it by hand using a table....I just wondered why this
option is not in the menus for the hypothesis tests when you want the
p-value to justify your answer...That is all! (When I taught
Statistics two years ago, we just did the hypothesis tests using
alpha=0.05 when we used a calculator and it wasn't an issue.)

[lee kucera]

You don't select a significance level with a hypothesis test. The
calculator reports the p-value and you decide if it is significant
based on your alpha.
lk

[Eddie]

The industry standards is 0.05 for alpha, but it is also an industry
standard to use 0.01 to say that is "highly significant" and there are
certain problems where you want to pick your alpha.....I just wanted
to know if there is a way to change the alpha value on the TI-
Nspire....Sounds like you cannot at this time.

Thanks for you help!

[Eddie]

I see what you are saying....Nevermind!

> > - Show quoted text -- Hide quoted text -

[Diane Broberg]

I do it all the time for statistics.  I simply copy the data and then click in the first cell that I want to paste in - not at the column heading.  It will paste it completely.

On Thu, Jun 11, 2009 at 9:13 PM, Eddie <ke...@k12tn.net> wrote:

[Eddie]

I finally got it to work---I had to click inside a cell again after I
got the error message..and then it worked.....Thanks though!

> > to manually type in a particularly long data set?- Hide quoted text -

[Thomas Hu]

A related question: how to do the opposite? I have a 20x20 matrix on nspire and need to copy it to Excel. I guess I need to put the whole thing on a Spreadsheet page first, but cannot find a quick way (other then manually putting each column of the matrix into a list which I must repeat 20 times...)

[John Hanna]

First thought: Nspire has mat>list.

 

 

Regards,

     John

--
--
To post to this group, send email to tins...@googlegroups.com
To unsubscribe send email to tinspire+u...@googlegroups.com
For more options, visit this group at
http://groups.google.com.au/group/tinspire?hl=en-GB?hl=en-GB
The tns documents shared by group members are archived at
https://sites.google.com/site/tinspiregroup/classroom-news/welcome-abouttime

---
You received this message because you are subscribed to the Google Groups "tinspire" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tinspire+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tinspire/d6b3d5c9-c2a0-416c-9577-561ff33e2b30%40googlegroups.com.

[John Hanna]

Can you share ONLY the matrix in a .tns?

 

Regards,

     John

 

From: tins...@googlegroups.com <tins...@googlegroups.com> On Behalf Of Thomas Hu
Sent: Sunday, May 17, 2020 2:59 PM
To: tinspire <tins...@googlegroups.com>
Subject: [tinspire] Re: Copying Data from MS Excel (or some other source) into Lists and Spreadsheet on the TI-Nspire

 

A related question: how to do the opposite? I have a 20x20 matrix on nspire and need to copy it to Excel. I guess I need to put the whole thing on a Spreadsheet page first, but cannot find a quick way (other then manually putting each column of the matrix into a list which I must repeat 20 times...)

--

[Thomas Hu]

Here's the 16x16 matrix (MT). I want to have it displayed on the spreadsheet page so that I can copy to Excel. Thanks guys.

To view this discussion on the web visit https://groups.google.com/d/msgid/tinspire/005801d62c94%241007b1d0%2430171570%24%40optonline.net.

[John Hanna]

Got it, Thomas:

Use mat>list(mt) that creates a 256-element list from the rows. In a spreadsheet you can put the list into a column, then copy 16 elements at a time into Excel columns.

Of course, there’s always the programming route (I would use ‘indirection’ to spawn the list names l1…l16).

To view this discussion on the web visit https://groups.google.com/d/msgid/tinspire/CAJHUirXNTDdea3Y4ZSmhLTSfa2x7%2B3FoAkT%3DDDSOp5K-7T%2BD7g%40mail.gmail.com.

[John Hanna]

Convert matrix into 16 lists:

 

 

Regards,

     John

 

From: tins...@googlegroups.com <tins...@googlegroups.com> On Behalf Of Thomas Hu

Sent: Sunday, May 17, 2020 9:03 PM
To: tins...@googlegroups.com

To view this discussion on the web visit https://groups.google.com/d/msgid/tinspire/CAJHUirXNTDdea3Y4ZSmhLTSfa2x7%2B3FoAkT%3DDDSOp5K-7T%2BD7g%40mail.gmail.com.

[Thomas Hu]

Thank you John, appreciate it.

To view this discussion on the web visit https://groups.google.com/d/msgid/tinspire/00b901d62d09%249a7f7c10%24cf7e7430%24%40optonline.net.