Question: I need help with problem b. I can't figure out the mean price per share has increase between ________% and 21.0% over the three-month period

I need help with problem b. I can't figure out the mean price per share has increase between ________% and 21.0% over the three-month period (to 1 decimal.

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 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. 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 dy denote the change in price per share for company / where dy = 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 (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 % and %% over the three-month period (to 1 decimal).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 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. 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 dy denote the change in price per share for company / where dy = 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 (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 % and %% over the three-month period (to 1 decimal).End of 1st Beginning of Change in Company Quarter Year Price (di) After reading these instructions delete all text in this shaded area. Bank of New York 25.53 18.31 Kraft Foods 40.01 34.56 Use the XLMiner Analysis ToolPak to conduct your analysis. Dupont 55.70 43.88 Consolidated Edison 59.62 59.83 After deleting all text in this shaded area, set the output range in Johnson & Johnson 67.16 62.88 the ToolPak to the top left cell of this area (F1). Union Pacific 110.08 104.34 Comcast 31.71 21.81 Your analysis output should fit into this shaded area. Applied Materials 14.45 8.71 Pfiser 44.81 39.42 General Electric 22.67 15.41 AT&T 34.03 27.54 Cisco Systems 23.05 15.28 Home Depot 52.31 40.64 JP Morgan Chase 47.08 30.55 Procter & Gamble 69.91 63.81 Verizon 39.23 38.12 Devon Energy 73.62 59.30 Lilly 42.07 39.66 Microsoft 33.26 24.56 The 95% confidence interval Formulas Coco Cola 76.01 67.47 C.I.Lower Limit (to 2 decimals) #N/A Qualcomm 69.76 53.60 C.I.Upper Limit (to 2 decimals) #N/A Exxon Mobil 88.93 81.86 Pacific Gas & Electric 25.25 18.84 Mean Price, Beginning of Year (to 2 decimals) Oracle Systems 31.56 23.58 Chevron 108.81 104.40 Percentage Change in the Population Mean Lower Percentage Change (to 1 decimal) Upper Percentage Change (to 1 decimal) #N/AEnd of 1st Beginning of Change in Company Quarter Year Price (di) After reading these instructions delete all text in this shaded area. Bank of New York 25.53 18.31 Kraft Foods 40.01 34.56 Use the XLMiner Analysis ToolPak to conduct your analysis. Dupont 55.70 43.88 Consolidated Edison 59.62 59.83 After deleting all text in this shaded area, set the output range in Johnson & Johnson 67.16 62.88 the ToolPak to the top left cell of this area (F1). Union Pacific 110.08 104.34 Comcast 31.71 21.81 Your analysis output should fit into this shaded area. Applied Materials 14.45 8.71 Pfiser 44.81 39.42 General Electric 22.67 15.41 AT&T 34.03 27.54 Cisco Systems 23.05 15.28 Home Depot 52.31 40.64 JP Morgan Chase 47.08 30.55 Procter & Gamble 69.91 63.81 Verizon 39.23 38.12 Devon Energy 73.62 59.30 Lilly 42.07 39.66 Microsoft 33.26 24.56 The 95% confidence interval Formulas Coco Cola 76.01 67.47 C.I.Lower Limit (to 2 decimals) #N/A Qualcomm 69.76 53.60 C.I.Upper Limit (to 2 decimals) #N/A Exxon Mobil 88.93 81.86 Pacific Gas & Electric 25.25 18.84 Mean Price, Beginning of Year (to 2 decimals) Oracle Systems 31.56 23.58 Chevron 108.81 104.40 Percentage Change in the Population Mean Lower Percentage Change (to 1 decimal) Upper Percentage Change (to 1 decimal) #N/A

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Reported...

Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model Following are income statements and balance sheets for Cisco Systems. Years Ended December ($ millions) Revenue...

Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Reported...

Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Intel Corporation. INTEL CORPORATION Consolidated Statements of Income Year Ended...

Please assist with question 2 part A through D. Thank you. Question 2 Partially correct Mark 4.00 out of 55.00 p Flag question Forecasting with the Parsimonious Method and Estimating Share Value...

Question 2 Partially correct Mark 4.00 out of 55.00 p Flag question Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model Following are income statements and balance...

July 27, 2019 July 28, 2018 $8,934 $11,750 21,663 5,491 1,383 37,614 5,554 1,846 5,095 4,949 2,940 61,837 3,006 Cisco Systems Inc. Consolidated Balance Sheets In millions, except par value Assets...

Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Reported...

A turbojet aircraft is flying with a velocity of 250 m/s at an altitude where the ambient conditions are 20 kPa and -25oC. The pressure ratio across the compressor is 12, and the temperature at the...

Osmosis occurs when two solutions of different concentrations are separated by a semipermeable membrane. The membrane allows solvent particles, but not solute particles, to pass through. Thus, the...

Current Artiempt in Frogress Marn Corporation incurred the following costs during 2 0 2 2 . \ table [ [ Direct material uned in product,$ 1 2 7 , 2 0 0 , Advertiving expense,$ 4 7 , 7 0 0 ] , [...

67% Question 18 Not yet answered Marked out of 1.00 Flag question 1:03 elearning.ibrict.edu.om 3G 50 If the piece rate of a manufacturing company is 200 baisa per unit, the standard output is 200...