Write down the value of the gradient of the regression line

Assignment Help Basic Statistics
Reference no: EM13841604

Business Statistics Major Assignment

This assignment requires a considerable amount of computer work and written comment. You may need to seek guidance from your tutor along the way. Do not leave the Assignment until too late. Each question carefully describes what you are required to do, so please follow the instructions carefully. Your answer to each question should begin with the number of the question. Refer to the General Marking Guide below for details.

In this assignment you will examine data on employees of a medium sized company. The variables which have been recorded for each employee are listed below, and the data is contained in the file Salary.xls.

Variable Description

Id Employee identity number

Gender Gender of staff member.

Start Yr Year employee started work with the company

Dept Department. 1: Warehousing; 2: Import/Export; 3:Production and 4: Management.

Begin $ Initial Salary

2011 $ Salary in 2011

Position Position in Company. 1:Management; 2: Clerical; 3: Production.

The company is about to enter into negotiations over the salaries of production workers and management has asked for a report on their current pay.

Random Sample: Before you begin your analysis you are required to take a random sample of size 100. Use the file Random Sampler Generator.xls to do this. Your tutor will show you how this can be done in EXCEL. Your answers to the assignment tasks below are to be based on your sample of 100 cases. Make sure to keep a safe copy of your sample since you cannot use Random Sampler Generator.xls to reproduce the first 2marks sample. Provide a printout of the data in your sample, with ID numbers in ascending order. When sorting your sample remember to highlight all of your sample data before sorting. Copy your sample file to another spreadsheet for working your assignment. Make sure you save your random sample.

Assignment Tasks

1. Determine the mean, standard deviation and standard error for the production workers in your sample. Use this information to carry out a t-test to see if the 5marks average pay for production workers is less than $49,000.

2. Construct a new variable called Experience which is equal to the length of time each employee has worked for the company up to the year 2011. State the formula used for the new variable.

Obtain a scatter-plot of Current Pay vs Experience for Production staff. Think carefully about which variable should go on the vertical axis - remember, it is the independent variable that goes on the horizontal axis (i.e. the x-axis). Make sure you 8marks label your axes properly and that your graph has an appropriate title.

Briefly describe the nature of the relationship between these two variables.

3. Use XL to carry out a regression analysis on these two variables. (This is for the production staff only.) Copy the output into your assignment and use it to respond to the following:

o Write down the regression equation.

o State the R-Square value and the Standard Error and explain what they mean with respect to this data.

o Write down the value of the gradient of the regression line and explain what it means in this case.

o Is the constant or intercept value significant in this case? How do you know this?

o Briefly explain why you think this regression model is, or is not, a good model.

4. For production staff, obtain a stratified scatterplot distinguishing males and females. 3marks Make sure that the scatterplot is labeled appropriately and that the markers for males and females can be easily distinguished and are an appropriate size.

Your scatterplot should include trendlines, equations and R2 values for each group.

Provide a brief comparison of the pay for the two groups, noting important 3 marks differences, if any, between them. Do males receive better pay than females?

Do males receive better pay increases than females?

5. Using information from your analyses write a short concluding paragraph about the pay of production staff and, in particular, the pay for male and female production 2marks staff.

If overall flow and structure of discussion, technical language, grammar and spelling is sound.

Reference no: EM13841604

Questions Cloud

Derives the error term for the following formulas : Using Taylor series expansion derives the error term for the following formulas: Use method of undetermined coefficients to derive second order scheme for ∂u/∂x using three points in the following way
Advantages and disadvantages of lease versus purchase : advantages and disadvantages of lease versus purchase
Create the physical data model : Using anyRDBMS preferably (MySQL), create the physical data model for the logical data model provided in the attachment. This should include all of the data definition language SQL.This should be based upon the previous ERD created (see figure bel..
What is a benefit corporation? : What is a benefit corporation?
Write down the value of the gradient of the regression line : Write down the value of the gradient of the regression line and explain what it means in this case. Is the constant or intercept value significant in this case? How do you know this?
Prepare a post-closing trial balance : Prepare a Post-Closing Trial Balance
Program-twos complement : Overview: The real point of this assignment is to give you a chance to work with exceptions. But you can't do anything with exceptions unless there's something that can go horribly wrong, so we need something with plenty of potential for error . ...
Find the pareto optimal allocations : Find the Pareto optimal allocations - Find the best allocation according to the utilitarian criterion and Find the quantity of each good traded, and ?nd each person's actual consumption of ale and bread.
Solution-p1mygrade : a) Name this Solution "p1MyGrade" and this project "MyGrade01". b) Write a simple program that does the following:

Reviews

Write a Review

 

Basic Statistics Questions & Answers

  What is the odds ratio for diabetes in a man age forty five

Evidence of statistical interaction or effect modification. What is the odds ratio for diabetes in a man aged 65 compared with a woman aged 60 (both have the same waist circumference)?

  Which scale will allow to make tallest model

The front hall display case. The display case is 30 inches tall. Which scale will allow her to make the tallest model that will fit in the display case?

  Why to bother testing if true mean is fifty ppm

Obvious tests In many cases, hypothesis testing is used when the evidence is obvious. For example, why would you even bother testing if the true mean is 50 ppm?

  Calculate interval to include all the mean

If 25 quarters are randomly selected calculate an interval that will include 95% of all the mean weights of randomly selected samples of quarters of size 25.

  At the exit the pressure and velocity are 1800 kpa and 619

steam enters an adiabatic nozzle at 4000 kpa 440 degrees celsius with a velocity of 75 ms. at the exit the pressure and

  How many samples would be required if we wished to obtain

planning parenthood reg a national organization that assists teenage mothers with pregnancy estimates that

  In a group of 15 batteries 6 are dead you chose 2 at

in a group of 15 batteries 6 are dead. you chose 2 at random. the expected number of good batteries is 1.2. what is the

  On a normal distribution with a mean of 500 and a standard

on a normal distribution with a mean of 500 and a standard deviation of 97 what percentage of cases will fall between

  Which of the following are categorical or qualitative

the state education department requires local school districts to keep these records on all students age race or

  Each individual letter of the word tennessee is placed on a

each individual letter of the word tennessee is placed on a piece of paper and all 9 pieces of paper are placed in a

  Null hypothesis-alternative hypothesis-investigative

For the following investigative scenarios, state the null hypothesis, and the alternative hypothesis. Also identify the Type 1 and Type 2 errors which can result based on the hypotheses that you defined.

  Testing for equality of mean

Final scores averaged 66 for the treatment group; the SD was 21. For the control group, the figures were 59 and 20. What do you conclude?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd