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
Elementary Geometry For College Students, 7e
7th Edition
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Alexander, Daniel C.; Koeberlein, Geralyn M.
Chapter8: Areas Of Polygons And Circles
Section8.4: Cicumference And Area Of A Cicle
Problem 46E: A tabletop is semicircular when its three congruent drop-leaves are used. By how much has the tables...
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
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill