Please solve the whole problem please. Please give me all the excel formulas that are needed to get the answer. I for sure need to show my work on work on excel example. ( for stdv, its =stdev(x1-x9) ) Let me know if you have any questions thank you so much.

a BANAFinaIFaIIZOZO Home Insert Draw Page Layout Formulas Data Review View L . -- _7l I ' . ' > l\\/ Ruler \\/l Formula Bar Zoom v H1 i i E @ \"ll '7' '7 \"HMl q 4 an n EL Normal Page reak Page Custom 'Z Gridlines 'g Headings Zoom to 100% Zoom-to blew Arrange Freeze Freeze Freeze Prevuew Layout Views Selection Window All Panes Top Row Colu A E29 7 . e W A B C D E F G H | J K L M _ IBusiness Analytics page 1 of 1 Final Exam 1 Question 3. This question is on one page with 7 parts. Show all work. All work must be done in Excel. ' 2 3 In an agricultural experiment, the effects of two fertilizers on the production of oranges were _ 4 FertilizerA Fertilizer 3 measured. Sixteen randomly selected plots of land were treated with fertilizer A, and twelve randomly 5 445 352 selected lots were treated with fertilizer B. The number of pounds of harvested fruit was measured for ._ 5 443 393 each plot. The manufactures would like to know if there is a difference in yields for the two fertilizers. ' 7 523 414 _ 8 457 437 1. Create a boxplot of the data. Be careful, the two variables do not have the same number of _ 9 464 408 observations. 10 437 387 2. State the null and alternative hypotheses. F\" 11 483 398 ' 12 515 373 3. Is this a right-tailed, left-tailed or two-tailed hypothesis test? _ 13 441 382 _ 14 417 424 4. Conduct a ttest to determine if there is a difference in yields for the two fertilizers. 15 491 368 U58 '1 = 0-055 "' 16 420 384 5 c | _ 17 403 . ompute a p-va ue. _ 18 400 6. Do you reject the null hypothesis? Tell me why. _ 19 466 20 505 7. State your conclusion F 21 22 Show all work, including intermediate calculations, and label all answers appropriately. All work must _ 23 be done in Excel. Please work down the page, not across. _ 24 25 F; 26 ' 27 28 __ 29 I Ii _ 30 31 ' 32 33 _ 34 35