Purchase Solution

REGRESSION MODELING IN EXCEL

Not what you're looking for?

Ask Custom Question

Using the BANK.SAV data file, construct a multiple regression model to test whether there is gender discrimination in the bank. The model should include one or more continuous variables and one or more dichotomous variables.

Please submit to me the output you generate
Describe your rationale for including the variables that you did
Assess the quality of the model you constructed and
discuss improvements you would like to make in the model.

Attachments
Purchase this Solution
Solution Summary

This Solution contains over 400 words and calculations to aid you in understanding the Solution to this question.

Purchase this Solution
Free BrainMass Quizzes
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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Regression Analysis - Operational Management

    241018 Regression Analysis - Operational Management. This is a problem #12, chapter 9 - Regression Analysis, from the textbook by Cliff Ragsdale, "Spreadsheet Modeling and Decision Analysis".

  • Regression Analysis - Operational Management

    241019 Regression Analysis Modeling - Operational Management This is a problem #13, chapter 9 - Regression Analysis, from the textbook by Cliff Ragsdale, "Spreadsheet Modeling and Decision Analysis".

  • Regression Analysis and Operational Managment

    242539 Regression Analysis and Operational Managment This is a problem #13, chapter 9 - Regression Analysis, from the textbook by Cliff Ragsdale, "Spreadsheet Modeling and Decision Analysis".

  • Regression Analysis and Operational Management

    This problem requires the use of Excel and the add-in, called Solver. The course is Excel-based and Solver is the optimization application used for all problems. Scatter plot of the data need to be prepared. Answer A.

  • Regression Analysis and Sales Forecasting

    From her recollection of her undergraduate course in statistics, she thought of regression analysis as a possibility in modeling new franchise sales.

  • Regression - 3 period moving average, and forecasting

    Plot the sales data in a chart in Excel. a. Add trend line to the chart b. Create a separate chart with a 3-period moving average. ii. Use Excel's regression function to estimate the trend line and produce a forecast for four periods ahead.

  • Regression Model to Predict Accounts Receivable

    The project will be graded on the accuracy of calculations, knowledge and understanding of the modeling topic, demonstration of Excel skills, and presentation, in relation to these specified criteria, and with consideration of the end-product to those

  • What is the linear regression and 5-month moving average forecast for the sales data?

    Regression Analysis Regression analysis includes any techniques for modeling and analyzing several variables, when the focus is on the relationship between a dependent variable and one or more independent variables.

  • Economic modeling and forcasting future events

    Multiple regression can establish that a set of independent variables explains a proportion of the variance in a dependent variable at a significant level (through a significance test of R^2).

View More Related Solutions