Purchase Solution

Scatter plot, correlation coefficient, and a hypothesis test

Not what you're looking for?

Ask Custom Question

(a) Make a scatter plot of the data. What does it suggest about the correlation between X and Y? (b) Use Megastat or Excel to calculate the correlation coefficient. (c) Use Excel to find t.05 for a two-tailed test. (d) Calculate the t test statistic (e) Calculate critical value of ra. (f) Can you reject p=0?

Orders(X) Shipping (Y)
1068 4489
1026 5611
767 3290
885 4113
1156 4883
1146 5425
892 4414
938 5506
769 3346
677 3673
1174 6542
1009 5088

Not sure on which formulas to use. Thanks

Purchase this Solution
Solution Summary

Scatter plot, correlation coefficient and hypothesis tests are analyzed using Excel. The t test and critical value is calculated.

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

  • Correlation Analysis for Given X and Y

    Solution explains step by step method for finding correlation coefficient between X and Y. Scatter Diagram is plotted and significance test is conducted for correlation between X and Y.

  • Scatter Plots and Correlations

    143748 Scatterplots, regression, and correlation [See the attached file for Baldor Electric Co. Information.] a. Plot the variables Net Sales (y) and Working Capital (x) in scatter-plot format.

  • Statistics

    341648 Statistics Problem 1 Consider the following prices and accuracy ratings for 27 stereo speakers. (a) Make a scatter plot of accuracy rating as a function of price. (b) Calculate the correlation coefficient. At ?

  • Correlation and regression: key informaiton

    Test the level of significance of the correlation coefficient r. Use a = 0.05. 4. Find the equation of the regression line for the data. Include the regression line in the scatter plot. 5.

  • Correlation/Linear Regression

    Construct a scatter plot using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r.

  • Statistics: Sex, Weight, GPA, Smoker and Arm and Leg Length

    In the above scatter plot weight (y) has been plotted against height (x). The scatter-plot exhibits a positive linear relationship between height and weight. As height increases, weight increases and vice versa.

  • Regression analysis

    222559 Regression analysis: scatter plot, correlation, hypothesis testing, and estimation. 12.4 a. Make a scatter plot. b. Calculate correlation coefficient. c. Calculate coefficient of determination. d.

  • Statistics -Correlation Hypothesis and Regression Hypothesis

    268541 Statistics -Correlation Hypothesis and Regression Hypothesis Please assist with a 5-step hypothesis test on the slope of a linear regression line. I have the scatter plot, line of best fit (including equation of the line).

  • Testing for Linear Correlation

    497621 Testing for Linear Correlation Testing for a linear correlation. Construct a scatter plot, find the value of the linear correlation coefficient r, and find the critical values of r from the table below using a=0.05.

View More Related Solutions