英语论文网

• For this project you will investigate the correlation between the subjects: Maths, Business, and Economics. On Blackboard, there is a file called: Semester 1 Scores (Bus).xlsx. This file contains all of the scores on the semester 1 finals for all three subjects. Your goal for this project is to choose 2 subjects and calculate the PPMCC and the line of best fit for your data. You will then create a scatter-plot graph that shows the data and includes the line of best fit. You are to do this twice. 对于这个项目，你将调查之间的相关科目：数学，商务和经济。在黑板上，有一个名为：第1学期成绩（巴士）的。xlsx 。该文件包含所有上学期1决赛的所有三个科目的分数。为这个项目，你的目标是选择2个科目和计算PPMCC的和最适合您的数据线。然后，您将创建一个散点图图表显示的数据，包括最佳拟合线。你做到这两次。
回想一下，你需要的公式是：

• Recall that the formulas you will need are:

Deadlines and Marks 截止日期和注意

• This project is worth 10% of your Maths year mark. 这个项目是你的数学年商标价值的10％。

• The project must be completed and submitted to your teacher and to TurnItIn during your ICT class, the week beginning May 9th. •项目必须完成并提交给你的老师，在您的信息和通信技术类， 5月9日开始的一星期Turnitin的。

What you need to include: 您需要什么，包括：

• Before beginning this project, you need to open up the Excel file that includes all of the data. Sort the data (according to the “random numbers” column) from smallest to largest. (SEE PICTURE BELOW) •在这个项目开始之前，你需要打开的Excel文件包含的所有数据。对数据进行排序（根据“随机数”一栏），从最小到最大。（见下图）

Now you will select the first 15 numbers from each column that you want to investigate. For example, if you are going to be comparing Business and Maths, then you need to copy the cells from A3: A17 and the cells from C3:C17 and paste into a new Excel file and label the columns. This will be your data that you will use to calculate the PPMCC and the line of best fit. (See picture below) 现在，您将选择15个号码，从每列要调查。例如，如果你要进行比较和数学，那么你需要复制的细胞从A3 ： A17和细胞C3 ： C17和粘贴到一个新的Excel文件和标签列。这将是您的数据，您将使用，计算PPMCC最佳拟合线。（见下图）

Create the necessary table to find the information you need to calculate the PPMCC and the line of best fit. 创建必要的表中找到您需要的信息来计算PPMCC和最佳拟合线。

• Show (using equation editor) all of the calculations used to find the PPMCC and the line of best fit.

• You will need to repeat the above again so that you have 2 sets of graphs. Choose 2 different subjects to compare the second time.
• Include an introduction that explains what the project will be trying to find and how. Explain what correlation is and how it is going to be used in your project.
• Include a conclusion that explains your findings.
• Include paragraphs after each table and graph explaining what you are doing and how you have done it.
Use correct formatting procedures that you learned in Semester 1, which include headers, footers, font, font size, line spacing, justified paragraphs, names/titles for all tables and graphs, axis labels for all graphs, and correct formatting for tables. The project should look professional.
• Use the Academic Writing Guide (also on Blackboard) for advice on what to include