Monthly Archives: October, 2016

Portfolio Management


Portfolio Management

1 Faculty of Business and Law 2016 – 2017

Module No: 352FIN MODULE TITLE: Portfolio Management

Coursework [Contributes 25% to total module mark]

Complete the following task individually using a report format. You should not use more than 2500 words. Using at least two shares from FTSE 100 components, create an investment portfolio for a risk-averse investor, and another portfolio for an investor with relatively high risk tolerance. Outline in a report the choice you made in creating these portfolios, and discuss the underlying portfolio theory. Compare and contrast the two portfolios in terms of return and risk. Choose appropriate portfolio performance measures to evaluate the two portfolios. You may assume that all investors and investments are based in the UK. You are required to use the year January 2015 – December 2015 for your daily data. Submission by 23.55 on date: 05/12/16 This assignment must be submitted, with a coursework cover sheet, to Turnitin via the module web (CUOnline, following the link provided there) by 23.55 on 5th December 2016. Students MUST keep copies (electronic file also) of their assignment. The electronic version of your assignment may be used to enable checks to be made using anti-plagiarism software and approved plagiarism checking websites. Word Length (2500 words at maximum). Any penalties for not complying with word limits will be in accordance with University and Faculty policy. Word count should be shown on the cover sheet. The tables, graphs, and reference will not be part of the word count. Assessment Criteria The marking criteria are indicative to the elements that one might wish to address in your report.1) Selection of assets & portfolio allocation must be clearly stated and justified. 2) Modern portfolio theory and relevant concepts should be applied, discussed and explained. 3) Explanation of the criteria used to make such a set of choices should be clearly discussed and their limitations considered. 4) Any limitations of the approach you have used to create your portfolio should be considered. Marks will be given for clear explanations of each step and element of your decisions in your report. Justification for each assumption and decision is encouraged. The calculations or spreadsheet should be appended to the back of the document. This does not count in the word count. You should look to demonstrate your understanding of the concept of portfolio construction, risk aversion and associated concepts along with the limitations of such an approach. Return of Marked Work Marked work available on Turnitin. You can expect to have marked work returned to you within 2 weeks after the submission date. 2 PLAGIARISM WARNING! – Assignments should not be copied in part or in whole from any other source, except for any marked up quotations, that clearly distinguish what has been quoted from your own work. All references used must be given, and the specific page number used should also be given for any direct quotations, which should be in inverted commas. Students found copying from the internet or other sources directly will get zero marks and may be excluded from the university. Note: Please make sure that your ID number and the module number appear on the actual coursework assignment as well as on the cover sheet that you attach to it. For large modules with multiple seminars, your Seminar Group or Tutor’s name must be clearly shown, to ensure that your assignment goes to the correct person for marking. (Put the class day and time if you cannot remember tutor’s name).

Purchase Assignment-Quantitative Methods for Decision Making


Purchase Assignment-Quantitative Methods for Decision Making

Department of Management and Marketing

Quantitative Methods for Decision Making

 

Project 1

 

 

Word report (the hand writing reports will not be accepted) that includes the following three parts:

 

Question 1:                                                                                                                                                       

An investment company has classified its clients according to their gender and the composition of their investment portfolio (bonds, stocks, or a diversified mix of bonds and stocks). The proportions of clients falling into the various categories are shown in the following table:

 

Gender

Portfolio composition
B (Bonds) S (Stocks) D (Diversified)
M (Male) 0.18 0.20 0.25
F (Female) 0.12 0.10 0.15

 

  1. What is the probability that a randomly selected client is male and has a diversified portfolio?
  2. Find the probability that a randomly selected client is male, given that the client has a diversified portfolio?
  3. Find the probability that a randomly selected client is Female, given that the client has a portfolio is composed of Bonds?
  4. Let us define the following two events:

E1: the investor is a male

E2: the portfolio is composed of Stocks.

Can we conclude that the events E1 and E2 are independent?

 

Question 2:                                                                                                                                                         

In a hotel chain, the average number of rooms rented daily during each month is 50 rooms. The population of rooms rented daily is assumed to be normally distributed with a standard deviation of 4 rooms. For a specific month of the year, what is the probability that the number of rented rooms, in that month, is between 45 and 60 rooms?

 

Question 3:                                                                                                                                                       

The University registrar office has got some data regarding a sample of 200 students among those enrolled in the MBA Program. The registrar notes that 50 students of the sample are holders of a bachelor degree in business administration. What is the probability that among this sample 20 students hold a bachelor in business administration?

Purchase Assignment-Quantitative Methods for Decision Making

Purchase Answers-Principles of Macroeconomics.


Purchase Answers-Principles of Macroeconomics.

Principles of Macroeconomics. DATA EXERCISE #2 INSTRUCTION

 

DUE DATE;

DATA EXERCISE #2

Format of the Project:

The Data Exercise Attachments are limited to a maximum two files in doc, docx., xls. xlsx., or rtf. formats. OTHER FORMATS ARE NOT ACCEPTABLE.

Please note that hand-written and scanned works, pdf. files, jpg. files, as well as files posted in google drive, will not be accepted .

The paper should be written in APA style Research Paper format.

Please note that Use of APA Citation Methodology is required for all parts of the assignment

 

Data exercise #2 Consists of three parts

 

Part 1: The Unemployment Rate (weight 30% of the assignment grade)

Complete the following exercise

Visit the Bureau of Labor Statistics Web Site,

www.bls.gov/news.release/empsit.toc.htm . Select Employment Situation Summary.

Write a report (1-2 pages double – spaced) to answer the questions:

  1. What month (and year) is summarized? What was the unemployment rate for that month? How does that rate compare with the rate in the previous month?
  2. What were the unemployment rates for adult women, teenagers, blacks, Hispanics, and whites? How did these rates compare with those a month earlier?
  3. What factors make it difficult to determine the unemployment rate?
  4. Why is unemployment an economic problem?
  5. What are the non-economic effects of unemployment?
  6. Who loses from unemployment?

 

Part 2: The Inflation Rate (weight 30% of the assignment grade)

Complete the following exercise:

Visit the Bureau of Labor Statistics Web Site,

www.bls.gov/news.release/cpi.toc.htm . Select Consumer Price Index Summary.

Write a report (1-2 pages double – spaced) to answer the questions:

  1. What month (and year) is summarized? What was CPI-U for that month?
  2. What was the rate of inflation (percentage change in the CPI-U) for the month? How does that rate of inflation compare with the rate in the previous month?
  3. Which two categories of goods or services had the greatest price increase for the month?
  4. Which two categories of goods or services had the lowest price increase (or greatest price decrease) for the month?
  5. Who loses from inflation?
  6. Who benefits from inflation?

 

Part 3: Unemployment Data by Labor Force Groups and Duration (40% of the project grade)

Go to https://www.whitehouse.gov/administration/eop/cea/economic-report-of-the-President/2016

– the home page of the Economic Report of the President.

Scroll down and Click on the link download as pdf.

