Cost estimation: High-low method and Least Squares (10 Marks)

  • Explain how a scattergraph is used to separate a mixed cost into its fixed and variable components.

(2 Mark)

Month Number of Patients Admitted Admitting Department Costs
May………………………………. 1,800 $14,700
June………………………………. 1,900 $15,200
July……………………………….. 1,700 $13,700
August……………………………. 1,600 $14,000
September………………………… 1,500 $14,300
October…………………………… 1,300 $13,100
November………………………… 1,100 $12,800
December………………………… 1,500 $14,600
  • The administrator of Aztec Hills Hospital would like a cost formula linking the administrative costs involved in admitting patients to the number of patients admitted during a month. The Admitting  Department’s cost and the number of patients admitted during the immediately preceding eight months  are given in the following table:

Required: 

  1. Use the high-low method to estimate the fixed and variable components of admitting costs. (2 Marks)
  1. Express the fixed and variable components of admitting costs as a cost formula in the form Y = a + bX (1 Mark)
  • Given a choice between a high-low method, a scattergraph or regression analysis, which method would you prefer to separating a mixed cost into its fixed and variable components? Why? (2 Marks)
  • Explain the concept of the relevant range. Howe does a company’s relevant range differ from the steps found in a step cost?

(2 Marks)

BRAIN SIZE AND INTELLIGENCE

