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
icon
Related questions
Question
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: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
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman