QBUS3330 S2 2024 Assignment 1
Page 1
This is an individual assignment. It is worth 10% of your final grade. It consists of three
questions. Each question is worth different marks. It is due on Friday 6 September at 11:59pm
and must be submitted through Canvas using Turnitin.
The submission will comprise two separate parts:
1. A typed report (PDF please) that addresses all questions and contains images all of
relevant tables, charts and decision trees within the report.
2. An Excel file with Precision Tree enabled containing all the original tables, charts and
decision trees. The report must be able to be read as a standalone document. The
Excel file is provided for backup and corroboration purposes.
Failure to submit both files by the due date will result in late penalties being applied.
Additional instructions occur after the questions.
Question 1 (25 marks)
Motivated by the looming Paris Olympics, back in 2023 the Australian Institute of Sport (AIS)
had to decide whether to introduce mandatory drug testing for athletes. Knowing that drug
tests are not completely reliable, they want to use decision tree analysis to see whether the
benefits outweigh the costs.
Probabilities:
If an athlete is tested for a particular drug, the test result will either be positive or negative.
However, as these tests are not completely accurate some athletes who are drug free test
positive (a false positive) and some athletes who are drug users test negative (a false
negative). The best data we have available suggests that 8% of all athletes use drugs. 2.5% of
all tests on DF athletes result in false positives and 7.5% of all tests on drug using athletes
result in false negatives.
Monetary Values:
The monetary values are difficult to assess but include the following:
The benefit B from correctly identifying a drug user and banning them.
The direct cost, C1, of a test.
The cost, C2, of violating a non-users privacy by performing the test.
The cost C3, of falsely accusing a non-user and banning them.
The cost C4, of not identifying a drug user and allowing them to participate.
We measure the benefit and costs by indexing them against cost C1, which we assign a value
of minus one (-1). This does not mean the direct cost of testing an athlete is 1,itjustmeans<br>thatweexpressallothermonetaryvaluesinmultiplesofC1.Theindexvaluesareshownin<br>Table1.1onthefollowingpage.<br><br>QBUS3330S22024Assignment1<br>Page2<br>Table1.1<br>Cost/benefitIndex<br>C1−1<br>C2−2<br>C3−20<br>C4−10<br>B+25<br>Questions:<br>1.InExcelcreatetwonetbenefitpay−offtablesthatmapthenetbenefitofeithertesting<br>(fourdifferentstates)ornottesting(twodifferentstates)againstthedecisiontoban<br>ornotbananathlete.Includethepay−offtablesinyourreport.Note:thefirsttable<br>shouldbeexpressedinindexnotation(+B,−C1,−C2etc)whilethesecondtableshould<br>statethenetbenefitinnumericaltermsbasedonvaluesindictedintable3.1.For<br>example,ifapositivetestisobtainedforanon−druguserandthisathleteisbanned,<br>therearethreeassociatedcosts:Costofthetest(−1),thecostofviolatingtheathlete′s<br>privacy(−2)andcostoffalselyaccusingtheathlete(−50).(6marks)<br>2.Calculatetherelevantposteriorprobabilities.IncludeanyBayestablesgeneratedin<br>Excelinyourreport.(4marks)<br>3.Basedonthevaluesinthenetbenefitpay−offtableandtheBayesianprobabilities,<br>createadecisiontreeusingPrecisionTreethatwillhelptheAISdecidewhetherthey<br>shouldimplementmandatorydrugtesting.Note:Becarefultoavoiddoublecounting<br>thecosts.Includeyourdecisiontreeinyourreport.(8marks)<br>4.Forthegivenassumptionsaroundthecostandbenefit,outlinethebeststrategyand<br>itsnetbenefitanddiscussthissolution.(2marks)<br>5.Conductabriefsensitivityanalysisgivingreasonswhyyoumightchangetherelative<br>indexvalues.Discusshowthismightimpacttheoriginalsolution.(5marks)<br><br>Question2(35marks)<br>IntelligentComputing(iC)hasbeeninvitedtosubmitbytheUniversityofSydneys<br>procurementoffice.Thecontractcallsforthesupplyof200genericdesktopcomputersand<br>associatedaccessorieswhichwillbeusedfordigitalin−placeexams.Allvendorsmustfulfilthe<br>orderwithin6weeksofcontractaward.<br>Despitetheurgencythecontractspecificationsaregenericandsotheuniversityhasinformed<br>allbiddersthatthelowbidwillwinthecontract.iCbelievesthatthecostofpreparingthebid<br>willbe10,000 and the cost of supplying the computers will be 190,000.<br>QBUS3330S22024Assignment1<br>Page3<br>Thebidsaresealed,soiChasnoinformationaboutthevalueofthebidstheircompetitors<br>willsubmit.However,inthelast12monthsiChasmanagedtopoachseveralkeyemployers<br>awayfromvendorswhoarecompetingforthecontractandsoiChasagoodunderstanding<br>ofhowthecompetitorsmaybehave.InsummaryiCbelievesthatthesizeandprobabilityof<br>alowcompetitorbidwillbeasfollows:<br>Table2.1<br>LowBidProbability<br>Lessthan230,000 0.20
Between 230,0代写QBUS3330、c++,Python00−240,000 0.40
Between 240,000−250,000 0.30
More than 250,0000.10<br>Inaddition,becauseofsupplychainconstraints,iCthinkthereisa30'000) Probability (′000)Probability('000) Probability
1 18.0 10% 27.0 20% 18.0 20%
2 36.0 30% 45.0 30% 45.0 40%
3 61.0 30% 61.0 20% 72.0 20%
4 90.0 30% 99.0 30% 90.0 20%
Write a report for potential investors which ranks the three investments in terms of their
attractiveness. Your report should be approximately 500 words. All diagrams and tables used
to support your analysis should be generated in Excel using Precision Tree. As you do not
know the individual risk preferences of investors you should consider all risk types.
Other Instructions
Word count
1,000 words +/-10% excluding tables, decision trees and charts and references. Any words
beyond 1,100 will not be marked. Submissions below 900 words may be penalised.
Style
This is a business report not an essay. The report should:
- Have a suitable cover page.
- Be divided into 3 distinct sections.
- The text should be concise. Using bullet points is acceptable.
- Avoid the use of personal pronouns.
- Be professionally and logically laid out with good grammar and spelling.
- Marks will be deducted for submissions that do not meet these requirements.
QBUS3330 S2 2024 Assignment 1
Page 5
Rubric
There general rubric relating to this assignment in the Assignment 1 Canvas module where
this brief is located that provides detailed information regarding the quality expectations of
the submission.
Late penalties
Reports submitted after the due date will incur a late penalty of 5% per day or part thereof.
Reports more than 10 days late will not receive a mark.
Academic integrity
This is an individual assignment. Collaboration is permitted to help understand the questions
otherwise all written work, research and analysis needs to be your own.
The university acknowledges that most students have access to generative artificial
intelligence (AI) technologies such as ChatGPT.
Students are permitted to use artificial intelligence (AI) tools such as ChatGPT etc. to generate
material that they will then evaluate, analyse and edit for incorporation into their reports.
Students must indicate when and where AI tools have been used. AI generated text cannot
be used or represented as original, self-authored work. Failure to declare the use of AI tools
will be reported as a major breach of policy for investigation.
Students are not permitted to use artificial intelligence (AI) tools such as ChatGPT etc. to
generate material that will be submitted unevaluated and unedited as part of their report. AI
tools cannot be relied upon to generate responses that will adequately address the
requirements of the assessment. Their undeclared use will be reported as a major breach of
policy for investigation.
In line with the Academic Integrity Procedures (2022), minor breaches of academic integrity
(including poor paraphrasing, failure to acknowledge the work of others or incorrect citations)
may be subject to a penalty of up to 15% of total available marks at the point of grading.
Major breaches of the Policy will be submitted for investigation to the Faculty's Academic
Integrity staff.
WX:codehelp