This link is located below Appendix B: Statistical Tables Relating to Income, Employment, and Production.

  1. Find unemployment data (Table B–12.—Civilian unemployment rate) for the following four years 1995, 2000, 2005, and the last available year. Use four labor force groups: males, and females, in each case 16 to 19 years of age, versus 20 years of age or over. Present the result in your project as a table.
  2. Use the Economic Report of the President (Table B–13.—Unemployment by duration and reason) to find data on the duration of unemployment in 1995, 2000, 2005, and the last available year. Present the result in your project as a table.

Write a report (1-2 pages double-spaced) about the results you received.

 In this paper consider, but do not be limited to the following:

  • Compare the distribution of unemployment by duration over these years. What relationship, if any, do you find?
  • Starting in the early 1990s many U.S. firms downsized their operations. In your opinion, how did this affect the duration of unemployment?
  • Demographic studies show that the proportion of teenagers and minorities in the U.S. population is likely to increase in the near future. In your opinion, what implications, if any, will this trend have on the unemployment rate?

 

 

WRITING GUIDELINE for the Data Exercise #2

 

DATA EXERCISE #2                                                   

Part 1: The Unemployment Rate.

Must be thorough in development and articulation in presenting and analyzing the data in the unemployment rate.

Part 2: The Inflation Rate.

Must be thorough in development and articulation in presenting and analyzing the data in for the inflation rate.

Part 3: Unemployment Data by Labor Force Groups and Duration. Must be very thorough in development and articulation in presenting and analyzing the data Unemployment Data by Labor Force Groups and Duration

 

Purchase Answers-Principles of Macroeconomics.

Need help;OH 45435 BME/ISE 3211 Human Biomechanics I


Need help;OH 45435 BME/ISE 3211 Human Biomechanics I

Department of Biomedical, Industrial, and Human Factors Engineering

Wright State University

• 3640 Colonel Glenn Hwy. • Dayton,

OH 45435 BME/ISE 3211 Human Biomechanics I

Course Project, Fall 2016 Due Date: 28 October 2016

Overview This document outlines the BME/ISE 3211 Human Biomechanics I Course Project in which biostatics analysis is used to design rehabilitation parameters for a patient with a torn distal biceps tendon. Each student will construct a free-body diagram of the human elbow/tendon system, perform static analysis of the system with an external load placed in the hand, calculate theoretical tendon tensions for a set of specified angles and loads, display data graphically, and design rehabilitation parameters within constraints set by an injury specialist. A formal report is to be submitted to a dropbox on Pilot with all relevant info and conclusions. Background You are a consulting biomedical/industrial engineer assisting an employer in a prominent regional manufacturing company. An employee has torn a distal biceps tendon and must undergo rehabilitation. An injury specialist has performed tests and advises that the injured tendon should not be subjected to forces exceeding 650 N during rehabilitation. The employee’s job requires routine handling of parts ranging from 3-6 kg. During manipulation of these parts, the employee must extend the arm with supinated palm and hold the forearm in a horizontal position such that the small angle between the long axis of the upper arm and the forearm ranges from 15°-75°. Your task is to perform biostatics analysis to determine if any of these loads causes tendon tension to exceed the value advised by the injury specialist. From this analysis, you will prepare a report for submission to the employer. Theoretical System Parameters for Biostatics Analysis Fig. 1 shows a pictorial diagram of the extended forearm holding a load in the supinated hand. Fig. 1: Pictorial diagram of the extended forearm handling a variable mass. Assume that the axis of rotation of the elbow is fixed at point O and the attachment point of the distal biceps tendon is located at point A, a = 5.7 cm from O. The mass of the entire forearm including hand is mB = 1.66 kg and its center of gravity is located at point B, b = 21.0 cm from O. Define the load in the hand as mC; its center of gravity is located at point C, c = 40.6 cm from O. Define FM as the biceps tendon tension. Assume that the line of action of FM is parallel to the long axis of the upper arm throughout the specified range of motion. Therefore, define θ as the angle FM makes with the forearm; i.e., with respect to horizontal. © 2016 J. Tritschler • Department of Biomedical, Industrial, and Human Factors Engineering Wright State University • 3640 Colonel Glenn Hwy. • Dayton, OH 45435 Report Guidelines and Grading Rubric 1) Prepare an electronically-generated free-body diagram of the system utilizing the parameters outlined above. You may use shapes in MS Word or the drawing program of your choice. Include all dimensional information and a coordinate system. (20%) 2) Derive an expression for the magnitude FM in terms of θ and mC. Hint: you only need one rotational equilibrium equation to do this. (20%) 3) Compute FM for each of seven masses placed in the hand [mC = 3.0, 3.5, 4.0, 4.5, 5.0, 5.5, and 6.0 kg] at each of seven angles of distal biceps tendon tension [θ = 15, 25, 35, 45, 55, 65, and 75°]. Prepare a table with these 49 values of distal biceps tendon tension, with θ placed along the x-axis (columns) and mC placed along the y-axis (rows). Label and caption this table. Highlight values that exceed the limit advised by the injury specialist in a suitable color. (20%) 4) Generate a graph with seven smoothed-line scatter plots (including data points) showing FM (y) vs. θ (x) for each of the seven masses using Excel or MatLab. Draw a heavy line on the graph in a suitable color indicating the tension limit advised by the specialist. Likewise, generate a similar graph showing FM (y) vs. mc (x) for each of the seven angles and a line indicating the advised tension limit. Label and caption both graphs. (20%) 5) Prepare a formal report in MS Word and submit a .docx file with the following sections: (20%) • Cover Page o name of the university and department o title of the report o submitted by: (your name) o submitted to: (Dr. Joe Tritschler) o date of submission • Introduction and Purpose o You may paraphrase the description of the problem in this assignment, but don’t simply copy and paste it. • Data and Results o Include all diagrams, derivations, equations, tables, and charts. • Discussion o Discuss the figures in the table and charts and address the following questions: What happens to the theoretical magnitude of distal biceps tendon tension as the arm becomes fully extended; i.e., θ approaches zero degrees? What does this suggest about the limitations of our analysis? • Conclusions and Recommendations o Should the injured employee undergo on-the-job rehabilitation? o Specify design parameters for a rehabilitation algorithm based on your computations. You may consult with a classmate regarding help with graphs or double-checking derivations, but all reports and corresponding work are individual for this assignment and will be checked by turnitin.com. Please upload your .docx file to the specified dropbox in Pilot no later than 5:00p.m. EST Friday 28 October 2016.

Need Help: Mid-term Exam; STATISTICS


Need Help: Mid-term Exam; STATISTICS

Make free inquiries at support@customwritings-us.com      

Answer all Questions (1 -5)                                                                                                   Total points 50

 

Q 1.  Identify the sample and population. Also, explain whether the sample is likely to be representative of the population.

  1. a) 5 students in a large university with more than 10,000 students were asked whether they exercise at least 30 minutes each day and only 2 said yes.

 

  1. b) 10,000 randomly selected adults in Massachusetts were asked whether they support the ballot question number 2 in the current election and 42% said yes while 58% said no.

 

 

Q 2.  A medical research team studied the ages of patients who had strokes caused by stress. The ages of 36 patients who suffered stress strokes were as follows.

