Help !

3 Excel Activity 1 - Confidence Interval fo... 0 x 10.3 Excel Activity 1 - Confidence Interval fo... stion 1 Question 1 0/10 a. Let The price per share of stock for a sample of 25 companies was mit di denote the change in price per Submit share for company / where recorded at the beginning of 2012 do = 1st quarter of 2012 price per and then again at the end of the 1st quarter of 2012. How stocks share minus the beginning of perform during the ist quarter is 2012 price per share. Use the an indicator of what is ahead for sample mean of these values to the stock market and the estimate the dollar amount a economy. The sample data are share of stock has changed during provided in the Excel Online file the 1st quarter below. Construct a spreadsheet to answer the following questions. $ 7.31 X (to 2 decimals) Due to a recent change by b. What is the 95% confidence Microsoft you will need to open interval estimate of the population the XLMiner Analysis ToolPak add- mean change in the price per in manually from the home share of stock during the first ribbon. Screenshot of ToolPak quarter? Interpret this result. X HILL Standard deviation (to 2 decimals): Open spreadsheet Confidence interval (to 2 decimals): a. Let di denote the change in price per share for company / where The mean price per share has di = 1st quarter of 2012 price per increase between % and share minus the beginning of % over the three-month 2012 price per share. Use the sample mean of these values to period (to 1 decimal). estimate the dollar amount a share of stock has changed during the 1st quarter Check My Work $ 7.31 X (to 2 decimals) Back Next Back Next nplane Open in App ... template Open in meaning of Change in End of ta Change in Price tag Quarter Price tag After reading forte insructions dot his shaded area. 17-31 3951 Use the al Miner Analysis TooPak to conduct your anipals Use The 31 Miner Analysis TooPak is cond 10.72 (0.73 shaded area. just the output range in 60.73 60.73 After deleting all hot in this shaded area, but the output range in 62 6# To TooPak to to top hat cel of this area (FIL. 110.28 103 54 110.25 101 54 3241 22.11 Your analysis sulput should fit into this shaded area. 22.11 Your analysis culpul should It into this shaded area. 1395 13 95 44.91 4491 32.17 11 28.74 12 22.85 30 84 15 35 17 41.03 72.32 60.30 19 The 19% confidence interval The 19's confidence Interval Cllower Lime Do 2 dedmany INA Cllower Lima no 1 dadimany 53.40 CLUpper Lima flo 2 decimshy 70.08 ClUpper Lima no 2 decimang 81.76 Mean Price, Beginning of Year (o 2 decimals) Mean Price, Beginning of Your (o 2 decimals) 109 18 Percentage Change in the Population Mixun 109 15 103.B montage Change in the Population Mun Lower Percentage Change (to 1 decimal) Lover Percentage Change (to 1 decimal Upper Percentage Chance to 1 decimal Upper Percentage Chance to 1 decimal