代写 BUS105: STATISTICS  统计 assignment

BUS105: STATISTICS

 

TRIMESTER1              2016         ASSIGNMENT

 
 
Introduction
 
This assignment requires you to analyse a given data set, draw conclusions from your analysis, and convey your conclusions in written form to a person with a very modest knowledge of statistics. You are also required to use some of the capabilitiesofSPSS for statistical analysis.
 
The assignment should be completed and submitted as a group assignment unless permission to submit an individual assignment has been received from your lecturer.
 
 
 
Ø    The number of students in each group should be no greater than three. Your group should meet to discuss fully the analysis required and should also review the memorandum before submitting.
 
Ø    Submit one printed copy onlyper group for marking.
 
 
Ø    Details of all members of the group must be included on the assignment cover sheet attached to the assignment. All members of the group will be allocated the same mark for the assignment. It is up to each group to ensure all members do the same amount of work in contributing to the assignment.
 
Before attempting the assignment read the section ‘Assignment Details’ given in the Unit Outline.
 
The assignment uses an Excel file called Conrobar.Your lecturer/tutor will advise you on how to download the database. The data can be readily analysed usingSPSS.
 
When you retrieve the Conrobardatafile for the assignment you are advised to immediately save it under another name, for example, Assgn1.xls. It is important to save your files often, (e.g. every 5 minutes), so that important work is not lost in the event of a computer malfunction.
 
 
 
 
 
 
 
 
 
 
 
 
Assignment Details
 
Ø  Charlie McArthy, Vice President of Planning and Development, has asked you,
Candice Bergen , Manager of Research and Analysis, and your team to analyse some data obtained from a survey of Conrobar employees.
Ø   The memo from Charlie McArthy is reproduced on page 4 of this document.
Ø   You are required to respond to Charlie’s memorandum answering all of his questions.
This is to be done by:
§    Preparing a data analysis documentusingSPSS.
§    Writing a memorandum in reply.
Task 1: Data analysis (10 marks)
 
You will need to examine and analyse the database thoroughly in order to prepare your answers to Charlie’s questions. To complete the analysis, you will need to do at least someof the following where appropriate:
 
·         Examine summary measures
·         Develop frequency tables and histograms
·         Develop contingency tables (cross tabs)
·         Producebox plots including multiple box plots where applicable
·         Producescatter graphs
 
v  Scatter graphs allow you to examine for possible relationships between two quantitative (numeric) variables.
v  Contingency tables(cross tabs) allow you to examine for possible relationships between two qualitative variables. For contingency tables involving quantitative variables, you will need to create the classes.
v  You will need to use the transform/recode feature in SPSS.
 
Ø    Include headings in your analysis in order that your lecturer can follow your work
 
Ø    For the submission of your assignment, the completed data analysis document is to be attached to the memo.
 
 
 
 
 
 
 
代写 BUS105: STATISTICS  统计 assignment 
 
 
Task 2: The Memorandum (10 marks)
 
Prepare a memorandum answering Charlie’s questions, providing essential information and conclusions. It is important to note that the memorandum is not a detailed research report. Thus, you should be able to convey your conclusions in about 4-5 pages(max).
Keep the English simple and the explanations brief.
Your answers should be based on the analysis. However, in your memo you must not refer explicitly to the DataAnalysis part of the submission. This analysis is kept by you for future reference and will not be seen by Charlie. If you feel it may help your explanation, you may include some suitable tables in the memo, but do not include any charts in the memorandumexcept for a bar chart and or pie chart if appropriate.
 
As a professional business person, the accuracy and readability of your business communications are of utmost importance to your career. With this in mind you will be assessed on your ability to interpret your analysis correctly and on your ability to convey your conclusions in simple, clear language. Marks will be deducted for any inconsistencies between your analysis and your memo.
      
When writing up the memorandum try not to write too much or too little. 
             You must decide the right balance.In summary, your memorandum must be:         
 
v  ahighlyreadable, understandable,plain languagedocument
v  it must beuseful, accurate, andinformative
v  it mustaddress all questions raised in the originating memo
 
§  There is no need to make any recommendations in the memo unless you are specifically asked to do so.
§  Refrain from expressing your opinions about your analysis, simply relate
 the information as determined by the analysis.
§     Let the statistics and or parameters speak for themselves.

Memorandum
 
