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 Assignment The 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-%) by 18th 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.NB General 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 Data Task 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), and say whether they are quantitative or qualitative.2.Using Excel, present the Job Category as a Pie Chart and as a Simple Bar Chart. Pay attention to labels, titles and general neatness.3.By means of Excel, use sensible grouping to organise the Salbeg data into a grouped frequency 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 a Relative Cumulative Frequency curve for the data obtained in Q3 (the variable Salbeg). Pay particular attention 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 hand draw them and scan the sheet in with your submission) What are the estimated values?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 – not R2 ) 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 a short note on what you think these graphs and r values tell you about the association between these variables.2.Use Excel to calculate the regression equation of Salary Now on Salary at Beginning and 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 line predict they would earn now? Would you have much faith in the accuracy of this forecast? Briefly explain your answer.2
Found this document preview useful?
You are reading a preview Upload your documents to download or Become a Desklib member to get accesss