Reference no: EM131068776
The answers are not provided properly for b to f Use Excel to Answer the Following Questions The price of a share of stock divided by the company's estimated future earnings per share is called the P/E ratio. High P/E ratios usually indicate "growth" stocks or maybe stocks that are simply overpriced. Low P/E ratios indicate "value" stocks or bargain stocks. A random sample of 51 of the largest companies in the U.S. gave the following P/E ratios in 2009 (Reference: Forbes): 11 35 19 13 15 21 40 18 60 72 9 20 29 53 16 26 21 14 21 27 10 12 47 14 33 14 18 17 20 19 13 25 23 27 5 16 8 49 44 20 27 8 19 12 31 67 51 26 19 18 32 a. Get the descriptive statistics for the data and verify that = 25.2 and s = 15.5. b. Check the sample size condition. c. Find a 99% confidence interval for the P/E population mean (µ) for all large U.S. companies. d. In June 2009, Bank of America had a P/E ratio of 14, Apple had a P/E ratio of 25, and Sears Holdings Inc. had a P/E ratio of 64. Examine the confidence interval in part c, and explain how you would describe these stocks at this time. e. Calculate the Pearson coefficient of skewness and comment on the normality of the data.
f. Graph the histogram and check for the normality of the data. Helpful Hints:
1. Add the ToolPak, click on File, choose Options, click on Add-Ins, choose Analysis ToolPak, ToolPak VBA and Solver, then click on Go.
2. Transfer the data from row to columns using "TRANSPOSE" fn on Excel: Copy the row you want to transfer, then select "Paste special" click on "transpose." Repeat for each row.
3. You can get the mean, median, S.D., Skewness (K3), Kurtosis (K4), confidence interval and more using the descriptive statistics fn. Click on Data, select Data Analysis, Descriptive Statistics. Sample size condition: n>10 and n > 10 Pearson Coefficient of Skewness = Graph the histogram to check for normality. Put your Bin in a column (you can name it with the variable name), these will be your classes or ranges. Click on Data, select Data Analysis, Histogram. Make sure you check the "Chart Output" box
|
Evaluate the development of the movement and its successes
: A strong thesis statement supported by research from at least 5 different sources. In a research-based project like this, it is important to refer to and cite your sources throughout the paper to show where your information is coming from and to s..
|
|
Write essay on the concepts discussed in article
: You may want to clarify the thesis topic, highlight the assumptions made, the biases of the author etc and provide a brief summary of the argument and the supporting evidence.
|
|
Term paper on- hydrogen fuel cell vehicles
: Choose one of these topics , TRANSPORTATION:- Transportation Energy Alternatives, Hydrogen Fuel Cell Vehicles, The Revival of Elactric Cars, Plug-in Hybrid Cars and The Past, Present and Future of Compressed-Air Vehicles.
|
|
Equation for the plane through the point
: Find an equation for the plane through the point (-1;1; 2) that contains the line of intersection of the planes P1 : x +y + z = 1 and P2 : x + 2y + 2z = 1.
|
|
Graph the histogram and check for the normality of the data
: The answers are not provided properly for b to f Use Excel to Answer the Following Questions The price of a share of stock divided by the company's estimated future earnings per share is called the P/E ratio. High P/E ratios usually indicate "grow..
|
|
What is the total value of the cash flows today
: What is the total value of the cash flows today? What is the total value of the cash flows at year 7? Draw the time line, mark out the time point and cash flows.
|
|
What are the key components of culture
: Why is socialization so important to the development of our self-concept? Explain the role of socialization in shaping our lives, using at least three concepts from the course material in your explanation.
|
|
Randomized complete block design
: What is the main assumption in a Randomized Complete block design, that is contrary to the assumption of an incomplete block design?
|
|
Estimate the height of a building
: An observer wants to estimate the height of a building. At herfirst measurement, the angle of elevation to the top of thebuilding is 45 degrees.
|