STA 320 Indiana Wesleyan University Chi Square and Analysis of Variance Excel Task

Description

 create a  pivot table from raw data and then use Excel to perform chi-square  hypothesis testing. Then, you will interpret the results to make  judgments in a given scenario.
Upon successful completion of the course material, you will be able to:
Perform chi-square hypothesis testing using an Excel template.

Resources
Textbook: Essentials of Statistics
Video: Chi-Square

File: WS5Practice (Excel)

Instructions
In your textbook, Essential Statistics, read Chapter 11, “Chi-Square and Analysis of Variance,” focusing on Section 11-3, “One-Way Analysis of Variance.”
Watch the video “Chi-Square”  explaining the Excel skills you will need to complete the practice  problem.MAG (Richter scale) DEPTH (km)
0.70
6.6
0.74
2.0
0.64
15.3
0.39
17.2
0.70
3.2
2.20
2.2
1.98
14.8
0.64
5.6
1.22
6.1
0.20
9.1
1.64
18.5
1.32
8.1
2.95
10.0
0.90
1.76
1.01
1.26
0.00
0.65
1.46
1.62
1.83
0.99
1.56
0.40
1.28
0.83
1.34
0.54
1.25
0.92
1.00
0.79
0.79
1.44
1.00
2.24
2.50
1.79
1.25
1.49
0.84
1.42
1.00
1.25
1.42
1.35
0.93
0.40
1.39
10.0
10.0
10.0
10.0
10.0
10.0
10.0
13.7
4.5
8.3
6.0
14.2
5.4
17.7
9.9
17.3
5.1
5.3
15.9
13.7
4.2
5.7
5.9
15.1
8.5
14.7
16.4
4.7
8.6
8.2
15.2
10.1
14.5
5.2
7.9
3.3
6.4
Place your pivot table here:
This is what the pivot table should look like:
This is STEP 1 of the process to create the pivot table.
Chi-Square Test
Is depth of earthquake independent of the magnitude?
Use .01 level of significance and quake raw data in worksheet RawData to summarize into c
Observed Frequencies
Depth (km)
Magnitude (Richter)
0-10
10-20
Total
0-1
>1
Total
0
0
0
Expected Frequencies
Depth (km)
Magnitude (Richter)
0-10
10-20
0-1
#DIV/0!
#DIV/0!
>1
#DIV/0!
#DIV/0!
Total
#DIV/0!
#DIV/0!
Data
Level of Significance
Number of Rows
Number of Columns
Degrees of Freedom
0.01
0
0
1
Results
Critical Value
Chi-Square Test Statistic
p -Value
Do not reject the null hypothesis
6.6349
0.0000
1.0000
0
0
Total
#DIV/0!
#DIV/0!
#DIV/0!
ata in worksheet RawData to summarize into counts.
Notice that >1 takes into account 2 lines of the pivot.
NOTE:
Your counts will come from the RawDat
when you create the pivot table there.
This is step 2 of the process.
Entering values correctly into table: (10 points)
Access this helpful video: Video
DO NOT touch the non-blue areas of the tables.
This is what the rows 33 through 43 should look like:
Entering correct alpha value (10 points)
from the RawData tab

Purchase answer to see full
attachment

We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.