Question 7 2 points Save Answer A sample of nine tourists indicated how much they spent on accommodation per night (in dollars) at a popular holiday destination. The amounts they paid for accommodation were as follows: 294.9 198.7 388.9 181.2 296.5 251.4 205.0 392.3 173.8 What is the difference between the median and the mean of the sample (correct to 2 decimal places)? Use (median - mean) as the order of the difference. ?A Moving to another question will save this response. > Question 8 2 points Save Answer A large international celebrity has just released her new album. She estimates that if sales are excellent, she can make a profit of $5.0 million from the album. If sales are good she can make a profit of $3.4 million. Finally, if sales are poor, she will only make $1.05 million. The probability that sales will be excellent is 0.46. The probability that sales will be good is 0.28. Calculate the expected profit for the newly released album (in $ millions) to two decimal places. ?G22 &JX A B C D E F G H J Suburb Sample size Population Average distance to work Average commute time Albany Creek 320 15769 16.30 75 Annerley 230 11336 8.40 30 Aspley 495 12108 23.90 105 Bald Hills 2458 7275 20.21 82 Caboolture 582 26443 12.03 30 Calamvale 4029 17443 8.93 47 Chermside 482 9430 12.03 50 Cleveland 987 50302 16.47 72 Eight Mile Plains 749 15000 5.60 29 Ferny Grove 1039 9302 3.84 21 Herston 4729 2043 9.38 45 Kelvin Grove 928 7938 4.05 20 Moorooka 567 10000 5.93 35 Paddington 384 12039 18.00 90 6 Sandgate 2837 49000 4.92 60 Springfield 472 6700 20.31 100 8 St Lucia 485 12030 9.20 50 9 Sunnybank 392 8648 10.92 50 0 Woolloongabba 878 5648 3.03 15 13Question 9 2 points S Open the Excel file DF1.6 (found in the LBRT #1 folder where you accessed this quiz). This file includes details of a survey on commuters from 19 suburbs in Brisbane. Copy the following data below that is in bold. Add this data as a new row to the existing data file DF1.6. It is easiest to make this new data the last row in the existing data file. Suburb Sample size Population Average distance to work Average commute time Z 700 3659 14.02 30 After you add this new row to DF1.6, use Excel to calculate the coefficient of correlation between the average distance to work and the average commute time (as a number between -1 and 1 correct to three decimal places)