Deakin Melbourne Boomers The Deakin Melbourne Boomers have been a part of the Women’s National Basketball League (WNBL) since 1984, making the club both the oldest WNBL club and the longest-running...

Deakin Melbourne Boomers The Deakin Melbourne Boomers have been a part of the Women’s National Basketball League (WNBL) since 1984, making the club both the oldest WNBL club and the longest-running elite-level women’s sports team in Australia (in any sport). The iconic brand of the Boomers is both nationally and internationally recognised, most notably for being home to more Olympians and Opals than any other basketball club across Australia. For 30 years the team was known as the Bulleen Boomers, before transforming into the Melbourne Boomers in 2013. In 2015 Deakin University joined as the club’s Naming Rights partner.


Data Description Deakin Melbourne Boomers Variable Name and Description: Campaign Sheet Campaign ID:Numbered list from Campaign 1 to campaign 250 Campaign Type:Campaigns have been allocated into three broad groups: -          Team-based -          Special Events and Occasions -          Membership Promotions Campaign Media:Media used in the campaigns: -          Website -          Email -          Facebook -          Other Social Media (e.g., Instagram, Twitter) Campaign Reach (NUM):Number of contacts (member and non-members) in the specific campaign Campaign Reach (CAT):Four reach levels are used by the Boomers: -          Targeted: 100 recipients or fewer -          Narrowcast: 101 to 1,000 recipients -          Medium: 1001 to 5,000 recipients -          Broadcast: All contacts (more than 5,000 recipients) Campaign Success:The Boomers track and score responses from all contacts across all campaigns on a scale of 0 (not at all) to 100 (fully successful) Campaign New Members: Number of new members signed as an outcome of the campaign. Campaign Revenue:All campaigns aim to raise revenue for the Boomers. The minimum campaign revenue generated is $0. The most successful campaigns exceed $10,000. Membership Sheet: Date:The month and year the number of new memberships recorded New Memberships:Number of new members joining in the specific month-year Campaign Campaign IDTypeMediaReach (NUM)SuccessNew MembersRevenue 1TeamEmail1025980$ 2,909 2Special EventsFacebook711036781$ 12,138 3PromotionsSocial Media97456167$ 4,719 4TeamWebsite1415284$ 3,145 5TeamEmail996180$ 2,939 6Special EventsFacebook375562446$ 7,285 7PromotionsSocial Media84569155$ 4,604 8TeamWebsite112391182$ 5,116 9TeamEmail569356$ 2,114 10Special EventsWebsite988480$ 2,747 11Special EventsSocial Media83264153$ 4,496 12PromotionsWebsite45498115$ 3,286 13TeamFacebook293372363$ 5,838 14TeamWebsite38788109$ 3,402 15Special EventsFacebook566761637$ 10,114 16PromotionsFacebook607957678$ 10,543 17PromotionsEmail7210072$ 2,701 18TeamEmail816378$ 2,898 19TeamSocial Media115619186$ 5,242 20Special EventsSocial Media123440193$ 5,259 21PromotionsWebsite62283132$ 3,809 22PromotionsFacebook658172728$ 14,422 23Special EventsEmail846678$ 2,829 24PromotionsWebsite89890160$ 4,493 25TeamFacebook499290569$ 9,043 26TeamEmail7410074$ 2,876 27Special EventsFacebook458372528$ 8,350 28PromotionsSocial Media87674158$ 4,508 29TeamWebsite2255493$ 3,205 30TeamEmail889779$ 2,866 31Special EventsFacebook468557539$ 8,645 32PromotionsSocial Media93476163$ 4,690 33TeamWebsite633363$ 2,536 34TeamEmail5310053$ 2,070 35Special EventsWebsite54767125$ 3,736 36Special EventsSocial Media97846168$ 4,617 37PromotionsWebsite39836110$ 3,200 38TeamFacebook519068589$ 9,335 39TeamWebsite45065115$ 3,351 40Special EventsFacebook582883653$ 10,268 41PromotionsFacebook309974380$ 6,148 42PromotionsEmail547654$ 2,087 43TeamEmail628362$ 2,397 44TeamSocial Media141525212$ 4,729 45Special EventsSocial Media128163198$ 5,350 46PromotionsWebsite3895109$ 3,328 47PromotionsFacebook479477549$ 8,808 48Special EventsEmail1176682$ 3,009 49PromotionsWebsite36215106$ 3,044 50TeamFacebook591776662$ 10,401 51TeamEmail576357$ 2,361 52Special EventsFacebook593129663$ 10,405 53PromotionsSocial Media150840221$ 4,962 54TeamWebsite121182$ 3,160 55TeamEmail849978$ 2,741 56Special EventsFacebook41177111$ 3,279 57PromotionsSocial Media74350144$ 4,109 58TeamWebsite58268128$ 3,716 59TeamEmail416241$ 1,766 60Special EventsWebsite38143108$ 3,233 61Special EventsSocial Media11866189$ 5,316 62PromotionsWebsite83140153$ 4,532 63TeamFacebook250877321$ 5,164 64TeamWebsite58612129$ 3,570 65Special EventsFacebook685536756$ 11,850 66PromotionsFacebook458776529$ 8,374 67PromotionsEmail874679$ 2,827 68TeamEmail508150$ 1,916 69TeamSocial Media91961162$ 4,538 70Special EventsSocial Media88869159$ 4,391 71PromotionsWebsite56840127$ 3,774 72PromotionsFacebook461779532$ 8,368 73Special EventsEmail1067081$ 2,990 74PromotionsWebsite37112107$ 3,199 75TeamFacebook624397694$ 10,841 76TeamEmail1226182$ 3,167 77Special EventsFacebook384877455$ 7,470 78PromotionsSocial Media82662153$ 4,326 79TeamWebsite34167104$ 3,206 80TeamEmail9910080$ 2,881 81Special EventsFacebook8437351491$ 13,993 82PromotionsSocial Media97683168$ 4,525 83TeamWebsite1597386$ 3,151 84TeamEmail6610066$ 2,381 85Special EventsWebsite57591128$ 3,535 86Special EventsSocial Media112454182$ 5,035 87PromotionsWebsite2488795$ 3,387 88TeamFacebook2814100351$ 5,679 89TeamWebsite30871101$ 3,048 90Special EventsFacebook70382774$ 12,150 91PromotionsFacebook707136777$ 11,971 92PromotionsEmail664966$ 2,535 93TeamEmail497849$ 1,935 94TeamSocial Media120587191$ 5,206 95Special EventsSocial Media138237208$ 4,738 96PromotionsWebsite59736130$ 3,850 97PromotionsFacebook105932795$ 12,339 98Special EventsEmail968080$ 2,745 99PromotionsWebsite2583796$ 3,283 100TeamFacebook52264593$ 9,349 101TeamEmail648864$ 2,296 102Special EventsFacebook351368421$ 6,704 103PromotionsSocial Media113280183$ 5,067 104TeamWebsite56385126$ 3,556 105TeamEmail1216782$ 2,914 106Special EventsFacebook478391548$ 8,739 107PromotionsSocial Media118461188$ 5,155 108TeamWebsite747374$ 2,738 109TeamEmail549054$ 2,132 110Special EventsWebsite86424156$ 4,677 111Special EventsSocial Media117587188$ 5,330 112PromotionsWebsite431243$ 2,074 113TeamFacebook480391550$ 8,685 114TeamWebsite71215141$ 4,119 115Special EventsFacebook489377559$ 8,889 116PromotionsFacebook579666650$ 10,472 117PromotionsEmail748874$ 2,615 118TeamEmail768176$ 2,807 119TeamSocial Media71784142$ 3,832 120Special EventsSocial Media152593223$ 4,953 121PromotionsWebsite76513147$ 4,054 122PromotionsFacebook315571386$ 6,431 123Special EventsEmail666866$ 2,279 124PromotionsWebsite86371156$ 4,403 125TeamFacebook201389271$ 5,984 126TeamEmail448644$ 1,725 127Special EventsFacebook669380739$ 11,546 128PromotionsSocial Media114419184$ 5,191 129TeamWebsite203790$ 3,282 130TeamEmail566756$ 2,399 131Special EventsFacebook414693485$ 7,654 132PromotionsSocial Media131688202$ 4,498 133TeamWebsite60040130$ 3,899 134TeamEmail1186582$ 2,841 135Special EventsWebsite97556168$ 4,813 136Special EventsSocial Media11747187$ 5,123 137PromotionsWebsite60475130$ 4,006 138TeamFacebook474588545$ 8,739 139TeamWebsite63844134$ 3,829 140Special EventsFacebook652760723$ 11,460 141PromotionsFacebook9600931030$ 15,847 142PromotionsEmail724672$ 2,560 143TeamEmail587858$ 2,184 144TeamSocial Media117527188$ 5,167 145Special EventsSocial Media89562160$ 4,592 146PromotionsWebsite55815126$ 3,771 147PromotionsFacebook545549616$ 9,732 148Special EventsEmail788678$ 2,898 149PromotionsWebsite58987129$ 3,703 150TeamFacebook563645634$ 10,036 151TeamEmail529052$ 2,025 152Special EventsFacebook461574532$ 8,519 153PromotionsSocial Media120846191$ 5,384 154TeamWebsite972180$ 2,932 155TeamEmail808378$ 2,776 156Special EventsFacebook891622923$ 14,212 157PromotionsSocial Media83981154$ 4,454 158TeamWebsite34554105$ 3,111 159TeamEmail718071$ 2,670 160Special EventsWebsite36184106$ 2,993 161Special EventsSocial Media133757204$ 4,528 162PromotionsWebsite30046100$ 3,040 163TeamFacebook304891375$ 6,052 164TeamWebsite1369684$ 3,069 165Special EventsFacebook613664684$ 10,751 166PromotionsFacebook338288408$ 6,805 167PromotionsEmail1387384$ 3,120 168TeamEmail816678$ 2,645 169TeamSocial Media68174138$ 4,112 170Special EventsSocial Media131232201$ 4,369 171PromotionsWebsite5652127$ 3,681 172PromotionsFacebook85611767$ 11,971 173Special EventsEmail746674$ 2,547 174PromotionsWebsite67742138$ 4,000 175TeamFacebook50128571$ 9,172 176TeamEmail577957$ 2,090 177Special EventsFacebook324475394$ 6,322 178PromotionsSocial Media105687176$ 5,024 179TeamWebsite2424094$ 3,390 180TeamEmail633663$ 2,334 181Special EventsFacebook3356100406$ 6,647 182PromotionsSocial Media116045186$ 5,282 183TeamWebsite31421101$ 3,059 184TeamEmail706470$ 2,632 185Special EventsWebsite82678$ 3,008 186Special EventsSocial Media135451205$ 4,500 187PromotionsWebsite77174147$ 4,222 188TeamFacebook655935726$ 11,263 189TeamWebsite72126142$ 4,029 190Special EventsFacebook324995395$ 6,414 191PromotionsFacebook302983373$ 6,054 192PromotionsEmail488748$ 1,962 193TeamEmail836678$ 2,964 194TeamSocial Media80768151$ 4,299 195Special EventsSocial Media84856155$ 4,396 196PromotionsWebsite284228$ 1,377 197PromotionsFacebook818022888$ 13,801 198Special EventsEmail907879$ 2,789 199PromotionsWebsite42165112$ 3,246 200TeamFacebook485991556$ 8,824 201PromotionsFacebook430062500$ 7,945 202Special EventsWebsite42620113$ 3,373 203PromotionsFacebook651972722$ 11,325 204TeamFacebook777970848$ 13,298 205TeamEmail736773$ 2,719 206Special EventsEmail669666$ 2,368 207PromotionsSocial Media10571176$ 4,874 208TeamSocial Media98083168$ 4,626 209TeamWebsite36850107$ 3,143 210Special EventsFacebook512452582$ 9,223 211PromotionsEmail887579$ 2,978 212TeamWebsite2149191$ 3,379 213TeamFacebook615375685$ 10,725 214Special EventsEmail776277$ 2,854 215Special EventsFacebook126177196$ 5,252 216PromotionsSocial Media70063140$ 3,890 217TeamWebsite35275105$ 3,188 218TeamEmail956780$ 2,897 219Special EventsFacebook789363859$ 13,578 220PromotionsSocial Media85078155$ 4,424 221PromotionsWebsite71446141$ 3,951 222TeamEmail666266$ 2,523 223TeamWebsite36883107$ 3,046 224Special EventsSocial Media63664134$ 3,752 225PromotionsWebsite38854109$ 3,484 226PromotionsFacebook397588468$ 7,403 227Special EventsWebsite42060112$ 3,290 228PromotionsFacebook676768747$ 11,771 229TeamFacebook436778507$ 8,019 230TeamEmail993680$ 2,901 231Special EventsEmail1146181$ 2,819 232PromotionsSocial Media74970145$ 4,101 233TeamSocial Media118872189$ 5,202 234TeamWebsite52547123$ 3,537 235Special EventsFacebook216482286$ 6,281 236PromotionsEmail518351$ 1,959 237TeamWebsite72035142$ 3,989 238TeamFacebook199370269$ 5,865 239Special EventsWebsite352335$ 1,558 240Special EventsFacebook631388701$ 11,008 241PromotionsFacebook396377466$ 7,651 242TeamEmail856479$ 2,752 243TeamEmail8510079$ 2,793 244Special EventsSocial Media104455174$ 4,930 245PromotionsSocial Media12042190$ 5,201 246PromotionsWebsite2124091$ 3,047 247TeamFacebook157073227$ 5,198 248TeamEmail1367284$ 2,939 249Special EventsWebsite66066136$ 3,839 250PromotionsFacebook93767164$ 4,623 Membership DateNew Memberships Jan-1173 Feb-1157 Mar-1157 Apr-1157 May-1156 Jun-1160 Jul-1156 Aug-1155 Sep-1157 Oct-1154 Nov-1182 Dec-1184 Jan-1278 Feb-1264 Mar-1256 Apr-1261 May-1263 Jun-1266 Jul-1273 Aug-1266 Sep-1268 Oct-1260 Nov-1292 Dec-1292 Jan-1382 Feb-1371 Mar-1368 Apr-1368 May-1370 Jun-1372 Jul-1374 Aug-13180 Sep-1374 Oct-1369 Nov-1398 Dec-13101 Jan-1494 Feb-1473 Mar-1475 Apr-1478 May-1480 Jun-1471 Jul-1482 Aug-1478 Sep-1476 Oct-1474 Nov-14106 Dec-14110 Jan-1598 Feb-1582 Mar-1583 Apr-1579 May-1578 Jun-1587 Jul-1596 Aug-1581 Sep-1586 Oct-15173 Nov-15105 Dec-15116 Jan-16107 Feb-1690 Mar-1692 Apr-1689 May-1698 Jun-1692 Jul-16102 Aug-1693 Sep-1694 Oct-1696 Nov-16121 Dec-16124 Jan-17113 Feb-1792 Mar-1798 Apr-1796 May-1798 Jun-1799 Jul-17101 Aug-1799 Sep-17101 Oct-17100 Nov-17123 Dec-17126 Jan-18116 Feb-18115 Mar-18106 Apr-18103 May-18108 Jun-18106 Jul-18112 Aug-18107 Sep-18108 Oct-18111 Nov-18131 Dec-18136 Jan-19114 Feb-1996 Mar-19100 Apr-1997 May-1995 Jun-1992 Jul-19105 Aug-19101 Sep-19102 Oct-19101 Nov-19123 Dec-19132 Jan-20107 Feb-2088 Mar-2093 Apr-2091 May-2093 Jun-2092 Jul-20100 Aug-2091 Sep-2095 Oct-2092 Nov-20113 Dec-20123 Q1 CONCLUSIONQ1 Campaign Type Team-basedI am 95% confident that … Special Events and OccasionsI am 95% confident that … Membership PromotionsI am 95% confident that … QuestionAnswer Which “Campaign Type” generates the highest Revenue? OUTPUTQ1 WORKINGQ1 Q2 CONCLUSIONQ2 Campaign Type Team-basedI am 95% confident that Special Events and OccasionsI am 95% confident that Membership PromotionsI am 95% confident that QuestionAnswer Is there any “Campaign Type” that, proportionally, is represented more (or less) than others? OUTPUTQ2 WORKINGQ2 Q3 CONCLUSIONQ3 Campaign Type Team-basedThe probability that "Campaign Success" … Special Events and OccasionsThe probability that "Campaign Success" … Membership PromotionsThe probability that "Campaign Success" … OUTPUTQ3 WORKINGQ3 Q4 CONCLUSIONQ4 New Memberships At a 5% Level of Significance… OUTPUTQ4 WORKINGQ4 Dashboard Additional Analysis Use this spreadsheet for additional analysis for your Report, or for the Dashboard. You may have several "Additional analysis" sheets. Note: This tab will not be marked MIS171 – Business Analytics - Trimester 1 2021 Assignment 2 – Individual DUE DATE AND TIME: Due by 8 p.m. AEST on Friday 30 April 2021 PERCENTAGE OF FINAL GRADE: 25% Submission: Two-page report (Word file) and data analysis and visualisation (Excel file) Description: This is an individual assignment, which focuses on materials presented from Week 1 to (and including) Week 6 (Hypothesis Testing). The scenarios presented in this assessment task simulates a data- driven
May 23, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here