Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Part Three: Excel Questions On Canvas in the z/t/chi-squared module there is a dataset called ASU wins per season which consists of ASU football wins

image text in transcribed
Part Three: Excel Questions On Canvas in the z/t/chi-squared module there is a dataset called "ASU wins per season" which consists of ASU football wins from 2000-2022. Using Excel calculate the following. Write how you got the calculations (e.g. "I used =average(B1::B54)". 4) Using a z-test, calculate if ASU's wins differ significantly from the average of all wins in College football during this period (mu = 5) with a population standard deviation of 3. Does ASU's football wins significantly differ from the population mean (6 points, 1 point each)? a) State the null and research hypotheses. b) Set the significance level c) Select the appropriate test d) Calculate the obtained value (show your work in excel notation). e) Calculate the p-value. hint: =MIN(probability, 1-probability) f) Make conclusion

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mechanics of Materials

Authors: Russell C. Hibbeler

10th edition

134319656, 978-0134319650

Students also viewed these Mathematics questions