InstructionsIn the following study, three different universities have been tracking a select group of professors over the course of their employment at that university to determine the number of students who are in a particular professor’s classes, how many of those students have graduated and if any of them have had their work published. In the attached Excel file Probabilities are the totals for each of the professors at the three different universities that participated in the study.The purpose of this study is to find the probabilities of graduation and publication for the students in the different professors’ courses. While a causal relationship may not be found between a professor and student graduation or publication, we need to rank the professors based on the different probabilities found with the data sets as described below.Prepare a report (see below) with your ranking of the professors based on the probabilities and conditional probabilities as well as the analysis of each university. Include the following seven (7) items in table format which is provided in the Probabilities file to support your ranking. NOTE: Be sure to use five (5) decimal places for your probabilities in the table, as some of them will be quite small.The overall probability of students graduating at each of the three universities.The overall probability of students having a publication at each of the three universities.The overall probability of students having a publication, given that they graduated at each of the three universities.The probability of a student graduating for each professor.The probability of a student having a publication for each professor.The probability of a student having a publication given that they graduated for each professor.Rank the professors within each university for each of the probabilities in 4 - 6. Then find the sum of the ranks and determine an overall ranking for each professor.MUST have  title page, an introduction, a body which answers the questions posed in the problem, and a conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. As with all written assignments, you should have in-text citations and a reference page too. Please include any tables of calculations, calculated values and graphs associated with this problem in the body of your assignment response.MUST be in APA Format for analysis. MUST provide an excel workbook with assignment!!

1.Provide two different examples of how research uses hypothesis testing, and describe the criteria for rejecting the null hypothesis. Discuss why this is important in your practice and with patient interactions.2.Evaluate and provide examples of how hypothesis testing and confidence intervals are used together in health care research. Provide a workplace example that illustrates your ideas.

ssignment 1: Bottling Company Case Study Due Week 10 and worth 140 points Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment. Write a two to three (2-3) page report in which you: Calculate the mean, median, and standard deviation for ounces in the bottles. Construct a 95% Confidence Interval for the ounces in the bottles. Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test. Provide the following discussion based on the conclusion of your test:   a. If you conclude that there are less than sixteen (16) ounces in a bottle of soda, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future. Or b. If you conclude that the claim of less soda per bottle is not supported or justified, provide a detailed explanation to your boss about the situation. Include your speculation on the reason(s) behind the claim, and recommend one (1) strategy geared toward mitigating this issue in the future. Your assignment must follow these formatting requirements: Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.  No citations and references are required, but if you use them, they must follow APA format. Check with your professor for any additional instructions. Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length. The specific course learning outcomes associated with this assignment are: Calculate measurements of central tendency and dispersal. Determine confidence intervals for data. Describe the vocabulary and principles of hypothesis testing. Discuss application of course content to professional contexts. Use technological tools to solve problems in statistics. Write clearly and concisely about statistics using proper writing mechanics. Attachments:  boco_paper_requirements_spr_16.docx