WS5-2_PivotTables.docx
The purpose of this document is to review the sections of the research paper template. The research paper template is in APA7 format. It includes a title page, table of contents, List of tables, list of figures, project background, project analysis, project summary, references, and appendices. The table of contents is not automatically updated, so you will need to manually update the page numbers in the table of contents. The project background section was reviewed in the prior workshop.
The three types of Project Analysis techniques are simple linear regression, t test hypothesis testing, and chi-square hypothesis testing. This formative assessment covers the Project Analysis section in more detail, and specifically the simple linear regression analysis. The project analysis section will contain the three forms of analysis needed for these reports to be complete. Both statistics and graphs are imperative to be complete. Any tables or figures shown will need to have APA covered. Tables require a heading of the format Table #<Number>. <Title>. Figure require a caption under them of the format Figure *<Number>. <Title>.
A chi-square test in hypothesis analysis is used for research when you have sample data with two categories and counts in a contingency table format (summary table with one category as rows, one category as columns and counts in the matrix of values). The chi-square test statistic is a calculation that Excel can provide. In a test on a sample, a hypothesis statement is made about the whether the two categorical variables are independent or not. The null hypothesis statement is that the two categorical variables are independent and the alternative hypothesis is that the categorical variables are not independent.

An example analysis is shown below. The H0 statement is that the categorical variables of depth and magnitude are independent. The H1 statement is that the categorical variables of depath and magnitude are not independent .
The judgment is based on 2 methods. The critical value method would compare the chi-square statistic of .1202 to boundary values of +6.63 and if the chi-square statistic is greater you reject the H0. The p-value method rejects H0 if the p-value is lower that the level of significance. In this case, .7288 is not lower than .01, so do not reject H0.

ASSESSMENT:
Match the following pieces of information to the correct answers.
2 Methods of judging H0 categorical variables are independent
p-value is lower than the level of significance Critical value or p-value
H0 for the analysis above True

ANSWERS
2 Methods of judging H0 categorical variables are independent
p-value is lower than the level of significance Critical value or p-value
H0 for the analysis above True

Chi-Square TestIs depth of earthquake independent of the magnitude?
Use .01 level of significance and quake raw data in worksheet RawData to summarize into counts.
Magnitude (Richter)0-1010-20Total
Notice that >1 takes into account 2 lines of the pivot.
0-111920
Entering values correctly into table: (10 points)
>1151530
Total262450
DO NOT touch the non-blue areas of the tables.
Magnitude (Richter)0-1010-20Total
0-110.40009.600020
>115.600014.400030
Total262450
Level of Significance0.01
Entering correct alpha value (10 points)
Number of Rows2
Number of Columns2
Degrees of Freedom1
Critical Value6.6349
Chi-Square Test Statistic0.1202
p-Value0.7288
Observed Frequencies
Depth (km)
Do not reject the null hypothesis
Expected Frequencies
Depth (km)
Data
Results