29   39   36   41   45   50   57   61   28   50   36   38

50   38   36   47   40   35   58   36   61   40   55   42

61   56   45   44   62   36   38   40   45   27   59   31

Construct a frequency distribution for these ages. Use 6 classes beginning with a lower class limit of 25.

 

 

 

Q 3.  In a survey, 28 voters were asked their ages. The results are shown below. Construct a histogram to represent the data (with 5 classes beginning with a lower class limit of 19.5 and a class width of 10). What is the approximate age at the center?

53  56  38  53  67  65  52  48  37  51  40  61   62 53

66  45  41 35  39 32  43  61  43  69  31  48   59 56

 

 

 

           

Q 4.   Consumer Reports published an article that listed the returns earned by numerous stock funds in 2005. Total percentage returns for 11 of these funds are shown below, listed in no particular order, and rounded to the nearest whole number.

15        29        21        30        26        33        30        32        38      31      27

  1. Calculate the mean, median, and mode for the return data.
  2. Calculate the range, variance, and standard deviation.
  3. Calculate the z score for the return of 34.
  4. Assuming that the distribution of above data is symmetric, find the two limits around the mean where we will find 95% of the observations.
  5. Find the data at the 70th percentile
  6. Find the 5 number summary of the data.
  7. Draw and label the complete boxplot.

 

Q 5.    A company surveyed 100 of its employees at random regarding their age by gender and found the following result

 

AGE

< 35 years 35-44 years 45-54 years >54 years
GENDER

Male

11 15 22 10
Female 8 17 13 4

If an employee is selected at random find the probability that the selected employee is

  1. Female
  2. Is 35-44 year old.
  3. Is male and is 45-54 year old.
  4. Is male or is 45-54 year old

 

If two employees are selected at random what is the probability that both employees are females when the selection is made

  1. With replacement
  2. Without replacement

Make free inquiries at support@customwritings-us.com      

 

RES5115: RESEARCH PREPARATION: PRINCIPLES AND APPROACHES QUANTITATIVE ASSIGNMENT(SPSS)


RES5115: RESEARCH PREPARATION: PRINCIPLES AND APPROACHES QUANTITATIVE ASSIGNMENT(SPSS)
SCHOOL OF SCIENCE
_______________________________________________________________________________________________
RES5115: RESEARCH PREPARATION: PRINCIPLES AND APPROACHES
QUANTITATIVE ASSIGNMENT
DUE DATE: Friday 28th of October 2016 before midnight
For this assignment, you are expected to perform all analyses using either SPSS or Excel/Real Statistics. However prior to this, you will need to generate your own sub-sample (unique to your student ID) from a larger sample using the random number generator in Microsoft Excel. To do this, you must first activate the Analysis ToolPak in Excel by following steps below.
Step 1: Open a new Excel spreadsheet as shown below.
2
Step 2: Go to File → Options.
Step 3: Click on Add-ins and then click Go…
3
Step 4: Select Analysis ToolPak and click OK.
You can now use the Analysis ToolPak under the Data tab by clicking on Data Analysis.
Note that the above steps are for Microsoft Excel 2010 and may differ slightly if you are using the 2013 version.
4
QUESTION 1 [25 MARKS]
BACKGROUND
A study was conducted to investigate the effects of short-term treatments with growth hormone (GH) on biochemical markers of bone metabolism in men with idiopathic osteoporosis. Subjects ranged in age from 32 to 57 years. Among the data collected were serum concentrations of insulin-like growth factor binding protein-3 at 0 and 7 days after the first injection and 1, 4, 8 and 12 weeks after the last injection (i.e. post- treatment) with GH. The serum concentration data for 116 men are given in the Excel file “Serum.xlsx”.
TASK 1 – SELECTING A SUB-SAMPLE
Open the Serum.xlsx data file as shown.
Click on the “Data” tab and then run the “Data Analysis” tool pack.
5
Select Random Number Generation and click OK.
Select “Uniform” in the drop-down menu next to “Distribution”. Then fill out the other boxes as shown. In the box corresponding to “Random Seed”, make sure you type the last two digits of your student ID here. This will ensure the set of random numbers is unique to you (unless someone else shares the same two numbers).
You should now be able to see 116 random numbers in Column H. Take note that your numbers will be different to those shown here.
Last two digits only
6
Highlight all the data in from Columns A to H using the mouse/keyboard. Then click on   and select Custom Sort…
Now click on  next to ColumnSort by and select (Column H). Make sure that under Order, it is set to Smallest to Largest. Then click OK.
The data are now sorted according to Column H. Again, note that what is shown here is very likely to be different to what you will have. Now, select the first 60 observations (i.e. Rows 2 to 61) from Columns A to G and copy this sub-sample across to SPSS or another Excel spreasheet (e.g. Sheet 2). These observations form the dataset that you will be working with for this question.
7
TASK 2 – ANALYSING THE DATA
(i) Use SPSS or Excel/Real Statistics and generate the necessary summary statistics and figures to describe the serum concentrations 0 and 7 days after the first GH injection. Proper interpretation of these output in the context of the problem is expected. (ii) Use the appropriate test in SPSS or Excel/Real Statistics and determine whether the GH treatment had any significant impact on serum concentration 7 days after the 1st injection. You will need to comment on the nature and extent of these differences (if any). Hypothesis statements are not necessary.  (iii) Confidence intervals should be presented and interpreted whenever possible. (iv) All relevant assumptions associated with your chosen test must be verified. (v) Repeat steps (i) – (iv), but in this instance compare the serum concentrations 1, 4, 8 and 12 weeks after the last GH injection. If the initial analysis suggests a difference, you will then need to perform a post hoc test to determine where the difference(s) lie. Hypothesis statements are not necessary. (vi) Based on the outcomes of the two analyses, comment on the short-term and post-treatment effect of GH treatment on serum concentrations.

