PLEASE HELP URGENT - it wont let me upload the data as a pdf?

Question 3. The expansion of the Istanbul International Airport has drawn media attention for its revolutionised baggage service which shortened the time a passenger needed to collect his or her baggage. To gauge the performance of its newly-installed baggage carousel, the department of aviation services has collected a random dataset on the number of bags per minute handled by Baggage Carousel A and Baggage Carousel B. These are two different carousels. You would like to summarise the dataset, compare the two carousels and report to the department of aviation services. (The dataset is given in the third sheet named Baggage carousel in the provided Excel file Data.xlsx). Your answers should address the following:

1. Choose appropriate graphs to visualise the dataset and provide relevant descriptive statistics and a brief commentary.

2. Compute the average time a passenger needs to wait to see the next piece of baggage. State the assumption you need to make this computation. Hint: what is the assumption behind modelling inter-arrival waiting time as an exponentially distributed variable?

3. Based on your assumptions for both carousels, compute (a) the probability that in one minute there are less than 7 bags and (b) the probability that in one minute there are less than 10 bags. Compare your computed results to what you observe from the data.

4. Explain why you do or do not think your assumption is valid for this dataset.

Thank you :)

Data:

Baggage Carousel A Operation Minute ID Number of baggages Minute 1 11 Minute 2 15 Minute 3 10 Minute 4 12 Minute 5 8 Minute 6 17 Minute 7 11 Minute 8 11 Minute 9 13 Minute 10 14 Minute 11 10 Minute 12 14 Minute 13 15 Minute 14 16 Minute 15 6 Minute 16 12 Minute 17 9 Minute 18 6 Minute 19 7 Minute 20 11 Minute 21 13 Minute 22 17 Minute 23 9 Minute 24 15 Minute 25 14 Baggage Carousel B Operation Minute ID Number of bagga Minute 1 10 Minute 2 9 Minute 3 11 Minute 4 7 Minute 5 8 Minute 6 15 Minute 7 6 Minute 8 8 Minute 9 10 Minute 10 18 Minute 11 11 Minute 12 17 Minute 13 9 Minute 14 17 Minute 15 18 Minute 16 13 Minute 17 4 Minute 18 13 Minute 19 9 Minute 20 14 Minute 21 17 Minute 22 7 Minute 23 17 Minute 24 11 Minute 25 12 20 Minute 26 Minute 27 Minute 28 Minute 29 Minute 30 Minute 31 Minute 32 Minute 33 Minute 34 Minute 35 Minute 36 Minute 37 Minute 38 Minute 39 Minute 40 Minute 41 Minute 42 Minute 43 Minute 44 Minute 45 Minute 46 Minute 47 Minute 48 Minute 49 Minute 50 Minute 51 Minute 52 Minute 53 11 17 16 8 19 11 6 11 9 8 12 17 12 10 13 19 15 8 12 8 13 14 12 7 11 13 11 Minute 26 Minute 27 Minute 28 Minute 29 Minute 30 Minute 31 Minute 32 Minute 33 Minute 34 Minute 35 Minute 36 Minute 37 Minute 38 Minute 39 Minute 40 Minute 41 Minute 42 Minute 43 Minute 44 Minute 45 Minute 46 Minute 47 Minute 48 Minute 49 Minute 50 Minute 51 Minute 52 Minute 53 17 7 5 15 11 18 10 15 12 12 10 12 17 9 16 17 16 8 17 18 17 11 18 12 11 12 10 11 14 14 9 1 Minute 54 Minute 55 Minute 56 Minute 57 Minute 58 Minute 59 Minute 60 Minute 61 Minute 62 Minute 63 Minute 64 Minute 65 Minute 66 Minute 67 Minute 68 Minute 69 Minute 70 Minute 71 Minute 72 Minute 73 Minute 74 Minute 75 Minute 76 Minute 77 Minute 78 Minute 79 Minute 80 Minute 81 17 12 13 9 13 15 16 15 9 13 13 14 15 12 12 8 9 9 9 14 18 10 5 16 16 14 16 9 Minute 54 Minute 55 Minute 56 Minute 57 Minute 58 Minute 59 Minute 60 Minute 61 Minute 62 Minute 63 Minute 64 Minute 65 Minute 66 Minute 67 Minute 68 Minute 69 Minute 70 Minute 71 Minute 72 Minute 73 Minute 74 Minute 75 Minute 76 Minute 77 Minute 78 Minute 79 Minute 80 Minute 81 16 6 9 13 8 18 8 18 8 20 10 21 11 10 11 15 15 12 12 14 13 9 1 9 Minute 82 Minute 83 Minute 84 Minute 85 Minute 86 Minute 87 Minute 88 Minute 89 Minute 90 Minute 91 Minute 92 Minute 93 Minute 94 Minute 95 Minute 96 Minute 97 Minute 98 Minute 99 Minute 100 Minute 101 Minute 102 Minute 103 Minute 104 Minute 105 Minute 106 Minute 107 Minute 108 Minute 109 12 4 6 14 18 5 9 7 8 11 17 7 11 6 12 13 10 19 8 12 8 11 15 19 13 9 13 19 Minute 82 Minute 83 Minute 84 Minute 85 Minute 86 Minute 87 Minute 88 Minute 89 Minute 90 Minute 91 Minute 92 Minute 93 Minute 94 Minute 95 Minute 96 Minute 97 Minute 98 Minute 99 Minute 100 Minute 101 Minute 102 Minute 103 Minute 104 Minute 105 Minute 106 Minute 107 Minute 108 Minute 109 12 17 13 16 6 9 7 17 14 10 18 12 12 13 9 9 8 6 13 14 14 9 15 13 13 10 15 1 13 15 1 Minute 108 Minute 109 Minute 110 Minute 111 Minute 112 Minute 113 Minute 114 Minute 115 Minute 116 Minute 117 Minute 118 Minute 119 Minute 120 Minute 121 Minute 122 Minute 123 Minute 124 Minute 125 Minute 126 Minute 127 Minute 128 Minute 129 Minute 130 Minute 131 Minute 132 Minute 133 Minute 134 Minute 135 19 9 6 14 6 12 9 12 10 14 9 8 8 16 10 9 Minute 108 Minute 109 Minute 110 Minute 111 Minute 112 Minute 113 Minute 114 Minute 115 Minute 116 Minute 117 Minute 118 Minute 119 Minute 120 Minute 121 Minute 122 Minute 123 Minute 124 Minute 125 Minute 126 Minute 127 Minute 128 Minute 129 Minute 130 Minute 131 Minute 132 Minute 133 Minute 134 Minute 135 15 14 14 21 12 12 10 10 6 5 11 14 8 15 12 14 13 15 14 12 14 9 16 10 16 3 10 7 10 10 14 12 14 13 11 11 17 17 12 14 Minute 136 Minute 137 Minute 138 Minute 139 Minute 140 Minute 141 Minute 142 Minute 143 Minute 144 Minute 145 Minute 146 Minute 147 Minute 148 Minute 149 Minute 150 Minute 151 Minute 152 Minute 153 Minute 154 Minute 155 Minute 156 Minute 157 Minute 158 Minute 159 Minute 160 Minute 161 Minute 162 Minute 163 16 12 9 11 20 5 13 13 12 12 10 9 14 14 12 10 19 7 13 14 10 15 11 11 Minute 136 Minute 137 Minute 138 Minute 139 Minute 140 Minute 141 Minute 142 Minute 143 Minute 144 Minute 145 Minute 146 Minute 147 Minute 148 Minute 149 Minute 150 Minute 151 Minute 152 Minute 153 Minute 154 Minute 155 Minute 156 Minute 157 Minute 158 Minute 159 Minute 160 Minute 161 Minute 162 Minute 163 12 11 16 6 10 12 10 14 17 12 20 7 17 14 4 10 14 14 13 10 16 13 11 11 17 8 21 17 12 Minute 164 Minute 165 Minute 166 Minute 167 Minute 168 Minute 169 Minute 170 Minute 171 Minute 172 Minute 173 Minute 174 Minute 175 Minute 176 Minute 177 Minute 178 Minute 179 Minute 180 Minute 181 Minute 182 Minute 183 Minute 184 Minute 185 Minute 186 Minute 187 Minute 188 Minute 189 Minute 190 Minute 191 19 11 9 11 15 7 10 10 14 13 12 13 16 9 9 10 10 20 8 8 13 12 19 7 5 15 13 12 Minute 164 Minute 165 Minute 166 Minute 167 Minute 168 Minute 169 Minute 170 Minute 171 Minute 172 Minute 173 Minute 174 Minute 175 Minute 176 Minute 177 Minute 178 Minute 179 Minute 180 Minute 181 Minute 182 Minute 183 Minute 184 Minute 185 Minute 186 Minute 187 Minute 188 Minute 189 Minute 190 Minute 191 14 10 13 18 8 10 16 13 18 9 14 12 8 5 12 10 16 8 15 4 6 5 15 10 18 4 17 10 co Minute 192 Minute 193 Minute 194 Minute 195 Minute 196 Minute 197 Minute 198 Minute 199 Minute 200 14 8 8 14 18 14 8 10 20 Minute 192 Minute 193 Minute 194 Minute 195 Minute 196 Minute 197 Minute 198 Minute 199 Minute 200 8 12 17 14 10 20 10 9 9 Baggage Carousel A Operation Minute ID Number of baggages Minute 1 11 Minute 2 15 Minute 3 10 Minute 4 12 Minute 5 8 Minute 6 17 Minute 7 11 Minute 8 11 Minute 9 13 Minute 10 14 Minute 11 10 Minute 12 14 Minute 13 15 Minute 14 16 Minute 15 6 Minute 16 12 Minute 17 9 Minute 18 6 Minute 19 7 Minute 20 11 Minute 21 13 Minute 22 17 Minute 23 9 Minute 24 15 Minute 25 14 Baggage Carousel B Operation Minute ID Number of bagga Minute 1 10 Minute 2 9 Minute 3 11 Minute 4 7 Minute 5 8 Minute 6 15 Minute 7 6 Minute 8 8 Minute 9 10 Minute 10 18 Minute 11 11 Minute 12 17 Minute 13 9 Minute 14 17 Minute 15 18 Minute 16 13 Minute 17 4 Minute 18 13 Minute 19 9 Minute 20 14 Minute 21 17 Minute 22 7 Minute 23 17 Minute 24 11 Minute 25 12 20 Minute 26 Minute 27 Minute 28 Minute 29 Minute 30 Minute 31 Minute 32 Minute 33 Minute 34 Minute 35 Minute 36 Minute 37 Minute 38 Minute 39 Minute 40 Minute 41 Minute 42 Minute 43 Minute 44 Minute 45 Minute 46 Minute 47 Minute 48 Minute 49 Minute 50 Minute 51 Minute 52 Minute 53 11 17 16 8 19 11 6 11 9 8 12 17 12 10 13 19 15 8 12 8 13 14 12 7 11 13 11 Minute 26 Minute 27 Minute 28 Minute 29 Minute 30 Minute 31 Minute 32 Minute 33 Minute 34 Minute 35 Minute 36 Minute 37 Minute 38 Minute 39 Minute 40 Minute 41 Minute 42 Minute 43 Minute 44 Minute 45 Minute 46 Minute 47 Minute 48 Minute 49 Minute 50 Minute 51 Minute 52 Minute 53 17 7 5 15 11 18 10 15 12 12 10 12 17 9 16 17 16 8 17 18 17 11 18 12 11 12 10 11 14 14 9 1 Minute 54 Minute 55 Minute 56 Minute 57 Minute 58 Minute 59 Minute 60 Minute 61 Minute 62 Minute 63 Minute 64 Minute 65 Minute 66 Minute 67 Minute 68 Minute 69 Minute 70 Minute 71 Minute 72 Minute 73 Minute 74 Minute 75 Minute 76 Minute 77 Minute 78 Minute 79 Minute 80 Minute 81 17 12 13 9 13 15 16 15 9 13 13 14 15 12 12 8 9 9 9 14 18 10 5 16 16 14 16 9 Minute 54 Minute 55 Minute 56 Minute 57 Minute 58 Minute 59 Minute 60 Minute 61 Minute 62 Minute 63 Minute 64 Minute 65 Minute 66 Minute 67 Minute 68 Minute 69 Minute 70 Minute 71 Minute 72 Minute 73 Minute 74 Minute 75 Minute 76 Minute 77 Minute 78 Minute 79 Minute 80 Minute 81 16 6 9 13 8 18 8 18 8 20 10 21 11 10 11 15 15 12 12 14 13 9 1 9 Minute 82 Minute 83 Minute 84 Minute 85 Minute 86 Minute 87 Minute 88 Minute 89 Minute 90 Minute 91 Minute 92 Minute 93 Minute 94 Minute 95 Minute 96 Minute 97 Minute 98 Minute 99 Minute 100 Minute 101 Minute 102 Minute 103 Minute 104 Minute 105 Minute 106 Minute 107 Minute 108 Minute 109 12 4 6 14 18 5 9 7 8 11 17 7 11 6 12 13 10 19 8 12 8 11 15 19 13 9 13 19 Minute 82 Minute 83 Minute 84 Minute 85 Minute 86 Minute 87 Minute 88 Minute 89 Minute 90 Minute 91 Minute 92 Minute 93 Minute 94 Minute 95 Minute 96 Minute 97 Minute 98 Minute 99 Minute 100 Minute 101 Minute 102 Minute 103 Minute 104 Minute 105 Minute 106 Minute 107 Minute 108 Minute 109 12 17 13 16 6 9 7 17 14 10 18 12 12 13 9 9 8 6 13 14 14 9 15 13 13 10 15 1 13 15 1 Minute 108 Minute 109 Minute 110 Minute 111 Minute 112 Minute 113 Minute 114 Minute 115 Minute 116 Minute 117 Minute 118 Minute 119 Minute 120 Minute 121 Minute 122 Minute 123 Minute 124 Minute 125 Minute 126 Minute 127 Minute 128 Minute 129 Minute 130 Minute 131 Minute 132 Minute 133 Minute 134 Minute 135 19 9 6 14 6 12 9 12 10 14 9 8 8 16 10 9 Minute 108 Minute 109 Minute 110 Minute 111 Minute 112 Minute 113 Minute 114 Minute 115 Minute 116 Minute 117 Minute 118 Minute 119 Minute 120 Minute 121 Minute 122 Minute 123 Minute 124 Minute 125 Minute 126 Minute 127 Minute 128 Minute 129 Minute 130 Minute 131 Minute 132 Minute 133 Minute 134 Minute 135 15 14 14 21 12 12 10 10 6 5 11 14 8 15 12 14 13 15 14 12 14 9 16 10 16 3 10 7 10 10 14 12 14 13 11 11 17 17 12 14 Minute 136 Minute 137 Minute 138 Minute 139 Minute 140 Minute 141 Minute 142 Minute 143 Minute 144 Minute 145 Minute 146 Minute 147 Minute 148 Minute 149 Minute 150 Minute 151 Minute 152 Minute 153 Minute 154 Minute 155 Minute 156 Minute 157 Minute 158 Minute 159 Minute 160 Minute 161 Minute 162 Minute 163 16 12 9 11 20 5 13 13 12 12 10 9 14 14 12 10 19 7 13 14 10 15 11 11 Minute 136 Minute 137 Minute 138 Minute 139 Minute 140 Minute 141 Minute 142 Minute 143 Minute 144 Minute 145 Minute 146 Minute 147 Minute 148 Minute 149 Minute 150 Minute 151 Minute 152 Minute 153 Minute 154 Minute 155 Minute 156 Minute 157 Minute 158 Minute 159 Minute 160 Minute 161 Minute 162 Minute 163 12 11 16 6 10 12 10 14 17 12 20 7 17 14 4 10 14 14 13 10 16 13 11 11 17 8 21 17 12 Minute 164 Minute 165 Minute 166 Minute 167 Minute 168 Minute 169 Minute 170 Minute 171 Minute 172 Minute 173 Minute 174 Minute 175 Minute 176 Minute 177 Minute 178 Minute 179 Minute 180 Minute 181 Minute 182 Minute 183 Minute 184 Minute 185 Minute 186 Minute 187 Minute 188 Minute 189 Minute 190 Minute 191 19 11 9 11 15 7 10 10 14 13 12 13 16 9 9 10 10 20 8 8 13 12 19 7 5 15 13 12 Minute 164 Minute 165 Minute 166 Minute 167 Minute 168 Minute 169 Minute 170 Minute 171 Minute 172 Minute 173 Minute 174 Minute 175 Minute 176 Minute 177 Minute 178 Minute 179 Minute 180 Minute 181 Minute 182 Minute 183 Minute 184 Minute 185 Minute 186 Minute 187 Minute 188 Minute 189 Minute 190 Minute 191 14 10 13 18 8 10 16 13 18 9 14 12 8 5 12 10 16 8 15 4 6 5 15 10 18 4 17 10 co Minute 192 Minute 193 Minute 194 Minute 195 Minute 196 Minute 197 Minute 198 Minute 199 Minute 200 14 8 8 14 18 14 8 10 20 Minute 192 Minute 193 Minute 194 Minute 195 Minute 196 Minute 197 Minute 198 Minute 199 Minute 200 8 12 17 14 10 20 10 9 9