Week 13 Excel Lab #5 – Relationships in Real Estate

4070 3870 4470 4060 4540 3880 4030 4060 4230 4310 4310 4130 4530 4470 4260 4350 4480 4060 4340 4220 3870 4160 4560 4190 4360 4220 4750 4310

Probability:Question 10 A baby born in 2011 is randomly selected. What is the probability that the baby was born in March? 2013 322 Select one: .083 830 065 041

How long does it take to finish the 1161-mile Iditarod Dog Sled Race from Anchorage to Nome, Alaska? Finish times (to the nearest hour) for 57 dogsled teams are shown below. 261 271 236 244 279 296 284 299 288 288 247 256 338 360 341 333 261 266 287 296 313 311 307 307 299 303 277 283 304 305 288 290 288 289 297 299 332 330 309 328 307 328 285 291 295 298 306 315 310 318 318 320 333 321 323 324 327 USE SALT For this problem, use five classes. (a) Find the class width. 25 236 261 286 311 336 (b) Make a frequency table showing class limits, class boundaries, midpoints, frequencies, relative frequencies, and cumulative frequencies. (Round your relative frequencies to two decimal places.) Class Limits Class Boundaries Midpoint Frequency I I I - 260 285 310 335 360 - Relative Cumulative Frequency Frequency

How long does it take to finish the 1161-mile Iditarod Dog Sled Race from Anchorage to Nome, Alaska? Finish times (to the nearest hour) for 57 dogsled teams are shown below. 261 271 236 244 279 296 284 299 288 288 247 256 338 360 341 333 261 266 287 296 313 311 307 307 299 303 277 283 304 305 288 290 288 289 297 299 332 330 309 328 307 328 285 291 295 298 306 315 310 318 318 320 333 321 323 324 327 For this problem, use five classes. (a) Find the class width. (b) Make a frequency table showing class limits, class boundaries, midpoints, frequencies, relative frequencies, and cumulative frequencies. (Give relative frequencies to 2 decimal places.) Relative Cumulative Class Limits Class Boundaries Midpoint Frequency Frequency Frequency

662 775 779 797 822 824 833 842 846 851 852 860 860 864 864 865 866 867 878 879 885 887 896 899 901 903 903 906 907 910 911 912 915 916 927 928 930 934 934 938 940 942 944 947 948 949 957 960 962 972 974 975 977 978 978 980 980 982 983 986 987 989 991 991 995 996 1000 1004 1006 1009 1014 1021 1027 1028 1028 1030 1033 1036 1036 1040 1041 1045 1050 1052 1056 1065 1067 1069 1069 1071 1078 1088 1097 1112 1118 1122 1123 1139 1148 983 Data above represents the average rent for 100 randomly selected U.S cities. According to www.apartments.com, the average rent for a two-bedroom apartment in the city of Napa is $1,967. How do other U.S cities' rents compare to Napa? Are they about the same, on average, or are significantly lower elsewhere? a. To test this hypothesis, two assumptions must be checked. One is that the sample data needs to be normally distributed. How do we know right away that this assumption is satisfied? b. What is the other assumption that needs to be…