19th Ave New York, NY 95822, USA

# 统计代写|一般统计学代写General Statistics代考|CIVL2530 How Do I Compute a Correlation Coefficient?

my-assignmentexpert™提供最专业的一站式服务：Essay代写，Dissertation代写，Assignment代写，Paper代写，Proposal代写，Proposal代写，Literature Review代写，Online Course，Exam代考等等。my-assignmentexpert™专注为留学生提供Essay代写服务，拥有各个专业的博硕教师团队帮您代写，免费修改及辅导，保证成果完成的效率和质量。同时有多家检测平台帐号，包括Turnitin高级账户，检测论文不会留痕，写好后检测修改，放心可靠，经得起任何考验！

## 统计代写|一般统计学代写General Statistics代考|How Do I Compute a Correlation Coefficient?

correlation coefficient is computed by inserting the proper values into a simple question.
The formula is as follows:
$$r_{x y}=\frac{n \Sigma X Y-\Sigma X \Sigma Y}{\sqrt{\left[n \Sigma X^2-(\Sigma X)^2\right]\left[n \Sigma Y^2-(\Sigma Y)^2\right]}}$$
where
$r_{x y}$ is the correlation coefficient between $X$ and $Y$;
$n$ is the size of the sample;
$X$ is the individual’s score on the $X$ variable;
$Y$ is the individual’s score on the $Y$ variable;
$X Y$ is the product of each $X$ score times its corresponding $Y$ score;
$X^2$ is the individual’s $X$ score, squared; and
$Y^2$ is the individual’s $Y$ score, squared.
For example, let’s compute the correlation coefficient, represented as a lowercase $r_{x y}$ for the the variables $X$ and $Y$, using the following data:

With the values substituted, the equation looks like this:
$$r_{x y}=\frac{10(360)-(46)(74)}{\sqrt{\left[10(238)-(46)^2\right]\left[10(578)-(74)^2\right]}}=.69$$
And the result is that $r_{x y}$ equals $.69$, a positive or direct correlation.

## 统计代写|一般统计学代写General Statistics代考|How Can I Use Excel to Compute a Correlation Coefficient?

To compute the correlation coefficient using Excel, you use the =CORREL function. We will be using the same set of data you saw in question #44.
If you are using a Mac or a PC, follow these steps:

Enter $=$ CORREL in the cell where you want the results to appear.

Enter the first data array, a comma, and then the second data array. The completed function should appear as shown in Figure $45.1$.

Press the Enter key, and as you will see, the correlation of 69 (rounded to the nearest 100 th) is returned to the cell in which the function is located.

If you are using the Windows version of Excel, you can also take advantage of the Correlation option in the Data Analysis ToolPak. To do this, follow these steps:

Click Data $\rightarrow$ Data Analysis, and you will see the Data Analysis Toolpak dialog box.

Double-click the Correlation option.

Complete the Correlation dialog box as you see in Figure $45.2$, indicating the Input Range, the Output Range, and whether you want to include column labels in the output.

Press the Enter key, and the resulting correlation matrix will appear as shown in Figure $45.3$.

## 统计代写一般统计学代写GENERAL STATISTICS代考|HOW DO I COMPUTE A CORRELATION COEFFICIENT?

$$r_{x y}=\frac{n \Sigma X Y-\Sigma X \Sigma Y}{\sqrt{\left[n \Sigma X^2-(\Sigma X)^2\right]\left[n \Sigma Y^2-(\Sigma Y)^2\right]}}$$

$r_{x y}$ 是之间的相关系数 $X$ 和 $Y$;
$n$ 是样本的大小;
$X$ 是个人在 $X$ 多变的;
$Y$ 是个人在 $Y$ 多变的; $X Y$ 是每个的产品 $X$ 得分乘以对应的 $Y$ 分数;
$X^2$ 是个人的 $X$ 得分，平方；和
$Y^2$ 是个人的 $Y$ 分数，平方。

$$r_{x y}=\frac{10(360)-(46)(74)}{\sqrt{\left[10(238)-(46)^2\right]\left[10(578)-(74)^2\right]}}=.69$$

## Matlab代写

MATLAB 是一种用于技术计算的高性能语言。它将计算、可视化和编程集成在一个易于使用的环境中，其中问题和解决方案以熟悉的数学符号表示。典型用途包括：数学和计算算法开发建模、仿真和原型制作数据分析、探索和可视化科学和工程图形应用程序开发，包括图形用户界面构建MATLAB 是一个交互式系统，其基本数据元素是一个不需要维度的数组。这使您可以解决许多技术计算问题，尤其是那些具有矩阵和向量公式的问题，而只需用 C 或 Fortran 等标量非交互式语言编写程序所需的时间的一小部分。MATLAB 名称代表矩阵实验室。MATLAB 最初的编写目的是提供对由 LINPACK 和 EISPACK 项目开发的矩阵软件的轻松访问，这两个项目共同代表了矩阵计算软件的最新技术。MATLAB 经过多年的发展，得到了许多用户的投入。在大学环境中，它是数学、工程和科学入门和高级课程的标准教学工具。在工业领域，MATLAB 是高效研究、开发和分析的首选工具。MATLAB 具有一系列称为工具箱的特定于应用程序的解决方案。对于大多数 MATLAB 用户来说非常重要，工具箱允许您学习应用专业技术。工具箱是 MATLAB 函数（M 文件）的综合集合，可扩展 MATLAB 环境以解决特定类别的问题。可用工具箱的领域包括信号处理、控制系统、神经网络、模糊逻辑、小波、仿真等。