Date:       02.01.2014
To:          Candice Bergen, Manager of Research and Analysis
From:      Charlie McArthy, Head of Human Resources
Subject:   Analysis of employee survey data
 

Dear Candice
 
For the next meeting of theConrobar Board I have been asked to table some observations on our employees. As you know we recently conducted a question survey of a sample of 48 of our employees.I understand that you have a copy of the results of that survey.
 
We would appreciate it if you could carry out some statistical analysis on those results and respond to this memorandum by answering the 8questionsI have listed below. Your response will enable me to prepare a paper for the meeting.
 
Just a reminder about the wording of your memorandum:we would prefer that you present your comments in a non-technical format. Statistical terminology can be confusing to the lay person.
 
However in anticipation of your report I have distributed a glossary of relevant statistical terms to some of my staff. The following terms may be included in the memo without the need for any explanation as to their meaning:
 
v  mean/average
v  median
v  mode/modal class
v  outliers
v  standard deviation
v  inter-quartile range
v  linear/non-linear relationship
v  coefficient of determination
 
If you intend using any other statistical terms in the memo, a very brief and simple explanation of their meaning would be appreciated.
 
 
 
 
 
 
 
 
 
 
 
 
 
QUESTIONS
 
1.                   The employeedatabasecontains the variableweekly ordinary time salary (WkSalry).With reference to thesample, we require:
 
(a)Summary statistics for the entire sample of 48 employees for this variable,that you
thinkmay berelevant.
 
(b)A similar studybased on:
 
(i)gender (ii)managers and non- managers(iii)  three levels of job security
 
Your answers to 1 (a) should include:
 
 
Your answers to 1 (b) should include:
 
2.                   The employeedata base contains the variablejob satisfaction (Jobsat).With reference to thesample, we require:
 
(a)Summary statistics for the entire sample of 48 employees for this variable, that you
thinkmay berelevant.
 
(b)A similar study based on:
 
(i)gender(ii)managers and non- managers(iii)  three levels of job security
 
  Your answers to 1 (a) should include:
 
 
Your answers to 1 (b) should include:
 
3.                     The board is also interested in establishing if there may be any significant linear relationships between the various numericalvariables included in the survey. In particular  could you please examine in some detail the following relationships:
 
·                       WkSalryversus EducYrs
·                       WkSalry versus  AtConrobar
·                       Prdtvty versus AtConrobar
·                       UOvTime versus Age  
·                       Prdtvty versus WkSalry
·                       DysAbsnt versus Age
·                       PrdtvtyversusDysAbsnt
·                       WkSalryversus Age
 
 
4.    Some board members feel that GenderandEducYrsmight be related. Could you please advise if there appears to be any difference in mean and median EducYrs between males and females in the sample?
 
 
5.    At a recent board meeting the very sensitive subject concerning days absent and genderwas mentioned. Could you please provide the relevant summary statistics which would answer the question whether femalesin the sample reported absent more than males?
 
 
 
 
 
 
 
 
 
 
 
 
QUESTIONS: Inferential Statistics
 
6.         Productivity (Prdtvty)
 
(a)                Please provide an estimate (95% level of confidence) of the meanProductivity of all our employees.
 
(b) Please provide an estimate (95% level of confidence) of the meanProductivity of all our:
 
  (i)   female employees  (ii)  male employees
 
  (c)     At the 95.0% significance level, can we conclude that there is a difference in mean
Productivity between males and females for all our employees?
 
(d)    What minimum sample size (n) would be required to estimate the population mean 
Productivity with a margin of error of 10 (ME = 10) with 95% confidence?
 
 
7.Age
 
 (a)      Please provide an estimate (95% level of confidence) of the meanAgeof all our 
employees.
 
   (b)      Please provide an estimate (95% level of confidence) of the meanAge of all our:
 
(i)   managers      (ii)   non-managers
 
    (c)   At the 95.0% significance level, can we conclude that there is a difference in mean     
           Age between managersand non-managers for all our employees?
 
 
8.  Conducting a Hypothesis Test
 
 
Ø  Students will need to state the null and alternative hypotheses correctly (symbols) (memo only) and then conduct a suitable hypothesis test using SPSS (in the analysis).
 
Ø  Students should then copy and paste the result of the test from the SPSS output into the memo.
 
Ø  Students then need to use the appropriate values from the output in order to explain their decision and then write the appropriate conclusion.   

代写 BUS105: STATISTICS  统计 assignment