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

• Manufacturing
• Hospital
• Consumer Food
• Financial

Select one of the databases based on the information in the Signature Assignment Options.

Provide a 1,600-word 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?

Assignment #7: One-sample Chi-Square
Directions: Use the Chi-Square option in the Nonparametric Tests menu to answer the questions based on the following scenario. (Assume a level of significance of .05 and use information from the scenario to determine the expected frequencies for each category)

During the analysis of the district data, it was determined that one high school had substantially higher Graduate Exit Exam scores than the state average and the averages of high schools in the surrounding districts. To better understand possible reasons for this difference, the superintendent conducted several analyses. One analysis examined the population of students who completed the exam. Specifically, the superintendent wanted to know if the distribution of special education, regular education, and gifted/talented test takers from the local high school differed from the statewide distribution. The obtained data are provided below.

*For purposes of testing, special education includes any student who received accommodations during the exam.
1. If the student distribution for the local high school did not differ from the state, what would be the expected percentage of students in each category?
2. What were the actual percentages of local high school students in each category? (Report final answer to two decimal places)
3. State an appropriate null hypothesis for this analysis.
4. What is the value of the chi-square statistic?
5. What are the reported degrees of freedom?
6. What is the reported level of significance?
7. Based on the results of the one-sample chi-square test, was the population of test taking students at the local high school statistically significantly different from the statewide population?
8. Present the results as they might appear in an article. This must include a table and narrative statement that reports and interprets the results of the analysis.
Note: The table must be created using your word processing program. Tables that are copied and pasted from SPSS are not acceptable.

Arthur: “George, come into my office for a few minutes. You know that the company brass want to increase the amount of automation in some of our factories. I just got word that this plant will be the first to be automated.”

George: “But the cost and accounting analyses we sent to headquarters last fall showed that it wouldn’t be profitable to make changes like that in this plant. Why did they pick this one?” Arthur: “Apparently, top management wants to try robots and all the high-tech gadgets at one factory, to see if they increase product quality and pay for themselves. They think that in the long run, stockholders will benefit from automation. Anyway, the decision has been made, and it’s our job to make it work. We’re going to have to sell the work force and the community on the decision.”

George: “That won’t be easy. Hundreds of people are going to lose their jobs. There isn’t much else that they can do around here, either.”

Arthur: “Some of the factory people will be able to stay on, if they get some additional training. We can convince the workers and the people in town that the decision was necessary, if we can show them accounting and cost information to justify the decision. If they see good, sound reasoning for the action, they’ll be less likely to resist and cause trouble. We need for them to maintain productivity and efficiency until the new equipment is here. I want you to work on a cost summary we can release to the employees and the town newspaper, showing why automation is a good idea.”

George: “But the net present value and other analyses I did earlier showed this plant should stay the way it is.”

Arthur. “When we were working on the analyses, you said yourself that the benefits of automation are hard to identify and assign numbers to. You had to make several assumptions in order to do those analyses. If you change some of your assumptions, you can make the numbers look better. Try a longer useful life for the new equipment, or change some of the projected cost information. As soon as you have the new numbers, bring them to me to look at.”

Do you agree with the decision of case participants and their opinions? Comment it and make your own recommendations

Read the article below then answer the question that follows.

PHILADELPHIA (WTXF) - The controversial Philadelphia soda tax has started. Sunday, the city began imposing a 1.5 cent per ounce tax on the supply of sweetened beverages to retail dealers, which is supposed to go towards quality pre-K, Community Schools, and better parks, libraries and rec centers.

Among the items taxed: regular and diet sodas, and also teas. The tax is also levied on syrups and concentrates used to make sweetened drinks. And drinks considered “zero calorie” are also taxed.

The tax will be paid by distributors of sweetened beverages, but certainly passed on to customers.

According to the city, a distributor is any person who sells sweetened beverages to a dealer, and a dealer is any person who sells sweetened beverages at retail. Dealers include delis, restaurants, and grocery stores.

For them, the tax will be due the 20th of each month for the prior month. That means the first payment will be due February 20, 2017, for distribution activity in January 2017.

