This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 000.00 9
112000 Enter data set. X06 =
Y06 = 9.00
112,000.00 7 Chapter 6: Using the Statistics Worksheet 55 Part 2: Computing the Results
Procedure Keystrokes Select statistical
calculation portion of
Statistics worksheet. Display (old contents) Clear worksheet. LIN Examine intercept. (as necessary) Examine correlation.
Enter X' (people). 8,423.08 r= Compute Y' (sales). 0.96 X' = 10 Enter Y' (sales). 47,115.38 b= Examine slope. a= 10.00 Y' =
Y' = 115000 Move up to compute
X' (people). 131,346.15
115,000.00 X' = 8.06 Because the correlation coefficient (r) of .96 is close to 1, the following
equation is a good approximation of the data.
Y = 47,115.38 + 8,423.08X
The analysis indicates that 10 salespeople will produce approximately
$131,346.15 in sales per month. To produce $115,000 in sales per month,
you need approximately eight salespeople. 56 Chapter 6: Using the Statistics Worksheet CHAPTER 7
Using the Other Worksheets The Percent Change/Compound Interest Worksheet
To access the Percent Change/Compound Interest worksheet, press
. You can also compute compound interest or perform costsellmarkup calculations. Percent Change/Compound Interest Worksheet Labels
Label Meaning Type of Variable OLD Old value Enter/compute NEW New value Enter/compute %CH Percent change Enter/compute #PD Number of periods Enter/compute Notes on the Percent Change/Compound Interest Worksheet
sets OLD, NEW, and %CH to zero and sets #PD to 1.
sets OLD, NEW, and %CH to zero and sets #PD to 1.
For percent change calculations, you can enter values for two of the three
variables (OLD, NEW, and %CH) and compute a value for the unknown
variable. (Leave the value for #PD as 1.) A positive percent change
represents a percentage increase, and a negative percent change represents
a percentage decrease.
For compound interest calculations, you can enter values for three of the
four variables and compute a value for the unknown variable. OLD =
present value, NEW = future value, %CH = interest rate per period, and #PD
= number of periods.
F...
View
Full
Document
This homework help was uploaded on 04/03/2014 for the course ECON 203 taught by Professor Petry during the Summer '09 term at University of Illinois, Urbana Champaign.
 Summer '09
 PETRY

Click to edit the document details