I have a question about a project from my college class of statistics. I have describe the method I’m going to use to compare groups for a small clinician study research on post-traumatic stress disorder but the data would have to be put on Microsoft excel software which I do not know how to do? I’m sure what method to use? I have hypothesis of two drugs that have different effects on lowering anxiety. You would have anxiety scores for drugs A and anxiety scores for drug B( all after week 4of treatment) to run inferential analysis after 4 weeks? here is the problem that I need to describe the method used using the numbers for the method and use mircosoft word document using these question to explain the method being used. Null hypothesis is H0: drug A = drug B Research hypothesis is H1: drug A ≠ drug B Dependent variable: Anxiety score changed after treatment. Independent variable: drug treatment The question to use: What is the significance level of the comparison? What was the alpha level you identified in Week 3? What was the means and variance for each variable? What was the test statistic? What was the critical value for both the one- and two-tailed test? Was your test one-tailed or two-tailed? Were you able to reject the null hypothesis? In other words, did you prove there was a difference? I did not state a direction in your Hypotheses (better than worse than) this will be a two-tailed test. You are looking for the differences in either direction. You would set your alpha level of .05 and have a sample for each group of 30 people that were volunteers for the study. How would I solve this problem and what method can be done for this question?