Please refer to the MS Excel file to sort out the data [Assignment_excel Sep_2022.xslx], you do...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Please refer to the MS Excel file to sort out the data [Assignment_excel Sep_2022.xslx], you do not have to write down the sorted numbers. The remaining procedure of computations however still need to answered by HAND on test pads. By using the inclusive or the exclusive version (but do not mix!) of position measurement: (a) Calculate - the 76th percentile - the 53rd percentile - the percentile rank of 13767300 (shares traded in a day) (b) Construct a Box and Whisker Plot for the data, showing all the necessary calculations for the Quartiles, Boundaries, etc. Trade volume of the shares from a company over a period of 250 days Day Trade Volume (number of shares traded) 10936200 9816600 6727200 4956700 8204700 5258800 1 2 23 4 5 6789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 5866700 7649800 8720200 5627000 8850100 9598600 11957700 6283300 5572400 9203200 5555600 12272500 11848000 7020300 11799500 13369500 10870200 6768500 17144800 21218100 19670700 11569600 14923500 13767300 5373300 5398100 4496200 13049100 15183400 9469000 14340400 8081900 7534300 7609000 7213900 14522800 14446700 9486700 12530900 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 10584400 15920600 10212600 8811000 11351300 11968200 20819300 9027100 28525200 17016400 362800 20312600 14136500 16490400 14552400 15224000 8365600 8641100 17399800 12652000 20461800 14679400 9129000 7841600 7124100 8893700 89 90 91 92 93 94 95 96 7913300 12739300 14492900 13473900 10453900 4507100 11348200 11084300 79 80 6692500 81 4195100 82 17756700 83 10975500 84 4435100 85 6376900 86 4970400 87 11207000 88 8722000 11705500 7064300 6577900 13918100 10122200 8600500 9240300 7426100 97 98 99 100 101 102 103 104 105 106 107 11255700 108 17967700 109 130000 110 8273200 111 15304800 112 113 114 10863800 115 19236900 116 15499200 117 11468100 10186600 7453900 120 3861300 121 4562900 122 6584900 123 48731300 124 17767500 125 19652800 126 18658400 127 11406800 128 118 119 129 130 9817800 16294500 11589000 131 18156800 132 133 5105200 11268400 11258600 4628100 4143700 4179700 5808400 1175000 2022200 5630900 134 135 13692600 15192600 16682600 13983700 5929600 16222100 6539100 7908100 9449900 141 10013600 142 15923500 143 13805100 144 10625300 145 21649200 146 147 136 137 138 30438200 12955400 139 140 15423500 11568500 148 22883500 149 25514400 150 9215300 151 15380100 152 22888600 153 12125900 154 16323700 9762100 10866600 9453400 155 156 157 158 11468200 159 10210000 160 161 162 163 164 165 166 11976400 167 15868700 168 16662100 169 13149200 9786200 5992200 8070600 170 171 172 173 174 6401300 7483500 9429300 7141200 7861700 6785900 175 176 177 178 179 10761200 14306100 12586600 6174200 5490800 14457200 15702000 180 16231900 181 10266800 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 10021800 7924500 3802700 3084200 5969800 7498600 6400000 6511000 8812400 6012300 4887900 8735100 3651500 3621700 8287000 6461100 12659100 5863000 16216300 12648800 8914600 203 8362500 204 8531000 205 10768700 206 12000200 207 10438900 208 7017800 209 56215300 210 12332300 211 212 213 6256000 214 8205400 215 11847300 216 12101000 217 6287500 218 9537300 219 7385300 □ 50 6 201 202 220 221 222 223 224 225 9710400 4940900 10502400 11104700 15716700 246 247 7357800 7365600 8007100 226 7321700 227 21225400 228 15388200 229 17640800 230 14506400 12979000 7187400 9792300 11766700 16896100 11498000 13394700 12221500 231 232 233 234 235 236 237 238 239 12758900 240 10494600 241 13780900 242 18502100 243 23051200 244 26400700 245 11653700 12761600 10012200 248 18915500 249 12524600 250 10502800 Please refer to the MS Excel file to sort out the data [Assignment_excel Sep_2022.xslx], you do not have to write down the sorted numbers. The remaining procedure of computations however still need to answered by HAND on test pads. By using the inclusive or the exclusive version (but do not mix!) of position measurement: (a) Calculate - the 76th percentile - the 53rd percentile - the percentile rank of 13767300 (shares traded in a day) (b) Construct a Box and Whisker Plot for the data, showing all the necessary calculations for the Quartiles, Boundaries, etc. Trade volume of the shares from a company over a period of 250 days Day Trade Volume (number of shares traded) 10936200 9816600 6727200 4956700 8204700 5258800 1 2 23 4 5 6789 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 5866700 7649800 8720200 5627000 8850100 9598600 11957700 6283300 5572400 9203200 5555600 12272500 11848000 7020300 11799500 13369500 10870200 6768500 17144800 21218100 19670700 11569600 14923500 13767300 5373300 5398100 4496200 13049100 15183400 9469000 14340400 8081900 7534300 7609000 7213900 14522800 14446700 9486700 12530900 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 10584400 15920600 10212600 8811000 11351300 11968200 20819300 9027100 28525200 17016400 362800 20312600 14136500 16490400 14552400 15224000 8365600 8641100 17399800 12652000 20461800 14679400 9129000 7841600 7124100 8893700 89 90 91 92 93 94 95 96 7913300 12739300 14492900 13473900 10453900 4507100 11348200 11084300 79 80 6692500 81 4195100 82 17756700 83 10975500 84 4435100 85 6376900 86 4970400 87 11207000 88 8722000 11705500 7064300 6577900 13918100 10122200 8600500 9240300 7426100 97 98 99 100 101 102 103 104 105 106 107 11255700 108 17967700 109 130000 110 8273200 111 15304800 112 113 114 10863800 115 19236900 116 15499200 117 11468100 10186600 7453900 120 3861300 121 4562900 122 6584900 123 48731300 124 17767500 125 19652800 126 18658400 127 11406800 128 118 119 129 130 9817800 16294500 11589000 131 18156800 132 133 5105200 11268400 11258600 4628100 4143700 4179700 5808400 1175000 2022200 5630900 134 135 13692600 15192600 16682600 13983700 5929600 16222100 6539100 7908100 9449900 141 10013600 142 15923500 143 13805100 144 10625300 145 21649200 146 147 136 137 138 30438200 12955400 139 140 15423500 11568500 148 22883500 149 25514400 150 9215300 151 15380100 152 22888600 153 12125900 154 16323700 9762100 10866600 9453400 155 156 157 158 11468200 159 10210000 160 161 162 163 164 165 166 11976400 167 15868700 168 16662100 169 13149200 9786200 5992200 8070600 170 171 172 173 174 6401300 7483500 9429300 7141200 7861700 6785900 175 176 177 178 179 10761200 14306100 12586600 6174200 5490800 14457200 15702000 180 16231900 181 10266800 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 10021800 7924500 3802700 3084200 5969800 7498600 6400000 6511000 8812400 6012300 4887900 8735100 3651500 3621700 8287000 6461100 12659100 5863000 16216300 12648800 8914600 203 8362500 204 8531000 205 10768700 206 12000200 207 10438900 208 7017800 209 56215300 210 12332300 211 212 213 6256000 214 8205400 215 11847300 216 12101000 217 6287500 218 9537300 219 7385300 □ 50 6 201 202 220 221 222 223 224 225 9710400 4940900 10502400 11104700 15716700 246 247 7357800 7365600 8007100 226 7321700 227 21225400 228 15388200 229 17640800 230 14506400 12979000 7187400 9792300 11766700 16896100 11498000 13394700 12221500 231 232 233 234 235 236 237 238 239 12758900 240 10494600 241 13780900 242 18502100 243 23051200 244 26400700 245 11653700 12761600 10012200 248 18915500 249 12524600 250 10502800
Expert Answer:
Answer rating: 100% (QA)
The data of trade volume of shares of a company is given for 250 days and the objective is to find the percentile value and fit a box and whisker plot Box Plot is used to find the outlier a The follow... View the full answer
Related Book For
Auditing The Art And Science Of Assurance Engagements
ISBN: 9780136692089
15th Canadian Edition
Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Chris E. Hogan, Joanne C. Jones
Posted Date:
Students also viewed these accounting questions
-
? ????????? 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 50 Use your 44 use is 45 46 47 48 49 Made sales of product Cost for the inventory that was sold Amount of the invoice (above) that returns and...
-
For the previous question, assume that you do not have sufficient savings to cover the entire amount required to start your sun-block business. You are going to have to get external financing. A...
-
You do not have to agree with Bogles planning strategy. Playing the devils advocate (one who argues for the opposite viewpoint), persuasively present another perspective. (You may want to do some...
-
You work in the finance department of a telecommunications firm with a large direct sales force selling high- speed fiber optics access lines to companies wanting telephone and Internet access. Your...
-
A 70.0-kg circus performer is fired from a cannon that is elevated at an angle of 40.0 above the horizontal. The cannon use strong elastic bands to propel the performer, much in the same way that a...
-
For a two-level system, the weight of a given energy distribution can be expressed in terms of the number of systems, N, and the number of systems occupying the excited state, n 1 . What is the...
-
The 2008 comparative balance sheet and income statement of Digital Subscriptions, Inc.. follow. Digital Subscriptions had no noncash investing and financing trans- actions during 2008. During the...
-
Can a creditor of both the husband and wife under the same obligation obtain an execution against a Winnebago mobile home owned by the husband and wife in tenancy by entirety?
-
On 10 May an investor sells a six-month put option on 1,000 shares of a stock. The current stock price $39 and the exercise price of the put option is $40. The price of the put option is $2.30 per...
-
GWE in store retail is considering closing stores to save a further 20% next year. Given current figures, how many stores would you expect GWE to close? GWE Profit and Loss for (Year 1) Asia...
-
When Maya drives to her office at 40m(i)/(h), it takes 10 fewer minutes than when she drives at 30m(i)/(h). How many minutes would it take her to get to work if she drove 50m(i)/(h) ?
-
A square chip of size \(8 \mathrm{~mm}\) is mounted on a substrate with the top surface being exposed to a coolant flow at \(20^{\circ} \mathrm{C}\). All other surfaces of the chip are insulated. The...
-
A thin metal plate has one large insulated bottom surface and the top large surface exposed to solar radiation at a rate of \(600 \mathrm{~W} / \mathrm{m}^{2}\). The surrounding air temperature is...
-
A simplified model can be applied to describe the steady-state temperature distribution through the core region, muscle region and skin region of the human body. The core region temperature...
-
Consider a person standing in a room, which is at a temperature of \(21^{\circ} \mathrm{C}\). Determine the total heat rate from this person if the exposed surface area of the person is \(1.6...
-
Consider a \(0.6 \mathrm{~m}\) high and \(2 \mathrm{~m}\) wide double-pane window consisting of two \(4 \mathrm{~mm}\) thick layers of glass \(\left(k=0.80 \mathrm{~W} / \mathrm{m}^{\circ} \mathrm{C}...
-
SE to convert (Ax, Ay)-->(A, theta) we find A by Ay cos(theta) Ax cos(theta) tan^-1 (Ayl/Ax|) O sqrt(Ax^2 +|Ay|^2)
-
Complete the following acid-base reactions: (a) HCCH + NaH
-
The following are independent situations for which you will recommend an appropriate auditors report. For each situation, using the framework for reporting decisions, identify the appropriate audit...
-
What are relevant management assertions? Why are relevant assertions important to the audit process?
-
You are the in-charge accountant on the audit of Dezine Inc. (DI). It is March 25, 2020, and your firm is partway through the audit for the year ended January 31, 2020. You are currently assigned to...
-
Fill in the Blank. In a random process, the outcome of an experiment will be a function of some _________ such as time.
-
What is the covariance between two random variables \(X\) and \(Y\) ?
-
The joint density function of two random variables \(X\) and \(Y\) is given by \[p_{X, Y}(x, y)= \begin{cases}\frac{x y}{9}, & 0 \leq x \leq 2,0 \leq y \leq 3 \\ 0, & \text { elsewhere }\end{cases}\]...
Study smarter with the SolutionInn App