There is three pages

Ok

AG505-Module 10-Lab.pdf X + Lab - Spring 2022 St X content/enforced/8015-AG50501W-LOPEZ/imscc8c3f758018ad44ee8caboc10a2c68952 PDF files? Set as default T V Table 3. Test Statistic Calculation. E O - E O - E) ( 0 - E) 2 / E , Sum = ? What is your final answer for the test statistic for the appropriate hypothesis? Need to carry at least four decimals in all your calculations to get the correct final answer. Points: 10) g. What is (are) the critical value(s) f test? Use a - 0.10 significance level. (Points: 10) Do you reject or fail to reject Ho? Make sure you explain why. (Points: 10) State the correct conclusion (" There is sufficient evidence at the a - 0.10 significance level to support.. ." or "There is NOT sufficient evidence at the a - 0.10 significance level to support. ."). Make sure you state the conclusion in terms of Hi. (Points: 10) Use Microsoft Excel to compute the P-value for the hypothesis test that gender is independent of drop reason. What is your P-value estimate? Hint: You need to use Tables I and 2 above and program in a cell in Excel the formula -CHISQ.TEST(actual_range,expected_range) (Points: 10) Page 3 of 3\fBeats the pull Summarud the weulta of the survey in the conting y uible below (Table 1). Htime Copy and paste the raw data sboys into Microsoft Excel. Make sure you stack the data Into two calumet. Then, use the Fiber feature of Microsoft Excel is separate the observations by gender and drop reason. That in, elect the variables gunder and drop reason, then click on the Data tib in the menu but it the top of the window, then click an the Filter button. Once the filter drop down arrow bocce display, you can proceed to filter the cherryations arise the realty in Talks I below, [Folate 10) Table 1. Results of the wirvey Grader Drop Henson Work Total Foron al Courec Female E. thes Table I shove and the formula - -to compute the ma pacied untila Summarize your results in Table 1 below, Make ous you carry it kan four decimals in all your calculation (Telate 10) table 1 Expected Counts Drop Brawn Work d Use the love equation bution from Microsoft Word to type the formula()for calculating the led satanic, Click on the Inscri lab, then click on the Equation button, then use itis Structures Minton in the Symbols barons from the Equation Tools Design tah to type The Table ] below to compute the test danone from Fill out its table in Microsoft E'scel and then copy and panto the table into your Word document. Ablemaindy. you Sum What h you Polait: 10) What (max) the critical value ) for thi but Un a = 0.10 significance Kvel ou explain why. (Palate: 10) Bite the oured conclusion (There is sufficisat evidence at the a =10 10 significance lovd to support for There is NOT sufficient evidence s the a -0 10 agaifcancel hard to support Make sure you stats the conclusion in terms of //. (Palate: 10) anduni of drop reason. What in your F-value catimale? /fim: You need to use Tibbex I and 2 above and program in a cell in Excel ily formula CHISQ.TEST(actual range, apaded range) (relatea. State the null and alternative hypotheses. (Points: 10) b. Summarize the results of the survey in the contingency table below (Table 1). Hint: Copy and paste the raw data above into Microsoft Excel. Make sure you stack the data into two columns. Then, use the Filter feature of Microsoft Excel to separate the observations by gender and drop reason. That is, select the variables gender and drop reason, then click on the Data tab in the menu bar at the top of the window, then click on the Filter button. Once the filter drop down arrow boxes display, you can proceed to filter the observations as needed and summarize the results in Table I below. (Points: 10) Table 1. Results of the survey. Drop Reason Gender Total Personal Work Course Female Male Total . Use Table I above and the formula E = row total x column total table total to compute the expected counts. Summarize your results in Table 2 below. Make sure you carry at least four decimals in all your calculations. (Points: 10) Table 2. Expected Counts Gender Drop Reason Personal Work Course Female Male d. Use the insert equation button from Microsoft Word to type the formula(s) for calculating the test statistic. Click on the Insert tab, then click on the Equation button, then use the Structures buttons and the Symbols buttons from the Equation Tools Design tab to type your formula. (Points: 10) e. Use Table 3 below to compute the test statistic. Hint: Fill out the table in Microsoft Excel and then copy and paste the table into your Word document. Alternatively, you can fill out the table in Microsoft Excel and then copy and paste the values into the table below. (Points: 10) Page 2 of 3 O\fX + ile 10: Lab - Spring 2022 St. X AG505-Module 10-Lab.pdf .edu/content/enforced/8015-AG50501W-LOPEZ/imscc8cBf758018ad44ee8caboc10a2c68952/ ding PDF files? Set as default .) CD A T V State the null and alternative hypotheses. (Points: 10) b. Summarize the results of the survey in the contingency table below (Table 1). Hint: Copy and paste the raw data above into Microsoft Excel. Make sure you stack the data into two columns. Then, use the Filter feature of Microsoft Excel to separate the observations by gender and drop reason. That is, select the variables gender and drop reason, then click on the Data tab in the menu bar at the top of the window, then click on the Filter button. Once the filter drop down arrow boxes display, you can proceed to filter the observations as needed and summarize the results in Table 1 below. (Points: 10) Table 1. Results of the survey. Gender Drop Reason Personal Work Total Course Female Male Total c. Use Table I above and the formula E, = row total * column total to compute the expected table total counts. Summarize your results in Table 2 below. Make sure you carry at least four decimals in all your calculations. (Points: 10) Table 2. Expected Counts Gender Drop Reason Personal Work Course Female Male d. Use the insert equation button from Microsoft Word to type the formula(s) for calculating the test statistic. Click on the Insert tab, then click on the Equation button, then use the Structures buttons and the Symbols buttons from the Equation Tools Design tab to type your formula. (Points: 10) e. Use Table 3 below to compute the test statistic. Hint: Fill out the table in Microsoft Excel and then copy and paste the table into your Word document. Alternatively, you can fill out the table in Microsoft Excel and then copy and paste the values into the table below. (Points: 10) Page 2 of 3 O O hp