The accompanying data file shows the monthly rent (Rent) and square footage (Footage) for 40 rentals...

Transcribed Image Text:

The accompanying data file shows the monthly rent (Rent) and square footage (Footage) for 40 rentals in a large college town. Click here for the Excel Data File: a. Calculate the mean and the standard deviation for monthly rent. Note: Round final answers to the nearest whole number. Mean Standard deviation 1,209 b. Calculate the mean and the standard deviation for square footage. Note: Round final answers to the nearest whole number. Mean Standard deviation 1,277 c. Which variable exhibits greater relative dispersion as measured by the coefficient of variation? Note: Round final answers to three decimal places. CV Rent CV Footage C1 Excel Ch3_Q13 V15_Data_File - Saved File Home Insert Draw Pag V 12 B A fx Footage A B D E F G H 1 se Rent Footage 2 1 608 543 3 2 596 685 4 3 777 728 5 4 830 857 6 5 824 912 7 6 808 1002 7 792 818 9 8 916 879 10 9 893 961 11 10 990 854 12 11 930 808 13 12 891 828 14 13 962 1014 15 14 1006 1061 16 15 1031 888 17 16 902 923 18 17 991 1288 19 18 1051 1126 20 19 985 1252 21 20 975 1154 22 21 991 1174 23 22 1133 932 23 1020 1063 25 24 1255 1276 26 25 1168 1399 27 26 1216 1335 28 27 1272 1297 29 28 1456 1161 30 29 1496 1269 31 30 1425 1453 32 31 1421 1722 33 32 1511 1463 34 33 1662 1412 35 34 1659 1424 36 35 1717 1230 37 36 1776 1970 38 37 1946 2187 39 38 2034 1630 40 39 2125 4416 The accompanying data file shows the monthly rent (Rent) and square footage (Footage) for 40 rentals in a large college town. Click here for the Excel Data File: a. Calculate the mean and the standard deviation for monthly rent. Note: Round final answers to the nearest whole number. Mean Standard deviation 1,209 b. Calculate the mean and the standard deviation for square footage. Note: Round final answers to the nearest whole number. Mean Standard deviation 1,277 c. Which variable exhibits greater relative dispersion as measured by the coefficient of variation? Note: Round final answers to three decimal places. CV Rent CV Footage C1 Excel Ch3_Q13 V15_Data_File - Saved File Home Insert Draw Pag V 12 B A fx Footage A B D E F G H 1 se Rent Footage 2 1 608 543 3 2 596 685 4 3 777 728 5 4 830 857 6 5 824 912 7 6 808 1002 7 792 818 9 8 916 879 10 9 893 961 11 10 990 854 12 11 930 808 13 12 891 828 14 13 962 1014 15 14 1006 1061 16 15 1031 888 17 16 902 923 18 17 991 1288 19 18 1051 1126 20 19 985 1252 21 20 975 1154 22 21 991 1174 23 22 1133 932 23 1020 1063 25 24 1255 1276 26 25 1168 1399 27 26 1216 1335 28 27 1272 1297 29 28 1456 1161 30 29 1496 1269 31 30 1425 1453 32 31 1421 1722 33 32 1511 1463 34 33 1662 1412 35 34 1659 1424 36 35 1717 1230 37 36 1776 1970 38 37 1946 2187 39 38 2034 1630 40 39 2125 4416

Answer rating: 100% (QA)

ANSWER a To calculate the mean and standard deviation for monthly rent Mean Use the AVERAGE function ... View the full answer