Through Thursday) from last year showing the restaurant income and number of rooms occupied.
able[[Day,Revenue,Occupied,Day,Revenue,Occupied],[1,$1,452,30,14,$1,425,31],[2,$1,361,29,15,$1,445,34],[3,$1,426,31,16,$1,439,34],[4,$1,470,32,17,$1,348,31],[5,$1,456,32,18,$1,450,30],[6,$1,430,32,19,$1,431,30],[7,$1,354,29,20,$1,446,31],[8,$1,442,30,21,$1,485,34],[9,$1,394,32,22,$1,405,30],[10,$1,459,32,23,$1,461,32],[11,$1,399,31,24,$1,490,30],[12,$1,458,31,25,$1,426,30],[13,$1,537,34,,,]]
Click here for the Excel Data File
a. Choose the scatter diagram that best fits the data.
Day 1 2 3
Revenue $1,452 $1,361 $1,426 $1,470 $1,456 $1,430 $1,354 $1,442 $1,394 $1,459 $1,399 $1,458 $1,537
Occupied 30 29 31 32
Day 14 15 16 17 18 19 20 21 22 23 24 25
Revenue $1,425 $1,445 $1,439 $1,348 $1,450 $1,431 $1,446 $1,485 $1,405 $1,461 $1,490 $1,426
Occupied 31 34 34 31 30 30 31 34 30 32 30 30
ok
5 6 7 8 9 10 11 12 13
nt
31 34
Click here for the Excel Data File a. Choose the scatter diagram that best fits the data
Scatter diagram 1
Scatter diagram 2
Scatter diagram 3
Scatterplot of Income vs Occupied
Scatterplot of Income vs Occupied
Scatterplot of Income vs Occupied
1540
1540
1340 25
35 Occupied
20
30 Occupied
30
40