Quantitative Techniques for Business: Assignment

Added on - 16 Sep 2019

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 2 of 4 pages
Quantitative Techniques for Business (BS2S81)Term 1 – Assessment 1 (Statistics tasks and report)Individual AssignmentThe assignment is based largely upon the EXCEL data file,Company Apple.xls. This fileshows details of 474 staff working for a large organisation in Wales. It consists of 10 piecesof information for each staff member. The file, together with explanation of the variables,isavailable from your ‘Assessment’ folder on blackboard.A new Managing Director has just joined your company and has asked you to analyse theinformation from ‘Company Apple’ data file and write a formal report about the currentpictures of employees working in the company.You are required to use the appropriate module concepts and techniques to complete thefollowing four tasks and analyse the ‘Company Apple’ data provided. The report should besubmitted in one single file within 2,500 words (+/- 1-%) by18th December 2016 Sunday23:55(Week 12). You are to submit the assignment via TurnItIn, on the Bb site. If you are upto 5 working days later than this you can gain a maximum mark of 40%.Later will be zero,unless you have submitted for and been granted extenuating circumstances.This assignment accounts for 50% of the marks awarded in the whole module.NBGeneral neatness and good presentation as well as arithmetic correctness, will be a factorin the marking of your submissions.Please include any relevant calculations where used, aswell as appropriate supporting information.Do not submit any material that is not strictlyrelevant to the tasks and assignment.TASKBASED ONTask 1Summarising DataTask 2Regression and CorrelationTask 3ProbabilityTask 4Probability DistributionsFor task 1 to 4, you should refer to the Excel file Company Apple.xls.Task 1: Summarising Data1.Classify the 10 variables by type (that is, nominal, ordinal, interval, ratio-scale), andsay whether they are quantitative or qualitative.2.Using Excel, present the Job Category as a Pie Chart and as a Simple Bar Chart. Payattention to labels, titles and general neatness.3.By means of Excel, use sensible grouping to organise the Salbeg data into a groupedfrequency distribution and cumulative frequency distribution.1
Quantitative Techniques for Business (BS2S81)Term 1 – Assessment 1 (Statistics tasks and report)4.Using Excel construct a Histogram, Frequency Polygon and aRelativeCumulativeFrequency curve for the data obtained in Q3 (the variable Salbeg). Pay particularattention to scale, labels, titles and general neatness.5.By putting lines on the Relative Cumulative Frequency curve estimate the median andquartiles of Salbeg. (can draw the lines using ‘Insert>Shapes>Lines’ tool or handdraw them and scan the sheet in with your submission) What are the estimatedvalues?6.Is the variable Salbeg symmetrical, negatively skew or positively skew? Write a shortnote summarising the evidence for your answer.Task 2: Regression & Correlation1.Use Excel to obtain scatterplots and coefficients of correlation (r values please – notR2) for the following pairs of variables:(a) Salary Now and Age. (b) Salary at Beginning and Age.(c) Salary Now and Salary at Beginning.Produce the results. Write ashortnote on what you think these graphs and r valuestell you about the association between these variables.2.Use Excel to calculate the regression equation of Salary Now on Salary at Beginningand to draw the line of this equation through the scatterplot.Write out the equation in full.For someone who began with a salary of £20,000, what would your regression linepredict they would earn now? Would you have much faith in the accuracy of thisforecast? Briefly explain your answer.2
Desklib Logo
You are reading a preview
Upload your documents to download or

Become a Desklib member to get access