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.