Roll an Eight-sided die S a inal Project Let us assume that you are rolling a 8 sided die 50 times, 100 times and 1000 times. Therefore, the possible values you can get in each roll are 1, 2, 3, 4, 5, 6, 7, 8. To get the data you do not have to roll a die, you can use EXCEL with the command =RANDRETWEEN(1,8). Which will give you a random number between 1 and 8. So, you will have three data sets with sample sizes 50, 100 and 1000. Part A Use EXCEL to do this part Create the three data sets using Excel. For each data set: 1. Prepare a frequency distribution table. (Ch 2) 2. Calculate relative frequency and percentage. (Ch 2) 3. Draw a frequency bar graph. (Ch 2) 4. Draw a ple chart for the percentage distribution. (Ch 2) 5. Calculate sample mean, sample variance and sample standard deviation. (Ch 3) 6. Calculate the three Quartiles and Prepare a Box-and-Whisker plot. (Ch 3) 7. Write P(1), P(2), P(3), outcome is 2) (Ch 4) P(8) using relative frequencies. (Where P(2) Is the probability that the Part R-Theoretical 1. If you roll an 8-sided die once and x is the outcome, (Ch5) a) Write the probability distribution of x (This will be the classical probability) b) Compare the above Probabilities in (a) with the probabilities you calculated for all three data sets in Part A-7. c) Calculate mean, variance and standard deviation of x using the probability distribution in (a) d) Compare the mean, variance and standard deviation you got in (c) with values you got for each sample in part A-5. STAT 3308 Final Project 2. For all the data sets find the 95% confidence interval for using. (Ch 8) 1. sample standard deviation found In Part A-5 and the t-distribution. il, the population standard deviation found in Part B-1(b) and the Z-distribution. 3. Conclusion-Write about your findings in part A and B for the three data sets. Write about what happened to the results as the sample size Increase. You can write the conclusion at the end of the project report or at the end of each section.