A study is done to find out whether there is a relationship between a woman's age and the amount of money she has saved (in RM'000). A random sample of data was collected from fifteen women in a residential area. The woman's age ranges from twenty-five to fifty-nine. Below are the results using MS Excel : Table 2 Regression Statistics Multiple R 0.986 R? R Square Adjusted R Square 0.969 Standard Error 1.098 Observations 15

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
QUESTION 3
A study is done to find out whether there is a relationship between a woman's age and the
amount of money she has saved (in RM'000). A random sample of data was collected from
fifteen women in a residential area. The woman's age ranges from twenty-five to fifty-nine.
Below are the results using MS Excel :
Table 2
Regression Statistics
Multiple R
R Square
0.986
R2
Adjusted R Square
0.969
Standard Error
1.098
Observations
15
Table 3
Standard
Coefficients
Error
t Stat
P-value
Intercept
-4.488
1.123
-3.996
0.002
Variable 1
0.580
0.028
0.000
20.999
a.
State the independent and dependent variables.
b.
Interpret the value of the correlation coefficient obtained in Table 2.
С.
Compute the coefficient of detemination and explain its meaning.
Determine the regression equation of amount of money saved on woman's age.
е.
Comment on the value of the coefficient, b, in the regression equation in (d).
f.
Predict the amount of money saved for a woman whose age is
i.
39
ii.
Is the prediction reliable? Explain.
64
d.
Transcribed Image Text:QUESTION 3 A study is done to find out whether there is a relationship between a woman's age and the amount of money she has saved (in RM'000). A random sample of data was collected from fifteen women in a residential area. The woman's age ranges from twenty-five to fifty-nine. Below are the results using MS Excel : Table 2 Regression Statistics Multiple R R Square 0.986 R2 Adjusted R Square 0.969 Standard Error 1.098 Observations 15 Table 3 Standard Coefficients Error t Stat P-value Intercept -4.488 1.123 -3.996 0.002 Variable 1 0.580 0.028 0.000 20.999 a. State the independent and dependent variables. b. Interpret the value of the correlation coefficient obtained in Table 2. С. Compute the coefficient of detemination and explain its meaning. Determine the regression equation of amount of money saved on woman's age. е. Comment on the value of the coefficient, b, in the regression equation in (d). f. Predict the amount of money saved for a woman whose age is i. 39 ii. Is the prediction reliable? Explain. 64 d.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar 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