Does a bigger brain make you smarter? . An Introduction (< 1 page) containing background information and the goal of the report. Find the information online and elsewhere and write a brief summary of the study and what the variables and data are about, so as to give some context to your report. (5 Marks; -1/2 SPSS ref; emphasize variable explanation) ii. An Analysis section containing all observations and of the analysis required in the report, and any that helps to support the goal of the report. This section should only contain statistical analysis, and no interpretation. Include subsections (Summary/Descriptive Statistics, Graphic Methods, Linear/Regression Analysis, and Hypothesis Testing, Population Estimation). a. Perform any appropriate descriptive statistics and graphical methods. Use graph styles presented in class and labs to produce graphs and look at the distribution of PIQ and MRI c unt before and after splitting genders. Can you see any connection with and without gender as a factor? Are there any trends or patterns? Can you see anything worth questioning or studying about the data? Summarize the basic statistics in terms of location and dispersion, and distribution of PIQ and MRI Count and also compare the differences between males and females in both . b. If appropriate, plot scatterplot or diagram and draw a regression line and compute its equation. Interpret any correlation and compute correlation coefficient and coefficient of determination relating the variables of interest. Can we make any predictions? Perform a linear regression to predict PIQ scores based on the MRI Count (brain size). Is there a significant relationship? Is there a significant relationship within each gender? Is brain size a good predictor of IQ in general and/or within each gender? (10 Marks; emphasize the importance of p-value testing) c. Include any hypothesis testing and population/variance estimation here as well. According to the Flynn Effect, IQ should rise over time (TED VIDEO – Why Our IQ Levels Are Higher than Our Grandparents). Since this study was in 1991 we would expect the mean IQ to be above the baseline 100. At the 5% level are the PIQ scores significantly above the 100 point baseline? (i.e., test value of 100, one-sided). Include all steps of the hypothesis testing process. Estimate an interval for the mean PIQ at the 95% confidence level, for each gender. Since the study was conducted in 1991, and according to the Flynn Effect the IQ should rise 3 points per decade (THE FLYNN EFFECT (Scientific American) does this interval help to confirm this? Include the intervals with proper interpretations as well. Test =118.3 and compare male vs. female for IQ. Also compare MRI for gender. (20 Marks: see below for breakdown) iii. Results, summarizing and giving context to the analysis. Interpretation and explanation of the results. (5 Marks) iv. Discussion and Conclusion(s), stating important or novel findings, comparison to other data available in the literature, and stating any future directions for further studies. Here you should write a short report (< 1 page) to summarize all your findings and conclusively answer whether there is a difference in IQ between males and females, and whether you can predict IQ by knowing the size of someone’s brain. (Find the mean PIQ value for this sample by SPSS. What is the point estimate for the mean PIQ value of the population? (1 Mark) (2) Construct a 95% confidence level for the population mean by SPSS. Interpret the meaning of the interval in your own words. Based on the interval is it likely the PIQ average is associated with a larger brain size based on MRI values? (5 Marks) (3) Construct an 80% confidence level for the population mean by SPSS. (3 Marks) (4) How does the 80% confidence interval compare to the 95% interval? (1 Marks) (5) Perform a Hypothesis Test a. State the null and alternative hypotheses. (2 Marks) b. Perform One-Sample or Two-Sample Test by SPSS and state significance or p-value. (2 Marks) c. Write your conclusion. (4 Marks) i. Do these data allow us to infer at the 5% significance level that IQ (intelligence) is related to brain size? ii. Is it significantly more than the baseline 100? The population =118.3?   iii. Why does the 95% Confidence interval, and 5% test not give the same answer always?

COVER THE GENETIC, TISSUE, CELLULAR, MOLECULAR AND BIOCHEMICAL ASPECTS OF THE DISORDER

The lecture series will cover the scientific knowledge relating to function and dysfunction in several areas.  These can be summarised as follows   Term one Cardiovascular and Respiratory system Musculoskeletal system Gastrointestinal tract Central nervous system   Term two Atherosclerosis Tumour biology Renal Sepsis Immune system   Table 1.  Topics covered in term one and two lectures   For the this assessment you must individually produce four short essays (two lecture topics from term one and two lecture topics from term two) detailing the scientific knowledge relating to altered health states relevant to the lectures in Table 1.   You are free to choose which areas and disorders to cover from the lectures but you must cover two relevant to term one and a further two relating to term two.    Answers should cover the genetic, tissue, cellular, molecular and biochemical aspects of the disorder and should also touch upon diagnostic and treatment options where applicable.      Reviews should use prose and annotated figures with appropriate legends can be used to aid clarity. Max word count per review topic 750 words excluding references, figures, tables and short legends (i.e. 1500 words per submission). Figures should be hand drawn rather than lifted directly from sources as this shows a greater understanding of the topic.  All references should be cited in Harvard format (please see your notes from last year and the student handbook for details of the Harvard system).  Marks will be deducted for reviews that exceed the word limit and the total word count should be detailed at the end of each review.     Coursework will be marked using the following school’s generic marking criteria.  Content (40%), understanding (20%), use of literature (10%) and general communication skills (30%

SCIENTIFIC POSTER IN HEPATITIS C

Your poster should report the latest research findings for a particular pathogen in one key aspect, namely, diagnostics, virulence factors, treatments or vaccine development, with an immunological or microbiological overview (or both). As the content of the poster is not your own research, it is a review poster and it is not expected to have major sections on material and methods. Your poster should contain something like the following:-   Title   …………..which appropriately describes what the poster is about for a named pathogen.   Introduction   …… which gives general/ background information about the pathogen and the disease(s) it causes. The introduction should be no more than 10-20% of the poster’s content.   The rest of the poster ……….. should deal with the particular aspect chosen for the named pathogen reporting in general terms any methods used, plus the results , and  discussion on the topic.   Conclusion ………. sums up the work and makes a critical statement about the validity of the work and it’s possible benefits.   Reference List …….records the references you have cited in your poster.

Juvenile Justice

Each 5 BULLETPOINTS MUST BE ADDRESSED WITH HEADER. PLAGIARISM WILL REQUIRE A TOTAL REFUND, AND IF PAPER IS NOT APA FORMAT.
 
Write a 1,050- to 1,400-word paper summarizing the key parameters of the juvenile justice system in the United States. Address the following:

  • The historical development of the juvenile justice system. Use case law or legislation to strengthen your discussion. Select a local law or statute in your area and analyze its use.
  • The origin and predominant philosophy of the juvenile system
  • Key differences between the juvenile and adult systems
  • Distinguish between dependency and delinquency
  • The reasoning behind and the importance of confidentiality in juvenile court

Format your presentation consistent with APA guidelines.

business management

International Opportunities” Please respond to the following:

 
 
Cooperative Strategy” Please respond to the following:

  • From an ethical perspective, determine how much information a firm is obliged to tell a potential strategic alliance partner about what it expects to learn from the cooperative arrangement. Explain your rationale.
  • From the e-Activity, determine which type of cooperative strategy would most benefit the two companies you researched. Provide specific examples to support your response.(research two U.S.-based companies you believe would mutually benefit from working together in some way. )

"Concurrency Control"

data dictionary

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.
Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following:

  • Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID)
  • Invoice (InvNumber, InvDate, EmpNumber,  InvAmount, CustomerID)
  • InvoiceLine (InvLineNumber, InvNumber,  ProductNumber, Quantity)
  • Product (ProductNumber, ProductDescription, ProductCost)
  • Department (DepartmentID, DepartmentDescription)
  • Job (JobID, JobDescription)
  • Customer (CustomerID, CustomerName, CustomerAddress, CustomerPhone)

Write a three to four (3-4) page paper in which you:

  1. Create a data dictionary that includes the following:
    1. A description of the content for each field
    2. The data type of each field
    3. The format the data will be stored as in the field
    4. The range of value for the field
    5. A label, as required, if the attribute is a primary key or foreign key

Note: An example is shown in Table 7.3 in chapter 7 of the textbook.

  1. Imagine that you are asked to identify the number of days that exist between the first invoice and last invoice for each month and complete the following:
    1. Construct a query that will show the number of days that exist between the first invoice and last invoice, for each month, for each employee, using the DATEDIFF function. Be sure to provide the SQL script that will carry out this function.
    2. Construct a query to show the expected payment date if invoices are due within 30 days of transaction.
    3. Construct a query that will show distinct area codes of the customers.
  2. Create a plan of the necessary activities that would be required to implement a valid database design process by including the following:
    1. Steps in the conceptual design stage
    2. Steps in DBMS selection stage
    3. Steps in logical design stage
    4. Steps in physical design stage
    5. Task details of each activity within each stage

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

  • Design a relational database so that it is at least in 3NF.
  • Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
  • Explain the key principles of data security and identify data security risk and violations in data management system design.
  • Use technology and information resources to research issues in the strategic implications and management of database systems.
  • Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.