Multiple regression models using excel

Reference no: EM1396412

Managers at Beta Technologies, Inc., have collected current annual salary figures and potentially related data for a random sample of 52 of the company's full-time employees. The data are in the file P2_1.XLS set out below. These data include each selected employee's gender, age, number of years of relevant work experience prior to employment at Beta, the number of years of employment at Beta, and the number of years of post-secondary education.

PROBLEM: Using Excel where possible to generate data and analysis, solve the following:

(a) Estimate a multiple regression model to explain the variation in employee salaries at Beta Technologies using all of the potential explanatory variables.

(b) Using your regression output, determine which of the explanatory variables should be excluded from the regression equation. Provide reasoning for your decision to remove each such variable.

Reference no: EM1396412

Questions Cloud

Probability related to car service in a specific month : A car rental company has determined that the probability a car will need service work in any given month is 0.2. The company has 900 cars.

Illustrate what type of research design was used : Then, attitudes toward abortion were measured for respondents in both groups. Illustrate what were the independent also dependent variables in this experiment? Illustrate what type of research design was used?

Describe the causes of turmoil in egypt : Describe the causes of turmoil in Egypt in early 2011. Explain at least two perspectives on circumstances. Appraise the prospects for Muslim brotherhood.

Determine the volume of plasmid dna in ul : The final elution of your miniprep plasmid DNA has a concentration of 250 ng/uL. You need to load 500 ng on an agarose gel to be able to see the DNA.

Multiple regression models using excel : Managers at Beta Technologies, Inc., have collected current annual salary figures and potentially related data for a random sample of 52 of the company's full-time employees.

Identify key problems blockbuster having success : Identify the key problems Blockbuster is having with achieving success with its recent acquisition of Movie link. Provide specific recommendations on Explain how Blockbuster should rectify these problems.

Interpreting regression output : A researcher used stepwise regression to create regression models to predict BirthRate (births per 1,000) using five predictors

Econo-tankers for short run-low and demand routes : In, addition, the company has decided to purchase at least three of the new Econo-Tankers for use on short-run, low-demand routes. As a final constraint, the conpany deos not want more than half the new models to be Super Tankers.

Portal for selective export of mrna out of the nucleus : What is the portal for selective export of mRNA out of the nucleus? When microtubules grow out of a centrosome, which end is oriented away from the centrosome?

User Account

All Pages