Please give an excel file with everything so i can look at it as reference in case i make a mistake in the future

build a coin toss simulator in Excel similar to the dice roll simulator in the Module 10 Excel project. With this simulation, you will flip 4-fair coins 60 times (for a total of 240 flips). For each 4-coin simulation, you will count how many heads appeared. (The value for the number of heads will be between 0 and 4).

In this simulation, you will use the =RANDBETWEEN(0,1) function. This function will pick a random number between its lower limit and its upper limit. In this particular case, the function will randomly pick a 0 or a 1.

If the function gives us a 0, we will say that corresponds to Tail for that toss. If the function gives us a 1, we will say that corresponds to a Head for that toss.

Label the first row as indicated below, and number column A 1-60 to indicate which coin toss you're recording. Columns B, C, D, and E should be the face values of the coins after they land. Image description: We have columns A - E across the top of the Excel sheet and rows 1 - 6 down the side of the Excel sheet. Across the first row we have labels. Cell A1 contains "Toss #". Cell B1 contains "Face 1". Cell C1 contains "Face 2". Cell D1 contains "Face 3". Cell E1 contains "Face 4". Down the first column we have our list of what set of tosses we are studying. Cell A2 contains "1". Cell A3 contains "2". Cell A4 contains "3". Cell A5 contains "4", and Cell A6 contains "5". Cell B2 begins our data generation with the function =RANDBETWEEN(0,1).

You will enter the =RANDBETWEEN(0,1) function for all cells needed in the table.

In your data, each row represents one experiment. One experiment is flipping 4 fair coins.

Notice that every time you hit enter, the values in columns B-E change. This is the randomness in action. When we graph this, though, we will want a set of data that doesn't change. To get this, highlight the data in columns A-E, copy all of it, then Paste Value in columns G-K. On the newest version of Excel, Paste Values is denoted with a small clipboard with 123 at the bottom right corner of it. Now we will be working with the data in Columns G-K and ignoring columns A and B.

In column L, you should record the number of heads you saw each time. Since we let an outcome of 1 represents heads, you can get the total number of heads for each experiment (row), by using the =Sum( ) function. Now, column L has the data that you will use to answer the following questions.

(3 pt) Once you have all of your data, make a frequency table for the Number of Heads. Your bins should be the values 0, 1, 2, 3, 4. Copy and paste the frequency table from Excel here.

0 4 1 38 2 88 3 84 4 26

(Data from what ive done so far, im stuck here)

(4 pt) Now, make a histogram of the Number of Heads. Make sure the histogram is completely labeled. Copy and paste the histogram from Excel here.

(3 pt) Does this histogram look like it may be a normal distribution? If yes, why? If no, why not?

(4 pt) Find the values for the mean and median of your data. Be sure to label each. How did you find the values?

(4 pt) Looking at your sample data only, find the percent of outcomes that had 0, 1 or 2 heads shown. How did you get this probability?

(4 pt) If we assume that the data you collected fits a normal distribution, find the z-score for 2 heads. Use this to find the percent of times that you would flip 4 coins and get 2 or fewer heads.