{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 3 Solutions

# Chapter 3 Solutions - 1.02 500 0.17 0.17 549 1.06 1.06 z x...

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

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

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

View Full Document
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

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

View Full Document

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

View Full Document

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

View Full Document
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

• Spring '08