STAT674-Fall 2018 Project Part 2 Project part 1 set up a very good foundation for you to create a macro to simulate the confidence interval of any kind of samples. Read the guidance carefully, and...

do my assignment for me


STAT674-Fall 2018 Project Part 2 Project part 1 set up a very good foundation for you to create a macro to simulate the confidence interval of any kind of samples. Read the guidance carefully, and submit 1)your code in a .docx or .rtf format and, 2) a report that documents your ideas, thinking process, key output from each steps, and answers to the questions, in docx format. Part A: Create a macro that will allow the flexibility of choosing · different sample sizes, · different numbers of samples, and · different levels of confidence levels, to simulate a confidence interval of a random normal variable. 1. Modify your code from part 1 to add macro variables. 2. Check your code and debug so that it can create similar results as you had in part 1. Due to the randomness of your sample obs, unless you had a way to define a random see, your numbers this time would be slightly different from last time. 3. Call your macro to create confidence intervals as below: 1) Sample size is 200, 400, 600 respectively 2) Number of samples is 400 and 600 respectively 3) Confidence level is 90% and 95% respectively Ultimately, you’ll call the macro 3x2x2=12 times. 4. Stack the 12 CI’s into one data table, add a variable to describe the sample size, number of samples and CI level. For example, the data set may look like this: SampSize NSamples confLevel CI_lowBound CI_HigBound 200 400 90 -.11 .12 ….. …… Bonus: 5. Comment on the relationship of CI width, CI confidence level, and sample size.