PLEASE SOLVE ALSO WITH EXCEL

1. Consider the system which you have proposed for your group for Phase 1 of the course project. (If you have not submitted a proposal for your course project, please contact me at my email address davood.shiri@bilgi.edu.tr for clarifying the situation as soon as possible). Choose the simulated data for one of the stochastic input data of your model which you simulated at Phase 2 of the course project. . (10 points) What is the sample size of your simulated data? (For example, if you have simulated interarrival times for 53 customers, the sample size is 53). . (20 points) Construct a histogram for your data in which the number of class intervals equals the rounded up value of the square root of the sample size. (30 points) Compare the shapes of Poisson, Exponential, and Normal distributions with the shape of the constructed histogram. Which one of these distributions has similar context to your data? The shape of which of these distributions is more similar to the shape of your histogram? . (10 points) Calculate the sample mean of the data? . (10 points) Calculate the sample variance of the data? . (10 points) Specify one of Poisson, Exponential, and Normal distributions as the family of the distribution of your simulated data. What are the parameters of the chosen distribution? Estimate the parameters of your specified distribution. (Hint: you should use sample mean or/and sample . (10 points) How can you test the hypothesis that your simulated data follows the specified prob- ability distribution? What is the effect of sample size on such a test? Please note the following remarks If you do not have a group, please send an email to me as soon as possible. I will share a data with you for HW 5. The HW should be done individually, collaboration is NOT allowed. However, please write the names of all your course project's group members in your submitted HW. You can draw the histogram manually or in Excel Please include detailed explanations and discussions in your HW submission to collect complete 100 points. 1. Consider the system which you have proposed for your group for Phase 1 of the course project. (If you have not submitted a proposal for your course project, please contact me at my email address davood.shiri@bilgi.edu.tr for clarifying the situation as soon as possible). Choose the simulated data for one of the stochastic input data of your model which you simulated at Phase 2 of the course project. . (10 points) What is the sample size of your simulated data? (For example, if you have simulated interarrival times for 53 customers, the sample size is 53). . (20 points) Construct a histogram for your data in which the number of class intervals equals the rounded up value of the square root of the sample size. (30 points) Compare the shapes of Poisson, Exponential, and Normal distributions with the shape of the constructed histogram. Which one of these distributions has similar context to your data? The shape of which of these distributions is more similar to the shape of your histogram? . (10 points) Calculate the sample mean of the data? . (10 points) Calculate the sample variance of the data? . (10 points) Specify one of Poisson, Exponential, and Normal distributions as the family of the distribution of your simulated data. What are the parameters of the chosen distribution? Estimate the parameters of your specified distribution. (Hint: you should use sample mean or/and sample . (10 points) How can you test the hypothesis that your simulated data follows the specified prob- ability distribution? What is the effect of sample size on such a test? Please note the following remarks If you do not have a group, please send an email to me as soon as possible. I will share a data with you for HW 5. The HW should be done individually, collaboration is NOT allowed. However, please write the names of all your course project's group members in your submitted HW. You can draw the histogram manually or in Excel Please include detailed explanations and discussions in your HW submission to collect complete 100 points