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.Open spreadsheetа. Letd; denote the change in price per share for company i whered; :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 haschanged during the 1st quarter$ 7.21(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): 4.42Confidence interval (to 2 decimals): ( 5.399.05The mean price per share has increase between 8.9% and 14.98 % over the three-month period (to 1 decimal).Check My WorkReset Problem AВCEFGHIEnd of 1stQuarterBeginning ofYearChange inPrice (d;)1CompanyChange in Price (di)2Bank of New York26.4317.019.42Kraft Foods39.6135.464.15Мean7.21844Dupont54.1044.389.72Standard Error0.8854813535Consolidated Edison59.4260.13-0.71Median6.566Johnson & Johnson68.4662.685.78Mode17.767Union Pacific108.68103.145.54Standard Deviation4.4274067658Comcast31.3121.519.80Sample Variance19.601930679Applied Materials15.159.116.04Kurtosis0.74694860910Pfiser44.8140.124.69Skewness0.75713011411General Electric22.3715.816.56Range18.4712 AT&T32.7328.044.69Minimum-0.7113Cisco SystemsHome Depot24.0516.987.07Maximum17.761453.2139.9413.27Sum180.4615JP Morgan Chase48.2831.3516.93Count2516 Procter & Gamble69.0164.914.10Largest(1)17.7617 Verizon40.4338.921.51Smallest(1)-0.7118Devon Energy72.7260.6012.12Confidence Level(95%)1.82754367819 Lilly41.6740.361.3120 Microsoft33.3624.568.80The 95% confidence intervalFormulas21Сосо Cola75.7167.178.54C.I.Lower Limit (to 2 decimals)5.39=G3-G1822 Qualcomm70.2652.5017.76C.I.Upper Limit (to 2 decimals)9.05=G3+G1823Exxon Mobil89.3382.067.2724Pacific Gas & Electric25.3520.544.81Mean Price, Beginning of Year (to 2 decimals)60.56=AVERAGE(C2,C26)25Oracle Systems31.2624.486.7826Chevron108.61104.104.51Percentage Change in the Population Mean27Lower Percentage Change (to 1 decimal)8.9%=G21/G2428Upper Percentage Change (to 1 decimal)14.9%=G22/G242930

Name: The price per share of stock for a sample of 25 companies was recorde
Uploaded: 2024-03-20T07:07:12.000Z
Channel: Bartleby
Description: 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

Mean=7.2184 Standard deviation 4.427 confidence interval 95% n=25 mean price beggining of…

Math

Statistics

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. Co following questions. Open spreadsheet a. Let d; 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 changed during the 1st quarter $ 7.21 (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 Standard deviation (to 2 decimals): 4.42 Confidence interval (to 2 decimals): ( 5.39 9.05 The mean price per share has increase between 8.9 |% and 14.9 % over the three-month period (to 1 decimal).

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. Co following questions. Open spreadsheet a. Let d; 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 changed during the 1st quarter $ 7.21 (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 Standard deviation (to 2 decimals): 4.42 Confidence interval (to 2 decimals): ( 5.39 9.05 The mean price per share has increase between 8.9 |% and 14.9 % over the three-month period (to 1 decimal).

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Which of the following is NOT an example of cross-sectional data?
The graph below is a scatter plot between liabilities and assets, bothexpressed in millions. i. Critically assess this scatter plot explaining about the relationship betweentwo variables.ii. A researcher claims that the correlation is showing that changes in assetscause changes in liabilities. Is he right or wrong? Explain your answer.
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Click on the datafile logo to reference the data .
dear sir mam how do u create a steam and leaf data plot
Briefly explain the difference between leading, coincident, and lagging indicators.
A case-control study is conducted to assess the relationship between heavy alcohol use during the first trimester of pregnancy and miscarriage. Fifty women who suffered miscarriage are enrolled along with 50 who delivered full term. Each participant’s use of alcohol during pregnancy is ascertained. Heavy drinking is defined as 4 or more drinks on one occasion. The data are shown below. Miscarriage Delivered Full Term Heavy Alcohol Use 14 4 No Heavy Alcohol Use 36 46 a. Compute the odds of miscarriage in women with heavy alcohol use in pregnancy. b. Compute the odds of miscarriage in women with no heavy alcohol use in pregnancy. c. Compute is the odds ratio for miscarriage as a function of heavy alcohol use.
A researcher surveyed 80 patients at a certain hospital. The histogram below gives the length of time patients waited to see a doctor at the hospital. The classes, in minutes, are 0 - 1.9, 2 - 3.9, etc., and the vertical axis represents the number of patients. 25 20 15 10 2 4 8. 10 wait time (minutes) (a) Use the histogram to determine the percent of patients that waited less than 6 minutes to see the doctor. (b) Determine the interval that contains the median wait time. **Include all decimal places** number of patients
Pathway: Business Below is a chart displaying the income of Starbucks from 2003-2017. Use the chart to answer the questions below Starbucks Revenue in Billions 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Find the range, mean, median, and mode for the revenue. 4.1 5.3 6.4 7.8 9.4 10.4 9.8 10.7 11.7 13.3 14.9 16.45 19.16 21.32 22.39
ixd s 67 Dr 5. Find the percentage of data points that lie above z 1.03. Draw a picture to support your work.
The accompanying table displays information about the number of births (in thousands) and the number of deaths (in thousands) for certain years. Report the death rate as a percentage of the birth rate, and comment on its trend over time. What is causing the trend? LOADING... Click the icon to view the data table. Report each death rate as a percentage of the birth rate. Year Births (thousands) Deaths (thousands) Percentage of deaths per births 2006 4275 2445 nothing% 2007 4320 2408 nothing% 2008 4241 2465 nothing% 2009 4140 2436 nothing% 2010 4002 2455 nothing% (Round to one decimal place as needed.)
The data in the picture contains purchase data for golf purchases. Create a doughnut chart in Excel to compare the purchases by gender each year with the US population. Below the chart, explain what it illustrates.
Find the percentage of data that lies below -2.40, above 1.73, and between -2.40 and 1.73