(All answers were generated using 1,000 trials and native Excel functionality.) The Iowa Energy are scheduled to...

80.2K

Verified Solution

Question

Statistics

(All answers were generated using 1,000 trials and native Excelfunctionality.)

The Iowa Energy are scheduled to play against the Maine RedClaws in an upcoming game in the National Basketball Association(NBA) G League. Because a player in the NBA G League is stilldeveloping his skills, the number of points he scores in a game canvary substantially. Assume that each player’s point production canbe represented as an integer uniform random variable with theranges provided in the following table:

Playerlowa EnergyMaine Red Claws
1    [5,20]    [7,12]
2    [7,20]    [15,20]
3    [5,10]    [10,20]
4    [10,40]    [15,30]
5    [6,20]    [5,10]
6    [3,10]    [1,20]
7    [2,5]    [1,4]
8    [2,4]    [2,4]

Develop a spreadsheet model that simulates the points scored byeach team and the difference in their point totals.

(a)What are the average and standard deviation of points scored bythe Iowa Energy?
Round your answers to one decimal place.
Average:
Standard Deviation:
What is the shape of the distribution of points scored by theIowa Energy?
- Select your answer -Bell-shaped, symmetricUniformBimodalLeftskewedRight skewedItem 3
(b)What are the average and standard deviation of points scored bythe Maine Red Claws?
Round your answers to one decimal place.
Average:
Standard Deviation:
What is the shape of the distribution of points scored by theMaine Red Claws?
- Select your answer -Bell-shaped, symmetricUniformBimodalLeftskewedRight skewedItem 6
(c)Let Point Differential = Iowa Energy points – Maine Red Clawpoints. What is the average Point Differential between the IowaEnergy and Maine Red Claws? What is the standard deviation of thePoint Differential? If your answer is negative, enter a minus signin the input box.
Round your answers to one decimal place.
Average:
Standard Deviation:
What is the shape of the Point Differential distribution?
- Select your answer -Bell-shaped, symmetricUniformBimodalLeftskewedRight skewedItem 9
(d)What is the probability that the Iowa Energy scores more pointsthan the Maine Red Claws?
Round your answer to the nearest whole number.
%
(e)The coach of the Iowa Energy feels that they are the underdogand is considering a riskier game strategy. The effect of thisstrategy is that the range of each Energy player’s point productionincreases symmetrically so that the new range is [0, original upperbound + original lower bound]. For example, Energy player 1’s rangewith the risky strategy is [0, 25]. How does the new strategyaffect the average and standard deviation of the Energy pointtotal? How does that affect the probability of the Iowa Energyscoring more points than the Maine Red Claws?
Round first two numerical answers to one decimal place and thelast answer to a whole percentage.
The average Iowa Energy point total is relatively unchangedat  points, and the standard deviation of the Iowa Energypoint total - Select your answer -is relatively unchangedatincreases todecreases toItem 12  points. Theprobability of the Iowa Energy scoring more points than the MaineRed Claws - Select your answer -is relatively unchanged atincreasestodecreases toItem 14  %.

Answer & Explanation Solved by verified expert
3.6 Ratings (398 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students