The 1.5-cent-per-ounce tax amounts to 18 cents on a 12-ounce can of soda or $1.44 on a six-pack of 16-ounce bottles. Two cities have soda or soft drink taxes but more than 30 cities and states have rejected them.

On Dec. 19, Common Pleas Court Judge Gary S. Glazer rejected the lawsuit challenging it filed by the American Beverage Association and others.

Lawyers for the beverage industry tried to block the tax, arguing it duplicates the state sales tax already imposed on soda and unfairly taxes drinks based on their size, not price.

But Shanin Specter, of Kline & Specter, PC, representing the plaintiffs in the beverage industry's lawsuit against the city, issued this three-word statement: "We shall appeal."

Suppose that someone has said: “Because the tax is paid by distributors, they will be 18c worse off for each can of soda they sell. That is why they are appealing the tax. Nobody else will be negatively impacted, because after all the distributers are the only ones who pay the tax.”

Explain what is wrong with this person’s statement.

Tax correctly depicted on Demand and Supply model, Diagram/s explained and used to support explanation, Discussion of which parties are impacted by the tax

1. Consider an economy with no international trade, no government spending and no taxes, whose consumption function and investment function are given by the following equations: C = 100,000 + .92Y I = 40,000

a. What is the equilibrium level of aggregate output for this economy?

b. What is the saving function for this economy?

c. Check the solution, as we did in class, by showing that at the equilibrium level of Y total spending exactly matches the level of output. At the equilibrium level of Y, what is the level of saving in the economy?

d. Sketch the solution in a graph. [BTW: PowerPoint has a very useful drawing program that will help you get good-looking diagrams; it is a good thing to know how to use. Go here for a basic tutorial: https://www.youtube.com/watch?v=M5X_zvh2j9Y. After constructing the diagram in PowerPoint you can cut & paste it into a Microsoft Word document.]

e. What is the Keynesian multiplier for this economy (see textbook, chapter 3)? If I increases by $2,000, what will be the new equilibrium level of Y?

2. Now let’s add Government Spending into the model. Government spending is a component of Aggregate Demand, just as Consumption Spending and Investment Spending. For now, let’s not worry about taxes; we can assume the government borrows to pay for all of its spending.

Consider a closed economy with no taxes, whose consumption function, investment level & government spending level are given by the following equations:

C = 5,000 + .80Y I = 9,000 G = 2000 where G represents government spending. The equilibrium condition is, as always, that the value of the economy’s output (Y) must be matched by aggregate demand, but now aggregate demand contains a third element, G. So the equilibrium condition from which we’ll start is now: Y = C + I + G.

a. What is the equilibrium level of aggregate output for this economy?

b. What is the saving function for this economy?

c. Check the solution, as we did in class, by showing that at the equilibrium level of Y total spending exactly matches the level of output. At the equilibrium level of Y, what is the level of saving in the economy?

d. Sketch the solution in a graph.

e. What is the Keynesian multiplier for this economy? If G decreases by $100, what will be the new equilibrium level of Y?

Read the article below then answer the question that follows.

The controversial Philadelphia soda tax has started. Sunday, the city began imposing a 1.5 cent per ounce tax on the supply of sweetened beverages to retail dealers, which is supposed to go towards quality preK, Community Schools, and better parks, libraries and rec centers. Among the items taxed: regular and diet sodas, and also teas. The tax is also levied on syrups and concentrates used to make sweetened drinks. And drinks considered “zero calorie” are also taxed. The tax will be paid by distributors of sweetened beverages, but certainly passed on to customers. According to the city, a distributor is any person who sells sweetened beverages to a dealer, and a dealer is any person who sells sweetened beverages at retail. Dealers include delis, restaurants, and grocery stores. For them, the tax will be due the 20th of each month for the prior month. That means the first payment will be due February 20, 2017, for distribution activity in January 2017. The 1.5-cent-per-ounce tax amounts to 18 cents on a 12-ounce can of soda or $1.44 on a six-pack of 16-ounce bottles. Two cities have soda or soft drink taxes but more than 30 cities and states have rejected them. On Dec. 19, Common Pleas Court Judge Gary S. Glazer rejected the lawsuit challenging it filed by the American Beverage Association and others. Lawyers for the beverage industry tried to block the tax, arguing it duplicates the state sales tax already imposed on soda and unfairly taxes drinks based on their size, not price. But Shanin Specter, of Kline & Specter, PC, representing the plaintiffs in the beverage industry's lawsuit against the city, issued this three-word statement: "We shall appeal."

Suppose that someone has said: “Because the tax is paid by distributors, they will be 18c worse off for each can of soda they sell. That is why they are appealing the tax. Nobody else will be negatively impacted, because after all the distributers are the only ones who pay the tax.” Explain what is wrong with this person’s statement.

Criteria:

-Tax correctly depicted on Demand and Supply model

-Diagram/s explained and used to support explanation

-Discussion of which parties are impacted by the tax

Case Study, Chapter 10, Principles and Practices of Rehabilitation

1. Mrs. Adams, 72 years of age, is admitted to the rehab unit with the diagnosis of stroke. The stroke affected the limbic area in the brain, which has caused the patient to have emotional labiality (her mood changes rapidly because she misinterprets situations). As a result of the emotional labiality, she sometimes refuses to be repositioned or to participate in physical or occupational therapy. She sometimes also refuses to eat and drink. The patient’s right side is paralyzed and flaccid. She has no feeling on her right side. She has reddened areas on her coccyx and both heels at least 1 cm in diameter that do not go away with repositioning. She is incontinent of urine and stool. She has problems with communication called global aphasia (difficulties understanding speech and the written word and difficulties with speaking and writing). She is 5 feet tall and weighs 178 pounds. She has a tendency to develop skin tears because her skin is thin, and she has several bandages on her arms. The family states they are concerned because the staff on the previous medical-surgical unit would drag their mother up in bed when she slid down. The staff would chart when their mother refused to be repositioned and then would not reposition her for hours. (Learning Objectives 2 and 4)

Explain the pathophysiology of the risk factors that predispose Mrs. Adams to developing pressure ulcers?

What nursing measures need to be instituted for Mrs. Adams based on the information presented in the case study?

2. You are assigned to care for David Ramsey, a 22-year-old male patient who sustained a back injury secondary to being thrown from a motorcycle. He did not damage the spinal cord, but the computed tomography revealed a compression fracture at L-2 (lumbar area). David complains of severe lower back pain with numbness and tingling in the lower extremities. You identify the following nursing diagnosis: Impaired Physical Mobility.

(Learning Objective 4)

What assessments are indicated based on this nursing diagnosis?

List other major nursing diagnoses based on David’s clinical presentation.

1. The correct mathematical models for the first four seconds of the motion map below are: ( can have multiple answers)

http://tinypic.com/view.php?pic=20u4v4o&s=8#.U62fWF6aL1o << graph that goes to the question

A) x(m)=1/2(-10m/s^2)t^2(s^2)+(10m/s)t(s), 0 < t <3s

