Need help with highlighted portions. I can't figure out the formulas to calculate the problem.

AutoSave OFF A H FC... Chapter 7 - Game Show Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Calibri (Body) v 11 AA ab Wrap Text General Ex AP- O. Ex Delete v v Z Sort & Find & Analyze Sensitivity Paste BIUV DV Av E Merge & Center v $ ~ % " Conditional Format Cell Formatting as Table Styles Format v Filter Select Data S33 4 fx A C D E F G H J K M N P Q R S T U V W X 23 the number of spins in cell B6 and notice how the number of outcomes in each replication is the same as the number of spins. Then make the number of spins equal to 10. 24 25 On the Simulation sheet, calculate the winnings for each replication of the experiment. Note that each "winning" value is the same thing as an x-bar for that row. 26 27 Using the experimental data, calculate the mean and the standard deviation of your Theoretically, what should be the values for the mean and standard deviation of these x-bars? (Hint: You 28 winnings. (Be sure you reference cells from the Simulation sheet.) will need to reference a cell on the Simulation sheet for one of these 29 (Experimental) Summary measures of winnings Theoretical measures for winnings 30 mean of winnings $500 Expected Value of winnings