Purchase Solution

Scatter plot and Linear Regression Equation Analysis

Not what you're looking for?

Ask Custom Question

13.5 Circulation is the lifeblood of the publishing business. The larger the sales of a magazine, the more it can charge advertisers. Recently, a circulation gap has appeared between the publishers reports of magazines newsstand sales and subsequent audits by the Audit Bureau of Circulations. The data below represent the reported and audited newsstand sales ( in thousands) in 2001 for the following 10 magazines:

Magazine Reported (X) Audited (Y)
YM 621.0 299.6
CosmoGirl 359.7 207.7
Rosie 530.0 325.0
Playboy 492.1 336.3
Esquire 70.5 48.6
TeenPeople 567.0 400.3
More 125.5 91.2
Spin 50.6 39.1
Vogue 353.3 268.6
Elle 263.6 214.3

A. Construct a scatter plot
B. Interpret the meaning of the slope, b in this position
C. Predict the mean audited newsstand sales for a magazine that reports the newsstand sales of 400,000.

13.9 An agent for a residential real estate company in a large city would like to be able to predict the monthly rental cost for apartments, based on the size of the apartment, as defined by the square footage. A sample of 25 apartments in a particular residential neighborhood was selected, and the information gathered revealed the following:

Rent($) Size(SquareFeet)
950 850
1600 1450
1200 1085
1500 1232
950 718
1700 1485
1650 1136
935 726
875 700
1150 956
1400 1100
1650 1285
2300 1985
1800 1369
1400 1175
1450 1225
1100 1245
1700 1259
1200 1150
1150 896
1600 1361
1650 1040
1200 755
800 1000
1750 1200

A. Construct a scatter plot.
B. Use the least squares method to find the regression coefficients b(0) and b(1).
C. Interpret the meaning of b(0) and b(1) in this problem.
D. Predict the mean monthly rent for an apartment that has 1,000 square feet.
E. Why would it not be appropriate to use the model to predict the monthly rent for apartments that have 500 square feet?
F. Your friends Jim and Jennifer are considering signing a lease for an apartment in this residential neighborhood. They are trying to decide between two apartments, one with 1,000 square feet for a monthly rent of $1,275 and with the other 1,200 square feet for a monthly rent of $1,425. What would you recommend to the based on (a) through (d)?

Purchase this Solution
Solution Summary

For the given data, scatter plot togather with the estimated regression eqation is obtained. Interpretation estimated egression coefficient are given and the estimated regression equation is used for prediction. Detailed calculations are provided in the Excel file.

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

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.

View More Free Quizzes
Related BrainMass Solutions

  • Time series & Regression analysis

    228336 Scatter Plot Time Series Part A Scatter plot 1) Does it look linear? Part B Regression Analysis 1.) What is the regression equation? 2.) What are the predictions for 2006 and 2007? Part C Working file 1.)

  • 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.

  • Regression analysis

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

  • Important information about Scatter Plot, Regression

    Create a scatter plot of the data and determine whether a linear relationship is appropriate. (b). Find the regression equation for the data. (c). The Netherlands employs 53,560 postal workers.

  • Personal Income Analysis

    Find the equation of the regression line for the data. Include the regression line in the scatter plot. 5. Use the regression line to predict the personal outlays when the personal income is 5.3 trillion dollars. 6.

  • 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).

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

    There you can see all the detailed results for the Regression model. However, for your purposes, all you need to do is to draw a scatter plot and add a trend line with the equation to tell you what the regression equation is.

  • scatter plot & least squrares regression line

    On the pop up box click on options and select display regression equation and R square value. Looking at the scatter plot the data seems to have a linear relationship. Slope of 21.581 means that every million cars drive 21.581 billion Kms.

  • Simple Linear Regression Analysis

    143752 Simple Linear Regression Analysis One of the editors of a major automobile publication has collected data on 30 of the best-selling cars in the United States.

  • Regression analysis

    Find the equation of the regression line for the given data, linear correlation coefficient, r, and the coefficient of determination, r2,.

View More Related Solutions