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 “
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:

6.     Reset the Spreadsheet.
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!

No comments:

Post a Comment

HP Prime and Casio fx-CG50: Trapezoid Midsegment, Height, Area

HP Prime and Casio fx-CG50:  Trapezoid Midsegment, Height, Area The program TRAPEZ calculates the following: Midsegment leng...