BUSINESS STATISTICS-Individual coursework-Answer 3 questions-Use the SPSS program

| April 17, 2015

Order Details;

Management School – Undergraduate Coursework Specification

 

Module Code: MGT223 Coursework Code: MGT223-1
Module Title: Business Statistics
Date Available: Wednesday 19th March
Submission details:  You should submit your coursework via the link on MOLE no later than  23:59 on Monday, 18th May 2015.

Turnitin: You are not required to submit your coursework via Turnitin

Contribution to Final Mark for Module: 20%
Maximum Word Length: No word limit

 

 

Requirements:

You are required to answer the THREE questions below.

Relevant data are on a separate sheet, and each student will be assigned an individual data sheet. These are available on the mgt223 MOLE site.

 

ALL STATISTICAL ANALYSIS SHOULD BE UNDERTAKEN USING SPSS.

 

  1. A manufacturer of golf equipment is seeking to develop a new, cut-resistant, longer-lasting golf ball. The research group assigned to this task has developed a new coating designed to resist cuts and provide a more durable ball.

 

One area of concern is the effect of the new coating on the driving distance of the ball – in order for the ball to compete in the current market it is essential that it offers driving distances comparable to those of the manufacturer’s current top model.  To compare the driving distances for the balls, 20 balls of each type were subjected to distance tests.  The testing was performed using a mechanical hitting machine so that any differences observed could be attributed to design differences between the 2 balls.  The test results, with distances measured to the nearest yard, are given on your data sheet.

  • Provide descriptive statistical summaries of the data for each model.
  • Use an appropriate test to compare the mean driving distances of the two models.
  • Use a non parametric test to test whether there are differences between the two models.
  • What are your recommendations?

 

  1. A study provided data on variables that may be related to the number of weeks a manufacturing worker has been jobless due to layoff. The dependent variable in the study (WEEKS) was defined as the number of weeks a worker has been jobless due to a layoff.  The following independent variables were used in the study:

AGE:                     The age of the worker

EDUC:                  The number of years of formal education

MARRIED:           A dummy variable: 1 if married, 0 otherwise

HEAD:                   A dummy variable: 1 if the head of the household, 0 otherwise

TENURE:              The number of years in last job

OCCUP:                1 if management occupation, 2 if sales occupation, 3 other occupation

 

The results of this study are provided on your data sheet.

  • Analyse the data using multiple regression techniques.
  • Provide a summary of your findings, suitable for inclusion in a management report.

 

  1. A manufacturing company designed an experiment to determine whether the number of defective parts produced by two machines differed and if the number of defective parts produced also depended on whether the raw material needed by each machine was loaded manually or by an automatic feed system. The data are given on your data sheet.
  • Analyse the data using appropriate statistical techniques.
  • Provide a summary of your findings, suitable for inclusion in a management report.

 

 

 

Assessment criteria <40%

(Fail)

40-44%

(Pass)

45-49%

(3rd  class)

50-59%

(2.2 )

60-69%

(2.1)

70 % and above

(1st class)

The ability to select and conduct an appropriate statistical analysis using SPSS. (35%) Inappropriate/incomplete choice of analysis Basic analysis with one or two errors/omissions Basic analysis with one or two minor errors/omissions Analysis using appropriate techniques.  . Full analysis.  . Full analysis all in the correct order.
The ability to provide a technical interpretation of your results. (35%) None provided/incorrect or misleading interpretation. Poor interpretation.  Confused in places Basic interpretation Adequate interpretation, demonstrating understanding of the techniques used. Full interpretation, demonstrating understanding of the techniques used. Full interpretation, demonstrating a clear understanding of the techniques used.
The ability to explain your results in non technical terms (where required) (10%) Not provided. Little thought given to this aspect. A limited attempt but poorly expressed.  Little mention of context. Some attempt to interpret the results of analysis within the context of the problem. A good attempt to interpret the results of analysis within the context of the problem. An excellent interpretation of the results of analysis within the context of the problem.
An understanding of the assumptions underpinning your analysis and the ability to check them where possible (10%) Demonstrates no understanding of the requirements of analysis No assumptions stated or tested. Demonstrates little understanding of the requirements of analysis Few assumptions stated and tested. Demonstrates limited understanding of the requirements of analysis Some assumptions stated and tested. Demonstrates some understanding of the requirements of analysis Most assumptions stated and tested. Demonstrates some understanding of the requirements of analysis All assumptions stated and tested. Demonstrates a full understanding of the requirements of analysis All assumptions stated and tested.  .
Presentation (10%) Poor presentation with many errors. Use of informal language, lacks clarity, poor expression. Unsatisfactory presentation. Poor grammar and expression. Presentation could be improved. Some errors in grammar and expression. Satisfactory presentation. Grammar/expression acceptable. Good quality presentation. Good attempt at spelling/grammar/use of expression. Excellent presentation with good syntax and spelling and/or fluent expression.

 

 

Referencing:

You must reference your work correctly using the Harvard method.  Failure to do so will result in the deduction of marks and possible proceedings under the University’s Regulations as to the Use of Unfair Means

Independence of working:

You are reminded of the University’s Regulations on the Use of Unfair Means, which are outlined in the School’s Handbooks.  Should you be found to be in breach of them you will be subject to disciplinary procedures.

Other Submission Details:

 

  • Your submission is aimed at an audience familiar with statistical techniques (with the exception of q 1(d), q2(b) and q3(b) where you are required to provide a summary of your analysis suitable for inclusion in a management report).

 

  • You should provide a full description of the results of each analysis, providing details of any hypothesis tests undertaken and the assumptions necessary for them to be valid, and referring to key statistics to demonstrate how you have arrived at your final conclusions.

 

  • Your submission should conform to Management School standards (see UG Handbook): the work should be on A4 paper with a standard anonymous cover sheet and stapled in the top left hand corner. The report must be word-processed and all statistical analysis must be produced using SPSS. Ideally, relevant output should be imported into the word-processed document. Graphs and tables should be clearly titled and numbered.

 

  • It is University policy that any delay will result in progressive penalties as set out in the Management School Undergraduate Handbook.

 

 

 

