Upon successful completion of the MBA program, imagine you work in the analytics department for a consulting company. Your assignment is to analyze the following databases: Hospital

Provide a detailed, four part, statistical report with the following sections:

Part 1 - Preliminary Analysis

Part 2 - Examination of Descriptive Statistics

Part 3 - Examination of Inferential Statistics

Part 4 - Conclusion/Recommendations

Part 1 - Preliminary Analysis Generally, as a statistics consultant, you will be given a problem and data. At times, you may have to gather additional data. For this assignment, assume all the data is already gathered for you.

State the objective: What are the questions you are trying to address? Describe the population in the study clearly and in sufficient detail: What is the sample? Discuss the types of data and variables: Are the data quantitative or qualitative? What are levels of measurement for the data?

Part 2 - Descriptive Statistics Examine the given data. Present the descriptive statistics (mean, median, mode, range, standard deviation, variance, CV, and five-number summary). Identify any outliers in the data. Present any graphs or charts you think are appropriate for the data. Note: Ideally, we want to assess the conditions of normality too. However, for the purpose of this exercise, assume data is drawn from normal populations.

Part 3 - Inferential Statistics Use the Part 3: Inferential Statistics document. Create (formulate) hypotheses Run formal hypothesis tests Make decisions. Your decisions should be stated in non-technical terms. Hint: A final conclusion saying "reject the null hypothesis" by itself without explanation is basically worthless to those who hired you. Similarly, stating the conclusion is false or rejected is not sufficient.

Part 4 - Conclusion and Recommendations Include the following: What are your conclusions? What do you infer from the statistical analysis? State the interpretations in non-technical terms. What information might lead to a different conclusion? Are there any variables missing? What additional information would be valuable to help draw a more certain conclusion?

3. Suppose you are the manager of an airline company. As a recent MBA graduate, you decided to use all the knowledge you have acquired to improve the firm’s pricing decisions. To begin with, you search for a market survey company to find out the demand curve for flights. The market survey company sent you back a report stating that there are two distinct segments of consumers - tourists and business travelers – and that their demand curves are given by the following equations:

Market Demand for Tourists: Q = 500 – 2P + 2I

Market Demand for Business Travelers: Q = 1000 – P + I

Where Q is the quantity demanded (in thousands of tickets), P is the price for a ticket, and I is the median income of each segment of consumers.

Currently, the price for tourists is $200 and the price for business travelers is $500. Moreover, the median income of tourists is $50 and the median income of business travelers is $100.

a) Using the point slope elasticity formula, what is the price elasticity of demand for airline tickets at the current price and income level for each group of consumer? Hint: to answer this question you will need to accurately determine the slope of the two demand curves given the level of income for each group and find the quantity each group demands at the current price for the group given the income that each group has.

b) Based on your result in (a), do you think you should raise or lower the price paid by tourists? What about the price paid by business travelers?

c) To verify your answer in (b), set a new price for tourists that is $50 higher or lower than the original price of $200 and a new price for business travelers that is $50 higher or lower than the original price of $500. Make your determination of whether to raise or lower the price based on your answers in (b). Relative to the revenue accrued in each market segment with the original prices, what happens to the revenue accrued by the airline in each market segment with the new prices? Hint: If the revenue does not increase then you need to redo this problem by moving the price in the opposite direction!

d) Using the two-point elasticity formula (the arc elasticity formula), what is the price elasticity of demand when you go from the original price to the new price? In doing this problem hold income constant.

You are a hotshot MBA financial analyst for the manager of the Emmons Corporation’s Machining Department. Your manager is visibly upset after being reprimanded for his department’s poor performance over the last month, as presented in the below report:

Emmons Corporation – Machining Department

Department Performance Report

For the Month of November 2016

“I just can’t understand all these unfavorable variances,” your manager complained to you. “When the big boss called me in, I thought she was going to give me a pat on the back for the great job that we had done in November. Instead, she handed me a copy of this report, read me the riot act, and pointed out to me that every variance was unfavorable! I need your help in countering the conclusions of this report.”

Your manager gives you the above report and you go back to your office to study and prepare the response for your manager. You know that direct labor wages and supplies are variable costs; supervision and depreciation are fixed costs, and maintenance and utilities are mixed costs. The fixed component of the original budget maintenance cost is $92,000. The fixed component of the original budget utilities cost is $11,700.

