Purchase Solution

Regression analysis using Excel

Not what you're looking for?

Ask Custom Question

In regression analysis, if a person spends $20 how much can he expect to win for the below

money spent money won
16 330
12 270
18 380
14 300

Would I use excel and what formula would I use?

Purchase this Solution
Solution Summary

This provides a brief example of setting up regression analysis in Excel.

Purchase this Solution
Free BrainMass Quizzes
Probability Quiz

Some questions on probability

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

View More Free Quizzes
Related BrainMass Solutions

  • Statistics - Regression using Excel

    142818 Regression Analysis using Excel. For the complete description of the problem, please see the specific problem posted. Using Excel as your processing tool, work through three simple regression analysis.

  • Regression analyses with Excel data analysis

    220010 Regression analyses using Excel data analysis add-in Details: Using Excel as your processing tool, work through three simple regression analyses.

  • Using Excel as your processing tool

    258689 Using Excel as your processing tool Using Excel as your processing tool, work through three simple regression analyses.

  • Benefits of regression analysis

    235585 Benefits of regression analysis Using Excel as your processing tool, work through three simple regression analyses. 1.

  • Multiple Regression Models Using Excel

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

  • Regression Analysis: 4 Steps for Benefits and Job Satisfaction

    280572 Regression Analysis: 4 Steps for Benefits and Job Satisfaction First run a regression analysis using the benefits column of all data points in the data set as the independent variable and the intrinsic job satisfaction column of all data points

  • Using excel to perform hypothesis testings

    TEST #1: Regression Analysis- Benefits & Intrinsic Perform the following Regression Analysis, using a .05 significance level Run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and

  • Regression Analysis: Analyzing Job Satisfaction

    364283 Regression Analysis: Analyzing Job Satisfaction Prepare a report using Excel as your processing tool to process 3 simple regression analyses. Create a graph with the trend-line displayed for each of the 3 different regressions. 1.

  • Correlation and Regression Analysis

    B) Draw a scatter diagram ([first input you data in excel column A & B. Use MegaStat, correlation/regression, scatterplot or use Excel, Tools, data analysis, regression function to answer questions c-e].

View More Related Solutions