Offices in various cities have the following number

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 cost-sellmarkup 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.

Ask a homework question - tutors are online