Question: Please answer questions in the Excel spread sheet picture. Project Part 4 - Hypothesis Testing Based on your sample, you will conduct a hypothesis test

Please answer questions in the Excel spread sheet picture.

Project Part 4 - Hypothesis Testing

Based on your sample, you will conduct a hypothesis test withto test two of the claims of the above article.

Using the same excel sheet as last week,answer the following in the "week 6" tab:

Claim: the average age of online students is 32 years old. Can you prove it is not?
What is the null hypothesis?
What is the alternative hypothesis?
What distribution should be used?
What is the test statistic?
What is the p-value?
What is the conclusion?
How do we interpret the results, in context of our study?
Claim: the proportion of males in online classes is 35%. Can you prove it is not?
What is the null hypothesis?
What is the alternative hypothesis?
What distribution should be used?
What is the test statistic?
What is the p-value?
What is the conclusion?
How do we interpret the results, in context of our study?

Please answer questions in the Excel spread sheet picture. Project Part 4

A Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do Exam Review and Exam Instructions not worry about failed assumptions tests. Use primary methods described in text and used on homework. For the following two hypothesis tests, use alpha = .05 JO UI B W N - Points Claim: The average age of online students is 32 years old. Can you prove it is not? Project Instructions 1 Ho 32 Note: Calculation cells should 8 Ha list the numbers and 9 operations used to get your Project Part 4 - Hypothesis Testing 10 Sample mean: 27.4 answers. Do not put the 11 Sample St. Dev: 7.65 Based on your sample, you will conduct a hypothesis test with to test two of the claims of the above article. generic formula and show all 12 calculation steps. Using the same excel sheet as last week, answer the following in the "week 6" tab: 13 2 Distribution: 14 . Claim: the average age of online students is 32 years old. Can you prove it is not? 15 2 Test Statistic: *2 decimals Calculation . What is the null hypothesis? 16 p-value: #4 decimals What is the alternative hypothesis? 17 Decision: . What distribution should be used? 18 What is the test statistic? o What is the p-value? Interpretation: . What is the conclusion? 19 2 (context) o How do we interpret the results, in context of our study? 20 . Claim: the proportion of males in online classes is 359%. Can you prove it is not? 21 . What is the null hypothesis? 22 Claim: The proportion of males in online classes is 35%. Can you prove it is not? What is the alternative hypothesis? 23 What distribution should be used? 1 Ho What is the test statistic? 24 What is the p-value? 25 Ha What is the conclusion? 26 How do we interpret the results, in context of our study? 27 Sample Proportion Males 0.64 Sample Proportion Females 0.36 28 29 2 Distribution: 30 Exam 3 Work Submission 31 3 Test Statistic: *2 decimals Calculation: IN You must submit all written work for the exam questions. Exams submitted without the accompanying work will not be 32 p-value: #4 decimals 33 Decision: Uploading your exam work in BlackBoard.docx 34 Interpretation: 35 2 (context) 36 . . . Week 5-Part 3 Week 6-Part 4 Sheet2 +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

File Home Insert Draw Page Layout Formulas Data Review View Help G30 X V 0.0385 A B C D E F G H K L M Note: The goal of the project is to practice making a confidence interval for a mean and...

if you need the additional worksheets I have done I have them just not sure exactly what data you need to solve. BUSI 230 Age Gender 43 F o What is the upper bound? 33 M o How do we interpret the...

Location Income ($1,000) Urban 27 Rural 25 Suburban 25 Suburban 26 Rural 30 Urban 29 Rural 33 Urban 30 Suburban 32 Urban 34 Urban 35 Urban 40 Rural 30 Rural 33 Urban 42 Suburban 32 Urban 43 Urban 43...

Project Description determine whether or not there exits difference in COVID-19 incidences across Florida and Arkansas using COVID-19 data, namely, Total Cases and Total Deaths and US population data...

'1' ' ' "" '7 " ' ' "' ' ""J' Project: Part 4 Hypothesis Tests Assignment For this part of the project and based on your sample, you will conduct a hypothesis test with a: = 0.05 to test two of the...

Ignore the project four part real direction r above ?? A D E F G BUSI Note: The goal of the project is to practice making a confidence interval for a mean and proportion with real data. Do not worry...

Project: Part 4 - Hypothesis Tests Assignment For this part of the project and based on your sample, you will conduct a hypothesis test with = 0.05 to test two of the claims of the above article....

Analyze 3 answers, just like before! 1) BERNIE Part One - Hypothesis Testing We use hypothesis testing to validate an assumption and testing the hypothesis helps one make an informed decision. The...

cc170785fa926b2240534b10e7743155388d392a ID hours 1 37.09953814 2 34.58422938 3 37.85777106 4 36.03408777 5 38.71008438 6 38.18084857 7 37.7883698 8 38.41027533 9 39.53619743 10 37.46797595 11...

Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do Helps for this spreadsheet: not worry about failed assumptions tests. Use...

When it is time to complete the Reply Post*, you will need to read through your classmate's original thoughts. Find one Original Post* to reply to in at least two paragraphs. For the Reply Post*, you...

Please demonstrate your knowledge of current assets and liabilities by discussing: Dependencies between current assets and current liabilities either through balance creations or balance changes. Are...

Cost of Goods Manufactured, Income Statement W. W. Phillips Company produced 4,000 leather recliners during the year. These recliners sell for $400 each. Phillips had 500 recliners in finished goods...

Three sell orders are placed for a stock today. Listed below are the bid and ask quotes at various times: Time Bid Price Bid Size Ask Price Ask Size 10:00 AM $12.10 300 $12.16 400 1:00 PM $12.00 300...

6. Explain the strengths of a dialectical approach.

2. Discuss the types of messages that are communicated nonverbally.

3. Values and Language. Although computer-driven translations have improved dramatically over earlier attempts, translation is still intensely cultural. Communication always involves many layers of...