Can someone explain to me how to answer number 3 on an excel spreadsheet? Thank you!

For each of these Scenarios. the fixed COS-t remains 5150.000. Use Scenario Manager to generate a summary report that gives the prot for each of these scenarios. Which scenario yields the highest prot? Which scenario yields the lowest prot? 2. Construct a spreadsheet simulation model to simulate 1.000 rolls of a die with the six sides numbered 1, 2. 3. 4, 5 and 6. a. Construct a histogram of the 1,000 observed dice rolls. {10) b. For each rotl of two dice, record the sum of the dice. Construct a histogram of the 1.000 observations of the sum of two dice. (10) c. For each roll of three dice, record the sum of the dice. Construct a histogram of the 1.000 observations of the sum of three dice. (10} d. For each roll of four dioe. record the sum of the dice. Construct a histogram of the 1.000 observations of the sum of four dice. (10) 3. You are considering the purchase of a new car and are weighing the choice between a Ford Fusion Hybrid sedan (which assists a gasoline engine with an electric motor powered via regenerative braking} and the Ford Fusion Non- Hybrid sedan ust a standard gasoline engine). The non-hybrid version costs $23,000 with fuel economy of 20 miles per gallon in city driving and 30 miles per gallon in highway driving. The hybrid version of the car costs $25,000 with fuel economy of 42 mites per gallon in city driving and 40 mites per gallon in highway driving. You plan to keep the car for 10 years. Your annual mileage is uncertain; you only know that each year you will drive between 9.000 and 13,000 miles. Based on your past driving patterns. 50% of your miles are city driving and 40% of your miles are highway driving. Assume that the gas price remains constant at $2.19 per gallon throughout the 10 years. Is there a cost savings when purchasing the hybrid version? If so, how much on average? (20}