Create a pivot table for all customers and their volume

Assignment Help Data Structure & Algorithms

Reference no: EM133391719

Question 1. Use this 2020 Hospital Data 4, and for the highest volume customer, and the 3rd highest volume customer:
• calculate the mean, median, mode, range
• perform a t-test (be sure to identify the alternative and null hypotheses) that the means are different

Question 2. Perform an ABC analysis on these data and also create a pivot table for all customers and their volume

Question 3. For the top volume customer, calculate the EOQ for the top 3 items (use 20% holding cost, and $87.50 ordering cost. assume the annual demand is the total demand for 2020).

Question 4. Create a regression, with demand as the dependent variable, and choose your own independent variables (be sure that you justify their inclusion into the model)

Attachment:- HospitalData.rar

Reference no: EM133391719

Questions Cloud

Facilitator in the school convenes process : A facilitator in the school convenes a process among the boys, the teacher, and key school staff to discuss how to repair the harm."

Discuss five facts described in the film that resonated : Briefly describe what the video is about. Identify people, places, events, or aspects of society, or nature that are the focus of this video.

Comment critically on the portrayal of gender : Comment critically on the portrayal of gender in one or two regular or occasional characters on the series.

What evidence do authors gerstel and sarkisian give : What evidence do authors Gerstel and Sarkisian give that social class is even more important than ethnicity in understanding differences among families?

Create a pivot table for all customers and their volume : Create a regression, with demand as the dependent variable, and choose your own independent variables (be sure that you justify their inclusion into the model)

Assume stock trades : Assume a stock trades at $98, the volatility of the stock is 29%, and the risk-free interest rate is 3.5%.

How did the organization past reputation influence public : How did the organization's past reputation influence the public's perception of the situation, and how it was punished by the league.

What about the post did you like or find interesting : How did the Post help to clarify or expand your understanding of the text? Did it encourage you to think differently, spark questions, or offer you direction

Demonstrate how racial classifications are arbitrary : Discuss how the Hudgins v. Wright and Ozawa v. United States court cases demonstrate how racial classifications are arbitrary.

User Account

All Pages