HP Prime Spreadsheet App Tutorial
8: Statistical Analysis
* 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:
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!
