Purchase Solution

Linear Regression

Not what you're looking for?

Ask Custom Question

Barron's conducts an annual review of online brokers, including both brokers that can be accessed via a Web browser, as well as direct-access brokers that connect customers directly connected with the broker's network server. Each broker's offerings and performance are evaluated in six areas using a point value of 0-5 in each category. The results are weighted to obtain an overall score, and a final star rating, ranging from zero to five stars, is assigned to each broker. Trade execution, ease of use, and range of offerings are three of the areas evaluated. A point value of 5 in the trade execution area means the order entry and execution process flowed easily from one step to the next. A value of 5 in the ease of use area means that the site was easy to use and can be tailored to show what the user wants to see. A value of 5 in the range offerings area means that all of the investment transactions can be executed online. The following data show the point values for trade execution, ease of use, range of offerings, and the star rating for a sample of 10 of the online brokers that Barron's evaluated.

Problem

Using alpha = .05

A. Determine the estimated regression equation that can be used to predict the start rating given the point values for execution, ease of use, and range of offerings, and briefly interpret the findings. Note: (keep all three independent variables in the regression model even if you find some independent variable(s) that is/are NOT statistically significant).

B. Use the F test to determine the overall significance of the relationship. What is the conclusion at the .05 level of significance? Note: Formulate the relevant hypotheses before you work on SPSS analysis.

C: Use the t test to determine the significance of each independent variable. What is your conclusion at the .05 level of significance? Note: Formulate the relevant hypotheses before you work on SPSS analysis

See attached problem and data file for more information.

Must be done in SPSS so I can see how the answers were arrived at. Prefer the steps to solve in SPSS be included.

Attachments
Purchase this Solution
Solution Summary

Solutions and complete explanations are included. All necessary SPSS steps are also included.

Solution Preview

Using SPSS exclusively:

Background

Barron's conducts an annual review of online brokers, including both brokers that can be accessed via a Web browser, as well as direct-access brokers that connect customers directly connected with the broker's network server. Each broker's offerings and performance are evaluated in six areas using a point value of 0-5 in each category. The results are weighted to obtain an overall score, and a final star rating, ranging from zero to five stars, is assigned to each broker. Trade execution, ease of use, and range of offerings are three of the areas evaluated. A point value of 5 in the trade execution area means the order entry and execution process flowed easily from one step to the next. A value of 5 in the ease of use area means that the site was easy to use and can be tailored to show what the user wants to see. A value of 5 in the range offerings area means that all of the investment ...

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

Measures of Central Tendency

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

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.

View More Free Quizzes
Related BrainMass Solutions

  • Relationship of Linear Regression & Correlation

    622757 Relationship of Linear Regression & Correlation When is it appropriate to use linear regression? What is the relationship between linear regression and correlation?

  • Discuss the definition of linear regression

    595859 Discuss the definition of linear regression What is linear regression? Can you give an example? Answer: linear regression is a tool to check the relationship between two variables.

  • simple linear regression models

    169332 simple linear regression models Develop simple linear regression models for predicting Games Won as a function of each of the independent variables in the 2000 NFL Data.xls worksheet individually.

  • Simple Linear Regression and Multiple Regression.

    Simple Linear Regression and Multiple Regression.

  • Advantages of Linear Regression in Complex Situations

    330240 Advantages of Linear Regression in Complex Situations How does a linear regression allow us to better estimate trends, costs, and other factors in complex situations? Linear regression estimates the line of best fit for any given data.

  • Simple Regressions and Multiple Regressions

    How is regression used to generate prediction equations in SPSS? How are prediction equations used to make predictions? What is multiple linear regression? How are predictions made using multiple linear regression equations?

  • Regression analysis and simple linear regression

    The following results were obtained as part of a simple linear regression analysis. MSE = 25.485.

  • ABC Furniture Company Linear Regression

    626456 ABC Furniture Company Linear Regression See Attached Background: Linear Regression Forecasting and Decision Trees Why is Forecasting important? How can we use Linear Regression as a forecasting method?

  • Theory, analysis and interpretation of regression

    Since in regression we need to solve for the coefficients of the regression line, matrix method can be used to this end. In this way, linear algebra can help perform linear regression.

  • Linear long-term trend.

    125118 Linear long-term trend. If a long-term trend is linear, how can regression analysis be adjusted to make business decisions? Regression analysis fits the least squares line to available data.

View More Related Solutions