Purchase Solution

Scatter Plot, Trendline Equation, Correlation and Regression

Not what you're looking for?

Ask Custom Question

1. Make an Excel scatter plot. What does it suggest about the population correlation between X and Y?

Part-Time Weekly Earnings ($) by College Students

Hours Worked (X) Weekly Pay (Y)
10 93
15 171
20 204
20 156
35 261

2. Make an Excel scatter plot. What does it suggest about the population correlation between X and Y? (Add the equation to the chart)

Data Set Telephone Hold Time (min.) for Concert Tickets
Operators (X) Wait Time (Y)
4 385
5 335
6 383
7 344
8 288

3. Interpret the slope of the fitted regression HomePrice = 125,000 + 150 SquareFeet. (b) What
is the prediction for HomePrice if SquareFeet = 2,000? (c) Would the intercept be meaningful if
this regression applies to home sales in a certain subdivision?

4. Choose one of these three data sets. (a) Make a scatter plot. (b) Let Excel estimate the regression line, with fitted equation and R2. (c) Describe the fit of the regression.

Commercial Real Estate (X = assessed value, $000; Y = floor space, sq. ft.)

Assessed Size
1,796 4,790
1,544 4,720
2,094 5,940
1,968 5,720
1,567 3,660
1,878 5,000
949 2,990
910 2,610
1,774 5,650
1,187 3,570
1,113 2,930
671 1,280
1,678 4,880
710 1,620
678 1,820

Attachments
Purchase this Solution
Solution provided by:
Anwesha Ghosh, MSc
Education
  • MSc, Osmania University
  • MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
  • BSc, Banaras Hindu University
Recent Feedback
  • "Very fast turnaround. Excellent communication! Much appreciated!"
  • "excellent"
  • "excellent"
  • "excellent work"
  • "Fantastic..great solution and very well explained!!!!"
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.

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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Regression and Correlation

    This solution shows how to create a scatter diagram, compute the coefficient of correlation, and determine the regression equation in Excel for the given problem.

  • Statistics of simple regression analyses

    Be sure to present three regression equations with R-squared value and three graphs. Provide the following summary table. Make an XY (scatter) plot and include the trendline.

  • Regression Analysis: AIU Job Satisfaction Data Base

    a b R2 1) 2) 3) Make an XY (scatter) plot and include the trendline. In Excel, you need to highlight the two columns you want to graph to make the scatter gram.

  • Regression analysis using BENEFITS column

    Solution: Scatter plot representing Overall and Benefits Regression Analysis r² 0.035 n 25 r -0.188 k 1 Std. Error 1.255 Dep. Var.

  • Scatter diagram, regression

    I have done the problem using excel and the inbuilt capabilities of excel to calculate the regression equation. You can do this by first creating a scatter plot on excel and then adding a trendline from the pull down menu. Hope it is clear.

  • Linear Regression and Correlation Analysis

    Linear regression and correlation analysis is examined. The expert develops a scatter plot for the data.

  • Linear Regression in Excel

    Use the data from Exercise #14.1 (see below) and (a) Plot a scatter diagram, (b) Show the linear trendline on the plot using, (c) Add the trendline equation, and (d) predict the sales for the years 2001 and 2002, (e) Compare with the actual

  • Scatter Plot Graph in Excel

    232575 Scatter Plot Trendline Regression (a) Use Excel to make a scatter plot of the data.

  • Regression Analysis: 4 Steps for Benefits and Job Satisfaction

    . ** please see the attached files for the complete solution response ** This solution provides a detailed explanation of the given regression analysis problem and includes an Excel formatted scatter plot for all three regressions.

View More Related Solutions