74 Create a table of descriptive statistics for attendance for each of the four

Question

74       

Create a table of descriptive statistics for attendance for each of the four teams, including the following statistics:

Count

Mean

Medium

Maximum

Quartile 1

Quartile 3

Interquartile range

Team Attendance Temp Royals 40605 80 Royals 10856 43 Royals 15975 64 Royals 15178 64 Royals 10788 52 Royals 24456 65 Royals 22264 35 Royals 17289 35 Royals 10470 67 Royals 11125 79 Royals 11825 68 Royals 12372 57 Royals 16850 75 Royals 15643 56 Royals 12555 62 Royals 24279 67 Royals 10820 55 Royals 12389 71 Royals 12334 74 Royals 12620 77 Royals 24055 78 Royals 20062 68 Royals 21740 76 Royals 21740 76 Royals 11773 82 Royals 13662 84 Royals 34194 84 Royals 40016 86 Royals 26905 83 Royals 13493 85 Royals 12963 88 Royals 14057 85 Royals 12952 91 Royals 12828 93 Royals 16373 90 Royals 29935 92 Royals 27441 96 Royals 22073 91 Royals 13031 86 Royals 24824 81 Royals 19504 84 Royals 12457 82 Royals 14905 86 Royals 14905 82 Royals 14677 88 Royals 13823 87 Royals 15522 92 Royals 20922 83 Royals 36277 84 Royals 36277 84 Royals 15637 97 Royals 14759 85 Royals 13066 87 Royals 13461 90 Royals 12669 96 Royals 23003 75 Royals 18213 88 Royals 15527 96 Royals 28834 70 Royals 26383 85 Royals 27565 92 Royals 11785 96 Royals 29685 87 Royals 22180 79 Royals 13440 87 Royals 11096 89 Royals 13077 88 Royals 15952 86 Royals 13363 96 Royals 19775 96 Royals 11442 95 Royals 9555 92 Royals 10106 88 Royals 12104 85 Royals 13271 77 Royals 15448 84 Royals 11177 71 Royals 9878 74 Royals 10203 82 Royals 11092 83 Phillies 50958 45 Phillies 18591 48 Phillies 18073 49 Phillies 14502 67 Phillies 13020 75 Phillies 14542 66 Phillies 14111 65 Phillies 13366 57 Phillies 15606 73 Phillies 19195 78 Phillies 12138 57 Phillies 12250 61 Phillies 12249 62 Phillies 15257 65 Phillies 16205 66 Phillies 32411 71 Phillies 12321 82 Phillies 13216 77 Phillies 12476 89 Phillies 20504 77 Phillies 32634 89 Phillies 21114 79 Phillies 21090 60 Phillies 22640 67 Phillies 26405 74 Phillies 15455 91 Phillies 16601 89 Phillies 19223 85 Phillies 14942 78 Phillies 13039 91 Phillies 16888 63 Phillies 20634 70 Phillies 41079 81 Phillies 17424 81 Phillies 21905 82 Phillies 22132 85 Phillies 17039 84 Phillies 18759 86 Phillies 38158 88 Phillies 18422 90 Phillies 20826 95 Phillies 50396 97 Phillies 12303 99 Phillies 44143 88 Phillies 15228 86 Phillies 17393 86 Phillies 23541 93 Phillies 27672 92 Phillies 20422 69 Phillies 23570 73 Phillies 25012 83 Phillies 27330 94 Phillies 22595 95 Phillies 20380 94 Phillies 17076 86 Phillies 23506 82 Phillies 28186 84 Phillies 20259 86 Phillies 14046 99 Phillies 14509 99 Phillies 14289 93 Phillies 31117 93 Phillies 20242 95 Phillies 58493 96 Phillies 16126 86 Phillies 13821 74 Phillies 14268 67 Phillies 18335 80 Phillies 21747 85 Phillies 24047 86 Phillies 13514 93 Phillies 14345 91 Phillies 14345 91 Phillies 12247 82 Phillies 13167 77 Phillies 13718 84 Phillies 16621 85 Phillies 23054 81 Phillies 15807 80 Phillies 14516 77 Cubs 40155 41 Cubs 34956 44 Cubs 18151 51 Cubs 22471 64 Cubs 24496 75 Cubs 33949 64 Cubs 36476 48 Cubs 29458 42 Cubs 30643 60 Cubs 28817 73 Cubs 33138 54 Cubs 23686 53 Cubs 35517 50 Cubs 35083 75 Cubs 35748 52 Cubs 33473 64 Cubs 27738 61 Cubs 34005 66 Cubs 35717 50 Cubs 37175 58 Cubs 37175 58 Cubs 40138 68 Cubs 37478 72 Cubs 38169 86 Cubs 39644 92 Cubs 37643 71 Cubs 38051 67 Cubs 38860 78 Cubs 38742 77 Cubs 39690 83 Cubs 35581 85 Cubs 36247 91 Cubs 38486 88 Cubs 37647 92 Cubs 38201 92 Cubs 29628 88 Cubs 32689 88 Cubs 37129 82 Cubs 39175 79 Cubs 39706 82 Cubs 38806 81 Cubs 40206 79 Cubs 39118 81 Cubs 38566 77 Cubs 39298 77 Cubs 37541 88 Cubs 29618 85 Cubs 32770 74 Cubs 32697 72 Cubs 34565 74 Cubs 39819 89 Cubs 34483 93 Cubs 33751 91 Cubs 38493 79 Cubs 39485 75 Cubs 38414 82 Cubs 39999 89 Cubs 29641 85 Cubs 34493 77 Cubs 37386 85 Cubs 39188 81 Cubs 38728 87 Cubs 38540 79 Cubs 38540 79 Cubs 36311 83 Cubs 37874 83 Cubs 37679 83 Cubs 37739 85 Cubs 36797 82 Cubs 36797 82 Cubs 30020 80 Cubs 21629 84 Cubs 28162 90 Cubs 29587 89 Cubs 20503 75 Cubs 28919 61 Cubs 29658 74 Cubs 20032 76 Cubs 27637 67 Cubs 38617 74 Cubs 37541 84 Reds 41913 56 Reds 19745 44 Reds 16448 41 Reds 17123 48 Reds 18176 44 Reds 17549 65 Reds 15853 83 Reds 14527 81 Reds 15848 83 Reds 14518 60 Reds 13004 72 Reds 14416 59 Reds 28341 61 Reds 22616 56 Reds 23426 76 Reds 12867 65 Reds 16167 77 Reds 15693 79 Reds 29008 65 Reds 25006 72 Reds 20622 78 Reds 16841 53 Reds 20314 65 Reds 23134 74 Reds 38777 85 Reds 27080 86 Reds 26470 81 Reds 19189 88 Reds 23102 63 Reds 30820 74 Reds 31419 74 Reds 29532 75 Reds 26654 80 Reds 27680 87 Reds 27908 90 Reds 26101 91 Reds 27243 89 Reds 23961 89 Reds 32233 90 Reds 19562 94 Reds 19488 94 Reds 16622 95 Reds 23369 92 Reds 26165 86 Reds 19778 89 Reds 28213 92 Reds 40168 76 Reds 27309 90 Reds 18398 92 Reds 19884 74 Reds 24910 76 Reds 23804 88 Reds 23258 93 Reds 27950 90 Reds 22708 71 Reds 40844 92 Reds 23657 91 Reds 20320 86 Reds 25813 87 Reds 22691 88 Reds 25967 87 Reds 20117 82 Reds 16660 82 Reds 19570 85 Reds 19570 85 Reds 17354 82 Reds 20503 82 Reds 16218 85 Reds 21288 88 Reds 20194 87 Reds 13434 95 Reds 13153 94 Reds 14514 79 Reds 16918 79 Reds 21791 87 Reds 24292 84 Reds 22201 81 Reds 36940 77 Reds 40804 77 Reds 40964

74       

Explanation / Answer

1. Count

By using excel we can find count of the attendance by using comand =count(given data of attendance)

Count = 321

2. Mean

Similarly mean can also be found by using command =AVERAGE(given data of attendance)

Mean = 23974.6916

3. Median

Command - =MEDIAN(given data of attendance)

Median = 21905

4. Maximum

Command - =Max(given data of attendance)

Maximum = 58493

4. Quartile 1 (Q1)

Command - =Quartile(given data of attendance,1)

First Quartile (Q1) = 15455

5. Quartile 3 (Q3)

Command - =Quartile(given data of attendance,3)

Third Quartile (Q3) = 32411

6.Interquartile range

Formula = Q3 - Q1 = 32411- 15455 = 16956

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.