8
QUESTION 2 [25 MARKS]
BACKGROUND
Mental illness within the Australian population is becoming more apparent. A nationwide survey in 2007 on mental health and wellbeing conducted by the Australian Bureau of Statistics (ABS) found that an estimated 3.2 million Australian (20% of the population between the ages of 16 and 85) had a mental disorder in the twelve months prior to the survey, and the estimated economic impact of mental health problems is up to $20 billion each year.
The mental health of fly-in/fly-out (FIFO) workers in resources sector became a subject of interest in recent years. Although the financial reward is great, reports of FIFO practices negatively impacting the workers and their Australian families are not uncommon.
To determine the extent of the mental health problem in the resources industry, a health and well-being survey was carried at a particular mining company. In the survey are questions relating to the worker’s demographics, behaviour in the past twelve months, work/lifestyle/family-related issues and others.
Also included in the survey are the Kessler’s mental health questions which will allow one to clinically determine the severity of mental health problems for an individual. The Kessler questions were developed by Professor Kessler and Mroczek (1992) to assess the severity (“1 = None of the time”, “2 = A little of the time”, “3 = Some of the time”, “4 = Most of the time” or “5 = All of the time”) of anxiety and depression related symptoms experienced in the past month. Collectively, they are the Kessler 10 or K10 questions. A K10 score is calculated by summing the scores of the 10 questions. The minimum possible score is 10 (low distress) and the maximum being 50 (very high distress).
Suppose that you are interested in examining whether there is an association between worker’s behaviours and their distress levels in the past 12 months.  The items of interest are presented in Table 1 and the relevant survey data are given in the Excel file “Mental Health.xlsx”. Note that a blank entry represents a missing response.
Table 1   Items of interest in the Health and Well-Being questionnaire Over the past 12 month (1 = Daily; 2 = Weekly; 3 = Monthly; 4 = Once or Twice; 5 = Almost never) (1) How often have you felt worn out? (2) How often have you been emotionally drained? (3) How often have you been irritable? (4) How often have you had aches and pains? (5) How often have you argued with a work colleague? (6) How often have you felt anxious? (7) How often have you had no energy or enthusiasm? (8) How often have you had 6 or more standard drink in one session? (9) How often have you used prescription or non-prescription drugs? (10) How often have you missed a meal? (11) How often have you argued with friends or family? (12) How often have you had trouble sleeping? (13) How often have you exercised?
9
TASK 1 – SELECTING A SUB-SAMPLE
Open the Mental Health.xlsx data file as shown.
Click on the “Data” tab and then run the Analysis ToolPak by clicking on Data Analysis.
Select Random Number Generation and click OK.
10
Select “Uniform” in the drop-down menu next to “Distribution”. Then fill out the other boxes as shown. In the box corresponding to “Random Seed”, make sure you type the last two digits of your student ID here. This will ensure the set of random numbers is unique to you (unless someone else shares the same two numbers).
You should now be able to see 1269 random numbers in Column O. Take note that your numbers will be different to those shown here.
Last two digits only
11
Highlight all the data in from Columns A to O using the mouse/keyboard. Then click on   and select Custom Sort…
Now click on  next to Column → Sort by and select (Column O). Then click OK.
The data are now sorted according to Column O. Again, note that what is shown here (next page) is very likely to be different to what you will have.
12
Now, select the first 150 observations (i.e. Rows 1 to 151) from Columns A to N. Copy this sub-sample across to another spreadsheet (e.g. Sheet 2) in Excel. In the example below, Sheet 2 was renamed to Sub- sample.

13
TASK 2 – SELECTING ITEMS FROM THE QUESTIONNAIRE TO ANALYSE
Now that you have your sub-sample, here you will determine which THREE (3) of the 13 items to analyse. Again, go to the “Data” tab and then run the “Data Analysis” tool pack. Select “Random Number Generation” and click “OK”.
Now generate 13 random uniform numbers and store them in Column P of the sub-sample spreadsheet. In the “Random Seed” box, type the last two digits of your student ID again.
You should now be able to see 13 random numbers in Column P. Take note that your numbers will again be different to those shown here. Now, type the numbers 1 – 13 (to represent the items) in Column Q and right next to the random numbers that you have just generated.
Last two digits only
14
Now, highlight all the numbers in Columns P and Q using the mouse/keyboard. Then sort the numbers by
clicking  and then   Sort Smallest to Largest.
The first three numbers in Column Q refer to the items in Table 1 that you will need to analyse. In this example, these are items (1), (3) and (13). Copy the relevant data for the 3 items and the corresponding K10 scores across to SPSS or another Excel spreadsheet (e.g. Sheet 3). These observations form the dataset that you will be working with for this question.
TASK 3 – ANALYSING THE DATA
(i) Use SPSS or Excel/Real Statistics and generate all necessary summary statistics and figures to describe the relationship between the workers’ mental health (according to the K10 scores) and each of your selected items (make sure you consider each item separately from the others). Proper interpretation of these output in the context of the problem is expected. (ii) Use the appropriate test in SPSS or Excel/Real Statistics and determine whether there is a difference in distress levels across the response categories for these each of these items. If so, perform a post-hoc test to determine where the difference(s) lie. You will need to comment on the nature and extent of these differences (if any). Hypothesis statements are not necessary.  (iii) Confidence intervals should be presented and interpreted whenever possible. (iv) All relevant assumptions associated with your chosen test must be verified.  (v) Briefly comment on the practical implications of your findings and how they may be useful.
15
SUBMISSION GUIDELINES:
This assignment must be completed using either SPSS or Excel/Real Statistics. It is expected that your assignment solutions are presented in the context of the problem. Simply stating the numbers from the output table will not suffice. Examples of this are given on Blackboard in the Quantitative weekly folders corresponding to the workshop weeks. The write-up of your analyses must be presented in Microsoft Word in Times New Roman format with 11-pt font with single spacing and in grammatically correct English. The page margins must be 2 cm for all sides. Failure to do so will result in deduction of marks. Furthermore, no handwritten assignments will be accepted. Copy only the relevant outputs, tables and/or figures from SPSS or Excel across to the Word document. All tables and figures must be labelled appropriately. The write-up for each question (not each part) must not exceed THREE (3) pages (including all tables and figures). Any lines exceeding the three-page limit will not be considered or read. Your assignment submission will also need to include the dataset that is unique to your student ID, along with a cover page (see page 16).
You are reminded of the declaration
“I certify that the attached assignment is my own work and that any material drawn from other sources has been acknowledged”.
that you sign when you complete the coversheet. The assignment solutions must be your own work.
You must submit your completed assignment via Turnitin by Friday 28th of October 2016 before midnight. In the interests of fairness, submission extensions will be given only in exceptional circumstances, and then only in accordance with University rules (see page 17).
Note: If your datasets do not match the ones generated with your student ID (last two digits only), you will be awarded a mark of zero regardless of whether the analysis is correct.
SUBMISSION CHECKLIST:
Your submission will need to be a single document containing the following:
o Cover sheet (1 page) o Your solutions to Questions 1 and 2 (maximum of 3 pages per question). o Your datasets (No restriction)
MARKING GUIDELINES:
(1) Adherence to submission guidelines above (10%) (2) Correct selection and implementation of tests and with correct findings (30%) (3) Proper presentation and interpretation of results in the context of the study and objective(s) (30%) (4) Use of statistics to support and re-inforce findings and arguments (15%) (5) Spelling, grammar and overall narrative (15%)
The above marking guidelines are estimates and variations may occur. If a test is incorrectly chosen, then only a maximum of 10 marks is attainable.
16
ASSIGNMENT COVER SHEET Electronic or manual submission
Form:  SSC-115-06-08
UNIT CODE:        TITLE:
NAME OF STUDENT (PRINT CLEARLY)                          FAMILY NAME                                  FIRST NAME
STUDENT ID. NO.
NAME OF LECTURER (PRINT CLEARLY)

DUE DATE
Topic of assignment

Group or tutorial (if applicable)

Course

Campus

