Project #3For A & B below, upload one Excel and Word file into Blackboard as indicated in class. For Excel, onlysubmit one file but use separate sheets as appropriate. You may work in groups of three for this project. If you choose to do this, make note the otherstudent(s) name(s) in the comments section when you submit the assignment in Blackboard. Eachindividual is responsible for the entire project and must upload a copy into their account toreceive credit. To ensure fairness and a credible curve, questions regarding the project should be asked in classrather than via e-mail or during office hours. The two week time-frame is to provide in-classclarity, not represent the rigor of the project.A. For this question you will be deriving statistical conclusions from actual survey data. Follow the stepsin order to receive full credit. Using the proportional and non-proportional student survey data provided complete thefollowing:i. 95% confidence interval for the mean with graphical illustrations of standard normaldistribution and corresponding Z or T values.ii. One tailed hypothesis test for the mean with corresponding computed and criticalvalues.iii. Two tailed hypothesis test for the mean with corresponding computed and criticalvalues.iv. 95% confidence interval for the standard deviation.v. Graphical illustration of Chi-Square distribution with critical values. You will also do a male vs. female “paired sample test” for one of your two questions (you mayassume the population variance is unknown but equal).
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|