Purchase Solution

Multiple Regression Models Using Excel

Not what you're looking for?

Ask Custom Question

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. 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.

Purchase this Solution

Solution Summary

Multiple regression models using excel for Beta Technologies Inc. are given. The variation in employees salaries are given through this analysis.

Purchase this Solution


Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.