Question 1 – Golf Equipment Manufacturer Model

Current New
278 280
285 291
278 267
271 264
260 263
285 257
256 273
281 261
280 270
270 269
255 268
267 281
281 269
284 277
271 284
277 243
260 279
270 252
283 260
265 272

 

 

 

 

 

 

 

Question 2 – Unemployment Study

 

WEEKS AGE EDUC MARRIED HEAD TENURE OCCUP
25 33 10 0 1 5 2
56 37 13 1 0 1 3
38 41 14 1 0 0 3
28 38 10 0 1 2 3
39 47 10 1 1 8 3
20 38 15 0 1 4 2
24 42 18 0 0 3 1
39 34 11 1 1 3 3
53 37 13 1 1 5 3
20 38 13 1 1 6 2
31 37 11 1 1 6 3
44 43 10 1 0 3 3
30 30 15 0 1 9 3
57 39 17 1 0 9 3
6 34 11 1 1 5 2
3 30 12 1 1 4 2
34 40 10 0 1 8 3
9 41 15 1 1 5 2
50 27 10 1 0 6 3
44 44 10 0 1 5 3
59 48 10 1 0 5 3
62 39 10 0 0 4 3
7 14 12 1 1 6 2
7 38 17 1 1 2 2
45 35 13 1 1 4 3
35 40 10 0 1 1 3
13 40 14 1 1 5 1
16 29 11 1 1 2 2
22 40 10 1 1 11 2
18 40 10 1 1 4 2

 

Question 3 – Manufacturing Company

 

Loading System
Manual Automatic
Machine 1 331 316
332 327
264 357
 
Machine 2 279 281
294 354
267 315

Please note that this a degree level coursework (second year of the university in the uk). Please use the program SPSS for the tables and graphs. Also see below because same of answers need to discuss them.

Individual coursework:
This is a technical piece of work. You are required to undertake specific analyses and demonstrate your understanding of them. You are not expected to produce a formal business report. There is no word limit but you should try to keep your answers concise.

The marking criteria focus on your technical ability and your ability to express the results clearly and concisely in technical and non-technical terms. You can demonstrate this by answering the questions that have been set.

Requirements:
You are required to answer the THREE questions below.
Relevant data are on a separate sheet.

ALL STATISTICAL ANALYSIS SHOULD BE UNDERTAKEN USING SPSS PROGRAM.

QUESTIONS:
1.A manufacturer of golf equipment is seeking to develop a new, cut-resistant, longer-lasting golf ball. The research group assigned to this task has developed a new coating designed to resist cuts and provide a more durable ball.

One area of concern is the effect of the new coating on the driving distance of the ball – in order for the ball to compete in the current market it is essential that it offers driving distances comparable to those of the manufacturers current top model. To compare the driving distances for the balls, 20 balls of each type were subjected to distance tests. The testing was performed using a mechanical hitting machine so that any differences observed could be attributed to design differences between the 2 balls. The test results, with distances measured to the nearest yard, are given on your data sheet.
(a)Provide descriptive statistical summaries of the data for each model.
(b)Use an appropriate test to compare the mean driving distances of the two models.
(c)Use a non parametric test to test whether there are differences between the two models.
(d)What are your recommendations?

2.A study provided data on variables that may be related to the number of weeks a manufacturing worker has been jobless due to layoff. The dependent variable in the study (WEEKS) was defined as the number of weeks a worker has been jobless due to a layoff. The following independent variables were used in the study:
AGE:The age of the worker
EDUC:The number of years of formal education
MARRIED:A dummy variable: 1 if married, 0 otherwise
HEAD:A dummy variable: 1 if the head of the household, 0 otherwise
TENURE:The number of years in last job
OCCUP:1 if management occupation, 2 if sales occupation, 3 other occupation

The results of this study are provided on your data sheet.
(a)Analyse the data using multiple regression techniques.
(b)Provide a summary of your findings, suitable for inclusion in a management report.

3.A manufacturing company designed an experiment to determine whether the number of defective parts produced by two machines differed and if the number of defective parts produced also depended on whether the raw material needed by each machine was loaded manually or by an automatic feed system. The data are given on your data sheet.
(a)Analyse the data using appropriate statistical techniques.
(b)Provide a summary of your findings, suitable for inclusion in a management report.

Referencing:
You must reference your work correctly using the Harvard method. Failure to do so will result in the deduction of marks and possible proceedings under the University’s Regulations as to the Use of Unfair Means

Other Submission Details:

Your submission is aimed at an audience familiar with statistical techniques (with the exception of q 1(d), q2(b) and q3(b) where you are required to provide a summary of your analysis suitable for inclusion in a management report).

You should provide a full description of the results of each analysis, providing details of any hypothesis tests undertaken and the assumptions necessary for them to be valid, and referring to key statistics to demonstrate how you have arrived at your final conclusions.

Your submission should conform to Management School standards (see UG Handbook): the work should be on A4 paper with a standard anonymous cover sheet and stapled in the top left hand corner. The report must be word-processed and all statistical analysis must be produced using SPSS. Ideally, relevant output should be imported into the word-processed document. Graphs and tables should be clearly titled and numbered.

 

Get a 5 % discount on an order above $ 150
Use the following coupon code :
2018DISC
An Exercise on NPV Profile Crossings
Russian Foreign Policy

Tags:

Category: Uncategorized

Our Services:
Order a customized paper today!