Required:

1. You recall studying flexible budgets in your amazing MBA program. Using a flexible budget approach, prepare the more appropriate performance report for your manager.
2. Based on your report in “a” above, how would you evaluate your department’s performance?

In a survey of MBA students, the following data were obtained on “students’ first reason for application to the school in which they matriculated.” Reason for Application School School cost or Quality Convenience Other Totals Enrollment Status Full Time 421 393 76 890 Part Time 400 593 46 1039 Totals 821 986 122 1929 (a) Develop a joint probability table for these data. (b) Use the marginal probabilities of school quality, school cost or convenience, and other to comment on the most important reason for choosing a school. (c) If a student goes full time, what is the probability that school quality is the first reason for choosing a school? (d) If a student goes part time, what is the probability that school quality is the first reason for choosing a school? (e) Are the enrollment status and the reason for application independent? Explain using probabilities.

•Exercise 1: It is assumed that 80% of the students pass the MBA 510 course. Calculate the following for a class of 15 students:

(a) the mean number of students expected to pass;

(b) the standard deviation;

(c) P(exactly 12 of the 15 students pass);

(d) P(at least 12 of the 15 students pass).

•Exercise 2: Five customers enter a store and make independent purchase decisions. The store’s records indicate that 20% of all customers who enter the store will make a purchase.         

(a) Does a general discrete probability distribution or the binomial distribution apply?

(b) Write the probability form applicable.  

Calculate the probability that:

(c) exactly 4 customers will make a purchase;

(d) less than 3 customers will make a purchase.

Please show all the work in Excel or Word.

Assignment Problem:

Matt Profitt, an MBA student, is studying companies that are going public for the first time. He is curious about whether or not there is a significant relationship between the size of the offering (in millions of dollars) and the price per share.

Size    108     4.4      3.5      8.6      139     228     47.5    5.5      175     12        51        66

Price   12        4          5          6          13        19        8.5      5          15        6          12        12        

a. Develop the appropriate scatterplot for the two variables in the Excel spreadsheet.

b. Based upon the visual inspection of the plot, what type (directional) of relationship do you anticipate between the dependent and independent variables? Offer a brief explanation why that makes theoretical sense.

Please use the example illustrated Tables 12.2 and 12.3 for guidance on the EXCEL steps appropriate to generate the information needed to address the remaining sections.

c. Calculate SS_XX,SS_YY, and SS_XY.

d. Calculate the estimated y intercept (b₀) and the estimated slope coefficient (b₁).

e. Interpret the estimate slope coefficient.

f. Construct the ANOVA appropriate for this regression model.

g. Calculate r².

h. Interpret the coefficient of determination.

i. Calculate s sub b1.

j. Calculate the correlation coefficient.

k. Test whether or not the population correlation coefficient (rho) differs from zero. Use alpha = 0.05.

Could you please just help me with J and K? Thank you so much!

Suppose that, after completing your MBA, you are offered a job as a management consultant in a firm specialized in engagement and productivity. One of your first assignments is related to the education sector. specifically working with a large university. The overall goal of the project you're managing is to identify and enhance motivational factors of students in a well-known university. The purpose is to help improve student motivation and learning engagement to help students reach their goal of degree completion. Because you have recently finished your studies, you feel you have a good understanding of the elements that motivate and de-motivate students.

This case was provided by Pro- fessor Daniel Purdy, Assistant Director of the MBA Program, and Professor Wendy Wilhelm, Professor of Marketing, both of Western Washington University.

The College of Business at Western Washington University is a full-service business school at a midsized regional university. The College of Business special- izes in undergraduate business education with selected gradu- ate programs. While the College emphasizes mostly professional education, it does so within a

offerings, such as the highly suc- cessful Manufacturing and Sup- ply Chain Management degree.

The College is commit-
ted to a student-centered style
of education that emphasizes
the students not as customers
but as equal stakeholders in the
process of education. As part
of its commitment to involving
the students as true partners,
the College has recently begun
the process of conducting focus
groups of undergraduate and
graduate students. The objec-
tive of these focus groups is to
identify negative and positive attitudes about the College and develop new ideas to improve the College.

liberal arts context. Business majors range from standards such as Accounting, Marketing, and Finance to more unique