B) v(m/s)=(-10m/s^2)t(s)+(20m/s), 0 < t <3s

C) x(m)=(-10m/s) delta t(s) +5m ,3 < t <4s

D) v^2(m^2/s^2) = 2(-10m/s^2) delta x(m) +(400m^2/s^2), 0 < t <3s

2. Examine the velocity versus time graph below. Select the mathematical models that COULD describe the graph from the choices below. COULD is the operative word - is there any information about the starting point in the velocity versus time graph? (could have muliple answers)

http://tinypic.com/view.php?pic=2j3jipi&s=8#.U62g3F6aL1o <<imagae of graph

A) x(m)=1/2(+4m/s/s)t^2(s^2)-(10m/s)t(s)+5m

B) v(m/s)=(+4m/s/s)t(s)+(-10m/s)

C) delta x(m)=1/2(v(m/s)-10m/s)t(s)

D) v^2(m/s)^2=2(4m/s/s) delta x(m)+100(m/s)^2

3. A mountain goat starts a rock-slide and the rocks crash down the slope 196 m. Down hill is the positive x direction. If the rocks reach the bottom in 3 s, what is the acceleration of the rock-slide? Please remember to include units but do NOT use "^" for "raise to the power". Use ratios only.

4.NBA player Michael Jordan had one of the longest hang times in the league, about 0.92s. In general if a person has a hang time of 0.93 how high do they jump? Please use 9.81m/s/s to solve this problem.