I certify that the attached assignment is my own work and that any material drawn from other sources has been acknowledged.   Copyright in assignments remains my property.  I grant permission to the University to make copies of assignments for assessment, review and/or record keeping purposes.  I note that the University reserves the right to check my assignment for plagiarism.  Should the reproduction of all or part of an assignment be required by the University for any purpose other than those mentioned above, appropriate authorisation will be sought from me on the relevant form.
OFFICE USE ONLY
If handing in an assignment in a paper or other physical form, sign here to indicate that you have read this form, filled it in completely and that you certify as above.
Signature Date
OR, if submitting this paper electronically as per instructions for the unit, place an ‘X’ in the box below to indicate that you have read this form and filled it in completely and that you certify as above.  Please include this page in/with your submission.   Any electronic responses to this submission will be sent to your ECU email address. Agreement                    Date
PROCEDURES AND PENALTIES ON LATE ASSIGNMENTS (University Rule 39)  A student who wishes to defer the submission of an assignment must apply to the lecturer in charge of the relevant unit or course for an extension of the time within which to submit the assignment. (39.1)  Where an extension is sought for the submission of an assignment the application must:  be in writing  –  preferably before the due date; and   set out the grounds on which deferral is sought. ( see 39.2)  Assignments submitted after the normal or extended date without approval shall incur a penalty of loss of marks. (see 39.5) ACADEMIC MISCONDUCT (University Rule 40) All forms of cheating, plagiarism or collusion are regarded seriously and could result in penalties including loss of marks, exclusion from the unit or cancellation of enrolment. – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
ASSIGNMENT RECEIPT       To be completed by the student if the receipt is required
UNIT

NAME OF STUDENT

STUDENT ID. NO.

NAME OF LECTURER

RECEIVED BY
Topic of assignment

DATE RECEIVED
17
CONDITIONS FOR ASSIGNMENT EXTENSION
In accordance with ECU policy, extensions are given on the following grounds and must include all appropriate supporting documentation:
 Ill health or injury for an extended period of time – medical certificate is required;  Compassionate grounds – supporting documentation includes e.g. newspaper notice plus other evidence if not the same family name, e.g. marriage certificate;  Representation in sporting activities at a national or international level;  Representation in significant cultural activities;  Employment related intrastate, interstate and overseas travel – a letter from your employer, including your supervisors’ full contact details.
The following factors will NOT be considered as grounds for extension:
 Routine demands of employment;  Stress or anxiety normally associated with examinations, required assessments or any aspect of course work;  Routine financial support needs;  Lack of knowledge of the requirements of academic work;  Difficulties with English language;  Scheduled anticipated changes of address, moving home etc;  Demands of sport, clubs, social or extra-curricular activity other than those specified above;  Recreational travel (domestic or international);  Planned events such as weddings, birthday parties etc;  Misreading the deadline.
All extension requests will require students to complete the Assignment Extension Form (downloadable from the Quantitative Assignment folder on BB), along with appropriate documentation such as a medical certificate, letter from employer, etc. Original copies of these documents will then need to be provided. Scanned or photocopied documents are NOT acceptable. All documents must be provided no longer than ONE week after the assignment deadline.

RES5115: RESEARCH PREPARATION: PRINCIPLES AND APPROACHES QUANTITATIVE ASSIGNMENT(SPSS)


1
SCHOOL OF SCIENCE
_______________________________________________________________________________________________
RES5115: RESEARCH PREPARATION: PRINCIPLES AND APPROACHES
QUANTITATIVE ASSIGNMENT
DUE DATE: Friday 28th of October 2016 before midnight
For this assignment, you are expected to perform all analyses using either SPSS or Excel/Real Statistics. However prior to this, you will need to generate your own sub-sample (unique to your student ID) from a larger sample using the random number generator in Microsoft Excel. To do this, you must first activate the Analysis ToolPak in Excel by following steps below.
Step 1: Open a new Excel spreadsheet as shown below.
2
Step 2: Go to File → Options.
Step 3: Click on Add-ins and then click Go…
3
Step 4: Select Analysis ToolPak and click OK.
You can now use the Analysis ToolPak under the Data tab by clicking on Data Analysis.
Note that the above steps are for Microsoft Excel 2010 and may differ slightly if you are using the 2013 version.
4
QUESTION 1 [25 MARKS]
BACKGROUND
A study was conducted to investigate the effects of short-term treatments with growth hormone (GH) on biochemical markers of bone metabolism in men with idiopathic osteoporosis. Subjects ranged in age from 32 to 57 years. Among the data collected were serum concentrations of insulin-like growth factor binding protein-3 at 0 and 7 days after the first injection and 1, 4, 8 and 12 weeks after the last injection (i.e. post- treatment) with GH. The serum concentration data for 116 men are given in the Excel file “Serum.xlsx”.
TASK 1 – SELECTING A SUB-SAMPLE
Open the Serum.xlsx data file as shown.
Click on the “Data” tab and then run the “Data Analysis” tool pack.
5
Select Random Number Generation and click OK.
Select “Uniform” in the drop-down menu next to “Distribution”. Then fill out the other boxes as shown. In the box corresponding to “Random Seed”, make sure you type the last two digits of your student ID here. This will ensure the set of random numbers is unique to you (unless someone else shares the same two numbers).
You should now be able to see 116 random numbers in Column H. Take note that your numbers will be different to those shown here.
Last two digits only
6
Highlight all the data in from Columns A to H using the mouse/keyboard. Then click on   and select Custom Sort…
Now click on  next to ColumnSort by and select (Column H). Make sure that under Order, it is set to Smallest to Largest. Then click OK.
The data are now sorted according to Column H. Again, note that what is shown here is very likely to be different to what you will have. Now, select the first 60 observations (i.e. Rows 2 to 61) from Columns A to G and copy this sub-sample across to SPSS or another Excel spreasheet (e.g. Sheet 2). These observations form the dataset that you will be working with for this question.
7
TASK 2 – ANALYSING THE DATA
(i) Use SPSS or Excel/Real Statistics and generate the necessary summary statistics and figures to describe the serum concentrations 0 and 7 days after the first GH injection. Proper interpretation of these output in the context of the problem is expected. (ii) Use the appropriate test in SPSS or Excel/Real Statistics and determine whether the GH treatment had any significant impact on serum concentration 7 days after the 1st injection. You will need to comment on the nature and extent of these differences (if any). Hypothesis statements are not necessary.  (iii) Confidence intervals should be presented and interpreted whenever possible. (iv) All relevant assumptions associated with your chosen test must be verified. (v) Repeat steps (i) – (iv), but in this instance compare the serum concentrations 1, 4, 8 and 12 weeks after the last GH injection. If the initial analysis suggests a difference, you will then need to perform a post hoc test to determine where the difference(s) lie. Hypothesis statements are not necessary. (vi) Based on the outcomes of the two analyses, comment on the short-term and post-treatment effect of GH treatment on serum concentrations.

