Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are living the dream - probably in a dream. Nick Nurse has hired you as an advanced statistician by his dream (both literally

You are living the dream - probably in a dream. Nick Nurse has hired you as an advanced statistician by his Player Nikola Jokic Jaren Jackson Jr Jason Tatum Luka Doncic OG Anunoby Pascal Siakam Trae Young Chris Paul

You are living the dream - probably in a dream. Nick Nurse has hired you as an advanced statistician by his dream (both literally and figuratively) team to find the best combination of players in certain situations. Before you wake up and come crashing back to Earth, report back to the coach with your lineup of five players. The player data are in the roster table below, and the guidelines the coach has set is listed below. He wants you to set up a late-game lineup that focuses on maximizing its defensive rating, which for an individual player is defined as ten times a player's number of blocks added to their number of rebounds. He also wants their total salaries under the salary cap of $150M. Their average height must be at least 200 cm. There can only be one center (C) and he wants at least two forwards (F). Create a model and use Excel Solver to optimize it according to the information given. Answer in Text box: Was Nikola Jokic chosen? Explain in a sentence or two why you think he was or wasn't. Player Nikola Jokic Jaren Jackson Jr Jason Tatum Luka Doncic OG Anunoby Pascal Siakam Trae Young Chris Paul Ja Morant Steph Curry Position Salary F F F F LL G G G G (SM) 47 27 32 43 18 29 43 30 33 53 Height (cm) 211 208 203 201 201 203 185 183 188 188 Points (per game) 25 19 30 32 17 24 26 12 26 29 FG (%) 63 51 47 50 48 48 43 42 47 49 3pt (%) (per game) (per game) 38 36 35 34 39 32 34 32 31 Rebounds Assists 43 11.8 6.8 8.8 8.6 5.0 7.8 3.0 5.0 5.9 6.1 9.8 1.0 4.6 8.0 2.0 5.8 10.2 7.4 3.4 6.3 Turnovers (per game) (per game) 3.6 1.7 2.9 3.6 2.0 2.4 4.1 1.0 1.1 Blocks 3.2 0.7 3.0 0.7 0.5 0.7 0.5 0.1 0.7 0.3 0.4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Since I cannot actually use Excel Solver or any other software to visually demonstrate the creation of the model I will explain the steps you would ne... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Gail Fayerman

1st Canadian Edition

9781118774113, 1118774116, 111803791X, 978-1118037911

More Books

Students also viewed these General Management questions

Question

What is meant by foreign currency risk for a company?

Answered: 1 week ago

Question

What is meant by the term non-controlling interest (NCI)?

Answered: 1 week ago