Explore BrainMass
Share

determine the correlation coefficient r

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Meryl's Apparel is an upscale chain of women's clothing stores, located primarily in the southwest United States. Due to recent success, Meryl's top management is planning to expand by locating new stores in other regions of the country. The director of planning has been asked to study the relationship between yearly sales and the store size. As part of the study, the director selects a sample of 25 stores and determines the size of the store in square feet and the sales for last year. The sample data follow. The use of statistical software is suggested.

a. Draw a scatter diagram. Use store size as the independent variable. Does there appear to be a relationship between the two variables. Is it positive or negative?
b. Determine the correlation coefficient and the coefficient of determination. Is the relationship strong or weak? Why?
c. At the 0.5 significance level, can we conclude there is a significant positive correlation?

© BrainMass Inc. brainmass.com October 25, 2018, 6:44 am ad1c9bdddf
https://brainmass.com/statistics/correlation/determine-the-correlation-coefficient-r-474066

Attachments

Solution Summary

In this solution, first, a scatter plot is presented in the excel. From the plot, we could estimate if the correlation is positive or negative. Meanwhile, the more quantitative analysis for the correlation coefficient and coefficient of determination could be found in the solution. Finally, a hypothesis test is laid out to examine if the correlation coefficient is significant.

$2.19
See Also This Related BrainMass Solution

Determining Sample Correlation Coefficients

1. The following statistics were calculated from pairs of observations where X represents the independent variable and Y represents the dependent variable.

Σx = 511 Σy = 314 Σxy = 19,064
Σx^2 = 34,234.5 Σy^2 = 13,036 n = 8

Determine the least squares line.
Determine the sample correlation coefficient between X and Y.
Determine if there is a linear relationship between X and Y at the .10 significance level.
Find a 90% confidence interval for the slope of the regression line.
Find a 90% confidence interval for the mean of Y if X = 60.
Find a 90% prediction interval for Y if X = 60.

View Full Posting Details