8
QUESTION 2 [25 MARKS]
BACKGROUND
Mental illness within the Australian population is becoming more apparent. A nationwide survey in 2007 on mental health and wellbeing conducted by the Australian Bureau of Statistics (ABS) found that an estimated 3.2 million Australian (20% of the population between the ages of 16 and 85) had a mental disorder in the twelve months prior to the survey, and the estimated economic impact of mental health problems is up to $20 billion each year.
The mental health of fly-in/fly-out (FIFO) workers in resources sector became a subject of interest in recent years. Although the financial reward is great, reports of FIFO practices negatively impacting the workers and their Australian families are not uncommon.
To determine the extent of the mental health problem in the resources industry, a health and well-being survey was carried at a particular mining company. In the survey are questions relating to the worker’s demographics, behaviour in the past twelve months, work/lifestyle/family-related issues and others.
Also included in the survey are the Kessler’s mental health questions which will allow one to clinically determine the severity of mental health problems for an individual. The Kessler questions were developed by Professor Kessler and Mroczek (1992) to assess the severity (“1 = None of the time”, “2 = A little of the time”, “3 = Some of the time”, “4 = Most of the time” or “5 = All of the time”) of anxiety and depression related symptoms experienced in the past month. Collectively, they are the Kessler 10 or K10 questions. A K10 score is calculated by summing the scores of the 10 questions. The minimum possible score is 10 (low distress) and the maximum being 50 (very high distress).
Suppose that you are interested in examining whether there is an association between worker’s behaviours and their distress levels in the past 12 months.  The items of interest are presented in Table 1 and the relevant survey data are given in the Excel file “Mental Health.xlsx”. Note that a blank entry represents a missing response.
Table 1   Items of interest in the Health and Well-Being questionnaire Over the past 12 month (1 = Daily; 2 = Weekly; 3 = Monthly; 4 = Once or Twice; 5 = Almost never) (1) How often have you felt worn out? (2) How often have you been emotionally drained? (3) How often have you been irritable? (4) How often have you had aches and pains? (5) How often have you argued with a work colleague? (6) How often have you felt anxious? (7) How often have you had no energy or enthusiasm? (8) How often have you had 6 or more standard drink in one session? (9) How often have you used prescription or non-prescription drugs? (10) How often have you missed a meal? (11) How often have you argued with friends or family? (12) How often have you had trouble sleeping? (13) How often have you exercised?
9
TASK 1 – SELECTING A SUB-SAMPLE
Open the Mental Health.xlsx data file as shown.
Click on the “Data” tab and then run the Analysis ToolPak by clicking on Data Analysis.
Select Random Number Generation and click OK.
10
Select “Uniform” in the drop-down menu next to “Distribution”. Then fill out the other boxes as shown. In the box corresponding to “Random Seed”, make sure you type the last two digits of your student ID here. This will ensure the set of random numbers is unique to you (unless someone else shares the same two numbers).
You should now be able to see 1269 random numbers in Column O. Take note that your numbers will be different to those shown here.
Last two digits only
11
Highlight all the data in from Columns A to O using the mouse/keyboard. Then click on   and select Custom Sort…
Now click on  next to Column → Sort by and select (Column O). Then click OK.
The data are now sorted according to Column O. Again, note that what is shown here (next page) is very likely to be different to what you will have.
12
Now, select the first 150 observations (i.e. Rows 1 to 151) from Columns A to N. Copy this sub-sample across to another spreadsheet (e.g. Sheet 2) in Excel. In the example below, Sheet 2 was renamed to Sub- sample.

13
TASK 2 – SELECTING ITEMS FROM THE QUESTIONNAIRE TO ANALYSE
Now that you have your sub-sample, here you will determine which THREE (3) of the 13 items to analyse. Again, go to the “Data” tab and then run the “Data Analysis” tool pack. Select “Random Number Generation” and click “OK”.
Now generate 13 random uniform numbers and store them in Column P of the sub-sample spreadsheet. In the “Random Seed” box, type the last two digits of your student ID again.
You should now be able to see 13 random numbers in Column P. Take note that your numbers will again be different to those shown here. Now, type the numbers 1 – 13 (to represent the items) in Column Q and right next to the random numbers that you have just generated.
Last two digits only
14
Now, highlight all the numbers in Columns P and Q using the mouse/keyboard. Then sort the numbers by
clicking  and then   Sort Smallest to Largest.
The first three numbers in Column Q refer to the items in Table 1 that you will need to analyse. In this example, these are items (1), (3) and (13). Copy the relevant data for the 3 items and the corresponding K10 scores across to SPSS or another Excel spreadsheet (e.g. Sheet 3). These observations form the dataset that you will be working with for this question.
TASK 3 – ANALYSING THE DATA
(i) Use SPSS or Excel/Real Statistics and generate all necessary summary statistics and figures to describe the relationship between the workers’ mental health (according to the K10 scores) and each of your selected items (make sure you consider each item separately from the others). Proper interpretation of these output in the context of the problem is expected. (ii) Use the appropriate test in SPSS or Excel/Real Statistics and determine whether there is a difference in distress levels across the response categories for these each of these items. If so, perform a post-hoc test to determine where the difference(s) lie. You will need to comment on the nature and extent of these differences (if any). Hypothesis statements are not necessary.  (iii) Confidence intervals should be presented and interpreted whenever possible. (iv) All relevant assumptions associated with your chosen test must be verified.  (v) Briefly comment on the practical implications of your findings and how they may be useful.
15
SUBMISSION GUIDELINES:
This assignment must be completed using either SPSS or Excel/Real Statistics. It is expected that your assignment solutions are presented in the context of the problem. Simply stating the numbers from the output table will not suffice. Examples of this are given on Blackboard in the Quantitative weekly folders corresponding to the workshop weeks. The write-up of your analyses must be presented in Microsoft Word in Times New Roman format with 11-pt font with single spacing and in grammatically correct English. The page margins must be 2 cm for all sides. Failure to do so will result in deduction of marks. Furthermore, no handwritten assignments will be accepted. Copy only the relevant outputs, tables and/or figures from SPSS or Excel across to the Word document. All tables and figures must be labelled appropriately. The write-up for each question (not each part) must not exceed THREE (3) pages (including all tables and figures). Any lines exceeding the three-page limit will not be considered or read. Your assignment submission will also need to include the dataset that is unique to your student ID, along with a cover page (see page 16).
You are reminded of the declaration
“I certify that the attached assignment is my own work and that any material drawn from other sources has been acknowledged”.
that you sign when you complete the coversheet. The assignment solutions must be your own work.
You must submit your completed assignment via Turnitin by Friday 28th of October 2016 before midnight. In the interests of fairness, submission extensions will be given only in exceptional circumstances, and then only in accordance with University rules (see page 17).
Note: If your datasets do not match the ones generated with your student ID (last two digits only), you will be awarded a mark of zero regardless of whether the analysis is correct.
SUBMISSION CHECKLIST:
Your submission will need to be a single document containing the following:
o Cover sheet (1 page) o Your solutions to Questions 1 and 2 (maximum of 3 pages per question). o Your datasets (No restriction)
MARKING GUIDELINES:
(1) Adherence to submission guidelines above (10%) (2) Correct selection and implementation of tests and with correct findings (30%) (3) Proper presentation and interpretation of results in the context of the study and objective(s) (30%) (4) Use of statistics to support and re-inforce findings and arguments (15%) (5) Spelling, grammar and overall narrative (15%)
The above marking guidelines are estimates and variations may occur. If a test is incorrectly chosen, then only a maximum of 10 marks is attainable.
16
ASSIGNMENT COVER SHEET Electronic or manual submission
Form:  SSC-115-06-08
UNIT CODE:        TITLE:
NAME OF STUDENT (PRINT CLEARLY)                          FAMILY NAME                                  FIRST NAME
STUDENT ID. NO.
NAME OF LECTURER (PRINT CLEARLY)

