Dashboar X G The oxyge X Pokemon X h Hulu + Liv X 10.3 Micr X MindTap - X Question X C | Chegg.c x C Target prc X (119) You X Course H X + C https:/g.cengage.com/staticb/ui/evo/index.html? deploymentld=5935112189509097482354739820&elSBN=9780357110614&id=15675... 0 * GG*30 Update : C Chapter 16 Learn... Khoi v KL CENGAGE | MINDTAP Q Search this course ? My Home 10.3 Microsoft Excel: Structured Activity #1 X Courses Question 1 1.67/10 Video Catalog and Study Tools Submit The price per share of stock for a sample of 25 companies was recorded at the beginning of 2012 and then again at the end of the ist quarter of 2012. A-7 Rental Options How stocks perform during the ist quarter is an indicator of what is ahead for the stock market and the economy. The sample data are provided in the Excel Online file below. Construct a spreadsheet to answer the following questions. College Success Tips Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak Career Success Tips X Open spreadsheet RECOMMENDED FOR YOU a. Let di denote the change in price per share for company i where di = ist quarter of 2012 price per share minus the beginning of 2012 price per share. Use the sample mean of these values to estimate the dollar amount a share of stock has changed during the ist quarter $ 7.44 (to 2 decimals) b. What is the 95% confidence interval estimate of the population mean change in the price per share of stock during the first quarter? Interpret this result. bongo Check In! Your Body and Standard deviation (to 2 decimals): Wellness Self-Assessment iz!] Confidence interval (to 2 decimals): ( The mean price per share has increase between % and % over the three-month period (to 1 decimal). Help Give Feedback Check My Work Reset Problem A+ Back NextDashbo: X G The oxy X Pokemo X h Hulu + L X 10.3 Mic X MindTar X Excel Ol X Question X C | Chegg X C Target p X (119) Yo X Course X + @ about:blank Update : C Chapter 16 Learn... Excel template - Saved Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing v Comments 5 v [ v Arial 10 B -HV MAV . .. Ev ab General $ v 00 .00 . .. F1 " X V fx T Test: Paired Two Sample for Means B E G H I J K L M End of 1st Beginning of Change in Quarter Year Price (di) T Test: Paired Two Sample for Means N 25.83 17.51 8.32 40.41 35.56 4.85 54.50 43.68 10.82 59.72 60.33 -0.61 68.26 63.58 4.68 110.08 102.94 7.14 31.61 21.41 10.20 14.05 7.81 6.24 45.21 40.02 5.19 11 21.67 15.71 5.96 12 33.43 27.54 5.89 13 22.15 16.28 5.87 14 51.4 39.24 12.17 15 47.18 31.45 15.73 16 69.81 65.01 4.80 17 40.73 37.42 3.31 18 73.02 60.20 12.82 19 42.67 38.76 3.91 20 34.86 24.26 10.60 The 95% confidence interval Formulas 21 76.51 68.77 7.74 C.I.Lower Limit (to 2 decimals) #N/A 22 70.66 51.80 18.86 C.I.Upper Limit (to 2 decimals) #N/A 23 88.03 82.16 5.87 24 23.95 20.44 3.51 Mean Price, Beginning of Year (to 2 decimals) #N/A 25 31.36 23.68 7.68 26 109.51 105.00 4.51 Percentage Change in the Population Mean E Data + Workbook Statistics Give Feedback to Microsoft - 100% + Calculation Mode: Automatic