Provide Step by Step excel solution and final picture of excel with explanation:

Transcribed image text: For each of the situations described below, generate 100 repeated simulation runs in Excel, using pseudorandom numbers. To do this, use the built-in RAND() function: in this case, everyone's results should be a bit different, and each simulation run leads to a different result. 1.1 A three-point field goal is a field goal in a basketball game made from beyond the three-point line (a designated arc surrounding the basket). A successful attempt is worth three points, in contrast to the two points awarded for field goals made within the three-point line. (Note for completeness that one point is awarded for each made free throw: these points are not considered here.) Simulate the performance of a basketball player who scores a three-point field goal 30 percent of the time, a two-point field goal 50 percent of the time, but misses to score 20 percent of the time. Based on the generated sample, record the empirical count for each outcome; then create a scatterplot of the basketball throw simulation results. 1.2 A traffic light at a street crossing is set green 50 percent of the time, yellow 10 percent of the time, and red 40 percent of the time. Simulate the color of the traffic light found at this crossing by a randomly arriving car. Based on the generated sample, record the empirical count for each outcome. Based on your simulation results, create a pie chart of the empirical distribution of the recorded traffic light colors