Purchase Solution

Using Excel: Correlation Work

Not what you're looking for?

Ask Custom Question

Please see the attached Excel worksheet for my questions on correlation.

I need to answer the following questions:

A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements.
B) Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure.
C) What is the best predicted value for diastolic pressure given that a woman has a systolic level of 100?

Attachments
Purchase this Solution
Solution Summary

The expert uses excel to examines correlation work.

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

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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

  • Scatter Plots and Correlation Coefficients

    Use Excel to construct a scatter plot. Compute the correlation coefficient by using columns in excel. You may use excel to do the hand computations. In other words you may use excel to sum up the column compute the squares of each column, etc.

  • Correlation & Regression

    The technology manual that was packaged with your book has an Excel section that can help with the graphing. Section 9.1 : Correlation 1. Construct a scatter plot using excel for the given data.

  • Bivariate Regression in Excel

    Use these sums to calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1,array2). Find t.05 for a two-tailed test for zero correlation. (d) Calculate the t test statistic. Can you reject rho = 0?

  • Spearman's correlation coefficient

    20539 Spearman's correlation coefficient Hello, I need to find out the Spearman's correlation coefficient of the attached data, I have analysed it using an Excel macro and come up with a different result from when I worked it out manually, using forumlas

  • Solve question on scatter plot, relationship, outlier, causality

    b) Using the same data conduct a correlation analysis using SPSS or Excel. What is the correlation coefficient? Is it a strong, moderate or weak correlation? Is the correlation significant or not? If it is what does that mean?

  • T test for Significance of correlation & Scatter plot

    (b) Make an Excel worksheet to calculate SSxx , SSyy , and SSxy . Use these sums to calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1,array2).

  • Statistics: Advertising and sales, correlation analysis

    Hello Please see the excel file attached for the calculations. Worksheet "Calculation of correlation coeff" contains calculations for correlation coeff. using formula.

  • Regression analysis

    What does it suggest about the correlation between X and Y? (b) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient. (c) Use Excel or Appendix D to find t.05 for a two-tailed test.

  • Correlation Coefficient, Coefficient of Determination and ANOVA

    Using the coefficient of correlation and coefficient of determination in Part B, calculate the t test for the coefficient of correlation. Ho: p = 0 H1: p ≠ 0 a. b. t = c.

View More Related Solutions