The following is an excerpt from the transcript of the first undergraduate focus group. This group included 14 stu- dents with the following makeup: 50% male and 50% female; 93% work part-time or more, and 7% do not work; and 29% management majors, with other majors no more than 15%.

Moderator: So what do you guys think are some ways that the College (not the University) can be improved? Jeff: I really like the fact that professors are accessible, willing to help and a lot of them let us call them by their first name. Something that I think could be better is that we don’t spend enough time learning how to do things but in- stead professors spend too much time talking about theory. Sarah: Yea, Yea, I agree totally. It seems like most of the time we aren’t learning practical skills but just talking about what we “should” do, not really learning how to do it. Moderator: Interesting points, how would you suggest the College try to increase the amount of practical learning? Todd: It would really be cool if we could do more real-life professional work in our classes. Things like skill-based projects that focus on doing what we would really do in our profession.

Tim: I think we should all have to do a mandatory intern- ship as part of our major. Right now, some majors let you do it as an elective but they are really hard to find and get. Moderator: Good ideas. Are there other things you think we could improve?

Rhonda: I agree that the professors try really hard to be open to students but the advising is really not very good, I don’t know how to fix it but I know my advisor is pretty much useless.

Ariel: I know, I know. It is so frustrating sometimes. I go to my advisor and she tells me to just fill in my degree

planning sheet and she’ll sign it. It’s like they don’t even know what I should be taking or why.
Jon: My advisor is kind of funny, he just tells me that he doesn’t really know that much about classes he doesn’t teach and my guess is as good as his. At least he’s honest anyway. Moderator: Ok, Ok, so the advising you are getting from the faculty leaves a little to be desired. What do you guys do to figure out how to plan your degrees if your advisors aren’t helping much?

Sarah: I just ask my friends who are further along in the major than I am.
Mark: Yea, me too. In the Student Marketing Association we all give each other advice on what professors are good, what classes go good together, which have prerequisites and stuff like that. It would be cool if we could have some- thing like that for the whole college.

Moderator: Don’t you think CBE could be improved if we developed some sort of Peer-Advising Program?

Using these excerpts as representative of the entire focus group transcript, answer the following questions:

1. Do you think focus groups were the appropriate research method in this case, given the research objectives? What other type(s) of research might provide useful data?

2. Evaluate the questions posed by the moderator in light of the research objectives/question: (a) Are any of them leading or biased in any way? (b) Can you think of any additional questions that could/should be included?

3. Examine the findings. How is CBE perceived? What are its apparent strengths and weaknesses?

4. Can we generalize these findings to all of the College’s students? Why or why not?

Overview- Assume you have just earned an MBA and taken a position as an analyst with an investment bank. You are assigned to a team of analysts responsible for monitoring pharmaceutical companies. Your report would be used in formulating buy/sell recommendations on these companies.

Assignment- Select Teva Pharmaceutical Industries, Ltd. and Merck & Co. for comparative purposes. Prepare a three‐year comparative report and financial analysis on the two companies using the most recent financial data from each company's annual financial statements.

Requirements The report must include:

1. Description and background of companies and product lines

2. How they compare:

a) Financially 1. Working capital 2. Current ratio 3. Liquidity 4. Financial leverage 5. R&D Expenditures 6. Profitability 7. Out‐of‐theordinaryevents/transactions 8. Cash flow analysis 9. Return on assets (ROA) 10. Return on equity (ROE)

b) Operationally 1. Number of days in accounts receivable and accounts receivable turnover 2. Number of daysin inventory and inventory turnover 3. R&D percentage ofrevenue 4. Organic growth vs. growth through mergers and acquisitions 5. Off‐balance sheetobligations

3. Recommendations on how the companies could improve ROE

4. Conclusion as to financial strengths and weaknesses of each company

Ohio, along with many other states as well as other countries, has issued Stay-at-Home orders. Colleges have closed campus and many may have moved back to home communities. Answer the following questions:

1) Should first responders (i.e.: Police Officers and/or Fire Fighters) get “hazard pay” during the Pandemic. If so, how much and how do you propose to finance the extra cost? If not, why not? If your community does not have a police or fire department, what impact do you think the Pandemic will have on current government operations and services of your community?

2) What impact is the COVID-19 Pandemic likely to have on the financial results of the community for 2020 and 2021?