Purchase Solution

Scatter plot & Linear Regression

Not what you're looking for?

Ask Custom Question

The IRS wants to develop a method for detecting whether or not individuals have overstated their deductions for charitable contributions on their tax returns. To assist in their efforts, the IRS supplied data found in the file DAT9-&.xlsx (attached), listing the adjusted gross income (AGI) and charitable contributions for 11 tax-payers whose returns were audited and found to be correct.

A. Prepare a scatter plot of the data. Does there appear to be a linear relationship between these variables?
B. Develop a simple linear regression model that can be used to predict the level of charitable contributions from a return's AGI. What is the estimated regression equation?
C. Interpret the value of R2.
D. How might the IRS use the regression results to identify returns with unusually high charitable contributions?

Attachments
Purchase this Solution
Solution Summary

Scatter plot & Linear Regression for IRS to detect overstated deductions for charitable

Solution Preview

See attached file.

1. See attachment for the scatter plot. It does appear to have a linear relationship.

2. The model excel has developed is y = 159.7x - 6169.9, where x is the adjusted gross income, and y is charitable contributions.

3. ...

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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

  • Scatter plot, correlation and linear regression

    The expert examines the scatter plot, correlation and linear regression.

  • scatter plot & least squrares regression line

    10265 Scatter Plot & Least Squrares Regression Line See the attached file. a. Create a scatter plot of the data. Do you think that there is a linear relationship between number of kilometers traveled and the number of cars? b.

  • Correlation Coefficient and Linear Regression

    The solution creates a correlation coefficient and linear regression for a scatter plot. A complete, neat and step-by-step solution is provided in the attached file.

  • Linear Regression: Limiting and Empowering Factors

    Once the scatter plot has been made, the trendline feature of Excel can be used to fit the linear regression line and state the value of the coefficient of determination R^2.

  • Regression

    10641 Regression A). Create a scatter plot (using excel) of the data. b). Find the equation of the linear regression line. c). Plot the regression line on the same plot as the data. d). How well do you think the line fits the data? e).

  • Regression analysis

    198747 Scatter Plot and Trend Line Please see the attached file. Please answer these questions based on the data file Packages. a.

  • Correlation aand regression analysis

    Construct a scatter plot. What does it suggest about the relationship between x and y? The points in the scatter diagram are away from the regression line. Thus non linear relationship is more suitable here. D. Construct a residual plot.

  • Regression model husband's education & wife's education

    Using the Graphs menu, make a scatter plot of husband's education against wife's education (variables husbeduc and wifeduc). Edit the chart to draw the regression line and print R². Graph (scatter plot with regression line).

  • Excellent Manufacturing Company lean six sigma project case

    The scatter plot looks linear, so we use linear regression to find linear regression equation y = 0.295x + 96.43. In the generated scatter plot using excel, we add a trendline to show the equation of the linear fit.

View More Related Solutions