Option 2: Probabilities of Graduation and PublicationInstructionsIn 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. Do not convert to percentages as we are interested in probabilities only here.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.Be sure to critically analyze the above calculations in your body paragraphs, explaining how you found each type of probability and then the results you obtained. Be sure to also explain your criteria for ranking in steps 4–7, and defend why you chose that ranking method—as your way might not be the typical method.Paper RequirementsWrite a report that uses the Written Assignment Requirements under the heading Expectations for CSU-Global Written Assignments found in the CSU-Global Guide to Writing and APA (Links to an external site.)Links to an external site.. Items that should be included, but are not limited Items that should be included, at a minimum, are a 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. Please include any tables of calculations, calculated values, and graphs associated with this problem in the body of your assignment response.Note: You must submit your Excel file with your report. This will aid in grading with partial credit if errors are found in the report.

As a manager, you have the following data collected by your data analyst regarding the price and quantity demanded: Price of One Shirt (P) Demand (D) 2300 152 2000 159 1700 164 1500 171 1300 176 1200 180 1000 189 Note that you are asked to use a graphing utility in this assignment. A recommended online utility is https://www.desmos.com/calculator (Links to an external site.). It allows graphing and then copying and posting into a Word document. Using a graphing utility, draw a scatter diagram with price as a function of demand. Using a graphing utility, build a logarithmic model from the data. Graph the logarithmic function in the scatter diagram. Use the function you found above to predict the number of quantities that will be demanded if the price is $1750. Use the function you found in #2 to predict the price, if the quantity demanded is 174. Requirements: Your paper should be 2-3 pages (not counting the title page and references page) and cite and integrate at least one credible outside source. The CSU Global Library (Links to an external site.) is a great place to find resources. Your textbook is a credible resource. Include a title page, introduction, body, conclusion, and a reference page. The introduction should describe or summarize the topic or problem. It might discuss the general applications of the topic or it might introduce the unique terminology associated with the topic. The body of your paper should address the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment. The conclusion should summarize your thoughts about what you have determined from your analysis in completing the assignment. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs. Include any tables of data or calculations, calculated values, and/or graphs referenced in the paper. (Note: The minimum required length excludes any tables, graphs, etc.)

Use the file Blood Pressure Data to answer the following questions. Be sure to check the options at the bottom of the linear regression dialog box. a.Determine the correlation coefficient between weight (the independent variable) and systolic pressure (the dependent variable). Describe your findings related to the magnitude and sign of the correlation. b.Determine the regression equation between weight and systolic pressure using the coefficients in the output. Interpret the meaning of each coefficient. c.Discuss the statistical meaning of the residuals shown in the Residual Output table. d.Evaluate the residual plot, and discuss your interpretation. e.Would you suspect that any of the data points might be considered outliers? On what do you base your decision?. Run a linear regression on the file Health Data, where population density per square mile is the independent variable, and Dr per 100000 is the dependent variable. Be sure to check the options at the bottom of the linear regression