9.3 Effective Tables
Week 9 isualizing and Presenting Data and Results
9.4 PivotTables
Week 9 isualizing and Presenting Data and Results
9.8 Effective Charts
Week 9 isualizing and Presenting Data and Results
10.2 Components of a Decision
Imagine that you are deciding between two different job offers. The two job offers are
the alternatives.
What are some of your objectives? (What is it that you¥ trying to maximize/minimize?)
What are some uncertainties that affect how well you will do on those objectives?
10.3 Expected Value
Week 10 ntroduction to Prescriptive Analytics
Please answer the following question.
An Eaglebucks Lotto ticket costs $1. 7% of the time (0.07 probability), the ticket wins a
$5 prize. 0.000001% of the time (1/100 million probability), the ticket wins a $50 million
prize. The rest of the time, the ticket wins $0. What is the expected value of a ticketÊprize? That is, on average, how much is a ticket worth?
10.4 Decision Trees
Week 10 ntroduction to Prescriptive Analytics
Please answer the following question.
You are organizing a 5K run for charity and are trying to decide between two venues: Outdoor stadium: capacity for 200 runners -Indoor stadium: capacity for 160 runners It
is a popular event, and the maximum number of runners will sign up. There is a 25%
chance of rain on the day of the event. If it rains, the event can either be cancelled
(resulting in $0 raised), or it can be moved indoors with a $3,000 fee for obtaining the
indoor venue on short notice. Historically, 50% of the runners do not show up on a rainy
day when the event is moved indoors on short notice; you expect 100 runners. Your knearest neighbors model predicted that you will raise $115 per runner. Construct and
solve a decision tree for this problem. What is the expected value of net dollar amount
raised?

Purchase answer to see full
attachment