Chapter 3 Solns

Chapter 3 Solns - 1.02 500 0.17 0.17 549 1.06 1.06 z x x s...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Seventy efficieny apartments were randomly sampled in a small college town. The monthly rent prices for these apartments are: Data Abs. Value 445 -0.84 0.84 Measures of Location 440 -0.93 0.93 465 -0.47 0.47 Mean = 490.8 =AVERAGE(A5:A74) 450 -0.75 0.75 600 1.99 1.99 Median = 475 570 1.45 1.45 510 0.35 0.35 Mode = 450 Is there more than one mode? 615 2.27 2.27 440 -0.93 0.93 80th Percentile = 537.8 =PERCENTILE(C5:C74,0.8) 450 -0.75 0.75 470 -0.38 0.38 Measures of Variability 485 -0.11 0.11 515 0.44 0.44 Range = 190 =MAX(A5:A74)-MIN(A5:A74) 575 1.54 1.54 430 -1.11 1.11 Variance = 2996.16 440 -0.93 0.93 525 0.62 0.62 Standard Deviation = 54.74 490 -0.01 0.01 580 1.63 1.63 Distribution Shape 450 -0.75 0.75 Skew = 0.92 =SKEW(A5:A74) 490 -0.01 0.01 z i x i z
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
590 1.81 1.81 Are there outliers? 525 0.62 0.62 450 -0.75 0.75 0 472 -0.34 0.34 470 -0.38 0.38 445 -0.84 0.84 435 -1.02 1.02 435 -1.02 1.02 425 -1.20 1.20 450 -0.75 0.75 475 -0.29 0.29 490 -0.01 0.01 525 0.62 0.62 600 1.99 1.99 600 1.99 1.99 445 -0.84 0.84 460 -0.56 0.56 475 -0.29 0.29 500 0.17 0.17 535 0.81 0.81 435 -1.02 1.02 460 -0.56 0.56 575 1.54 1.54 435 -1.02
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1.02 500 0.17 0.17 549 1.06 1.06 z x x s i i =-475-0.29 0.29 445-0.84 0.84 600 1.99 1.99 445-0.84 0.84 460-0.56 0.56 480-0.20 0.20 500 0.17 0.17 550 1.08 1.08 435-1.02 1.02 440-0.93 0.93 450-0.75 0.75 465-0.47 0.47 570 1.45 1.45 500 0.17 0.17 480-0.20 0.20 430-1.11 1.11 615 2.27 2.27 450-0.75 0.75 480-0.20 0.20 465-0.47 0.47 480-0.20 0.20 510 0.35 0.35 440-0.93 0.93 Excel Functions: AVERAGE MEDIAN MODE PERCENTILE PERCENTRANK VAR (VARP) STDEV (STDEVP) SKEW COUNTIF A golfer is interested in investigating the relationship, if any, between driving distance and 18-hole score. 277.6 69 259.5 71 269.1 70 267.0 70 255.6 71 272.9 69 Covariance = -7.08 Correlation = -0.96 Average Driving Distance Average 18-hole Score Excel Features/Functions: COVAR CORREL ( )( ) 35.40 7.08 1 6 1 i i xy x x y y s n- --= = = -- -...
View Full Document

This note was uploaded on 10/14/2008 for the course STATS 500 taught by Professor Grady during the Spring '08 term at Xavier.

Page1 / 8

Chapter 3 Solns - 1.02 500 0.17 0.17 549 1.06 1.06 z x x s...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online