Read Lecture 3. React to the material in this lecture. What is unclear about setting up and using Excel for these statistical techniques? Looking at the data, develop a test for mean differences between the genders on a variable other than compa-ratio or salary you feel might be important in answering our equal pay for equal work question. Interpret your results. 

You have been hired in the finance department at a large, metropolitan, for-profit hospital. Your duties are very important to the entire hospital in terms of financing operating costs. Additionally, you are also in charge of 3 employees who work under you to help with the day-to-day accounting activities. Your role includes budgeting, managing the general ledger accounts, utilizing financial formulas to perform accounting activities, and training and development of your 3 employees. This professional career is exciting and challenging for you but is also enjoyable and rewarding as you work your way up the career ladder toward reaching your goal of becoming the Chief Executive Officer (CEO) of the hospital. 

Due to scarce resources, your organization is faced with the decision of choosing between mutually exclusive projects (i.e., build a rehab center or build a neonatal wing). You have been asked to develop a financial analysis of the two projects based on Net Present Value (NPV), Return on Investment (ROI), and Profitability Index (PI). Briefly explain the following concepts and their use/value in assessing the validity of the two mutually exclusive projects:

• NPV 
• ROI 
• PI 
• Payer (or case) mix 

Submitting your assignment in APA format means, at a minimum, you will need the following:

• Title page: Remember the running head and title in all capital letters. 
• Abstract: This is a summary of your paper, not an introduction. Begin writing in third-person voice. 
• Body: The body of your paper begins on the page following the title page and abstract page, and it must be double-spaced between paragraphs. The typeface should be 12-pt. Times Roman or 12-pt. Courier in regular black type. Do not use color, bold type, or italics except as required for APA level headings and references. The deliverable length of the body of your paper for this assignment is 35 pages. In-text academic citations to support your decisions and analysis are required. A variety of academic sources is encouraged. 
• Reference page: References that align with your in-text academic sources are listed on the final page of your paper. The references must be in APA format using appropriate spacing, hang indention, italics, and upper- and lower-case usage as appropriate for the type of resource used. Remember, the reference page is not a bibliography, but it is a further listing of the abbreviated in-text citations used in the paper. Every referenced item must have a corresponding in-text citation