The prices of Rawlston, Inc. stock (y) over a period of 12 days, the number of shares (in 100s) of company's stocks sold (x1), and the volume of exchange (in millions) on the New York Stock Exchange (x2) are shown below. Day (x1) (x2) (v) 87.50 86.00 1 950 11.00 2 3 945 11.25 84.00 940 11.75 4 83.00 930 11.75 5 84.50 935 12.00 6. 84.00 935 13.00 7 82.00 932 13.25 8 80.00 938 14.50 9 78.50 925 15.00 10 79.00 900 16.50 17.00 77.00 77.50 11 875 12 870 17.50 Excel Analysis Toolpak was used to determine the least-squares regression equation. The computer output is shown below. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted RS Standard Em Observations 0.949 0.901 0.879 1.205 12.000 ANOVA df MS 59.424 Significance F Regression 2.000 118.847 40.922 0.000 Residual 9.000 13.069 1.452 Total 11.000 131.917 Coefficients Standard Emo. 118.506 t Stat 3.530 Lower 95% Upper 95% Lower 95.0% Upper 95.0% 194.458 0.055 P-value Intercept (x1) ((2) 33.575 0.006 42.553 42.553 0.088 194.458 0.016 0.031 0.517 0.618 0.088 0.055 -1.573 0.359 4.381 0.002 2.385 0.761 -2.385 -0.761
The prices of Rawlston, Inc. stock (y) over a period of 12 days, the number of shares (in 100s) of company's stocks sold (x1), and the volume of exchange (in millions) on the New York Stock Exchange (x2) are shown below. Day (x1) (x2) (v) 87.50 86.00 1 950 11.00 2 3 945 11.25 84.00 940 11.75 4 83.00 930 11.75 5 84.50 935 12.00 6. 84.00 935 13.00 7 82.00 932 13.25 8 80.00 938 14.50 9 78.50 925 15.00 10 79.00 900 16.50 17.00 77.00 77.50 11 875 12 870 17.50 Excel Analysis Toolpak was used to determine the least-squares regression equation. The computer output is shown below. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted RS Standard Em Observations 0.949 0.901 0.879 1.205 12.000 ANOVA df MS 59.424 Significance F Regression 2.000 118.847 40.922 0.000 Residual 9.000 13.069 1.452 Total 11.000 131.917 Coefficients Standard Emo. 118.506 t Stat 3.530 Lower 95% Upper 95% Lower 95.0% Upper 95.0% 194.458 0.055 P-value Intercept (x1) ((2) 33.575 0.006 42.553 42.553 0.088 194.458 0.016 0.031 0.517 0.618 0.088 0.055 -1.573 0.359 4.381 0.002 2.385 0.761 -2.385 -0.761
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
Question

Transcribed Image Text:17. If in a given day, the number of shares of the company that were sold was 94,500 and the volume of exchange on the
New York Stock Exchange was 16 million, what would you expect the price of the stock to be?
Between 70 and 79
a.
b.
Between 80 and 89
с.
Between 90 and 99
d.
Between 100 and 109

Transcribed Image Text:The prices of Rawlston, Inc. stock (y) over a period of 12 days, the number of shares (in 100s) of company's stocks sold
(x1), and the volume of exchange (in millions) on the New York Stock Exchange (x2) are shown below.
Day
(x1)
950
(x2)
(v)
87.50
11.00
2
86.00
945
11.25
3
84.00
940
11.75
11.75
4
83.00
930
5
84.50
935
12.00
6.
84.00
935
13.00
13.25
7
82.00
932
8
80.00
938
14.50
78.50
925
15.00
10
79.00
900
16.50
77.00
77.50
11
875
17.00
12
870
17.50
Excel Analysis Toolpak was used to determine the least-squares regression equation. The computer output is shown
below.
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
0.949
0.901
Adjusted RS
Standard Em
Observations
0.879
1.205
12.000
ANOVA
df
MS
59.424
Significance F
SS
Regression
2.000
118.847
40.922
0.000
Residual
9.000
13.069
1.452
Total
11.000
131.917
Coefficients Standard Ero
118.506
0.016
33.575
0.031
t Stat
3.530
P-value
0.006
Lower 95% Upper 95% Lower 95.0% Upper 95.0%
194.458
194.458
Intercept
(x1)
(2)
42.553
42.553
-0.517
0.618
0.088
0.055
0.088
0.055
-1.573
0.359
4.381
0.002
-2.385
-0.761
2.385
-0.761
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 3 steps with 2 images

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