please provide CORRECT answers! Thank you.

Transcribed Image Text:File 015 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 ctric 25 26 27 28 29 30 son on Home B End of 1st Quarter Insert x ✓ fx 26.23 40.71 55.60 60.12 68.16 109.58 31.61 13.85 46.31 22.77 33.03 22.25 53.01 47.38 69.01 40.43 72.42 41.47 33.86 76.81 69.56 89.63 25.25 30.36 109.61 Data Draw Times New Ro... ✓ 12 C Beginning of Year + 17.91 35.06 44.28 60.13 62.88 104.04 20.81 9.61 39.32 16.11 27.74 15.88 40.74 31.35 65.11 37.82 60.60 40.06 24.06 67.37 52.10 82.86 20.44 23.98 104.80 Page Layout D Change in Price (di) Calculation Mode: Automatic Workbook Statistics v B E Formulas Data F Review View Help v The 95% confidence interval C.I.Lower Limit (to 2 decimals) C.I.Upper Limit (to 2 decimals) ab After reading these instructions delete all text in this shaded area. Use the XLMiner Analysis ToolPak to conduct your analysis. After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (F1). Your analysis output should fit into this shaded area. G Mean Price, Beginning of Year (to 2 decimals) Percentage Change in the Population Mean Lower Percentage Change (to 1 decimal) Upper Percentage Change (to 1 decimal) General H Formulas ←0 .00 I #N/A #N/A #N/A #N/A #N/A .00 →.0 D J ‒‒‒ K L Σ Editing 会 M Ov Give Feedback to Microsoft N Comments 90% +
Transcribed Image Text: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 1st quarter of 2012. How stocks perform during the 1st 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. 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 X Open spreadsheet a. Let di denote the change in price per share for company i where di 1st 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 1st quarter $ 7.34 (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. Standard deviation (to 2 decimals): Confidence interval (to 2 decimals): ( = The mean price per share has increase between Check My Work Reset Problem ) % and % over the three-month period (to 1 decimal).

Question

please provide CORRECT answers! Thank you. File015123456789101112131415161718192021222324 ctric252627282930sononHomeBEnd of 1stQuarterInsertx ✓ fx26.2340.7155.6060.1268.16109.5831.6113.8546.3122.7733.0322.2553.0147.3869.0140.4372.4241.4733.8676.8169.5689.6325.2530.36109.61DataDrawTimes New Ro... ✓ 12CBeginning ofYear+17.9135.0644.2860.1362.88104.0420.819.6139.3216.1127.7415.8840.7431.3565.1137.8260.6040.0624.0667.3752.1082.8620.4423.98104.80Page LayoutDChange inPrice (di)Calculation Mode: Automatic Workbook StatisticsvBEFormulasDataFReviewView HelpvThe 95% confidence intervalC.I.Lower Limit (to 2 decimals)C.I.Upper Limit (to 2 decimals)abAfter reading these instructions delete all text in this shaded area.Use the XLMiner Analysis ToolPak to conduct your analysis.After deleting all text in this shaded area, set the output range inthe ToolPak to the top left cell of this area (F1).Your analysis output should fit into this shaded area.GMean Price, Beginning of Year (to 2 decimals)Percentage Change in the Population MeanLower Percentage Change (to 1 decimal)Upper Percentage Change (to 1 decimal)GeneralHFormulas←0.00I#N/A#N/A#N/A#N/A#N/A.00→.0DJ‒‒‒KLΣEditing会MOvGive Feedback to MicrosoftNComments90% + 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 1st quarter of 2012. How stocks perform during the1st 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 thefollowing questions.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 ToolPakXOpen spreadsheeta. Letdi denote the change in price per share for company i wheredi1st 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 haschanged during the 1st quarter$ 7.34(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.Standard deviation (to 2 decimals):Confidence interval (to 2 decimals): (=The mean price per share has increase betweenCheck My WorkReset Problem)% and% over the three-month period (to 1 decimal).

Accepted Answer

End of 1st Quarter
Beginning of Year

Change in Price (d)

26.23
17.91

40.71
35.06

55.6…