1. The student researched the legal statues affecting the selection and hiring of employees.
2. The student identified the number and type of positions that need to be filled at the new office. Moreover, the student discussed qualifications, e.g., education level and number of years of experience, associated with each position.
3. The student researched, evaluated and chose several selection devices such as interviews or ability tests to reject or accept applicants. Moreover, the student assessed the weaknesses and strengths of these selection devices.
4. The student researched, evaluated and chose whether or not to utilize integrity testing and drug testing.
5. The student applied correct APA, style, usage, grammar, and punctuation.
6. The student supported the research paper with at least four different scholarly sources such as research journals, research studies, government or accredited educational institutions websites.

Immune Responses

Abnormal immune responses can trigger a range of autoimmune diseases, in which an individual’s immune system is attacking normal tissues in the body. Well-known examples of autoimmune diseases are type 1 diabetes mellitus, lupus, and multiple sclerosis.

Ideally, one would like to harness the immune system to attack abnormal substances or tissues like cancer, while sparing the normal (unaffected) tissue. Many tumor cells produce antigens (proteins) that theoretically ought to trigger an immune response: that is, one’s immune system ought to recognize cancer cells as somehow foreign or abnormal, and thereafter eliminate these cells from the body. The field of cancer immunotherapy is actively pursuing this study.

Tumor antigens may also be useful for diagnostic tests; high levels of tumor antigens could be taken as markers or indicators of cancer. In this assignment, you will be examining levels of tumor-associated antigens (TAAs) as determined from immunoassays (i.e., biochemical tests that measure the concentrations of the tumor-associated antigens in serum samples).

• Download the Excel file MHA610_assignment_3_data.xls, and open it.
• The spreadsheet contains data on 250 individuals: 90 normal individuals from San Diego (the controls), and 160 individuals from Korea and China, all of whom were diagnosed with hepatocellular carcinoma (HCC).
  • Serum samples were taken from the controls and from the cases at time of diagnosis of HCC. Levels of a panel of 12 tumor-associated antigens (TAAs) were assessed via immunoassays in all individuals;
    • The levels are given in the columns with headings Ab14, HCC1, IMP1, KOC, MDM2, NPM1, P16, P53, P90, RaIA, and Survivin. (These are the designations of the 12 TAAs, all of which were thought to be potentially predictive of cancer.)
• The underlying question is whether we can effectively discriminate between the cases and controls on the basis of the levels of these TAAs. This is sometimes termed a classification problem in the statistics and biostatistics literature: we wish to classify individuals as normal or cancer patients on the basis of their TAA levels.
• We will examine these data in Statdisk. Use the MHA610_Week 3_Assignment_Data.CSV file to upload this information into Statdisk.
  • If you choose the latter option, Start Statdisk, then choose File>Open and select the .csv file you created (unless you changed the name, it ought to be MHA610_assignment_3_data.csv)
  • Check the box that specifies the data contains column titles or headers, select Comma separated for how the data are delimited, click finish, and the dataset will have been successfully imported into Statdisk.
  • NOTE: you may want to read through the remainder of the assignment first, before proceeding with this step. This may save you some work afterwards!
• Note that Statdisk operates on columns of data, and that both cases and controls are contained in each column of TAA levels. It will be necessary to separate the cases and controls for further analyses. This can be accomplished either by copying within Statdisk or by reverting to the original Excel workbook, copying in Excel, exporting as a .csv file, and then importing into Statdisk. (Don’t say you weren’t warned!)
• Explain if you would characterize any or all of the TAA levels as approximately normally distributed for the controls and for the cases.
  • Provide plots and statistics in support of your conclusions.
• Explain if any of the TAAs are useful for discriminating between the cases and controls.
  • Provide plots and statistics in support of your conclusions.
• All writing assignments should be at least 250-500 words in APA format supported by scholarly sources.

BONUS. In the above, we pooled all cases together.  Summarize whether you think this is legitimate or whether the levels of any of the TAAs appear to differ significantly between the cases from China and the cases from Korea. Provide evidence in support of your conclusion.

Consider the following scenario:

As supervisor for a retail company, you supervise six people in your location. You are responsible for their payroll and commissions each week. This task would normally take a couple of hours on paper, but you now have the expertise needed to automate the process by using formulas and functions in an Excel spreadsheet.

Use the data provided to create a worksheet described below:

You must create a workbook with separate sheets for each week that would allow sales managers to compare sales figures and commissions from one week to the next. Each worksheet should calculate the payroll amount for each of your six employees. If sales are below $1,000, then the commission paid is 5% of the sales. If sales are between $1,000 and $3,999.99, the commission paid is 10% of the sales. If sales are $4,000 or higher, the sales person receives a 12.5% commission rate.

Sales people will be paid either their commission or hourly pay earned amount—whichever is higher. Hourly employees receive 150% of their hourly rate for any hours worked over 40 hours per week (time and a half for overtime worked).

Each worksheet should contain the following headings:

• Employee
• Sales
• Hours Worked
• Hourly Pay
• Commission Earned
• Hourly Pay Earned
• Payroll Amount

To complete this workbook, you must write specific formulas and functions. The Commission Earned, Hourly Pay Earned (for the two hourly employees), and Payroll Amount columns require you to use IF functions. Remember, the payroll amount for salespeople will be either the commission earned or hourly pay earned—whichever is greater. Do not calculate commission earned for hourly employees or overtime for sales employees (this is anyone who has a sales figure in the Sales column).

Remember to format your worksheets, rename and change color on the tabs, and submit your workbook to your instructor using the following naming convention: LastnameFirstnameIP5.xls.

I will Pay $2.00 down with an Additional $12.00 Upon Completion. You MUST Follow All Instructions to a Tee!