MindTap for TOM X Excel Online Stud X Excel Online Stud X Excel Online Stuc X Ask a Question X Excel Online Stud X Excel Online Stuc X Excel Online Stuc X The Batman 41 X . . . - C Search WaveBrowser or type a URL G Hue, Vietnam. c. Fe... Bookmarks W f Twitter YouTube G Google (2) f Home A Music Reviews, Rati... C AMC Theatres - Get... Movie Reviews and... b Billboard - Music C... .. YouTube Statistics,.. Rotten Tomatoes.... template - Saved Search (Alt + Q) O Excel File Home Insert Draw Page Layout Formulas Data Review View Help Editing v Comments V V V Arial 10 B vv Av ... Eva Merge General v Conditional Formatting v Styles v Z Format As Table E Ap Ov . . . V V A2 X V fx 35.3 G H M Q R S C2 B Tax Prep Time (hrs) O X 35.3 MindTap - Cengage Learning X + A W N 30.5 37.4 - C ng.cengage.com/staticb/ui/evo/index.html?deploymentld=5... 2 * 26.5 13 G Hue, Vietnam. c. Fe... Bookmarks W f Twitter YouTube G Google (2) f Home +9.9 28 .8 44 CENGAGE |MINDTAP Q Search this course ? W 10 61.6 0.5 Microsoft Excel: Structured Activity X 40.5 34.9 47.9 Question 1 X 36.6 0/1 AARP reported on a study conducted to learn how long it takes + 24.1 39.8 individuals to prepare their federal income tax return (AARP C2 47.8 S Submit Bulletin, April 2008). The data contained in the Microsoft Excel 18.5 Online file below are consistent with the study results. These A-Z 20 36.6 data provide the time in hours required for a sample of 40 39.2 individuals to complete their federal income tax returns. Assume 14.5 that the population standard deviation is known to be o = 11 Office 37.3 hours. 40.5 49.3 26 45.5 28.3 28 Open spreadsheet 19.5 29 5.6 What is the 95% confidence interval estimate of the mean time it 30 52.6 takes an individual to complete a federal income tax return (1 41.4 decimal)? O' 32 45.3 ? 33 39 29.45 X to 37.2 X + 34 33.7 hours 35 29.4 36 14 .5 37 40.1 38 33.7 39 36.9 Back Autosaved at 10:25 PM Next 40 5.6 41 33.7 42 43 44 45 46 47 48 Sheet1 Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + 10:40 PM 55 F 2/10/2022 21 Mostly cloudy