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
Related questions
Topic Video
Question

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.
Open spreadsheet
а. Let
d; denote the change in price per share for company i where
d; :
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.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.42
Confidence interval (to 2 decimals): ( 5.39
9.05
The mean price per share has increase between 8.9
% and 14.9
8 % over the three-month period (to 1 decimal).
Check My Work
Reset Problem

Transcribed Image Text:A
В
C
E
F
G
H
I
End of 1st
Quarter
Beginning of
Year
Change in
Price (d;)
1
Company
Change in Price (di)
2
Bank of New York
26.43
17.01
9.42
Kraft Foods
39.61
35.46
4.15
Мean
7.2184
4
Dupont
54.10
44.38
9.72
Standard Error
0.885481353
5
Consolidated Edison
59.42
60.13
-0.71
Median
6.56
6
Johnson & Johnson
68.46
62.68
5.78
Mode
17.76
7
Union Pacific
108.68
103.14
5.54
Standard Deviation
4.427406765
8
Comcast
31.31
21.51
9.80
Sample Variance
19.60193067
9
Applied Materials
15.15
9.11
6.04
Kurtosis
0.746948609
10
Pfiser
44.81
40.12
4.69
Skewness
0.757130114
11
General Electric
22.37
15.81
6.56
Range
18.47
12 AT&T
32.73
28.04
4.69
Minimum
-0.71
13
Cisco Systems
Home Depot
24.05
16.98
7.07
Maximum
17.76
14
53.21
39.94
13.27
Sum
180.46
15
JP Morgan Chase
48.28
31.35
16.93
Count
25
16 Procter & Gamble
69.01
64.91
4.10
Largest(1)
17.76
17 Verizon
40.43
38.92
1.51
Smallest(1)
-0.71
18
Devon Energy
72.72
60.60
12.12
Confidence Level(95%)
1.827543678
19 Lilly
41.67
40.36
1.31
20 Microsoft
33.36
24.56
8.80
The 95% confidence interval
Formulas
21
Сосо Cola
75.71
67.17
8.54
C.I.Lower Limit (to 2 decimals)
5.39
=G3-G18
22 Qualcomm
70.26
52.50
17.76
C.I.Upper Limit (to 2 decimals)
9.05
=G3+G18
23
Exxon Mobil
89.33
82.06
7.27
24
Pacific Gas & Electric
25.35
20.54
4.81
Mean Price, Beginning of Year (to 2 decimals)
60.56
=AVERAGE(C2,C26)
25
Oracle Systems
31.26
24.48
6.78
26
Chevron
108.61
104.10
4.51
Percentage Change in the Population Mean
27
Lower Percentage Change (to 1 decimal)
8.9%
=G21/G24
28
Upper Percentage Change (to 1 decimal)
14.9%
=G22/G24
29
30
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman