What is the function for me to set up problem 1a?

AutoSave OFF A A FC ... Activity6(Spring 2021) (2) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 10 AA D Wrap Text v General 4 V v Paste BIUV A Merge & Center v $ Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data AR75 X V fx Activity 6-MATH 250 ants of Statistics-Spring 2021 MATH 250- Elements of Statistics DUE DATE: 04/ 16/2021 Class Data, Spring 2021---CLEANED Student Data-ID# Renumbered NAME: General Instructions: Please place your name above, then complete the following questions. No The Read the entire documentoctowho gela recifor me a attaching your Excel file through the completion link in the Unit 3 Activity 6 assignment description in Black board. Use the area to the near right in this Excel beive full credit. worksheet when calculating any statistics/parameters. Methods/work used to calculate values and reach conclusions must be shown in the spread sheet in order to As discussed in the 1 1th & 1 2th chapters of the text, one can use data from arandom sample to lesta claim or hypothes a claim or hypothesis aboutapopulation. For you will apply your understanding of hypothesis testing to actual data- the data collected in Activity la of this course. This activity is designed to haveyou use the cleaned chess dan of go date values in cach variable to testsome claims. This dame is given again to the right, and you are encourage heproblem , then me templates, see the blue box to theright. anges to the values, and this will serve as your "work" for that particular problem. For specific directions about the conclusion. Also, as stated in the resources, there are requirements to applying hypothesis testing that should be checked--requirements that our of the activity you MAY ASSUME thatall requirements for hypothesis testing have been metregarding the data collection process. Again, don't forget that the Unit 3 Excel Guide (part 1) includes templates that one can use to produce key testing measures quickly. 1. Ithas been claimed that the mean age of all FHSU Online Elements of Statistics students is less than thirty-two years old. Using the Age sample data ordinate title and ededd cogle Many through a formalhypothesis testing procedure with a(5%) levelof significance. bar or s. calculate trage values using Exel commands within y tends "bar.".p.a, etc.), then go to the templates tab in the Unit 3 Excel Guide (part 1) and determine which template to use, based on the established at ca. Use cell references from the completed temp late to answer parts c) - g). using the instructions in theblue-shaded 4. Draw proper concusions based upon the resulting calculated value Next, give the conclusion of your hypothesis text (choose "reject the null hypothesis" or "fail to reject the null hypothesis") based on the test statistic PROVIDE THE FOLLOWING INFORMATION. LION DEMYPOTHESIS TESTBASEDON TEST FINAL INTERPRETIVE SENTENCE: 2. Pastenrollmentdata indicates that justa slightmajority--$2%-of the students taking Elementary of Statistics at FHSU have brown hair. Is the hypothesis testing procedure with a 10% level of sign fries at from this claim, as measured statistically ? Justify your answer through a formal *-bar,",p.a, etc.), then go to the templates tab in the Unit3 Excel Guide (part 1) and determine which temp late to use, based on the established area. Use cellreferences from the completed template to answer parts c) , therightof the problem u andfor the P-value and explains why you close (choose reject the nullhy set the nullhypothesis") based on the test statistic Finally, give an interpretive sen ten ce. Follow examples given in the Unit3 Excel Guide for correct wording. PROVIDE THE FOLLOWING INFORMATION. Sample's Test Striate CONCLUSION OF HYPOTHESIS TESTBASED ON TESTSTATISTIC ANDIOR P:VALUE AND EXPLAIN WHY; FINAL INTERPRETIVE SENTENCE: 3. Ithas been claimed that the mean heightof adults in the U.S. is more than 1 66 em. Does the data of our statistics class supporter contradict this claim? of and interpretation based on the P-value is required in this problem. You will choose your own level of significance. etc.), then go to the templates tab in the Unit 3 Excel Guide (part 1 ) and determine which kemp late to use, based on the claim in theproblem. Copy an completed temp me joie (including tide) to the rightof the problem using the instructions in the blue-shaded area. Use cellreferences from the explain why you chosey se "reject the null hypothesis" or "fail to reject the null hypothesis") based on the P-value and eminem in thelinits Excel Guide for correct wardine Activity 6 + Select destination and press ENTER or choose Paste 44%