Sunday, September 20, 2015

HP Prime Spreadsheet App Tutorial 5: Spreadsheets and Histograms

HP Prime Spreadsheet App Tutorial 5:  Spreadsheets and Histograms





Lesson 5 Objectives:

* Generate a random list of integers for a column
* Store a Spreadsheet column to a Statistics Variable
* Use a Spreadsheet column in a histogram

Generate a random list of integers:

RANDINT(length of list, lower limit, upper limit).  The result is a list.


Steps:

1.     Start by selecting the header cell for Column A.  Press [ Toolbox ], 5 for Probability, 4 for Random, 2 for Integer to call the RANDINT function.   A list a generated, so no equals sign is needed.  Enter 100 for the length of list, 0 for the lower limit, and 100 for the upper limit.  The result is RANDINT(100,0,100).  Press the soft key ( OK ).
2.    Name Column A DATA.   Go to the header cell, enter DATA, and press on the soft key ( Name ).
3.    Press the [ Home ] button.  Select the D1 variable from the Statistics 1Var app by pressing [ Vars ], the ( App ) soft key, then Statistics 1Var, then Numeric, and D1. 
4.    Continue by entering DATA.   (colon, equals, DATA).   The complete command should be Statistics_1Var.D1DATA.
5.    On to the Histogram:  Press the [ Apps ] and choose the Statistics 1Var app.   You’ll be taken to the Num view and D1 should be filled in.
6.    Press the [ Symb ] key for the Symbolic view.   Enter D1 for H1 and select Histogram. 
7.    Press [ Shift ], [ Plot ] (Plot Setup).   Change the H Width to 10. 
8.    Press [ View ] and select Autoscale.    This Histogram is complete.




This concludes Lesson 5.  I plan to post additional lessons in the near future.   

Eddie


This blog is property of Edward Shore,  2015.

2 comments:

  1. Hello Eddie,
    Thank you very much for this tutorial series. I'm taking Intro to Microeconomics and using the HP Prime calculator spreadsheet app to program some repetitive calculations. Is there a way (that I'm obviously missing) to save a spreadsheet file and later load that file? Or is the spreadsheet app completely working memory based?
    Thank you so much,
    Chuck

    ReplyDelete
  2. Well, I just found the answer to my own question. With the spreadsheet constructed, return to the APPS screen and select "Save" and provide a name. To load, simply highlight the newly saved spreadsheet and hit "Enter". Sorry for any inconvenience.

    ReplyDelete

How to Rotate Graphs

How to Rotate Graphs Introduction The key is to use parametric equations in our rotation.  Using the rotation angle θ, the rotatio...