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

What level of data does the example represent? Credit Card Number
Identify the type of data that would be used when the variable of interest is most-watched TV show.
The comparison line graph indicates the rainfall for the last six months of two different 2013 years in Nowhereville. How many more inches of rain fell in October 2013 than in September 2013? 2014 04 July Aug Sept Oct Nov Dec Month ..... inch(es) (Simplify your answer.) Rainfall (in inches)
What is the best description of the relationship in the scatter plot?
You want to compare the average number of books read by the US adults in 2001 with the average number of books read by the US adults in 2021. A. Is the data paired or not?
Earnings of Nonliving Celebrities Forbes magazine prints an annual Top-Earning Nonliving Celebrities list (based on royalties and estate earnings). Find the mean, median, mode, and midrange for the data. Comment on the skewness. Figures represent millions of dollars. Rodgers & Hammerstein 235 John Lennon 15 Michael Jackson 90 Dr. Seuss 15 Elvis Presley 55 Albert Einstein 10 JRR Tolkien 50 Michael Crichton 9. Charles Schulz 35 Jimi Hendrix 8 Send data to Excel Part: 0 / 5 Part 1 of 5 Find the mean. Rounding rule for the mean: round to one more decimal place than the data as needed. Mean:
Explain the meaning of the specified term. Distribution of a data set
Identify the line most likely to graphically represent the mean, median and mode of the distribution? Explain how you know. А: B: С: C A B
Gabriel and Lucia took a road trip across the country. The room costs, in dollars, for their overnight stays are listed in the accompanying table. Find the mean of the distribution.
Find the mean, median, and mode(s) of the data in the following stem-and-leaf plot. The leaf represents the ones digit. 09 1 59 2 6788 1 Part 1 of 3 Find the mean. Round your answer to one decimal place, if necessary. Mean: S Part 2 of 3 Find the median. Round your answer to one decimal place, if necessary. Median: X S
ts eBook Print References a. 100 m dash times (n = 6 top runners): b. Number of children (n = 13 families): c. Number of cars in driveway (n = 8 homes): Click here for the Excel Data File (a) Find the mean, median, and mode for each data set. (Round your answers to 2 decimal places.) 100 m dash times Number of children Number of cars in driveway Mean 100 m dash times Number of children Number of cars in driveway Median 9.87, 9.98, 10.02, 10.15, 10.36, 10.36 0, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 6 0, 0, 1, 1, 2, 2, 3, 5 Mode (b) Which of these three measures is the weakest indicator of a "typical" data value?
Use the data in the following table, which lists carbon dioxide concentrations (in parts per million) for each year from 1960 to 2009, with projected values used for the last four years. After finding the values of the mean and range for each decade, find the values of x, and R. Also find the values of LCL and UCL for an R chart, and find the values of LCL and UCL for an x chart. 1960s 318.4 319.5 321.8 322.9 324.8 325.4 326.9 328.5 330.3 331.4 1970s 333.4 334.6 335.5 337.1 339.3 340.4 341.4 343.1 344.7 346.5 1980s 348.1 348.8 351.2 352.1 353.8 355.4 356.9 358.5 359.8 360.6 1990s 361.9 363.6 365.8 366.7 368.6 369.2 371.7 372.4 373.5 375.2 2000s 377.6 378.7 379.6 381.8 382.8 384.2 386.3 387.6 388.7 390.5 x=enter your response here (Round to three decimal places as needed.) Part 2 R=enter your response here (Round to two decimal places as needed.) Compute the values of LCL and UCL for an R chart. LCL=enter your response here, UCL=enter your response here (Round to…