## Friday, September 25, 2015

### HP Prime Spreadsheet App Tutorial 8: Statistical Analysis

HP Prime Spreadsheet App Tutorial 8:  Statistical Analysis

Lesson 8 Objectives:

* Use One Variable Statistical Analysis and Customize its format
* Calculation regression analysis

Part 1:  One Variable Statistics

How to find STAT1:  In the Spreadsheet, press [ Menu ], 7.

Simple Syntax:
STAT1(range of data, “configuration”)

STAT1 can be expanded for more uses, please consult the HP Prime Graphing Calculator User Guide for details (pg. 345-346).  There is also a two-variable version, STAT2.

Configuration is a string and is optional.  This allows us to refine or select just what we want to see.  Each symbol is separated by a single space.

STAT1 configuration
Common symbols to use:
 Symbol Function How to Get it h Place row labels Insert h (lower case) at the beginning at the configuration string.  “h “ H Place column labels Insert H (upper case) at the beginning at the configuration string.  “H “ x̅ Mean Type “+CHAR(57344)+” s Standard Deviation Type “s “ σ Population Deviation Get σ from [Shift], [ 6 ] menu Σ Sum Get Σ from [Shift], [ 6 ] menu 2 Square Symbol, add to s, σ, or Σ Attach “+CHAR(178)+” n Number of data points Type “n”

Please see the steps for an example.

Note:  I had the calculator set to Fix 3.

Part 1 Steps:

1.     Enter the following data:
·         A1 = 5.250
·         A2 = 5.990
·         A3 = 6.345
·         A4 = 6.989
·         A5 = 7.210
·         A6 = 7.116
·         A7 = 7.385
2.    Go to cell B1.  Enter =STAT1(A1:A7).  You will see all the possible results and the labels.  The next steps will show you how to use specific configuration.
3.    Select cells B1:C16 and press the [  Del ] key.  We have to manually clear the results.  The next step will detail how to display only the number of data points (n), mean (x̅), and standard deviation (s).
4.    Again, go to B1 and enter =STAT1(A1:A7, “n x̅ s”).
·         Keystrokes:  [Shift], [ . ] (=), [Menu], 7 for STAT1, [ ( ) ], type A1:A7, [ , ], [Shift], [ 0 ] ( “ “ ), [ALPHA], [Shift], [ ( ) ] (n), [SPACE], [ → ], [ + ], type CHAR(57344), [ + ], [Shift], [ 0 ] ( “ “ ), [ALPHA], [Shift], [ 9 ] ( s ), (OK)
·         Note that you will see only numeric results.   If you want labels, we will need to add an h (for Row Headers) or H (for Column headers) to the beginning of the configuration.
5.    Edit B1 to read =STAT1(A1:A7, “h n x̅ s”).  You should see row headers as well as the wanted results.

Part 2:  Regression Analysis

Simple Syntax:
REGRS(range, model number)

Please refer to the HP Prime User Guide, pg. 347 for all the details of this command.

Common regression models and the number that represents them:

1 for Linear.  (y = m*x + b)
2 for Logarithmic (y = m*ln x + b)
3 for Exponential (y = b*e^(m*x))
4 for Power (y = b*x^m)
6 for Inverse (y = m/x + b)
9 for Quadratic (y = a + b*x + c^2)

Part 2 Steps:

7.    Enter the following labels and data:
·         A1 = “Hours”
·         B1 = “Sales”
·         C1 = “Data”
·         A2 = 50, B2 = 4300
·         A3 = 52, B3 = 4800
·         A4 = 51, B4 = 4600
·         A5 = 49, B5 = 4480
·         A6 = 48, B6 = 4270
·         A7 = 50, B7 = 4330
8.    Go to cell C2.  Type =REGRS(A2:B7, 1).  This performs linear regression on the data.

Note:  You can add a custom configuration to REGRS.  See the manual for details.

That is it for Lesson 8.  In Lesson 9, we’ll cover using custom functions in the Spreadsheet app.  Until next time,

Eddie

This blog is property of Edward Shore, 2015.   Post 501!

### TI 30Xa Algorithms: Greatest Common Divisor

TI 30Xa Algorithms: Greatest Common Divisor To find the greatest common divisor between two positive integers U and V: Let U ≥ V. ...