DUE DATE
Topic of assignment

Group or tutorial (if applicable)

Course

Campus

I certify that the attached assignment is my own work and that any material drawn from other sources has been acknowledged.   Copyright in assignments remains my property.  I grant permission to the University to make copies of assignments for assessment, review and/or record keeping purposes.  I note that the University reserves the right to check my assignment for plagiarism.  Should the reproduction of all or part of an assignment be required by the University for any purpose other than those mentioned above, appropriate authorisation will be sought from me on the relevant form.
OFFICE USE ONLY
If handing in an assignment in a paper or other physical form, sign here to indicate that you have read this form, filled it in completely and that you certify as above.
Signature Date
OR, if submitting this paper electronically as per instructions for the unit, place an ‘X’ in the box below to indicate that you have read this form and filled it in completely and that you certify as above.  Please include this page in/with your submission.   Any electronic responses to this submission will be sent to your ECU email address. Agreement                    Date
PROCEDURES AND PENALTIES ON LATE ASSIGNMENTS (University Rule 39)  A student who wishes to defer the submission of an assignment must apply to the lecturer in charge of the relevant unit or course for an extension of the time within which to submit the assignment. (39.1)  Where an extension is sought for the submission of an assignment the application must:  be in writing  –  preferably before the due date; and   set out the grounds on which deferral is sought. ( see 39.2)  Assignments submitted after the normal or extended date without approval shall incur a penalty of loss of marks. (see 39.5) ACADEMIC MISCONDUCT (University Rule 40) All forms of cheating, plagiarism or collusion are regarded seriously and could result in penalties including loss of marks, exclusion from the unit or cancellation of enrolment. – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
ASSIGNMENT RECEIPT       To be completed by the student if the receipt is required
UNIT

NAME OF STUDENT

STUDENT ID. NO.

NAME OF LECTURER

RECEIVED BY
Topic of assignment

DATE RECEIVED
17
CONDITIONS FOR ASSIGNMENT EXTENSION
In accordance with ECU policy, extensions are given on the following grounds and must include all appropriate supporting documentation:
 Ill health or injury for an extended period of time – medical certificate is required;  Compassionate grounds – supporting documentation includes e.g. newspaper notice plus other evidence if not the same family name, e.g. marriage certificate;  Representation in sporting activities at a national or international level;  Representation in significant cultural activities;  Employment related intrastate, interstate and overseas travel – a letter from your employer, including your supervisors’ full contact details.
The following factors will NOT be considered as grounds for extension:
 Routine demands of employment;  Stress or anxiety normally associated with examinations, required assessments or any aspect of course work;  Routine financial support needs;  Lack of knowledge of the requirements of academic work;  Difficulties with English language;  Scheduled anticipated changes of address, moving home etc;  Demands of sport, clubs, social or extra-curricular activity other than those specified above;  Recreational travel (domestic or international);  Planned events such as weddings, birthday parties etc;  Misreading the deadline.
All extension requests will require students to complete the Assignment Extension Form (downloadable from the Quantitative Assignment folder on BB), along with appropriate documentation such as a medical certificate, letter from employer, etc. Original copies of these documents will then need to be provided. Scanned or photocopied documents are NOT acceptable. All documents must be provided no longer than ONE week after the assignment deadline.

Need Help: Analysis of Financial Statements


Need Help: Analysis of Financial Statements

Assessment Brief

Module Title: Financial Analysis
Assessment Title: Analysis of Financial Statements
Assessment Type: Formal Report to Board of Directors
Restrictions on Time/Length : 3,000 words (excl. Bibliography) +/- 10%
Individual/Group: Individual
Assessment Weighting: 50%

 Assessment Task : NB refer to Marking Scheme

 

Lecturer will assign you a FTSE [LONDON] listed company.

 

Requirements

  1. Analyse and discuss its financial performance and financial position. Your analysis will be supported by appropriate and relevant ratio calculations and explanatory comments. Trends should be identified and analysed. All workings to be presented.                                                                                                                                     60 marks
  2. Recommend TWO initiatives the company might take in order to improve the position as shown by your analysis of the ratios. 20 marks
  3. A competitor organisation wishes to buy 10% of your company’s shares.

Estimate the value of a 10% stake, using at least two valuation methods, showing and explaining your workings.                                                                                               20 marks

 

                                                                                                                                    Total = 100 marks

 

Listed FTSE [London] companies

http://www.londonstockexchange.com/exchange/prices-and-markets/stocks/indices/constituents-indices.html?index=UKX

 

Further Information

 

  1. Merely computing ratios and observing whether they are improving/disimproving is NOT analysis – the requirement is to establish WHY the ratios are trending as they are. It is STRONGLY recommended that you examine competitors’ ratios, seek industry norms, and source published professional opinions [eg brokers’ / investment reports]. Please refer to Marking Scheme.

 

  1. The lecturer has at his disposal, academic software which compares each assignment with every previous assignment. Any instance of collusion / academic impropriety will be dealt with severely.

 

 

 

 

 

 

 

 

 

 

Marking Scheme – Individual Assignment

 

Q1

  1. Computation of 5 sets of ratios over at least 3 years = 10 marks

 

  1. Interpretation of ratios to include competitor comparison, industry standards, researched professional opinion = 50 marks

 

Q2

 

  1. Two well argued and explained initiatives, 10 marks each

 

Q3

  1. Valuation of 10% investment – needs 2 methods – 10 marks each

You need to do about SABMiller, you will find it in the list

 

 

