Purchase Solution

Coefficients of correlation and determination, regression equations, and weighted moving averages

Not what you're looking for?

Ask Custom Question

This posting has 5 examples of how to calculate a coefficient of correlation (r), coefficient of determination (r^2), regression equation, and weighted moving average.

1. The following sample observations were randomly selected.

[table of data] - SEE ATTACHMENT

Determine the coefficient of correlation and the coefficient of determination. Interpret.

2. Bi-lo Appliance Stores has outlets in several large metropolitan areas. The general sales manager
plans to air a commercial for a digital camera on selected local TV stations prior to a sale starting
on Saturday and ending Sunday. She plans to get the information for Saturday-Sunday digital
camera sales at the various outlets and pair them with the number of times the advertisement was
shown on the local TV stations. The purpose is to find whether there is any relationship between
the number of times the advertisement was aired and digital camera sales. The pairings are:

[table of data]

a. What is the dependent variable?
b. Draw a scatter diagram.
c. Determine the coefficient of correlation.
d. Determine the coefficient of determination.
e. Interpret these statistical measures.

3. Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a
relationship between the number of client contacts and the dollar amount of sales. To document
this assertion, Mr. McWhinney gathered the following sample information. The X column indicates
the number of client contacts last month, and the Y column shows the value of sales ($ thousands)
last month for each client sampled.

[table of data]

a. Determine the regression equation.
b. Determine the estimated sales if 40 contacts are made.

4. We are studying mutual bond funds for the purpose of investing in several funds. For this particular
study, we want to focus on the assets of a fund and its five-year performance. The question
is: Can the five-year rate of return be estimated based on the assets of the fund? Nine mutual
funds were selected at random, and their assets and rates of return are shown below.

[table of data]

a. Draw a scatter diagram.
b. Compute the coefficient of correlation.
c. Compute the coefficient of determination.
d. Write a brief report of your findings for parts b and c.
e. Determine the regression equation. Use assets as the independent variable.
f. For a fund with $400.0 million in sales, determine the five-year rate of return (in percent).

5. The yield on a 30-year treasury note at the end of each year since 1990 is recorded below. Compute
a five-year weighted moving average using weights of .1, .1, .2, .3 and .3, respectively.
Describe the trend in yield.

[table of data]

Attachments
Purchase this Solution
Solution Preview

1. The following sample observations were randomly selected.

[table of data]

Determine the coefficient of correlation and the coefficient of determination. Interpret.

The coefficient of correlation (r) is a number between -1 and +1 that measures the linear dependence between two random variables. The limiting values of -1 and +1 indicate perfect negative and perfect positive correlation, respectively; a correlation of zero suggests a complete lack of association between the two variables.

[equations]

See attached Excel spreadsheet for calculations of Sxx, Sxy, and Syy.

r = -.89

The variables x and y have a fairly strong negative relationship. That is, higher values of x are typically associated with lower values of y.

The coefficient of determination (r2) is a measure of the goodness of fit of a regression model that is equal to the square of the coefficient of correlation.

r2 = (-.89) 2 = .79

This means that 79% of the variation in y is explained by the linear relationship with x.

2. Bi-lo Appliance Stores has outlets in several large metropolitan areas. The general sales manager
plans to air a commercial for a digital camera on selected local TV stations prior to a sale starting
on Saturday and ending Sunday. She plans to get the information for Saturday-Sunday digital
camera sales at the various outlets and pair them with the number of times the advertisement was
shown on the local TV stations. The purpose is to find whether there is any relationship between
the number of times the advertisement was ...

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.

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.

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

  • Multiple choice questions

    Correlation b. Linear regression c. Coefficient of determination d. Regression D 10. In adjusted exponential smoothing, the closer beta is to ____________, the stronger a trend is reflected.

  • Linear regression, multiple regression, time series

    CMA: Centered Moving Average: Take average of n periods, and plots the average in the middle period. Exponential Smoothing is a special case of the weighted moving averages method in which we select only the weight for the most recent observation.

  • Appropriate quantitative forecasting methods

    Moving averages (simple moving average, weighted moving average): forecast is based on arithmetic average of a given number of past data points. 2.

  • Why is the trend commonly thought to be the most important c

    Why are simple moving averages and weighted averages commonly used forms of forecasting? Simple moving averages and weighted averages are commonly used forms of forecasting because they smooth the data.

  • Forecasting for Palmdale Human Service Agency

    averages, weighted moving averages, exponential smoothing, and time series regression.

  • Forecast personnel expenses for year 20X5

    averages, weighted moving averages, exponential smoothing, and time series regression.

  • Correlation and regression, hand calculations

    This solution shows details of how to calculate correlation coefficients, and regression coefficients for simple linear regression by hand and gives an interpreation of the slope of the regression equation.

  • Determining Coefficients in Regression Analysis

    197539 Determining Coefficients in Regression Analysis The following sample observations were randomly selected. Please see the attached file. Determine the coefficient of correlation and the coefficient of determination.

  • The answer to Correlation Analysis

    How is coefficient of determination used to make decisions? d. What is the standard error of estimate? Describe with an example. e. What are the coefficients of the linear regression model and what do they mean? f.

View More Related Solutions