Company Ticker Sector Market cap (£bn) Employees
Anglo American plc AAL Mining 6.09 100,000
Antofagasta ANTO Mining 4.71 4,005
ARM Holdings ARM Engineering 13.2 2,000
Ashtead Group AHT Equipment rental 4.26 12,810
Associated British Foods ABF Food 25.77 102,000
AstraZeneca AZN Pharmaceuticals 51.23 57,200
Babcock International BAB Engineering 4.65 34,000
BAE Systems BA. Military 16.01 107,000
Barratt Developments BDEV Building 5.86 5,000
Berkeley Group Holdings BKG Building 4.60 2,050
BHP Billiton BLT Mining 41.88 46,370
BP BP Oil and gas 63.13 97,700
British American Tobacco BATS Tobacco 71.4 87,813
British Land BLND Property 7.13 177
BT Group BT.A Telecomms 45.61 89,000
Bunzl BNZL Industrial products 6.38 12,368
Burberry BRBY Fashion 5.65 10,851
Capita CPI Support Services 7.38 46,500
Carnival Corporation & plc CCL Leisure 24.85 86,800
Centrica CNA Energy 10.72 40,000
Coca-Cola HBC AG CCH Consumer 5.1 38,312
Compass Group CPG Food 20.21 471,108
CRH plc CRH Building materials 10.9 76,433
Diageo DGE Beverages 46.01 25,000
Dixons Carphone DC. Retail 5.16 40,000
EasyJet EZJ Travel 6.17 11,000
Experian EXPN Information 11.1 17,000
Fresnillo plc FRES Mining 6.99 2,449
GKN GKN Manufacturing 4.79 50,000
GlaxoSmithKline GSK Pharmaceuticals 67.38 97,389
Glencore GLEN Mining 16.96 57,656
Hammerson HMSO Property 4.42 277
Hikma Pharmaceuticals HIK Manufacturing 3.71 6,000
Imperial Brands IMB Tobacco 35.78 38,200
Inmarsat ISAT Telecomms 4.47 1,590
InterContinental Hotels Group IHG Hotels 5.75 345,000
International Consolidated Airlines Group SA IAG Travel 11.01 58,476
Intertek ITRK Product testing 4.67 33,000
Intu Properties INTU Property 3.89 2,180
ITV plc ITV Media 10.15 4,059
Johnson Matthey JMAT Chemicals 4.79 9,700
Kingfisher plc KGF Retail homeware 7.8 80,000
Land Securities LAND Property 8.19 700
Marks & Spencer MKS Retailer 7.01 81,223
Merlin Entertainments MERL Leisure 4.42 28,000
Mondi MNDI Manufacturing 6.37 26,000
National Grid plc NG Energy 36.14 27,000
Next plc NXT Retail clothing 6.9 58,706
Pearson PLC PSON Education 6.52 37,000
Persimmon plc PSN Building 6.34 2,450
Randgold Resources RRS Mining 5.89 6,954
Reckitt Benckiser RB Consumer goods 46.32 32,000
RELX Group REL Publishing 25.54 28,500
Rexam REX Packaging 25.54 19,000
Rio Tinto Group RIO Mining 34.84 67,930
Rolls-Royce Holdings RR. Manufacturing 11.8 55,500
Royal Dutch Shell RDSA Oil and gas 160.12 90,000
Royal Mail RMG Delivery 4.41 150,000
SABMiller SAB Beverages 67.32 70,000
Sage Group SGE IT 6.26 12,300
Sainsbury’s SBRY Supermarket 5.02 150,000
Severn Trent SVT Water 5.04 8,051
Shire plc SHP Pharmaceuticals 22.52 4,200
Sky plc SKY Media 17.5 22,800
Smith & Nephew SN. Medical 10.27 11,000
Smiths Group SMIN Engineering 3.84 23,550
Sports Direct SPD Retail 2.4 17,210
SSE plc SSE Energy 14.03 19,965
Taylor Wimpey TW. Building 5.99 3,860
Tesco TSCO Supermarket 14.92 519,671
Travis Perkins TPK Retailer 4.46 24,000
TUI Group TUI Leisure 76,000
Unilever ULVR Consumer goods 90.42 171,000
United Utilities UU Water 6.36 5,096
Vodafone Group VOD Telecomms 56.55 86,373
Whitbread WTB Retail hospitality 7.09 86,800
Wolseley plc WOS Building materials 9.20 44,000
Worldpay WPG Payment services 5.9 4,500
WPP plc WPP Media 19.01 162,000

 

 

 

Art Essay questions:


Art Essay questions:

 

  1. Discuss the main features of King Zoser’s (Djoser’s) mortuary complex at Saqqara, how the complex expresses the Egyptian view of the role of the Pharaoh, and how the features of Saqqara point forward to subsequent art and architecture. Please include specific details in your essay to support your descriptions and main points.

 

  1. Choose two of the following periods or cultures, and discuss how the content of art (subject matter) reflects the central concerns of society, and how the style and form (way that the content is conveyed) may be interpreted to express the character of the society: Cave paintings (Ice Age art), Sumerian art, Amarna period in Egypt, Minoan art.

 

  1. Discuss the main features of Queen Hatshepsut’s mortuary complex at Deir el-Bahri. How does the complex express the Egyptian view of the role of the Pharaoh? How does it express the Hatshepsut’s own interests? What was new and what was traditional in the design? Please include specific details in your essay to support your descriptions and main points.

 

Need Help-CEE 213—Deformable Solids


Need Help-CEE 213—Deformable Solids

The Mechanics Project Arizona State University CP 4—Plane Beam 1

Computing Project 4 Plane Beam

The computing project Plane Beam concerns the solution of the problem of a prismatic beam subjected to a variable transverse load. The goal is to write a MATLAB program that will allow the solution for a variety of load distributions and for all possible boundary conditions (i.e., fixed, simple, slide, or free at either end). The theory needed to execute this project is contained in the set of notes (entitled CP 4— Plane Beam) that accompany this problem statement. Those notes provide an introduction to each aspect of the computation required to solve the problem. This project is very similar to CP 1—Axial Bar, and it would be a very good idea to use the code for that project as the starting point for this one. The general steps are as follows: 1. Develop a routine based upon Simpson’s Rule to numerically integrate the applied loading terms that produce the quantities I0, I1, I2, and I3 that are mentioned in the CP4 notes. To get this part working dust off the Simpson code segment from CP1 and add the new pieces (i.e., I2, and I3). Verify the numerical integration by comparing with integrals you can do by hand. 2. Develop a routine to set up and solve the system of equations that allow for the determination of the state variables (w, , M, and V) at both ends of the bar. This step will require some logic to make it work easily for different boundary condition cases (it should cover all of them). Debug your code with a problem that you can solve by hand (e.g., beam fixed at one end with a uniformly distributed load). 3. Develop a routine to integrate the governing equations from the left end to the right end using generalized trapezoidal rule to do the integration numerically. Store the results at each step along the axis and provide a plot of the applied load q, the transverse displacement w, the rotation of the cross section , the bending moment M, and the net shear force V as functions of x. A good way to verify this step is to just plot the functions and verify that they go to the right values at x=L. 4. Generate a library of load forms, including some simple ones (e.g., uniform load) to verify the code. You should be able to use your MATLAB function LoadFunctionCP.m for this task with little or no change. 5. Use the library to explore aspects of the problem. For example: CEE 213—Deformable Solids The Mechanics Project Arizona State University CP 4—Plane Beam 2 a. Explore how the distribution of load affects the displacement, rotation, moment and shear along the length of the beam. b. Investigate a distributed load over a small segment of the bar (with no load over the rest of it) to see how a distributed load in the limit does the same thing as a concentrated load. Make sure to increase the amplitude of the distributed load as you decrease the length of its action so that the total force is equal to a fixed value (i.e., the value of the concentrated force you are comparing it to). What happens to the shear diagram? What does the moment diagram look like? c. Explore how the state variables work to meet the boundary conditions (e.g., the slope of the rotation function should go to zero at a free end). d. Explore any other feature of the problem that you find interesting. Write a report documenting your work and the results (in accord with the specification given in the document Guidelines for Doing Computing Projects). Post it to the Critviz website prior to the deadline. Please consult the document Evaluation of Computing Projects to see how your project will be evaluated to make sure that you can get full marks. Note that there is no peer review process for reports in this course.

%d bloggers like this: